Hi, do you have mysql module for php installed?

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

What do you get then for: http://10.5.10.21/siremis/bin/home.php

but you get redirected to login page, right?

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

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

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(a)redhat.com>om>: > 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(a)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(a)lists.sip-router.org > http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users >

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 05/27/2010 03:16 AM, Vicente wrote: 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?

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.