[Serusers] SER + Mysql.so problem

[smy at addm.com]

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