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

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

Bugs item #584018, was opened at 2002-07-19 15: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: James Flemer (jimmerman)
Date: 2002-07-19 16: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