1
dbkeebler
Could not connect to the database server
  • 2004/9/24 1:13

  • dbkeebler

  • Just popping in

  • Posts: 1

  • Since: 2004/9/24


Apache=2.0.50
PHP=4.3.6
MySQL=4.1.2


My sister wants a portal dealy and found your software. I'm in the middle of installing the beast and keep hitting the wall at the "check database" page. Of course the page gives me NO useful information nor is there anything about it in the php_error_log or the apache error log for that virtual host.

So I ran 'strace' against all my running apache children and found this:

[pid 9099] socket(PF_FILE, SOCK_STREAM, 0) = 28
[pid 9099] fcntl64(28, F_GETFL) = 0x2 (flags O_RDWR)
[pid 9099] fcntl64(28, F_GETFL) = 0x2 (flags O_RDWR)
[pid 9099] fcntl64(28, F_SETFL, O_RDWR|O_NONBLOCK) = 0
[pid 9099] connect(28, {sa_family=AF_FILE, path="/var/lib/mysql/mysql.sock"}, 110) = 0
[pid 9099] fcntl64(28, F_SETFL, O_RDWR) = 0
[pid 9099] setsockopt(28, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
[pid 9099] setsockopt(28, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
[pid 9099] poll([{fd=28, events=POLLIN, revents=POLLIN}], 1, 60000) = 1
[pid 9099] read(28, "B\0\0\0", 4) = 4
[pid 9099] read(28, "\n4.1.2-alpha-standard\0\376\t\0\0?,]o7acO\0,\202\10\2\0\0\0\0\0\0\0\0\0\0\0\0\0\0?1tuoNw.zAsA\0", 66) = 66
[pid 9099] write(28, "\23\0\0\1\205 \377\377\377xoops\0[WELKKY@", 23) = 23
[pid 9099] read(28, "g\0\0\2", 4) = 4
[pid 9099] read(28, "\377\343\4Client does not support authentication protocol requested by server; consider upgrading MySQL client", 103) = 103
[pid 9099] shutdown(28, 2 /* send and receive */) = 0
[pid 9099] close(28) = 0

The most important piece of course is the "Client does not support authentication protocol requested by server; consider upgrading MySQL client" message. Tho I find this quite odd because I run a bunch of other PHP/MySQL software on this same apache instance against the same MySQL server without any similar issues.

Anyone know what client the error message is suggesting I upgrade?

-Frank

Login

Who's Online

409 user(s) are online (55 user(s) are browsing Support Forums)


Members: 0


Guests: 409


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Oct 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits