22 Sep
2005
22 Sep
'05
7:06 a.m.
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(a)addm.com [mailto:smy@addm.com]
Sent: 22 September 2005 02:08
To: Simon
Cc: 'Greger V. Teigre'; serusers(a)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(a)systemsrm.co.uk>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(a)iptel.org [mailto:serusers-bounces@lists.iptel.org] On
Behalf Of smy(a)addm.com
Sent: 21 September 2005 20:33
To: Greger V. Teigre
Cc: serusers(a)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(a)teigre.com>om>:
http://www.google.com/search?hs=CDT&hl=en&lr=&client=opera&…
ail.iptel.org+mysql+remote+-make+url&btnG=Search
smy(a)addm.com wrote:
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
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(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers