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(a)lists.sip-router.org
Subject: sr-users Digest, Vol 87, Issue 64
To: sr-users(a)lists.sip-router.org
Date: Mon, 20 Aug 2012 16:17:22 +0200
Send sr-users mailing list submissions to
sr-users(a)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(a)lists.sip-router.org
You can reach the person managing the list at
sr-users-owner(a)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:
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 <davemac2626(a)live.co.uk>
Subject: [SR-Users] Siremis login issue
To: <sr-users(a)lists.sip-router.org>
Message-ID: <DUB117-W1040D3073CA62A3AE627CF787B90(a)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