I am new to SER, forgive me if I use "strange terms" or ask stupid or obviously things ;-)
I downloaded SER and compiled from source. I tried to use the ser_mysql.sh script to create the database and the permittion.
For me unknown reasons, the permissions for all ser(ro) are set to 'N' in the table mysql.user I tried to change it to 'Y' with
GRANT ALL PRIVILEGES ON ser.* to 'ser'@'localhost' IDENTIFIED BY 'password'
but that does not change anything in the mysql.user
Strange is also that the database ser does not show up at all in phpMyAdmin and also the 4 records in mysql.user.
Before I changed /usr/local/etc/ser/ser.cfg to reflect the mysql I tried to start ser with /usr/local/sbin/serctl start
and I had many ser process in my ps list, but now it says: :/usr/local # /usr/local/sbin/serctl start
Starting SER : PID file exists! (/var/run/ser.pid) already running?
What have I done wrong?
bye
Ronald Wiplinger
Ronald Wiplinger wrote:
I am new to SER, forgive me if I use "strange terms" or ask stupid or obviously things ;-)
I downloaded SER and compiled from source. I tried to use the ser_mysql.sh script to create the database and the permittion.
I could solved some parts, but hang here:
Sep 29 17:09:50 dns ser: WARNING: fix_socket_list: could not rev. resolve 192.168.0.254 Sep 29 17:09:50 dns ser: WARNING: fix_socket_list: could not rev. resolve 192.168.0.254 Sep 29 17:09:50 dns /usr/local/sbin/ser[11517]: Maxfwd module- initializing Sep 29 17:09:50 dns /usr/local/sbin/ser[11517]: new_connection(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Sep 29 17:09:50 dns /usr/local/sbin/ser[11517]: db_init(): Could not create a connection Sep 29 17:09:50 dns /usr/local/sbin/ser[11517]: ERROR: auth_db_ver: unable to open database connection Sep 29 17:09:50 dns /usr/local/sbin/ser[11517]: auth_db:str_fixup(): Error while querying table version Sep 29 17:09:50 dns /usr/local/sbin/ser[11517]: ERROR: fix_expr : fix_actions error
grep sock /etc/my.cnf socket = /tmp/mysql.sock
Where do I set this in SER?
bye
Ronald Wiplinger
Ronald,
I would recommend that you download the Getting Started document from http://www.onsip.org/ because it will help you get up and running with little effort.
Regards, Paul
On 9/29/05, Ronald Wiplinger ronald@elmit.com wrote:
Ronald Wiplinger wrote:
I am new to SER, forgive me if I use "strange terms" or ask stupid or obviously things ;-)
I downloaded SER and compiled from source. I tried to use the ser_mysql.sh script to create the database and the permittion.
I could solved some parts, but hang here:
Sep 29 17:09:50 dns ser: WARNING: fix_socket_list: could not rev. resolve 192.168.0.254 Sep 29 17:09:50 dns ser: WARNING: fix_socket_list: could not rev. resolve 192.168.0.254 Sep 29 17:09:50 dns /usr/local/sbin/ser[11517]: Maxfwd module- initializing Sep 29 17:09:50 dns /usr/local/sbin/ser[11517]: new_connection(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Sep 29 17:09:50 dns /usr/local/sbin/ser[11517]: db_init(): Could not create a connection Sep 29 17:09:50 dns /usr/local/sbin/ser[11517]: ERROR: auth_db_ver: unable to open database connection Sep 29 17:09:50 dns /usr/local/sbin/ser[11517]: auth_db:str_fixup(): Error while querying table version Sep 29 17:09:50 dns /usr/local/sbin/ser[11517]: ERROR: fix_expr : fix_actions error
grep sock /etc/my.cnf socket = /tmp/mysql.sock
Where do I set this in SER?
bye
Ronald Wiplinger
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-
Paul Hazlett -
Ronald Wiplinger