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: sr-users-request@lists.sip-router.org Subject: sr-users Digest, Vol 87, Issue 64 To: sr-users@lists.sip-router.org Date: Mon, 20 Aug 2012 16:17:22 +0200
Send sr-users mailing list submissions to sr-users@lists.sip-router.org
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 sr-users-request@lists.sip-router.org
You can reach the person managing the list at sr-users-owner@lists.sip-router.org
When replying, please edit your Subject line so it is more specific than "Re: Contents of sr-users digest..."
Today's Topics:
- Siremis login issue (dave mccann)
- Re: Siremis login issue (Max M?hlbronner)
- Re: [sr-dev] new feature: option to remove, contacts based on sip nat keepalives (Yufei Tao)
- Re: Siremis login issue (Ivan Milivojevic)
Message: 1 Date: Mon, 20 Aug 2012 12:51:57 +0100 From: dave mccann davemac2626@live.co.uk Subject: [SR-Users] Siremis login issue To: sr-users@lists.sip-router.org Message-ID: DUB117-W1040D3073CA62A3AE627CF787B90@phx.gbl 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