Kernel (50), No DB Connection

Kernel (50), No DB Connection

Monday 10 November 2003 11:12:04 am - 5 replies

Author Message

Willie Seabrook

Monday 10 November 2003 12:49:53 pm

Look at my post a few ones down from yours. It looks like we have the same problem. I have gone into more depth than you have here. Perhaps there is a bug in 3.2-3???

Regards,
Willie

Emory Rowland

Monday 10 November 2003 3:07:45 pm

Yes, it seems the same. The only thing you mentioned that I didn't check was the sock. I'm not sure about that.

steve p

Monday 10 November 2003 6:57:01 pm

I have the same problem . .it seems no matter what I try I can not connect to postresql.
I have tried the manual installation, the wizard .. and both of those numerous times and it's always the same thing. I am root on this server and I am setting up the dB and user properly (other cms/forum/phpsql apps work) .. why not this one?
ezpublish seems to be exactly what I want, and I can't run it!!!

Willie Seabrook

Tuesday 11 November 2003 9:00:28 pm

You may want to check your sockets:

Create a file info.php in your document root (the directory where ezpublish index.php is) and put in it:

<?php

phpinfo();

?>

Now load that up at http://localhost/info.php and scroll down to the mysql section.
What does the MYSQL_SOCKET parameter have in it?

It may have a value like /tmp/mysql.sock
Go to whatever directory it has (in this case /tmp/) and check to see there is a file there. If not, you need to find mysql.sock.

Its probably in /var/lib/mysql/mysql.sock or similar.

Then:
cd /tmp
ln /var/lib/mysql/mysql.sock mysql.sock or
ln -s /var/lib/mysql/mysql.sock mysql.sock

to create a symbolic link to whereever your sock is. This is probably similar process with postgresql.

Let me know how you get on.

steve p

Wednesday 12 November 2003 4:45:14 pm

I'm using postgresql, here is the printout from phpinfo:

PostgreSQL Support enabled
Active Persistent Links 0
Active Links 0

Directive Local Value Master Value
pgsql.allow_persistent
On On
pgsql.max_links
Unlimited Unlimited
pgsql.max_persistent
Unlimited Unlimited

Like I said, I can connect from other php/sql apps, just not from ezpublish.

I have done it both ways, editing the .ini file and using the wizard. Setting up different accounts, root account (postgresql) .. .nothing seems to work.

You must be logged in to post messages in this topic!

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.