Re: [Serusers] DB Error(table admin_privileges not exist) when usingserweb - sr-users

17 Jun 2004


      I find the reason. The version of SER that I used is branch 0.8.12 from CVS server. But SERWEB is compliant with CVS branch 0.8.13. The file ser_mysql.sh from branch 0.8.13 create table admin_privileges.
So are there a branch of SERWEB support SER 0.8.12 ?
Jimmy
----- Original Message ----- 
From: "wangji" wangji@bjut.edu.cn
To: serusers@iptel.org
Sent: Thursday, June 17, 2004 7:39 PM
Subject: [Serusers] DB Error(table admin_privileges not exist) when usingserweb
...
Hi all,
    I got a DB error when I tried to login into serweb(both admin and user_interface). 
   The message showing on IE is "DB Error: no such table, file: /var/www/novsky.com/serweb/html/data_layer.php:405". 
   I checked mysql's log. It query DB ser, is:
    select priv_name, priv_value from admin_privileges where username = 'admin' and domain = 'iptel.org' and (priv_name = 'change_privileges' or priv_name = 'is_admin');
   That table "admin_privileges" is not exist.
   In DB ser, there are these tables:
+-----------------------+
| Tables_in_ser         |
+-----------------------+
| acc                   |
| active_sessions       |
| aliases               |
| config                |
| domain                |
| event                 |
| grp                   |
| location              |
| missed_calls          |
| pending               |
| phonebook             |
| preferences           |
| reserved              |
| server_monitoring     |
| server_monitoring_agg |
| silo                  |
| subscriber            |
| uri                   |
| version               |
+-----------------------+
And these tables is created by ser_mysql.sh.
How can I do?
Best regards,
Jimmy
--------------------------------------------------------------------------------
...

Serusers mailing list
Serusers@iptel.org
http://mail.iptel.org/mailman/listinfo/serusers