Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Wed May 24, 2017 2:12 am
VoIP Billing solution


All times are UTC




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Error in install script ./install-db.sh
PostPosted: Sat Aug 27, 2016 6:08 pm 
Offline

Joined: Sat Aug 20, 2016 4:38 pm
Posts: 11
[a2billing 2.2.0, Debian 8, asterisk 13]

I have spent weeks trying to install and reinstall a2billing - I keep getting stuck in meeting Checkpoint 1 : Check that the database (my2billing) and that (97) tables have been created. I ONLY GET 94 TABLES

When I run the ./install-db.sh script, I get a series of errors:

mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1067 (42000) at line 44: Invalid default value for 'datelastrun'

ERROR 1067 (42000) at line 34: Invalid default value for 'stopdate'

ERROR 1146 (42S02) at line 91: Table 'mya2billing.cc_version' doesn't exist
this gets repeated from line 91 to line 31 below
ERROR 1146 (42S02) at line 31: Table 'mya2billing.cc_version' doesn't exist

Anyone experienced this? Close to giving up on a2billing


Top
 Profile  
 
 Post subject: Re: Error in install script ./install-db.sh
PostPosted: Sun Aug 28, 2016 12:20 am 
Offline

Joined: Sat Aug 20, 2016 4:38 pm
Posts: 11
I think I have figured out the solution..

This is caused by the new mysql 5.7.6 having a sql_mode set by default to NO_ZERO_IN_DATE,NO_ZERO_DATE. This is what throws up the errors and prevents the creation of three tables.

The solution is to add the following in my.cnf under [mysqld]

sql_mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Then delete the old mya2billing database and re-run the two steps:
mysql -u root -p < DataBase/mysql-5.x/a2billing-createdb-user.sql followed by
./install-db.sh

It runs smoothly without errors and generates 97 tables.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 
VoIP Billing solution


All times are UTC


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group