<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.28.3">
</HEAD>
<BODY>
Vicente.<BR>
<BR>
Thanks for solving my problem. <IMG SRC="cid:1277192916.2261.20.camel@DELL" ALIGN="middle" ALT=":-)" BORDER="0"><BR>
You pointed me in the right direction.<BR>
<BR>
The mistake I made was this:<BR>
==================<BR>
When reading the website<BR>
<BR>
<B><I>Create user access table:</I></B>
<UL>
<LI>create a new table in <A HREF="http://www.kamailio.org">Kamailio (OpenSER)</A> database name ob_users:
</UL>
<PRE>
CREATE TABLE `ob_users` (
`SYSID` int(11) NOT NULL auto_increment,
`USERID` varchar(15) NOT NULL,
`PASSWORD` varchar(15) default NULL,
PRIMARY KEY (`SYSID`)
);
</PRE>
I created a new database ob_users with a table ob_users, in stead of inserting the table into the database openser.<BR>
<BR>
Thanks,<BR>
Henk<BR>
<BR>
<BR>
<BR>
On Tue, 2010-06-22 at 08:54 +0200, Vicente Ferrando Berenguer wrote:<BR>
<BLOCKQUOTE TYPE=CITE>
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?
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
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.
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
El 21/06/2010, a las 16:42, Henk Oegema escribió:
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BLOCKQUOTE TYPE=CITE>
Vicente<BR>
<BR>
<BR>
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><BR>
<BR>
<?xml version="1.0" standalone="no"?><BR>
<Config><BR>
<DataSource><BR>
<Database Name="Default" Driver="Pdo_Mysql" Server="localhost" DBName="openser" User="openser" Password="openserrw" /><BR>
<Database Name="Siremis" Driver="Pdo_Mysql" Server="localhost" DBName="openser" User="openser" Password="openserrw" /><BR>
</DataSource><BR>
</Config><BR>
==============================================================<BR>
<?xml version="1.0" standalone="no"?><BR>
<Config><BR>
<DataSource><BR>
<Database Name="Default" Driver="Pdo_Mysql" Server="192.168.1.14" DBName="openser" User="openser" Password="openserrw" /><BR>
<Database Name="Siremis" Driver="Pdo_Mysql" Server="192.168.1.14" DBName="openser" User="openser" Password="openserrw" /><BR>
</DataSource><BR>
</Config><BR>
=============================================================<BR>
<?xml version="1.0" standalone="no"?><BR>
<Config><BR>
<DataSource><BR>
<Database Name="Default" Driver="Pdo_Mysql" Server="127.0.0.1" DBName="openser" User="openser" Password="openserrw" /><BR>
<Database Name="Siremis" Driver="Pdo_Mysql" Server="127.0.0.1" DBName="openser" User="openser" Password="openserrw" /><BR>
</DataSource><BR>
</Config><BR>
<BR>
<BR>
On Mon, 2010-06-21 at 09:41 +0200, Vicente wrote:<BR>
<BLOCKQUOTE TYPE=CITE>
Hi,<BR>
<BR>
Have you tried this?<BR>
<TT><FONT COLOR="#3a3935">On 05/27/2010 10:15 AM, Elena-Ramona Modroiu wrote:</FONT></TT><BR>
<TT><FONT COLOR="#737373">> Note as well that in some OSes, connecting to openser database from</FONT></TT><BR>
<TT><FONT COLOR="#737373">> 127.0.0.1 is not same as localhost (which is used by kamctl to create</FONT></TT><BR>
<TT><FONT COLOR="#737373">> openser user and database), so try with localhost instead of 127.0.0.1</FONT></TT><BR>
<TT><FONT COLOR="#737373">> in siremis/metadata/Config.xml, in case you still get problems.</FONT></TT><BR>
<BR>
The problems you report seems to be related with the database connection settings.<BR>
<BR>
Regards. <BR>
<BR>
El dom, 20-06-2010 a las 18:10 +0200, Henk Oegema escribió:<BR>
<BLOCKQUOTE TYPE=CITE>
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. <BR>
Kamailio, the MySQL server and Siremis are running on the same server. The server is running Debian 5.0.4 <BR>
<BR>
I have followed the Siremis installation instructions at the following link: <A HREF="http://www.voipuser.org/ship_to.php?url=http://siremis.asipto.com/install/">http://siremis.asipto.com/install/</A> <BR>
<BR>
I reach a point were I can get to the Siremis web interface login page but when <B>I enter the user name and password nothing happens</B>. <BR>
<BR>
<BR>
/var/log/apache2/access.log :<BR>
=============================<BR>
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"<BR>
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"<BR>
192.168.1.101 - - [19/Jun/2010:15:53:22 +0200] "GET /siremis/js/sound.js HTTP/1.1" 404 270 "<A HREF="http://192.168.1.14/siremis/bin/">http://192.168.1.14/siremis/bin/</A>" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (lucid) Firefox/3.6.3"<BR>
192.168.1.101 - - [19/Jun/2010:15:53:23 +0200] "GET /siremis/js/sound.js HTTP/1.1" 404 270 "<A HREF="http://192.168.1.14/siremis/bin/">http://192.168.1.14/siremis/bin/</A>" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (lucid) Firefox/3.6.3"<BR>
192.168.1.101 - - [19/Jun/2010:15:53:38 +0200] "POST /siremis/bin/controller.php HTTP/1.1" 200 20 "<A HREF="http://192.168.1.14/siremis/bin/">http://192.168.1.14/siremis/bin/</A>" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Ubuntu/10.04 (lucid) Firefox/3.6.3"<BR>
<BR>
/var/log/apache2/error.log :<BR>
============================<BR>
[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: <A HREF="http://192.168.1.14/siremis/bin/">http://192.168.1.14/siremis/bin/</A><BR>
[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: <A HREF="http://192.168.1.14/siremis/bin/">http://192.168.1.14/siremis/bin/</A><BR>
<BR>
</BLOCKQUOTE>
</BLOCKQUOTE>
<BR>
<BR>
</BLOCKQUOTE>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
<BR>
</BLOCKQUOTE>
<BR>
</BODY>
</HTML>