[Serusers] serweb, getting it working

[Arnd Vehling]

Hi,

Ticknor.Scott at ic.gc.ca wrote:
> basically, i am getting MySQL errors when trying to access serweb.
> --
> Warning: Access denied for user: 'ser at Lima' (Using password: YES) in
> /var/www/html/phplib/db_mysql.inc on line 73
> Database error: pconnect(Lima, ser, $Password) failed.
> MySQL Error: ()
> Session halted.
> --
> 
> the ser db is created, along with a 'ser' user and the default heslo passwd.
> i used phpMyAdmin to grant ser full permissions over the ser db. i suspected
> the problem is the appending of @Lima to the user name was problematic, so i
> created a 'ser at Lima' user and gave it permissions for the ser db as well.
> still no luck.

The mysql user access rights are obviously wrong. Did you:

grant ALL on ser.* to 'ser'@'lima' identified by 'password';?

If the database and webinterface are on the same host try:

grant ALL on ser.* to 'ser'@'localhost' identified by 'password';

and change 


>                 $this->db_host="Lima";  //database host

to 

>                 $this->db_host="localhost";  //database host

regards,

  Arnd