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