26 Sep
2005
26 Sep
'05
6:57 a.m.
Hi all,
After I played with the config file, I may have discovered something that may
cause the problem with remote DB.
Since I was following the onsip.org setup, I had a line in the config....
modparam("auth_db|permissions|uri_db|usrloc", "db_url",
"mysql://ser:heslo@localhost/ser")
then I've decided to use ACC for accounting, there fore I have added
acc related
modparam, including.....
modparam("acc", "db_url",
"mysql://ser:heslo@localhost/ser")
*******
Now, with localhost DB connection, everything worked out find. Once I switch
the localhost to another IP, it didn't connect. So after playing with SER for
a while, I have merged the acc to the first modparam line where it is now.....
modparam("acc|auth_db|permissions|uri_db|usrloc", "db_url",
"mysql://ser:heslo@xxx.xxx.xxx.xxx/ser")
Then all of a sudden, it worked!!! I have not done anything else other than
tweaking the config file. Thus I would like to know if the mysql.so can not
support multiple modparam db_url entries if I were to use a remote DB??? or
perhaps if this is a bug in the mysql.so???
This is only an elementary testing, thus I'm not even sure if I should
be fixing
the problem via this method. Perhaps all of you can give me some insights.
Thanks.
Best Regards,
Samuel Yeung
Quoting "Greger V. Teigre" <greger(a)teigre.com>om>:
If you have recently (re)installed mysql libraries,
you may also try
to make ser again to be absolutely sure that the db modules have been
linked correctly.
g-)
Simon wrote:
Sam,
Could you send your config file so that I can have a look at it.
I can only assume there is a fault somewhere there - you have not
defined a particular variable.
Simon
-----Original Message-----
From: smy(a)addm.com [mailto:smy@addm.com]
Sent: 22 September 2005 02:08
To: Simon
Cc: 'Greger V. Teigre'; serusers(a)lists.iptel.org
Subject: RE: [Serusers] SER + Mysql.so problem
Simon,
The connectivity from a remote source to the Mysql DB is working,
since
my other
apps are connecting to the DB. Also, your command has been tried and
succeeded,
since I'd have to do a similar DB connect for those Apps which has to
be connected to the DB server.
Are you running a separate DB / SER installation??? If so, any
insights are greatly appreciated.
Best Regards,
Samuel Yeung
Quoting Simon <sermail(a)systemsrm.co.uk>uk>:
Samuel,
My suggestion would be to test the remote working of mysql
separately. Have you tried running 'mysql --host
"my.remoteserver.com" -u?? -p??" to check basic connectivity.
If this works then it is definitely a config problem in ser.cfg.
Simon
-----Original Message-----
From: serusers-bounces(a)iptel.org [mailto:serusers-bounces@lists.iptel.org]
On Behalf Of smy(a)addm.com
Sent: 21 September 2005 20:33
To: Greger V. Teigre
Cc: serusers(a)lists.iptel.org
Subject: Re: [Serusers] SER + Mysql.so problem
Greger,
Thanks for suggesting the search..... yet I've read all these posts
previously
without a fix, at least not a clear answer on what to do. The only
thing that
remotely resembles to an answer is setting up the MYSQL environment
of which I've also tried.
Is there something that I have to recompile with the "-make url"
option of which
you've suggested in the search??
The ser.cfg has:
loadmodule "/usr/local/lib/ser/modules/mysql.so"
modparam("auth_db|permissions|uri_db|usrloc", "db_url",
?mysql://ser:heslo@xxx.xxx.xxx.xxx/ser")
Thanks
Best Regards,
Samuel Yeung
Quoting "Greger V. Teigre" <greger(a)teigre.com>om>:
http://www.google.com/search?hs=CDT&hl=en&lr=&client=opera&…
> ail.iptel.org+mysql+remote+-make+url&btnG=Search
>>
>> smy(a)addm.com wrote:
>>> Hi all,
>>>
>>> I've been working with SER + Mysql for over a month without any
>>> problems, yet all these (including the DB) are installed on the
>>> same server (LocalHost). I'm currently trying to centralize and
>>> securing all Data, thus would like to move all data to a
>>> centralized DB offsite.
>>>
>>> Now, I have SER DB migrated to this new DB server, and have changed
>>> the SER.cfg so that all mysql related loadmodule would be pointing
>>> to the proper server (ip address) instead of localhost. This is
>>> where the nightmare begins.
>>>
>>> The SER server can not seem to be connecting to the Mysql Server
>>> properly. Thus it took me over 3 days to debug and see if there
>>> were any auth problems from a remote site to the Mysql server.
>>> Apparently, remote auth & connect to the DB is working perfectly
>>> since I've installed other application which can connect to this DB
>>> server.
>>>
>>> So I've checked with the SER log + ngrep, of which to my amazement
>>> that the SER never sent any signals to the DB server. As soon as I
>>> moved the DB back to localhost, everything worked! My question is,
>>> is there something I need to configure in the mysql module so that
>>> it can work with a remote server????
>>>
>>> Any insight is greatly appreciated!!!
>>>
>>> Best Regards,
>>> Samuel Yeung
>>>
>>> _______________________________________________
>>> Serusers mailing list
>>> serusers(a)lists.iptel.org
>>> http://lists.iptel.org/mailman/listinfo/serusers
>>
>>
>
>
> _______________________________________________
> Serusers mailing list
> serusers(a)lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers