RE: [Phphelpdesk-help] New install problems

[Are W. <are...@ly...>]

|	I have just installed phphelpdesk and cannot get past the initial
|login page. I try to log in with admin, admin and this is the error message
|I get back.
|
|" Warning: MySQL Connection Failed: Can't connect to local MySQL server
|through socket '/var/lib/mysql/mysql.sock' (111) in
|/var/www/html/helpdesk/includes/connect.inc.php on line 4
|ERROR: Can not connect to database "
|	The database is created using the script provided, can someone give
|me a clue? Thanks.

Adrian,

A few things to check:

Is your MySQL-daemon even running? You do not mention your platform de
choix, but a command like /your/path/to/initscripts/mysql status (ie.
/etc/rc.d/init.d/mysql status on most *nixes) should give you a pointer.
Both the rpms and tarballs for later MySQL versions automagically set up
init scripts during installation.

You do say however, that you managed to create the database, so the
abovementioned might not be the problem. Try dumping the phphelpdesk base.
Then create the database once again using 'mysqladmin -u root -pyourpassword
create phphelpdesk' from shell. Then enter the mysql concole (mysql -u root
-pyourpassword), enter 'use phphelpdesk', and then 'source
phphelpdesk.mysql'. (Make sure you're in the 'sql'-subdir when doing this,
or rectify pathnames as needed)
The reason for trying this is that some MySQL-versions are a bit buggy when
it comes to creating databases with permisions et al straight from scripts.

Give it a try, and let me know how it works.

Rgds,

Are