H Dave,
Do you have siremis.user table?
If you don't, you should make it.
CREATE TABLE `users` ( `SYSID` int(11) NOT NULL auto_increment, `USERID` varchar(15) NOT NULL, `PASSWORD` varchar(15) default NULL, PRIMARY KEY (`SYSID`) );
insert into ob_users(USERID, PASSWORD) values ('admin', 'admin');
And then try to access through web.
Regards, Ivan
From: sr-users-bounces@lists.sip-router.org [mailto:sr-users-bounces@lists.sip-router.org] On Behalf Of dave mccann Sent: Monday, August 20, 2012 1:52 PM To: sr-users@lists.sip-router.org Subject: [SR-Users] Siremis login issue
Hi All
I have installed Kamailio with Siremis, Kamailio is working fine and starts and I have been through the initial setup for Siremis however when i go to login to the web management page it gives an error:
"Error in query:: SELECT T0.id, T0.username, T0.password, T0.enctype, T0.email, T0.status, T0.lastlogin, T0.lastlogout, T0.create_by, T0.create_time, T0.update_by, T0.update_time FROM `user` T0 WHERE T0.username='openser' and status='1' LIMIT 1. SQLSTATE[42S02]: Base table or view not found: 1146 Table 'siremis.user' doesn't exist"
I have tried the default "admin/admin" login as mentioned in the install guide and have also tried the default passwords for Kamailio "openser - (with default password 'openserrw') and openserro - (with default password 'openserro'). I have also tried root/*password* and also siremis/siremis which is contained in the /var/www/siremis-3.2.1/siremis/config.xml however none were successful and the same error appeared. I read that it was a permissions error however have set directory /var/www/siremis-3.2.1 to chmod 777 including all sub dirs and files.
Can anyone please help as this is that last bit that I need to overcome :)
Many thanks and best regards.
Dave