You need to properly configure mysql by granting proper privileges for root for remote connections. This is not a kamailio issue.
Regards, Ovidiu Sas On Thu, May 7, 2009 at 1:14 PM, Alex R.S.M <alex_...@hotmail.com> wrote: > DBHOST is already set to the external server ip. > > DBHOST=<external_mysql_server_ip> > > The openser db is created but with no table. Here is the error I am getting: > > > MySQL password for root: > INFO: test server charset > INFO: creating database openser ... > ERROR 1044 (42000) at line 2: Access denied for user 'root'@'%' to database > 'openser' > ERROR: Creating core database and grant privileges failed! > > user "root" on all hosts ("%") is manually added. > > > > >> Date: Thu, 7 May 2009 17:56:54 +0200 >> From: mico...@gmail.com >> To: alex_...@hotmail.com >> CC: users@lists.kamailio.org >> Subject: Re: [Kamailio-Users] creating openser db on an external mysql >> server >> >> there is also the variant of setting DBHOST env variable. >> >> Cheers, >> Daniel >> >> On 05/07/2009 05:24 PM, Ovidiu Sas wrote: >> > Define the correct settings in kamctlrc. >> > >> > Regards, >> > Ovidiu Sas >> > >> > On Thu, May 7, 2009 at 11:19 AM, Alex R.S.M <alex_...@hotmail.com> >> > wrote: >> > >> >> Hi, >> >> >> >> Creating openser database on the localhost works fine using "kamdbctl >> >> create". >> >> >> >> However, I need to create openser database on an external mysql server. >> >> I >> >> tried the following command but it's not working: >> >> >> >> kamdbctl create openser@<external_mysql_server_ip> >> >> >> >> What's the correct command? >> >> >> >> Thanks, >> >> A R >> >> >> >> >> >> >> >> ________________________________ >> >> Windows Liveā¢: Keep your life in sync. Check it out. >> >> _______________________________________________ >> >> 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 >> >> >> >> >> > >> > _______________________________________________ >> > 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 >> > >> > >> >> -- >> Daniel-Constantin Mierla >> http://www.asipto.com/ >> > > ________________________________ > HotmailĀ® has a new way to see what's up with your friends. Check it out. > _______________________________________________ > 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 > _______________________________________________ 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