17 Jun
2004
17 Jun
'04
11:22 a.m.
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(a)bjut.edu.cn>
To: <serusers(a)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(a)iptel.org
http://mail.iptel.org/mailman/listinfo/serusers