[Kamailio-Users] siremis

[Bruce Ferrell]

hh174 wrote:
> [2009-06-08 14:34:52 (GMT)] An exception occurred while executing this
> script:
> Error message: #0, SQLSTATE[HY000] [2003] Can't connect to MySQL server
> on 'sql.sipit.be' (13)
> Script name and line number of error:
> /var/www/siremis/openbiz/others/zendfrwk/library/Zend/Db/Adapter/Pdo/Abstract.php:131
> 
> 
> Hello Ramona,
> 
> I get this error with Siremis .
> [2009-06-08 14:34:52 (GMT)] An exception occurred while executing this
> script:
> Error message: #0, SQLSTATE[HY000] [2003] Can't connect to MySQL server
> on 'sql.sipit.be' (13)
> Script name and line number of error:
> /var/www/siremis/openbiz/others/zendfrwk/library/Zend/Db/Adapter/Pdo/Abstract.php:131
> 
> 
> 
> In fact, in the xml, there are 2 DB entries..
>    * edit file siremis/metadata/Config.xml and set MySQL server address,
> username, password and Kamailio (OpenSER) database name.
>       <Database Name="Default" Driver="Pdo_Mysql" Server="xx.sipit.xx"
> DBName="openserx" User="zzz" Password="xxx" />
>       <Database Name="Siremis" Driver="Pdo_Mysql" Server="xx.sipit.xx"
> DBName="openserx" User="zzz" Password="xxx" />
> 
> 
> I have a default entry and a siremis entry...
> Wich one has to be modified?
> Do I have to change the names?  (even when changed, it doesn't work)
> 
> ob_usershas been created.
> 
> 
> Kamailio version is 1.5.1
> Siremis is 0.9.2
> 
> what do I wrong?
> 
> Kind regards,
> 
> Olivier (The guy who where on the Fosdem restaurant in Brussels)
> 

Check the mysql permissions for the user on the database.

On the machine with siremis type:

  mysql -h xx.sipit.xx -u zzz -p openserx

enter the password you set when prompted.  If you get access denied, log
into mysql as the admin used (usually root, but it could be something
else) and type:

  grant all on openserx.* to 'zzz' identified by 'xxx';

you may have to use the form of 'zzz'@'machine' to get the grant right.

when the mysql line works, siremis should work as well, or at least THAT
error will go away.

Bruce