[Serusers] SER + Mysql.so problem

[Greger V. Teigre]

http://www.google.com/search?hs=CDT&hl=en&lr=&client=opera&rls=en&q=site%3Amail.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