[SR-Users] Can't login to Siremis.
Vicente
vicente at wipzona.es
Tue Jun 22 11:58:09 CEST 2010
You're wellcome.
It is good to know what was your problem and that it has been
solved.
Kind Regards.
Vicente.
El mar, 22-06-2010 a las 09:54 +0200, Henk Oegema escribió:
> 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/06e3d84e/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/06e3d84e/attachment.png>
More information about the sr-users
mailing list