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@iptel.org [mailto:serusers-bounces@lists.iptel.org]On Behalf Of Sebastian Kigelman Sent: Friday, July 01, 2005 8:44 AM To: 'Iqbal' Cc: serusers@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@gigo.co.uk] Sent: Friday, 01 July, 2005 09:40 To: Sebastian Kigelman Cc: serusers@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@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
.
.
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers