[Serusers] SER + Remote MySQL Server

Iqbal iqbal at gigo.co.uk
Fri Jul 1 14:40:07 CEST 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 at gigo.co.uk] 
>Sent: Friday, 01 July, 2005 08:24
>To: Sebastian Kigelman
>Cc: serusers at 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 at kigelman.com.ar>
>>To: <serusers at 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 at lists.iptel.org
>>>http://lists.iptel.org/mailman/listinfo/serusers 
>>>   
>>>
>>>      
>>>
>>
>>_______________________________________________
>>Serusers mailing list
>>serusers at lists.iptel.org
>>http://lists.iptel.org/mailman/listinfo/serusers
>>
>>.
>>
>> 
>>
>>    
>>
>
>
>
>.
>
>  
>




More information about the sr-users mailing list