hi, first post here after reading thru the archives and whatnot. im a ser-n00b, so go easy. i installed from source with the -all option for all modules. everything is where it should be, i think. basically, i am getting MySQL errors when trying to access serweb. -- Warning: Access denied for user: 'ser@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@Lima' user and gave it permissions for the ser db as well. still no luck. here are some relevant bits from ser.cfg. if you need me to post logs, other config files, let me know. thanks for reading!
---- $this->db_host="Lima"; //database host $this->db_name="ser"; //database name $this->db_user="ser"; //database conection user $this->db_pass="heslo"; //database conection password
$this->root_path="/serweb/"; /* root uri of your server */ /* $this->root_uri="http://Lima/"; */ $this->root_uri="http://10.0.0.54/";
/* where is your zone file on your server ? */ $this->zonetab_file = "/usr/share/zoneinfo/zone.tab"; /* serweb will send confirmation emails and SIP IMs -- what sender address should it claim ? should appear in them ? */ $this->mail_header_from="registrar@mydomain.org";
$this->web_contact="sip:daemon@Lima"; /* spool directory with voicemail messages */ $this->voice_silo_dir = '/var/spool/voicemail/'; /* directory with voicemail greetings */ $this->greetings_spool_dir = '/var/greetings/'; /* serweb talks to SER via FIFO -- this is FIFO's name, it must have the same value as SER's fifo config param */ $this->fifo_server="/tmp/ser_fifo"; ----
Hi,
Ticknor.Scott@ic.gc.ca wrote:
basically, i am getting MySQL errors when trying to access serweb.
Warning: Access denied for user: 'ser@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@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