[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