[Serusers] SER + Remote MySQL Server

Fri Jul 1 16:06:17 CEST 2005

This works perfectly!!! So, there no permisions problems... BTW, I using the
MySQL Server as a remote server for several others applications (Web Sites,
etc), so remote authentications are working fine...

-----Original Message-----
From: Karl H. Putz [mailto:kputz at columbus.rr.com] 
Sent: Friday, 01 July, 2005 10:21
To: Sebastian Kigelman
Cc: serusers at lists.iptel.org
Subject: RE: [Serusers] SER + Remote MySQL Server

Are you able to remotely connect to mysql from the command line of your SER
machine?

mysql -h 192.168.1.1 -u ser -p heslo

Of course, use the IP address of your MySQL server.

There is some config you need to do on the MySQL side to allow connection
from a non-local
IP address.  Check the archives or the MySQL site for details on this is you
need it.

Karl Putz

>-----Original Message-----
>From: serusers-bounces at iptel.org [mailto:serusers-bounces at lists.iptel.org]On
>Behalf Of Sebastian Kigelman
>Sent: Friday, July 01, 2005 8:44 AM
>To: 'Iqbal'
>Cc: serusers at lists.iptel.org
>Subject: RE: [Serusers] SER + Remote MySQL Server
>
>
>I already try that, but I only get a message in the console saying:
>"Starting SER:", and nothing else happens... :-(
>
>-----Original Message-----
>From: Iqbal [mailto:iqbal at gigo.co.uk]
>Sent: Friday, 01 July, 2005 09:40
>To: Sebastian Kigelman
>Cc: serusers at lists.iptel.org
>Subject: Re: [Serusers] SER + Remote MySQL Server
>
>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
>>>
>>>.
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>.
>>
>>
>>
>
>
>_______________________________________________
>Serusers mailing list
>serusers at lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers
>