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/