[SR-Users] Can't login to Siremis.

Henk Oegema henk at oegema.com
Tue Jun 22 09:54:25 CEST 2010


Vicente.

Thanks for solving my problem.  :-)
You pointed me in the right direction.

The mistake I made was this:
==================
When reading the website

Create user access table:

      * create a new table in Kamailio (OpenSER) database name ob_users:

CREATE TABLE `ob_users` (
  `SYSID` int(11) NOT NULL auto_increment,
  `USERID` varchar(15) NOT NULL,
  `PASSWORD` varchar(15) default NULL,
  PRIMARY KEY  (`SYSID`)
);

I created a new database ob_users with a table ob_users, in stead of
inserting the table into the database openser.

Thanks,
Henk



On Tue, 2010-06-22 at 08:54 +0200, Vicente Ferrando Berenguer wrote:

> Have you created the ob_users table in openser database and added the
> openser user and password you are using? Is MySQL accepting the
> connection?
> 
> 
> 
> Quite a few things can fail but DB connection seems to be the most
> probable cause. Try with another browser also. Safari is not working
> for me. And you can also try to clean the browser cache and cookies.
> 
> 
> 
> El 21/06/2010, a las 16:42, Henk Oegema escribió:
> 
> 
> 
> > Vicente
> > 	
> > 
> > I've tried with Server="localhost', Server="192.168.1.14" and
> > Server="127.0.0.1, but I still can't login.  <face-sad.png>
> > 
> > <?xml version="1.0" standalone="no"?>
> > <Config>
> >    <DataSource>
> >                 <Database Name="Default" Driver="Pdo_Mysql"
> > Server="localhost" DBName="openser" User="openser"
> > Password="openserrw" />
> >                 <Database Name="Siremis" Driver="Pdo_Mysql"
> > Server="localhost" DBName="openser" User="openser"
> > Password="openserrw" />
> >    </DataSource>
> > </Config>
> > ==============================================================
> > <?xml version="1.0" standalone="no"?>
> > <Config>
> >    <DataSource>
> >                 <Database Name="Default" Driver="Pdo_Mysql"
> > Server="192.168.1.14" DBName="openser" User="openser"
> > Password="openserrw" />
> >                 <Database Name="Siremis" Driver="Pdo_Mysql"
> > Server="192.168.1.14" DBName="openser" User="openser"
> > Password="openserrw" />
> >    </DataSource>
> > </Config>
> > =============================================================
> > <?xml version="1.0" standalone="no"?>
> > <Config>
> >    <DataSource>
> >                 <Database Name="Default" Driver="Pdo_Mysql"
> > Server="127.0.0.1" DBName="openser" User="openser"
> > Password="openserrw" />
> >                 <Database Name="Siremis" Driver="Pdo_Mysql"
> > Server="127.0.0.1" DBName="openser" User="openser"
> > Password="openserrw" />
> >    </DataSource>
> > </Config>
> > 
> > 
> > On Mon, 2010-06-21 at 09:41 +0200, Vicente wrote:
> > 
> > >     Hi,
> > > 
> > >     Have you tried this?
> > > On 05/27/2010 10:15 AM, Elena-Ramona Modroiu wrote:
> > > > Note as well that in some OSes, connecting to openser database
> > > from
> > > > 127.0.0.1 is not same as localhost (which is used by kamctl to
> > > create
> > > > openser user and database), so try with localhost instead of
> > > 127.0.0.1
> > > > in siremis/metadata/Config.xml, in case you still get problems.
> > >     
> > >     The problems you report seems to be related with the database
> > > connection settings.
> > > 
> > >     Regards. 
> > > 
> > > El dom, 20-06-2010 a las 18:10 +0200, Henk Oegema escribió:
> > > 
> > > > I'm trying to install Siremis 1.0.0 to work with Kamailio 3.0
> > > > and I'm having some problems which hopefully somebody can help
> > > > with. 
> > > > Kamailio, the MySQL server and Siremis are running on the same
> > > > server. The server is running Debian 5.0.4 
> > > > 
> > > > I have followed the Siremis installation instructions at the
> > > > following link: http://siremis.asipto.com/install/ 
> > > > 
> > > > I reach a point were I can get to the Siremis web interface
> > > > login page but when I enter the user name and password nothing
> > > > happens. 
> > > > 
> > > > 
> > > > /var/log/apache2/access.log :
> > > > =============================
> > > > 192.168.1.101 - - [19/Jun/2010:15:53:22 +0200] "GET /siremis/
> > > > HTTP/1.1" 302 271 "-" "Mozilla/5.0 (X11; U; Linux i686; en-US;
> > > > rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (lucid) Firefox/3.6.3"
> > > > 192.168.1.101 - - [19/Jun/2010:15:53:22 +0200]
> > > > "GET /siremis/bin/ HTTP/1.1" 200 1083 "-" "Mozilla/5.0 (X11; U;
> > > > Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04
> > > > (lucid) Firefox/3.6.3"
> > > > 192.168.1.101 - - [19/Jun/2010:15:53:22 +0200]
> > > > "GET /siremis/js/sound.js HTTP/1.1" 404 270
> > > > "http://192.168.1.14/siremis/bin/" "Mozilla/5.0 (X11; U; Linux
> > > > i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (lucid)
> > > > Firefox/3.6.3"
> > > > 192.168.1.101 - - [19/Jun/2010:15:53:23 +0200]
> > > > "GET /siremis/js/sound.js HTTP/1.1" 404 270
> > > > "http://192.168.1.14/siremis/bin/" "Mozilla/5.0 (X11; U; Linux
> > > > i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (lucid)
> > > > Firefox/3.6.3"
> > > > 192.168.1.101 - - [19/Jun/2010:15:53:38 +0200]
> > > > "POST /siremis/bin/controller.php HTTP/1.1" 200 20
> > > > "http://192.168.1.14/siremis/bin/" "Mozilla/5.0 (X11; U; Linux
> > > > i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (lucid)
> > > > Firefox/3.6.3"
> > > > 
> > > > /var/log/apache2/error.log :
> > > > ============================
> > > > [Sat Jun 19 15:53:22 2010] [error] [client 192.168.1.101] File
> > > > does not exist: /var/www/siremis-1.0.0/siremis-web/js/sound.js,
> > > > referer: http://192.168.1.14/siremis/bin/
> > > > [Sat Jun 19 15:53:23 2010] [error] [client 192.168.1.101] File
> > > > does not exist: /var/www/siremis-1.0.0/siremis-web/js/sound.js,
> > > > referer: http://192.168.1.14/siremis/bin/
> > > > 
> > 
> > 
> > 
> 
> 
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20100622/03843561/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: face-smile.png
Type: image/png
Size: 873 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20100622/03843561/attachment.png>


More information about the sr-users mailing list