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

[Joe Micciche]

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 <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
>>

-- 
==================================================================
Joe Micciche                            jmiccich at redhat.com
Red Hat, Inc.                           http://www.redhat.com
Senior Communications Engineer          X(81) 44554
+1.919.754.4554
==================================================================