On Freitag, 8. Mai 2009, Alex R.S.M wrote: > Hi, > > Still, I am have problem connecting kamailio to a remote mySQL. Here is > what I have done so far: > > Let's assume my kamailio and mySQL servers have the following IP: > Kamailio: 1.1.1.1 > mySQL: 2.2.2.2 > > > I granted "root" user to a access all tables from kamailio host: > GRANT ALL ON *.* TO root@'1.1.1.1' IDENTIFIED BY '????'; > > mysql> select host,user,password from user; > 1.1.1.1 | root | *669148??????????????????? > > > After that, I prefectly can connect to the remote mySQL from kamailio > directly using "root" user: mysql -h 2.2.2.2 -u root -p??? > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 18 > Server version: 5.0.51a-3ubuntu5.1-log (Ubuntu) > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > mysql> > > > However, When I try to create "openser" database using "kamdbctl create" > command I am getting the following error:
Hi Alex, i've tried to reproduce your problem on a remote mysql with db. I run into the same problem as you if i failed to grant the "Grant_priv" to my remote user. Can you take a look if the root user has this right? This right is aparently not included in '*.*'. Cheers, Henning
_______________________________________________ Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
