[Serusers] SER + Mysql.so problem

[smy at addm.com]

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 at teigre.com>:

> 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 at addm.com [mailto:smy at addm.com]
>> Sent: 22 September 2005 02:08
>> To: Simon
>> Cc: 'Greger V. Teigre'; serusers at 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 at systemsrm.co.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 at iptel.org [mailto:serusers-bounces at lists.iptel.org]
>>> On Behalf Of smy at addm.com
>>> Sent: 21 September 2005 20:33
>>> To: Greger V. Teigre
>>> Cc: serusers at 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 at teigre.com>:
>>>
>>>>
>>>
>> http://www.google.com/search?hs=CDT&hl=en&lr=&client=opera&rls=en&q=site%3Am
>>> ail.iptel.org+mysql+remote+-make+url&btnG=Search
>>>>
>>>> smy at 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 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
>
>