RE: [Serusers] SER + Remote MySQL Server

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(a)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: 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

>the ser_mysql.sh and serctl.sh scripts setting DBHOST=<MySQL IP Address>

>both files. I thought that those changes would allow to ser

>start using the remote MySQL server, but analyzing the ser debug

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

>located on a remote machine?... > > Thanxs in advance! > >Zeva > > >----- Original Message ----- >From: "Sebastian Kigelman" &lt;sebastian(a)kigelman.com.ar&gt; >To: &lt;serusers(a)lists.iptel.org&gt; >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

>>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"

>>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:

>>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

.