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 at lists.sip-router.org
> Subject: sr-users Digest, Vol 87, Issue 64
> To: sr-users at lists.sip-router.org
> Date: Mon, 20 Aug 2012 16:17:22 +0200
>
> Send sr-users mailing list submissions to
> sr-users at 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 at lists.sip-router.org
>
> You can reach the person managing the list at
> sr-users-owner at 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 at live.co.uk>
> Subject: [SR-Users] Siremis login issue
> To: <sr-users at lists.sip-router.org>
> Message-ID: <DUB117-W1040D3073CA62A3AE627CF787B90 at 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
>
> -------------- 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 <mm at 42com.com>
> Subject: Re: [SR-Users] Siremis login issue
> To: "SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) -
> Users Mailing List" <sr-users at lists.sip-router.org>
> Message-ID: <503230D0.9060007 at 42com.com>
> 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 <edesibe at googlemail.com>
> Subject: Re: [SR-Users] Siremis login issue
> To: "'SIP Router - Kamailio \(OpenSER\) and SIP Express Router \(SER\)
> - Users Mailing List'" <sr-users at lists.sip-router.org>
> 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: 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.htm>
>
> ------------------------------
>
> _______________________________________________
> sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
> End of sr-users Digest, Vol 87, Issue 64
> ****************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20120820/68e9a0f8/attachment-0001.htm>