Re: [cobalt-developers] MySQL PHP problem

[David Keyes <dave@xxxxxxxxxxxxxxx>]

Colin,

I don't think it's a firewall issue. I have a qube3 and it had the same problems. The reason it couldn't connect through the socket was because there wasn't one (!). There was also the issue of mysql support not noted on the phpinfo page. The module for PHP had to be dynamically loaded. Anyway, the connection script I use now has the following lines at the begining...

    function connect()
    {
	$test=extension_loaded('mysql.so');
	if ($test == FALSE) {
	  dl('mysql.so');
	$sockset=shell_exec("ln -s -f /var/lib/mysql/mysql.sock /tmp/mysql.sock");
	}
     ........


Good luck

David Keyes



> 
> From: Colin McQueen <cmcqueen@xxxxxxxxxxxxxx>
> Date: 2002/10/23 Wed AM 12:48:11 MST
> To: cobalt-developers@xxxxxxxxxxxxxxx
> Subject: [cobalt-developers] MySQL PHP  problem
> 
> Hi
> 
> I have started to have a bit of success with MySQL and PHP but am
> struggling because I cannot get any shell access from home through our
> firewall.
> 
> Attempting to list the databases via PHP I get
> 
>  
> 
>  Warning: Can't connect to local MySQL server through socket
>  '/tmp/mysql.sock' (111) in (directory path snipped) on line 9
>  
> Dunno if this helps but:-
> 
> If I run a <?php phpinfo(); ?> line then I get
> a lovely set of details but the mysql set says the directive for default
> port and socket have no value.
> 
> Any ideas?  Is this because of the firewall or something I need to
> change in the config?
> 
> TIA
> 
> -- 
> 
> Colin McQueen : Using an Acorn StrongARM Risc PC
> Web Domain    :       http://www.mcqueen.uk.net/
> BSc Zoology + Oceanography : PGCE : MSc in CBL/T
> 
> _______________________________________________
> cobalt-developers mailing list
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers
>