22 Jun
2010
22 Jun
'10
5:58 a.m.
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/
>
