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