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 <[email protected]>: >> 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. >> >> [r...@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 [email protected] >> 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 >> [email protected] >> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users >> -- ================================================================== Joe Micciche [email protected] 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 [email protected] http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
