On 05/26/2010 04:20 PM, Elena-Ramona Modroiu wrote:

Hi,

do you have mysql module for php installed?

Yes I do.

Package matching php-mysql-5.1.6-27.el5.i386 already installed.

joe

Regards, Ramona

On 05/26/2010 10:07 PM, Joe Micciche wrote:

...

RHEL5.5 server Kamailio 3.0 built from source via Git Apache/2.2.3 PHP 5.3.2 MySQL 5.1.47

chown -R apache /var/www/html/siremis-1.0.0, apache is the httpd user.

Used the instructions from Asipto's site for Siremis install and configure, added the alias to httpd.conf, Config.xml is:

<?xml version="1.0" standalone="no"?>

<Config> <DataSource> <Database Name="Default" Driver="Pdo_Mysql" Server="127.0.0.1" DBName="openser" User="openser" Password="*****" /> <Database Name="Siremis" Driver="Pdo_Mysql" Server="127.0.0.1" DBName="openser" User="openser" Password="*****" /> </DataSource> </Config>

I navigate to the Siremis page, http://10.5.10.21/siremis/ and get the login screen, enter the login credentials, Submit, and nothing happens.

httpd/error_log: [Wed May 26 12:49:45 2010] [error] [client 10.3.226.168] File does not exist: /var/www/html/siremis-1.0.0/siremis-web/js/sound.js, referer: http://10.5.10.21/siremis/bin/ [Wed May 26 12:49:45 2010] [error] [client 10.3.226.168] File does not exist: /var/www/html/siremis-1.0.0/siremis-web/js/sound.js, referer: http://10.5.10.21/siremis/bin/

I have wiped Siremis and done a fresh install, restarted httpd, and still nothing.

Does anyone have ideas or suggestions on where else to look?

On 05/26/2010 04:58 PM, Elena-Ramona Modroiu wrote:

What do you get then for:

http://10.5.10.21/siremis/bin/home.php

Exact same results, nothing happens.

httpd/error_log: [Wed May 26 13:59:33 2010] [error] [client 10.3.226.168] File does not exist: /var/www/html/siremis-1.0.0/siremis-web/js/sound.js, referer: http://10.5.10.21/siremis/bin/login.php

httpd/access_log: 10.3.226.168 - - [26/May/2010:13:59:32 -0400] "GET /siremis/bin/home.php HTTP/1.1" 302 - "-" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Firefox/3.6.3" 10.3.226.168 - - [26/May/2010:13:59:32 -0400] "GET /siremis/bin/login.php HTTP/1.1" 200 2887 "-" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Firefox/3.6.3" 10.3.226.168 - - [26/May/2010:13:59:33 -0400] "GET /siremis/js/sound.js HTTP/1.1" 404 293 "http://10.5.10.21/siremis/bin/login.php" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Firefox/3.6.3" 10.3.226.168 - - [26/May/2010:13:59:44 -0400] "POST /siremis/bin/controller.php HTTP/1.1" 200 1208 "http://10.5.10.21/siremis/bin/login.php" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Firefox/3.6.3"

On 05/26/2010 05:19 PM, Elena-Ramona Modroiu wrote:

but you get redirected to login page, right?

Correct, redirects to http://10.5.10.21/siremis/bin/login.php.

Can you check into files from siremis/log/ to see if you spot something unusual?

Log has this repeated for every login attempt, there is nothing else in the log.

[root@s01 siremis-1.0.0]# cat siremis/log/log_DEBUG.html 26/May/2010:16:46:21 - (DEBUG | DATAOBJ) Query Sql = SELECT T0.SYSID, T0.USERID, T0.PASSWORD FROM ob_users T0 WHERE T0.USERID='admin' AND T0.PASSWORD='*****'

Also, can you create a simple php page to print the phpinfo() and double-check the mysql extension for php is enabled?

Hopefully this is what you're looking for, from phpinfo. Sorry my php skills aren't great.

mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 5.1.47 MYSQL_MODULE_TYPE external MYSQL_SOCKET /var/lib/mysql/mysql.sock MYSQL_INCLUDE -I/usr/include/mysql MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient

Directive Local Value Master Value mysql.allow_local_infile On On mysql.allow_persistent On On mysql.connect_timeout 60 60 mysql.default_host no value no value mysql.default_password no value no value mysql.default_port no value no value mysql.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock mysql.default_user no value no value mysql.max_links Unlimited Unlimited mysql.max_persistent Unlimited Unlimited mysql.trace_mode Off Off

