[SR-Users] Siremis V2.0.0 Released - bug?

Jeremya jeremy at electrosilk.net
Tue Nov 2 07:57:24 CET 2010


Elena-Ramona Modroiu wrote:
> Hi,
>
> Siremis v2.0.0 is out – the web management interface for Kamailio
> (Openser) v3.1.0 and SIP Express Router (SER).

I downloaded and installed the latest source version of kamailio 3.1.0
(not git) and compiled an installed it. This works as expected.

I then downloaded siremis v 2.0.0 and installed it as instructed,
including creating the siremis tables etc. I can use it to some extent,
but the 'save' function for user edits fails. I can't change existing
users nor add new ones. The form just sits there

I can add roles and groups O.K.

The error message in CRIT.log is

'11/02/2010','06:55:11','CRIT','ErrorHandler','EVAL: $ret = guest, 3,
10; ',''


The user table structure is

mysql> explain user;
+-------------+------------------+------+-----+---------+----------------+
| Field       | Type             | Null | Key | Default | Extra          |
+-------------+------------------+------+-----+---------+----------------+
| id          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| username    | varchar(64)      | NO   | UNI |         |                |
| password    | varchar(64)      | NO   |     |         |                |
| enctype     | varchar(64)      | NO   |     | SHA1    |                |
| email       | varchar(64)      | YES  | MUL |         |                |
| status      | int(2)           | YES  |     | 1       |                |
| lastlogin   | datetime         | YES  |     | NULL    |                |
| lastlogout  | datetime         | YES  |     | NULL    |                |
| create_by   | int(10)          | YES  |     | 1       |                |
| create_time | datetime         | YES  |     | NULL    |                |
| update_by   | int(10)          | YES  |     | 1       |                |
| update_time | datetime         | YES  |     | NULL    |                |
+-------------+------------------+------+-----+---------+----------------+
12 rows in set (0.00 sec)

user table contents are

mysql> select * from user;
+----+----------+------------------------------------------+---------+------------------------+--------+---------------------+---------------------+-----------+---------------------+-----------+---------------------+
| id | username | password                                 | enctype |
email                  | status | lastlogin           |
lastlogout          | create_by | create_time         | update_by |
update_time         |
+----+----------+------------------------------------------+---------+------------------------+--------+---------------------+---------------------+-----------+---------------------+-----------+---------------------+
|  1 | admin    | d033e22ae348aeb5660fc2140aec35850c4da997 | SHA1    |
admin at yourcompany.com  |      1 | 2010-11-01 18:54:54 | 2009-08-24
13:24:14 |         1 | 2010-05-01 01:19:57 |         1 | 2010-11-01
18:54:54 |
|  2 | member   | 6467baa3b187373e3931422e2a8ef22f3e447d77 | SHA1    |
member at yourcompany.com |      1 | 2010-05-01 01:19:57 | 2009-08-23
23:39:37 |         1 | 2010-05-01 01:19:57 |         5 | 2010-05-01
01:19:57 |
|  3 | guest    | 35675e68f4b5af7b995d9205ad0fc43842f16450 | SHA1    |
guest at yourcompany.com  |      1 | NULL                |
NULL                |      NULL | 2010-01-12 02:20:10 |      NULL |
2010-01-12 02:20:10 |
+----+----------+------------------------------------------+---------+------------------------+--------+---------------------+---------------------+-----------+---------------------+-----------+---------------------+
3 rows in set (0.00 sec)

debug is

'11/01/2010','23:54:51','DEBUG','DATAOBJ','Query Sql = SELECT T0.id,
T0.username, T0.password, T0.enctype, T0.email, T0.status, T0.lastlogin,
T0.lastlogout, T0.create_by, T0.create_time, T0.update_by,
T0.update_time FROM  `user` T0   LIMIT 10 BIND: ','n/a'
'11/01/2010','23:54:55','DEBUG','DATAOBJ','Query Sql = SELECT T0.id,
T0.username, T0.password, T0.enctype, T0.email, T0.status, T0.lastlogin,
T0.lastlogout, T0.create_by, T0.create_time, T0.update_by,
T0.update_time FROM  `user` T0  WHERE T0.id = :_v1  LIMIT 1 BIND: 3','n/a'
'11/01/2010','23:54:55','DEBUG','DATAOBJ','Query Sql = SELECT T0.id,
T0.name, T0.description, T0.startpage, T0.status, T0.default FROM 
`role` T0  INNER JOIN `user_role` TX ON TX.role_id = T0.id  WHERE
TX.user_id = '3'  LIMIT 10 BIND: ','n/a'
'11/01/2010','23:54:55','DEBUG','DATAOBJ','Query Sql = SELECT T0.id,
T0.name, T0.description FROM  `group` T0  INNER JOIN `user_group` TX ON
TX.group_id = T0.id  WHERE TX.user_id = '3'  LIMIT 10 BIND: ','n/a'
'11/01/2010','23:54:56','DEBUG','DATAOBJ','Query Sql = SELECT T0.id,
T0.url, T0.cat_id, T0.timestamp FROM  `help_category_mapping` T0  WHERE
T0.url='system/user_detail/3'  BIND: ','n/a'
'11/01/2010','23:54:58','DEBUG','DATAOBJ','Query Sql = SELECT T0.id,
T0.username, T0.password, T0.enctype, T0.email, T0.status, T0.lastlogin,
T0.lastlogout, T0.create_by, T0.create_time, T0.update_by,
T0.update_time FROM  `user` T0  WHERE T0.id = :_v1  LIMIT 1 BIND: 3','n/a'
'11/01/2010','23:54:59','DEBUG','DATAOBJ','Query Sql = SELECT T0.id,
T0.url, T0.cat_id, T0.timestamp FROM  `help_category_mapping` T0  WHERE
T0.url='system/user_edit/3'  BIND: ','n/a'
'11/01/2010','23:55:11','DEBUG','DATAOBJ','Query Sql = SELECT T0.id,
T0.username, T0.password, T0.enctype, T0.email, T0.status, T0.lastlogin,
T0.lastlogout, T0.create_by, T0.create_time, T0.update_by,
T0.update_time FROM  `user` T0  WHERE T0.id = :_v1  LIMIT 1 BIND: 3','n/a'

Any help appreciated.

(P.S. The timezones seem to be different between DEBUG.log and CRIT.log)



More information about the sr-users mailing list