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,statistics,sqlquery','2099-01-02','AG
Projects','Administrator','+31208005160','support@1example.com','1','','','','','','','','ser_radius,cisco,asterisk,ser_acc,ser_missed_calls','0','','2010-07-11
04:48:00','xj28k');
SOAP/server_lib.php:
$query="select * from auth_user