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 _______________________________________________ Kamailio (OpenSER) - Users mailing list [email protected] http://lists.kamailio.org/cgi-bin/mailman/listinfo/users http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
