<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
Hi All<br><br>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: <br><br><ul><li class="level1"><div class="li"> Create Siremis Database - this create database 'siremis'</div>
</li><li class="level1"><div class="li"> Import Default Data - this imports initial data into database 'siremis'</div>
</li><li class="level1"><div class="li"> Update SIP Database - this updates the structure of Kamailio database for accounting and charts modules</div>
</li><li class="level1"><div class="li"> Replace DB Config - this updates Siremis configuration file with the details to access databases</div></li></ul><br><BR>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.<br><BR><br><BR>Cheers guys<BR><br><BR>Dave<br><BR><br><br><div><div id="SkyDrivePlaceholder"></div>> From: sr-users-request@lists.sip-router.org<br>> Subject: sr-users Digest, Vol 87, Issue 64<br>> To: sr-users@lists.sip-router.org<br>> Date: Mon, 20 Aug 2012 16:17:22 +0200<br>> <br>> Send sr-users mailing list submissions to<br>> sr-users@lists.sip-router.org<br>> <br>> To subscribe or unsubscribe via the World Wide Web, visit<br>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users<br>> or, via email, send a message with subject or body 'help' to<br>> sr-users-request@lists.sip-router.org<br>> <br>> You can reach the person managing the list at<br>> sr-users-owner@lists.sip-router.org<br>> <br>> When replying, please edit your Subject line so it is more specific<br>> than "Re: Contents of sr-users digest..."<br>> <br>> <br>> Today's Topics:<br>> <br>> 1. Siremis login issue (dave mccann)<br>> 2. Re: Siremis login issue (Max M?hlbronner)<br>> 3. Re: [sr-dev] new feature: option to remove, contacts based on<br>> sip nat keepalives (Yufei Tao)<br>> 4. Re: Siremis login issue (Ivan Milivojevic)<br>> <br>> <br>> ----------------------------------------------------------------------<br>> <br>> Message: 1<br>> Date: Mon, 20 Aug 2012 12:51:57 +0100<br>> From: dave mccann <davemac2626@live.co.uk><br>> Subject: [SR-Users] Siremis login issue<br>> To: <sr-users@lists.sip-router.org><br>> Message-ID: <DUB117-W1040D3073CA62A3AE627CF787B90@phx.gbl><br>> Content-Type: text/plain; charset="iso-8859-1"<br>> <br>> <br>> Hi All<br>> <br>> 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:<br>> <br>> "Error in query:: SELECT T0.id, T0.username, T0.password, T0.enctype, <br>> T0.email, T0.status, T0.lastlogin, T0.lastlogout, T0.create_by, <br>> T0.create_time, T0.update_by, T0.update_time FROM `user` T0 WHERE <br>> T0.username='openser' and status='1' LIMIT 1. SQLSTATE[42S02]: Base <br>> table or view not found: 1146 Table 'siremis.user' doesn't exist"<br>> <br>> 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.<br>> <br>> Can anyone please help as this is that last bit that I need to overcome :)<br>> <br>> Many thanks and best regards.<br>> <br>> Dave<br>> <br>> -------------- next part --------------<br>> An HTML attachment was scrubbed...<br>> URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20120820/603aa6ab/attachment-0001.htm><br>> <br>> ------------------------------<br>> <br>> Message: 2<br>> Date: Mon, 20 Aug 2012 14:42:56 +0200<br>> From: Max M?hlbronner <mm@42com.com><br>> Subject: Re: [SR-Users] Siremis login issue<br>> To: "SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) -<br>> Users Mailing List" <sr-users@lists.sip-router.org><br>> Message-ID: <503230D0.9060007@42com.com><br>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed<br>> <br>> On 08/20/2012 01:51 PM, dave mccann wrote:<br>> > Base table or view not found: 1146 Table 'siremis.user' doesn't exist"<br>> <br>> I did not use siremis before, but the error indicates a problem with the <br>> DB setup. (table missing)<br>> <br>> Did you install/configure Database access correctly?<br>> <br>> <br>> Best Regards<br>> <br>> <br>> Max M.<br>> <br>> <br>> <br>> ------------------------------<br>> <br>> <br>> Message: 4<br>> Date: Mon, 20 Aug 2012 15:00:52 +0200<br>> From: Ivan Milivojevic <edesibe@googlemail.com><br>> Subject: Re: [SR-Users] Siremis login issue<br>> To: "'SIP Router - Kamailio \(OpenSER\) and SIP Express Router \(SER\)<br>> - Users Mailing List'" <sr-users@lists.sip-router.org><br>> Message-ID: <00f701cd7ed3$d56b2320$80416960$@com><br>> Content-Type: text/plain; charset="iso-8859-2"<br>> <br>> H Dave, <br>> <br>> Do you have siremis.user table?<br>> <br>> If you don't, you should make it.<br>> <br>> CREATE TABLE `users` (<br>> `SYSID` int(11) NOT NULL auto_increment,<br>> `USERID` varchar(15) NOT NULL,<br>> `PASSWORD` varchar(15) default NULL,<br>> PRIMARY KEY (`SYSID`)<br>> );<br>> <br>> insert into ob_users(USERID, PASSWORD) values ('admin', 'admin');<br>> <br>> And then try to access through web.<br>> <br>> Regards,<br>> Ivan<br>> <br>> <br>> From: sr-users-bounces@lists.sip-router.org<br>> [mailto:sr-users-bounces@lists.sip-router.org] On Behalf Of dave mccann<br>> Sent: Monday, August 20, 2012 1:52 PM<br>> To: sr-users@lists.sip-router.org<br>> Subject: [SR-Users] Siremis login issue<br>> <br>> Hi All<br>> <br>> I have installed Kamailio with Siremis, Kamailio is working fine and starts<br>> and I have been through the initial setup for Siremis however when i go to<br>> login to the web management page it gives an error:<br>> <br>> "Error in query:: SELECT T0.id, T0.username, T0.password, T0.enctype,<br>> T0.email, T0.status, T0.lastlogin, T0.lastlogout, T0.create_by,<br>> T0.create_time, T0.update_by, T0.update_time FROM `user` T0 WHERE<br>> T0.username='openser' and status='1' LIMIT 1. SQLSTATE[42S02]: Base table or<br>> view not found: 1146 Table 'siremis.user' doesn't exist"<br>> <br>> I have tried the default "admin/admin" login as mentioned in the install<br>> guide and have also tried the default passwords for Kamailio "openser -<br>> (with default password 'openserrw') and openserro - (with default password<br>> 'openserro'). I have also tried root/*password* and also siremis/siremis<br>> which is contained in the /var/www/siremis-3.2.1/siremis/config.xml however<br>> none were successful and the same error appeared. I read that it was a<br>> permissions error however have set directory /var/www/siremis-3.2.1 to chmod<br>> 777 including all sub dirs and files.<br>> <br>> Can anyone please help as this is that last bit that I need to overcome :)<br>> <br>> Many thanks and best regards.<br>> <br>> Dave<br>> -------------- next part --------------<br>> An HTML attachment was scrubbed...<br>> URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20120820/ecce70d0/attachment.htm><br>> <br>> ------------------------------<br>> <br>> _______________________________________________<br>> sr-users mailing list<br>> sr-users@lists.sip-router.org<br>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users<br>> <br>> <br>> End of sr-users Digest, Vol 87, Issue 64<br>> ****************************************<br></div> </div></body>
</html>