[SR-Users] Siremis 1.0 login fails (or, does nothing)

[Laszlo]

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 at 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 at 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 at 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 at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>