[phpesp-dev] [ phpesp-Bugs-584018 ] SQL Connection failing without error

[<no...@so...>]

Bugs item #584018, was opened at 2002-07-19 13:50
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=584018&group_id=8956

Category: SQL
Group: v1.4
Status: Open
Resolution: None
Priority: 1
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: SQL Connection failing without error

Initial Comment:
Hi!

I'm getting the following rather cryptic sort of error
message when attempting to first run admin.php:

HTTP 503 Service Unavailable
[ Connection to database failed. Please check
configuration. ]
[ : ]

Upon further examination, I found that the [ : ] part
was supposed to contain the MySQL error message and it
doesn't. Here's everything I can tell you about my
installation:

1. I followed the instructions in the README exactly. I
have a database user named phpesp with password phpesp
and a database phpesp which has been created by the
phpESP.sql file. 

2. The above error is actually generated when I visit
an index.php, which is a symlink to admin.php (this was
going to change later). 

3. Mysql version: 3.23.36 Linux: 2.4.2-2smp Redhat 7.3. 

4. Here's the entry from the table mysql.user for the
user phpesp:
| %                             | phpesp@%   |
196ccabe5c8e0b3d | Y           | Y           | Y      
    | Y           | N           | N         | N       
   | N             | N            | N         | N     
    | N               | N          | N          |

So, that's Select, Update, Insert, Delete privs.

What could possibly be going wrong? 
[jo...@ma...]

----------------------------------------------------------------------

Comment By: Nobody/Anonymous (nobody)
Date: 2002-07-22 13:11

Message:
Logged In: NO 

Ah ha! Removing that @ sign certainly helped a lot. The
problem was that there was no /tmp/mysql.sock. Even if there
had been, I couldn't connect using the mysql command listed
below, so I've made changes to my mysql setup to allow for
the login. Now things appear to be working just fine. Might
I suggest a couple of things:

1. Remove that @ sign from the general distrobution. More
data is always better than less when trying to figure out
what's wrong.

2. Make these failures fail a little more gracefully, so you
never get an error in which the mysql error shows as [ : ],
which doesn't help at all.

3. Perhaps an installation script? It doesn't seem hard to
do using make/sed/awk or perl. I don't think it's
unreasonable to require any of those things on a server
where phpesp is going to be installed. That way, your
instructions wouldn't need to say "Go to file x and change
the location of y to whatever you set it to", and you could
check for things like a proper mysql installation.

----------------------------------------------------------------------

Comment By: James Flemer (jimmerman)
Date: 2002-07-19 14:54

Message:
Logged In: YES 
user_id=39444

You can remove the "@" in front of the mysql_connect(), and
then you might get a php error with more details. Verify
that the mysql extension is loaded (from a phpinfo() page),
if you are using the stock redhat apache, then I am pretty
sure it is.

Also try to connect to the database from the web server
command line:
$ mysql -uphpesp -p phpesp

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=584018&group_id=8956