New subject: Can't login to Siremis.

22 Jun 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/
 >   

Re: [SR-Users] Can't login to Siremis.