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