[Serusers] Re: error with cdrtool installation

[Adrian Georgescu]

Varala,

Please download 1.0.4 these problems have been corrected there.

Adrian

On Jun 3, 2004, at 10:54 AM, varala ramakanth wrote:

> hello adrian,
>
> now if i execute ./setup_mysql.sh i get this error
> [root at server mysql]# ./setup_mysql.sh
> ERROR 1136 at line 4: Column count doesn't match value
> count at row 1
>
> at line 4 i have
>
>
>
>
> i have checked the cdrtools database and destinations
>
> table in that i have seen that
>
> we have only four fields
>
> mysql> desc destinations
>     -> ;
> +-----------+---------------------+------+-----+--------- 
> +----------------+
> | Field     | Type                | Null | Key |
> Default | Extra          |
> +-----------+---------------------+------+-----+--------- 
> +----------------+
> | id        | bigint(20) unsigned |      | PRI | NULL
>   | auto_increment |
> | dest_id   | varchar(25)         |      | MUL |
>   |                |
> | dest_name | varchar(255)        |      |     |
>   |                |
> | language  | char(2)             |      |     | NL
>   |                |
> +-----------+---------------------+------+-----+--------- 
> +----------------+
> 4 rows in set (0.00 sec)
>
>
> but while insering form create_date.sql i observed
>
> this
>
> INSERT INTO destinations VALUES
> (1908,'9501','Conference','NL',0,0,0,0);
>
> so is this a bug or any other table values
>
>
>
> with regards
>
> rama kanth
>
>
> --- Adrian Georgescu <ag at ag-projects.com> wrote:
>> Try this
>>
>>
>> INSERT INTO auth_user VALUES
>>
> ('c14cbf141ab1b7cd009356f555b607dc','admin','admin','admin,callsearch,s 
> t
>>
>> atistics,sqlquery','2099-01-02','Amin user',
>> 'Admin
>> user','+878-11
>>
> -7472999222','support at x.com','1','1','','','','','','ser_radius,asteris 
> k
>>
>> ,ser_acc,cisco','0','','2006-05-14
>> 12:55:00','94nx9');
>>
>> On Jun 3, 2004, at 8:29 AM, varala ramakanth wrote:
>>
>>> INSERT INTO auth_user
>>>
>>
> (user_id,username,password,perms,expire,organization,name,tel,email,dis
>>
>>>
>>
> play_cli,dispaly_card,domainFilter,codeFilter,aNumberFilter,afterDateFi
>>
>>>
>>
> lter,sources,otp_enable,otp_rcpt,otp_expire,otp_passwd)
>>> VALUES
>>>
>>
> ('c14cbf141ab1b7cd009356f555b607dc','admin','admin','admin,callsearch,s
>>
>>> tatistics,sqlquery','2099-01-01','AG
>>> Projects','Adrian
>>> Georgescu','31-620-534309','support at ag-
>>> projects.com','1','1','','','','','0000-00
>>>
>>
> -00','ipnxcdr,ipnxlog,telecats,asterisk,cisco,ser','0','','2003-10-28
>>> 12:52:00','8n36r');
>>
>
>
>
> 	
> 		
> __________________________________
> Do you Yahoo!?
> Friends.  Fun.  Try the all-new Yahoo! Messenger.
> http://messenger.yahoo.com/