[SR-Users] Siremis login issue

[Ivan Milivojevic]

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 at lists.sip-router.org
[mailto:sr-users-bounces at lists.sip-router.org] On Behalf Of dave mccann
Sent: Monday, August 20, 2012 1:52 PM
To: sr-users at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20120820/ecce70d0/attachment-0001.htm>