Hi All I managed to figure out that the table had not been created in the database. So i deleted the install.lock file in the Siremis directory to run the install again. This time I clicked on all the boxes that were on step 2:
Create Siremis Database - this create database 'siremis' Import Default Data - this imports initial data into database 'siremis' Update SIP Database - this updates the structure of Kamailio database for accounting and charts modules Replace DB Config - this updates Siremis configuration file with the details to access databases Then after it had finished I was able to login using the default admin/admin. Thanks for the reply Max greatly appreciated for the time taken to do so - Ivan - I didnt get chance to test what you had put however I will take a note of it for future reference.......hopefully I may be able to return the favor in the future if you guys need a hand. Cheers guys Dave > From: [email protected] > Subject: sr-users Digest, Vol 87, Issue 64 > To: [email protected] > Date: Mon, 20 Aug 2012 16:17:22 +0200 > > Send sr-users mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of sr-users digest..." > > > Today's Topics: > > 1. Siremis login issue (dave mccann) > 2. Re: Siremis login issue (Max M?hlbronner) > 3. Re: [sr-dev] new feature: option to remove, contacts based on > sip nat keepalives (Yufei Tao) > 4. Re: Siremis login issue (Ivan Milivojevic) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 20 Aug 2012 12:51:57 +0100 > From: dave mccann <[email protected]> > Subject: [SR-Users] Siremis login issue > To: <[email protected]> > Message-ID: <[email protected]> > Content-Type: text/plain; charset="iso-8859-1" > > > 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/603aa6ab/attachment-0001.htm> > > ------------------------------ > > Message: 2 > Date: Mon, 20 Aug 2012 14:42:56 +0200 > From: Max M?hlbronner <[email protected]> > Subject: Re: [SR-Users] Siremis login issue > To: "SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - > Users Mailing List" <[email protected]> > Message-ID: <[email protected]> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > On 08/20/2012 01:51 PM, dave mccann wrote: > > Base table or view not found: 1146 Table 'siremis.user' doesn't exist" > > I did not use siremis before, but the error indicates a problem with the > DB setup. (table missing) > > Did you install/configure Database access correctly? > > > Best Regards > > > Max M. > > > > ------------------------------ > > > Message: 4 > Date: Mon, 20 Aug 2012 15:00:52 +0200 > From: Ivan Milivojevic <[email protected]> > Subject: Re: [SR-Users] Siremis login issue > To: "'SIP Router - Kamailio \(OpenSER\) and SIP Express Router \(SER\) > - Users Mailing List'" <[email protected]> > Message-ID: <00f701cd7ed3$d56b2320$80416960$@com> > Content-Type: text/plain; charset="iso-8859-2" > > 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: [email protected] > [mailto:[email protected]] On Behalf Of dave mccann > Sent: Monday, August 20, 2012 1:52 PM > To: [email protected] > 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.htm> > > ------------------------------ > > _______________________________________________ > sr-users mailing list > [email protected] > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users > > > End of sr-users Digest, Vol 87, Issue 64 > ****************************************
_______________________________________________ SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list [email protected] http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
