Hello,

I've made some tests and now I suspect that what I see is a DB package bug.

I run the following script and it works fine:

<?php

$mysqli = new mysqli("localhost", "test1", "", "testdb");

/* check connection */ 
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

printf("Host information: %s\n", $mysqli->host_info);

if ($result = $mysqli->query("SELECT * FROM contents")) {
    printf("Select returned  %d rows", $result->num_rows);

}

while ($row = mysqli_fetch_assoc($result)) {
    print_r($row);
}

/* close connection */
$mysqli->close();

?>

While trying to connect to the same db using PEAR::DB_DataObject (connection
string: mysqli://[EMAIL PROTECTED]/testdb)

Still gives me this error
"Can't connect to local MySQL server through socket '' (111)"

> -----Original Message-----
> From: Martin Norland [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 08, 2005 10:19 PM
> To: php-db@lists.php.net
> Cc: 'MySQL General List'; 'PHP General List'
> Subject: Re: [PHP-DB] mysqli connection problem
> 
> My intention of setting the reply-to was not to offend, or claim you
> were wrong - merely to move the discussion to the list I felt (and still
> feel - as I've done it again) is most appropriate for the question.
> 
> anyway, back to the task at hand
> 
> ( first: I'm assuming you restarted apache after changing your php.ini -
> otherwise, that's your problem. )
> 
> Whatever the case, the error message clearly shows that it is not
> reading the value, however it's set - because the error is still showing
> a blank string for the socket.  If it were a permissions problem with
> the socket, you wouldn't be getting that exact error - at the very
> least, it would still show the correct socket path.  More likely, it
> would also error with a "cannot open socket" or equivalent.
> 
> You may wish to examine ini_get(), ini_get_all(), phpinfo(), or
> php_ini_scanned_files(), to verify if it is set, or to see if it's being
> overwritten somewhere.
> 
> Cheers,
> 
> Denis Gerasimov wrote:
> > Didn't help me. MySQL socket does exist - /var/lib/mysql/mysql.sock
> (default
> > location).
> > mysqli.default_socket is NOT set to null but to this value (manually, as
> you
> > advised)
> >
> > Again,
> >
> > 1. Connection to localhost still fails with message "Can't connect to
> local
> > MySQL server through socket '' (111)"
> >
> > 2. Connection to server's domain name fails too (!) with message "Access
> > denied for user 'user'@'example.com' (using password: YES)"
> >
> > 3. Connection to localhost through mysql shows the following config
> >
> > mysql> status
> > --------------
> > mysql  Ver 14.7 Distrib 4.1.9, for pc-linux-gnu (i686)
> >
> > Connection id:          42
> > Current database:
> > Current user:           [EMAIL PROTECTED]
> > SSL:                    Not in use
> > Current pager:          stdout
> > Using outfile:          ''
> > Using delimiter:        ;
> > Server version:         4.1.9-standard
> > Protocol version:       10
> > Connection:             Localhost via UNIX socket
> > Server characterset:    latin1
> > Db     characterset:    latin1
> > Client characterset:    latin1
> > Conn.  characterset:    latin1
> > UNIX socket:            /var/lib/mysql/mysql.sock
> > Uptime:                 1 day 3 hours 1 min 7 sec
> >
> > Threads: 3  Questions: 272  Slow queries: 0  Opens: 64  Flush tables: 1
> > Open tables: 26  Queries per second avg: 0.003
> > --------------
> >
> > Seems to be a security issue... Any more ideas about these symptoms?
> >
> >
> >>-----
> >>I can't see any reason why you wouldn't be able to use the same socket -
> >>you're connecting to the same exact server, it's just a path.  You
> >>should be perfectly able to set your mysqli.default_socket to the same
> >>as the mysql.default_socket.  I can't tell you what the default for your
> >>system is, but there are php functions to get configuration options, if
> >>you don't have it in any obvious places.
> >>
> >>Cheers,
> >>--
> >>- Martin Norland, Database / Web Developer, International Outreach x3257
> >>The opinion(s) contained within this email do not necessarily represent
> >>those of St. Jude Children's Research Hospital.
> >>
> >>
> >>
> >>--
> >>MySQL General Mailing List
> >>For list archives: http://lists.mysql.com/mysql
> >>To unsubscribe:
> >>http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
> 
> 
> --
> - Martin Norland, Database / Web Developer, International Outreach x3257
> The opinion(s) contained within this email do not necessarily represent
> those of St. Jude Children's Research Hospital.
> 
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]

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

Reply via email to