Can someone send me the structure of the auth_user table for CDRTool. I just
downloaded CDRTool-3.3.5 and followed the install instructions. When I run
"./setup_mysql.sh password localhost" I get the following error: ERROR 1146
(42S02) at line 1: Table 'cdrtool.auth_user' doesn't exist
Thanks,
Josh
I can not find a single reference to a table creation in any files. see
below:
[root@localhost CDRTool]# pwd
/var/www/CDRTool
[root@localhost CDRTool]# grep -R auth_user *
accounts_lib.phtml: $query="select * from auth_user";
accounts.phtml: $query="delete from auth_user";
accounts.phtml: $query="update auth_user set
accounts.phtml: $query="select * from auth_user";
accounts.phtml: $query="insert into auth_user
log.phtml: $query="select * from auth_user where perms like
'%admin%'";
phplib/local.inc: var $database_table = "auth_user";
phplib/local.inc: $this->db->query("select * from auth_user where
phplib/local.inc: $update="update auth_user
setup/mysql/alter_tables.mysql:alter table auth_user change column
only_customer domainFilter varchar(255) not null;
setup/mysql/alter_tables.mysql:alter table auth_user change column
only_cscode codeFilter varchar(255) not null;
setup/mysql/alter_tables.mysql:alter table auth_user change column only_cli
aNumberFilter varchar(255) not null;
setup/mysql/alter_tables.mysql:alter table auth_user change column
only_after_date afterDateFilter varchar(255) not null;
setup/mysql/alter_tables.mysql:alter table auth_user drop column
only_cardservice;
setup/mysql/alter_tables.mysql:alter table auth_user drop column
only_cardclass;
setup/mysql/alter_tables.mysql:alter table auth_user change column
display_card compidFilter varchar(255) not null;
setup/mysql/alter_tables.mysql:alter table auth_user add column
serviceFilter varchar(255) not null after codeFilter;
setup/mysql/alter_tables.mysql:alter table auth_user change column
codeFilter cscodeFilter varchar(255) not null;
setup/mysql/create_data.mysql:INSERT INTO auth_user VALUES
('c14cbf141ab1b7cd009356f555b607dc','admin','admin','admin,callsearch,statis
tics,sqlquery','2099-01-02','AG
Projects','Administrator','+31208005160','support(a)1example.com','1','','',''
,'','','','','ser_radius,cisco,asterisk,ser_acc,ser_missed_calls','0','','20
10-07-11 04:48:00','xj28k');
SOAP/server_lib.php: $query="select * from auth_user