I know when I first started working with a host that provided MySQL support,
there was a very specific path I had to use in the connection string because
"...the MySQL server is behind a very strict firewall." If I didn't use the
path exactly as their prototype indicated, I'd get errors like you have
posted.

I'd suggest you check your host's self-help tech support pages, drop them an
e-mail or call them.

> -----Original Message-----
> From: Robert Wagner [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 03, 2003 4:27 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Re: Is MySQL available from my host.
> 
> 
> "Robert Wagner" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > I recently signed up with a "low-cost" web server, in order 
> to do some
> > web-page accessed database work. The server has PHP Version 
> 4.0.6 and
> > phpinfo() yields (in part):
> >
> >       PHP Version 4.0.6
> >
> >       System SunOS src 5.7 Generic_106541-12 sun4u sparc
> > SUNW,UltraSPARC-IIi-cEngine
> >       Build Date Feb 28 2002
> >       Configure Command  './configure' '--disable-pear' 
> '--enable-ftp'
> > '--with-sybase-ct=/usr/local/freetds' '--enable-trans-sid'
> > '--enable-force-cgi-redirect'
> >       Server API CGI
> >       Virtual Directory Support disabled
> >       Configuration File (php.ini) Path
> /usr/local/affinity/etc/php.ini
> >       ZEND_DEBUG disabled
> >       Thread Safety disabled
> >
> >        This program makes use of the Zend scripting language engine:
> >       Zend Engine v1.0.6, Copyright (c) 1998-2001 Zend Technologies
> >
> >
> >
> >                      |
> > (Some output omitted here)
> >                      |
> > mysql
> >       MySQL Support enabled
> >       Active Persistent Links 0
> >       Active Links 0
> >       Client API version 3.23.32
> >       MYSQL_MODULE_TYPE builtin
> >       MYSQL_SOCKET /tmp/mysql.sock
> >       MYSQL_INCLUDE
> >       MYSQL_LIBS
> >
> >
> >
> >       Directive Local Value Master Value
> >       mysql.allow_persistent
> >      On On
> >       mysql.default_host
> >      no value no value
> >       mysql.default_password
> >      no value no value
> >       mysql.default_port
> >      no value no value
> >       mysql.default_socket
> >      no value no value
> >       mysql.default_user
> >      no value no value
> >       mysql.max_links
> >      Unlimited Unlimited
> >       mysql.max_persistent
> >      Unlimited Unlimited
> >
> >
> > ftp
> >       FTP support enabled
> >
> >
> > Additional Modules
> >
> >
> > Environment
> >       Variable Value
> >       TZ US/Pacific
> >       DOCUMENT_ROOT /nfs/cust/9/36/06/260639/web
> >       HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, 
> image/pjpeg,
> > application/vnd.ms-excel, application/msword,
> > application/vnd.ms-powerpoint, application/x-shockwave-flash, */*
> >       HTTP_ACCEPT_ENCODING gzip, deflate
> >       HTTP_ACCEPT_LANGUAGE en-us
> >       HTTP_CONNECTION Keep-Alive
> >       HTTP_HOST www.mymain.com  (<Renamed for his message!)
> >       HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 6.0; Windows NT
> 5.1)
> >       PATH /usr/bin:/bin:/usr/local/bin
> >       REDIRECT_DOCUMENT_ROOT /nfs/cust/9/36/06/260639/web
> >       REDIRECT_STATUS 200
> >       REDIRECT_URL /Experiments/PHP_Info.php
> >       REMOTE_ADDR (Deleted for this message)
> >       REMOTE_PORT 7016
> >       SCRIPT_FILENAME /usr/local/apache/cgi-bin/php.cgi
> >       SERVER_ADDR 10.3.1.126
> >       SERVER_ADMIN [EMAIL PROTECTED]  (<Renamed for his message!)
> >       SERVER_NAME www.mymain.com  (<Renamed for his message!)
> >       SERVER_PORT 80
> >       SERVER_SIGNATURE
> >       SERVER_SOFTWARE Apache/1.3.26 (Unix) mod_mhp mod_mhp_log
> > mod_virtcgi frontPage/5.0 mod_status_mhp
> >       GATEWAY_INTERFACE CGI/1.1
> >       SERVER_PROTOCOL HTTP/1.1
> >       REQUEST_METHOD GET
> >       QUERY_STRING
> >       REQUEST_URI /Experiments/PHP_Info.php
> >       SCRIPT_NAME /bin/php.cgi
> >       PATH_INFO /Experiments/PHP_Info.php
> >       PATH_TRANSLATED
> > /nfs/cust/9/36/06/260639/web/ET_Experiments/PHP_Info.php
> >       REMOTE_HOST (Deleted for this message)
> > (Moreoutput omitted after this)
> ---------------
> When I posted my original message, I forgot to include the result I'm
> getting from the script:
> <?php
>    mysql_connect() or
>        die("Could not connect (sob): " . mysql_error());
>    printf ("MySQL host info: %s\n", mysql_get_host_info());
> ?>
> ----------
> The result:
> ----------
> Warning: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2) in
> /nfs/cust/9/36/06/260639/web/ET_Experiments/MySQL_Info.php on line 7
> 
> Warning: MySQL Connection Failed: Can't connect to local MySQL server
> through socket '/tmp/mysql.sock' (2) in
> /nfs/cust/9/36/06/260639/web/ET_Experiments/MySQL_Info.php on line 7
> Could not connect (sob): Can't connect to local MySQL server through
> socket '/tmp/mysql.sock' (2)
> ---------------
> 
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to