[Kamailio-Users] creating openser db on an external mysql server

[Daniel-Constantin Mierla]

On 05/07/2009 08:39 PM, Alex R.S.M wrote:
>
> root has full privilege and is accessible from remote connection. 
> This is how I granted:
>
> GRANT ALL ON *.* TO root@'%'

using % is not recommended at all - it is a high security risk.

Cheers,
Daniel

> IDENTIFIED BY '???';
>
>
>
> > Date: Thu, 7 May 2009 13:30:37 -0400
> > Subject: Re: [Kamailio-Users] creating openser db on an external 
> mysql server
> > From: osas at voipembedded.com
> > To: alex_rsm at hotmail.com
> > CC: miconda at gmail.com; users at lists.kamailio.org
> >
> > 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_rsm at 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: miconda at gmail.com
> > >> To: alex_rsm at hotmail.com
> > >> CC: users at 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_rsm at 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 at 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 at 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 at lists.kamailio.org
> > > http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
> > > http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
> > >
>
> ------------------------------------------------------------------------
> Hotmail® has ever-growing storage! Don’t worry about storage limits. 
> Check it out. 
> <http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutorial_Storage1_052009> 
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Kamailio (OpenSER) - Users mailing list
> Users at 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/