[Serusers] SER + Mysql.so problem

Greger V. Teigre greger at teigre.com
Thu Sep 22 07:54:45 CEST 2005


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 




More information about the sr-users mailing list