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