New subject: [Serusers] SER + Remote MySQL Server

1 Jul 2005

      jan posted this
modparam("auth_db|usrloc", "db_url", "mysql://ser:heslo@server_host/ser")
so replace ser with your username
helso with ur password
server_host with the Ip address of your mysql server
leave the second ser alone, since thats the DB name, and I am guessing you have installed it with default name
Iqbal
Sebastian Kigelman wrote:
...
Thank you Iqbal for your answer... Have you the right line that I need to
put on my ser.cfg?, I will really appreciate if you can provide me the
information.
-----Original Message-----
From: Iqbal [mailto:iqbal@gigo.co.uk] 
Sent: Friday, 01 July, 2005 08:24
To: Sebastian Kigelman
Cc: serusers@lists.iptel.org
Subject: Re: [Serusers] SER + Remote MySQL Server
Yup, I think thats how most have it, on a remote server, have you tried 
connecting from your command line where ser is to the remote mysql 
machine, if that fails, which it normally does, its down to a 
permissions problem in Mysql.
Otherwise in ser.cfg you can define the IP address of your remote mysql 
server
Iqbal
Sebastian Kigelman wrote:
...
Finally, I know why I am having problems with SER + MySQL: I think
is that because I trying to run SER and MySQL in different machines. Per
the
...
installation instructions that I found in www.iptel.org, I have installed
SER on other machine in the same subnet, and I was able to create and
initialize the DB with the "ser_mysql create" command. I do that modifying
the ser_mysql.sh and serctl.sh scripts setting DBHOST=<MySQL IP Address> on
both files. I thought that those changes would allow to ser application to
start using the remote MySQL server, but analyzing the ser debug messages,
I
...
understand that the application is trying to locate the DB on the local
machine.
So, there is somebody that there is implemented SER + Remote MySQL
Server?... can you tell me what I need to do to tell to SER that the DB is
located on a remote machine?...
Thanxs in advance!

Zeva
----- Original Message ----- 
From: "Sebastian Kigelman" sebastian@kigelman.com.ar
To: serusers@lists.iptel.org
Sent: Wednesday, June 29, 2005 11:34 AM
Subject: [Serusers] 2nd try: SER does not start with MySQL
...
Hi there!!!... Iam newy in SER mailing list, and I have a problem with my
SER installation that I saw that other members have before, but I can't 
find
a solution to the issue.
I have installed the SER (v0.8.14), all works fine until I add MySQL 
support
to get persistent users. after that, when I run "serctl start" I get this
error:

Starting SER : cat: /var/run/ser.pid: No such file or directory
started pid()

I have made some test to troubleshot this issue, for exsaplme: remplacing
DIR=... with the full path to SER executable in "serctl"... and also I
increase the debug level in "ser.cfg" to 7, and I get this output:

MyHost:/etc/ser# ser -c
0(2577) loading module /usr/lib/ser/modules/mysql.so
0(2577) loading module /usr/lib/ser/modules/sl.so
0(2577) loading module /usr/lib/ser/modules/tm.so
0(2577) loading module /usr/lib/ser/modules/rr.so
0(2577) loading module /usr/lib/ser/modules/maxfwd.so
0(2577) loading module /usr/lib/ser/modules/usrloc.so
0(2577) loading module /usr/lib/ser/modules/registrar.so
0(2577) loading module /usr/lib/ser/modules/auth.so
0(2577) loading module /usr/lib/ser/modules/auth_db.so
0(2577) set_mod_param_regex: usrloc matches module usrloc
0(2577) set_mod_param_regex: found <db_mode> in module usrloc
[/usr/lib/ser/modules/usrloc.so]
0(2577) set_mod_param_regex: auth_db matches module auth_db
0(2577) set_mod_param_regex: found <calculate_ha1> in module auth_db
[/usr/lib/ser/modules/auth_db.so]
0(2577) set_mod_param_regex: auth_db matches module auth_db
0(2577) set_mod_param_regex: found <password_column> in module auth_db
[/usr/lib/ser/modules/auth_db.so]
0(2577) set_mod_param_regex: rr matches module rr
0(2577) set_mod_param_regex: found <enable_full_lr> in module rr
[/usr/lib/ser/modules/rr.so]
0(2577) find_export: found <mf_process_maxfwd_header> in module
maxfwd_module [/usr/lib/ser/modules/maxfwd.so]
0(2577) find_export: found <sl_send_reply> in module sl_module
[/usr/lib/ser/modules/sl.so]
0(2577) find_export: found <sl_send_reply> in module sl_module
[/usr/lib/ser/modules/sl.so]
0(2577) find_export: found <record_route> in module rr
[/usr/lib/ser/modules/rr.so]
0(2577) find_export: found <loose_route> in module rr
[/usr/lib/ser/modules/rr.so]
0(2577) find_export: found <t_relay> in module tm
[/usr/lib/ser/modules/tm.so]
0(2577) find_export: found <www_authorize> in module auth_db
[/usr/lib/ser/modules/auth_db.so]
0(2577) find_export: found <www_challenge> in module auth
[/usr/lib/ser/modules/auth.so]
0(2577) find_export: found <save> in module registrar
[/usr/lib/ser/modules/registrar.so]
0(2577) find_export: found <lookup> in module registrar
[/usr/lib/ser/modules/registrar.so]
0(2577) find_export: found <sl_send_reply> in module sl_module
[/usr/lib/ser/modules/sl.so]
0(2577) find_export: found <t_relay> in module tm
[/usr/lib/ser/modules/tm.so]
0(2577) find_export: found <sl_reply_error> in module sl_module
[/usr/lib/ser/modules/sl.so]
0(2577) routing table 0:
...blah
...blah
...blah
...blah
WARNING: could not rev. resolve 192.168.0.4
Listening on
           127.0.0.1 [127.0.0.1]:5060
           192.168.0.4 [192.168.0.4]:5060
Aliases: MyHost:5060 localhost:5060 localhost.localdomain:5060
config file ok, exiting...
0(2577) DEBUG: tm_shutdown : start
0(2577) DEBUG: tm_shutdown : empting hash table
0(2577) DEBUG: tm_shutdown: releasing timers
0(2577) DEBUG: tm_shutdown : removing semaphores
0(2577) DEBUG: tm_shutdown : done
0(2577) shm_mem_destroy
0(2577) destroying the shared memory lock

I couldn't find what is wrong in my configuration...
BTW, I can add, remove and edit users in MySQL Database using "serctl"
subscribers commands (that means that my SER machine is talking with MySQL
server as in expected)

Serusers mailing list
serusers@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers

Serusers mailing list
serusers@lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
.
.