pdo_mysql PDO Driver for MySQL enabled Client API version 5.1.47

Thanks for your help with this, Ramona.

Hi Laszlo, yes I created the table, added the user and password.

And Marc, neither enter nor using the mouse works. :)

joe

On 05/26/2010 07:03 PM, Laszlo wrote:

Joe,

These steps are also done by you, right?

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`) );

* add an user. Example, from MySQL client: insert into

ob_users(USERID, PASSWORD) values (‘admin’, ‘admin’);

-Laszlo

2010/5/27 Joe Micciche jmiccich@redhat.com:

...

On 05/26/2010 05:19 PM, Elena-Ramona Modroiu wrote:

...

but you get redirected to login page, right?

Correct, redirects to http://10.5.10.21/siremis/bin/login.php.

...

Can you check into files from siremis/log/ to see if you spot something unusual?

Log has this repeated for every login attempt, there is nothing else in the log.

[root@s01 siremis-1.0.0]# cat siremis/log/log_DEBUG.html 26/May/2010:16:46:21 - (DEBUG | DATAOBJ) Query Sql = SELECT T0.SYSID, T0.USERID, T0.PASSWORD FROM ob_users T0 WHERE T0.USERID='admin' AND T0.PASSWORD='*****'

...

Also, can you create a simple php page to print the phpinfo() and double-check the mysql extension for php is enabled?

Hopefully this is what you're looking for, from phpinfo. Sorry my php skills aren't great.

mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 5.1.47 MYSQL_MODULE_TYPE external MYSQL_SOCKET /var/lib/mysql/mysql.sock MYSQL_INCLUDE -I/usr/include/mysql MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient

Directive Local Value Master Value mysql.allow_local_infile On On mysql.allow_persistent On On mysql.connect_timeout 60 60 mysql.default_host no value no value mysql.default_password no value no value mysql.default_port no value no value mysql.default_socket /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock mysql.default_user no value no value mysql.max_links Unlimited Unlimited mysql.max_persistent Unlimited Unlimited mysql.trace_mode Off Off

pdo_mysql PDO Driver for MySQL enabled Client API version 5.1.47

Thanks for your help with this, Ramona.

--

Joe Micciche jmiccich@redhat.com Red Hat, Inc. http://www.redhat.com Senior Communications Engineer X(81) 44554

+1.919.754.4554

---

SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

Hi,

I also had similar problems to log into Siremis some weeks ago. It was caused by a combination of circumstances.

First I had an error with the mysql password configured for Siremis. No error messages pointed to that direction. After correcting the password, I couldn't connect. Then I removed the cookies and temp files on the browsers. And then I can login with Firefox or Camino. But still can't login with Safari.

What browser are you using?

El mié, 26-05-2010 a las 19:17 -0400, Joe Micciche escribió:

I've verified ob_users table exists in openser db, and a select * from ob_users verifies I am using the correct login and password.

mysql> select * from ob_users; +-------+--------+-----------+ | SYSID | USERID | PASSWORD | +-------+--------+-----------+ | 1 | admin | ***** | +-------+--------+-----------+ 1 row in set (0.00 sec)

On Thu, May 27, 2010 at 1:10 PM, Joe Micciche jmiccich@redhat.com wrote:

On 05/27/2010 03:16 AM, Vicente wrote:

...

Hi,

I also had similar problems to log into Siremis some weeks ago. It was caused by a combination of circumstances.

First I had an error with the mysql password configured for Siremis. No error messages pointed to that direction. After correcting the password, I couldn't connect. Then I removed the cookies and temp files on the browsers. And then I can login with Firefox or Camino. But still can't login with Safari.

What browser are you using?

Hi Vicente, I have cleared everything in my browsers and still no luck. I am primarily using Firefox and Chromium, and have tried Epiphany, Galeon, and even lynx.

The lack of any error messages is frustrating. Is there any way to turn up debugging for Siremis?

Hello,

I had a similar problem and solved it with that patch : http://siremis.svn.sourceforge.net/viewvc/siremis/trunk/siremis/bin/index.ph...

maybe it can help.

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

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.

Success! Changing 127.0.0.1 to localhost in Config.xml got it working.

Many thanks again Ramona and everyone else who jumped in!

- -- ================================================================== Joe Micciche jmiccich@redhat.com Red Hat, Inc. http://www.redhat.com Senior Communications Engineer X(81) 44554 +1.919.754.4554 Key: 65F90FE1 ==================================================================