8 Jun
2009
8 Jun
'09
11:28 a.m.
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