RHEL5.5 server Kamailio 3.0 built from source via Git Apache/2.2.3 PHP 5.3.2 MySQL 5.1.47 chown -R apache /var/www/html/siremis-1.0.0, apache is the httpd user. Used the instructions from Asipto's site for Siremis install and configure, added the alias to httpd.conf, Config.xml is: <?xml version="1.0" standalone="no"?> <Config> <DataSource> <Database Name="Default" Driver="Pdo_Mysql" Server="127.0.0.1" DBName="openser" User="openser" Password="*****" /> <Database Name="Siremis" Driver="Pdo_Mysql" Server="127.0.0.1" DBName="openser" User="openser" Password="*****" /> </DataSource> </Config> I navigate to the Siremis page, http://10.5.10.21/siremis/ and get the login screen, enter the login credentials, Submit, and nothing happens. httpd/error_log: [Wed May 26 12:49:45 2010] [error] [client 10.3.226.168] File does not exist: /var/www/html/siremis-1.0.0/siremis-web/js/sound.js, referer: http://10.5.10.21/siremis/bin/ [Wed May 26 12:49:45 2010] [error] [client 10.3.226.168] File does not exist: /var/www/html/siremis-1.0.0/siremis-web/js/sound.js, referer: http://10.5.10.21/siremis/bin/ I have wiped Siremis and done a fresh install, restarted httpd, and still nothing. Does anyone have ideas or suggestions on where else to look?

On 05/26/2010 04:20 PM, Elena-Ramona Modroiu wrote: Yes I do. Package matching php-mysql-5.1.6-27.el5.i386 already installed.

joe

On 05/26/2010 04:58 PM, Elena-Ramona Modroiu wrote: Exact same results, nothing happens.

httpd/error_log: [Wed May 26 13:59:33 2010] [error] [client 10.3.226.168] File does not exist: /var/www/html/siremis-1.0.0/siremis-web/js/sound.js, referer: http://10.5.10.21/siremis/bin/login.php httpd/access_log: 10.3.226.168 - - [26/May/2010:13:59:32 -0400] "GET /siremis/bin/home.php HTTP/1.1" 302 - "-" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Firefox/3.6.3" 10.3.226.168 - - [26/May/2010:13:59:32 -0400] "GET /siremis/bin/login.php HTTP/1.1" 200 2887 "-" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Firefox/3.6.3" 10.3.226.168 - - [26/May/2010:13:59:33 -0400] "GET /siremis/js/sound.js HTTP/1.1" 404 293 "http://10.5.10.21/siremis/bin/login.php" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Firefox/3.6.3" 10.3.226.168 - - [26/May/2010:13:59:44 -0400] "POST /siremis/bin/controller.php HTTP/1.1" 200 1208 "http://10.5.10.21/siremis/bin/login.php" "Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.3) Gecko/20100423 Firefox/3.6.3"

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 &lt;jmiccich(a)redhat.com&gt;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 >

I've verified ob_users table exists in openser db, and a select * from ob_users verifies I am using the correct login and password. mysql> select * from ob_users; +-------+--------+-----------+ | SYSID | USERID | PASSWORD | +-------+--------+-----------+ | 1 | admin | ***** | +-------+--------+-----------+ 1 row in set (0.00 sec)

On 05/27/2010 03:16 AM, Vicente wrote: Hi Vicente, I have cleared everything in my browsers and still no luck. I am primarily using Firefox and Chromium, and have tried Epiphany, Galeon, and even lynx. The lack of any error messages is frustrating. Is there any way to turn up debugging for Siremis?

Note as well that in some OSes, connecting to openser database from 127.0.0.1 is not same as localhost (which is used by kamctl to create openser user and database), so try with localhost instead of 127.0.0.1 in siremis/metadata/Config.xml, in case you still get problems.