abills.net.ua

Dear Friends,

I got backup for mysql and abills like mysqldump --quick -u root -p test > db_test_20120127.sql from Billing server. Then upload these files (db_abills_20130708.sql and db_mysql_20130708.sql )to new billing server via mysql -u root -p test < db_test_20120708.sql.

The upload process was successful. But I cannot access to new server via web interface and username password was changed. I have tried to access via old server username password and new server username password. But both of them not match to access account.

How to access to new server via web interface ?

BR
Battumur

check $conf{secretkey} on onl and new billings
it must be similar

I have checked secretkey and both of them same.

$conf{secretkey}="test12345678901234567890";
$conf{secretkey}="test12345678901234567890";


What could I do ?

BR
Battumur

also I found some diffrent from these as below,

Old server: $conf{version}='0.50b'; #02.04.2009
New server: $conf{version}='0.53b'; #05.04.2011




Old server: nothing
New server: $conf{USERS_WEB_ADMIN_ID}=3;

abills version does matter to this issue ?


BR
Battuur

if you use 0.50 dump in 0.53 system
you need to add changes from changelog

http://abills.net.ua/wiki/doku.php/abil ... elogs:0.5x

Thank you for your help,

Generally if I could reinstall Freebsd system and install same as old sever abills version 0.50 then it should be solve or not ?

old damop will work withot changes with same version of abills

I think as below is match to my new server abills system version.

04.04.2011

■
Добавлено уведомление о продлении услуги для модуля Abon

■
Добавлен внешний обработчик для модуля Abon. Разрешает запускать внешние программы при активации или блокировании услуги.

■
Комиссия за использование карточки оплаты

■
Добавлена плотность подключения в журнал адресов

■
Добавлен экспорт в XML журналов платежей и снятий

■
Список адресов с которых разрешено подключаться администратору $conf{ADMINS_ALLOW_IP};

■
Создание счёта при активации услуги модулем Abon (периодические платежи)

■
Периодическое оповещение о завершении услуги и отправка счёта на оплату для модуля Abon

■
Установка типа снятий для модуля Abon


MySQL:

ALTER TABLE abon_tariffs ADD COLUMN `activate_notification` tinyint(1) unsigned NOT NULL DEFAULT '0';
ALTER TABLE abon_tariffs ADD COLUMN `ext_cmd` VARCHAR(240) NOT NULL DEFAULT '';
ALTER TABLE abon_tariffs ADD COLUMN `create_account` tinyint(1) unsigned NOT NULL DEFAULT '0';
ALTER TABLE abon_tariffs ADD COLUMN `fees_type` tinyint(2) unsigned NOT NULL DEFAULT '0';
ALTER TABLE abon_tariffs ADD COLUMN `notification1` tinyint(1) unsigned NOT NULL DEFAULT '0';
ALTER TABLE abon_tariffs ADD COLUMN `notification2` tinyint(1) unsigned NOT NULL DEFAULT '0';
ALTER TABLE abon_tariffs ADD COLUMN `notification3` tinyint(1) unsigned NOT NULL DEFAULT '0';
ALTER TABLE abon_tariffs ADD COLUMN `notification_account` tinyint(1) unsigned NOT NULL DEFAULT '0';
ALTER TABLE abon_tariffs ADD COLUMN `alert` tinyint(1) unsigned NOT NULL DEFAULT '0';
ALTER TABLE abon_tariffs ADD COLUMN `alert_account` tinyint(1) unsigned NOT NULL DEFAULT '0';

ALTER TABLE abon_user_list ADD COLUMN `notification1` date NOT NULL default '0000-00-00';
ALTER TABLE abon_user_list ADD COLUMN `notification1_account_id` int(11) unsigned NOT NULL DEFAULT 0;
ALTER TABLE abon_user_list ADD COLUMN `notification2` date NOT NULL default '0000-00-00';

Then I have tried to add above configs but get a below error

mysql> ALTER TABLE abon_tariffs ADD COLUMN `activate_notification` tinyint(1) unsigned NOT NULL DEFAULT '0';
ERROR 1146 (42S02): Table 'mysql.abon_tariffs' doesn't exist
mysql>


What I need now ?

I have been re-installing new system again. But I need same as old server abills $conf{version}='0.50b'; #02.04.2009. Where can I download it ?

I have check this version from http://abills.net.ua/wiki/doku.php/abills but there has not like this version.

Please suggest me ?

BR
Battumur

As your suggest is 0.54. I need to 0.50b version. Please mind it,

Dear Friend,

I have installed same abills version that dump is working fine.

Thank you so much,


BR
Battumur

I have faced another issue that is Enter full pathname of shell or RETURN for /bin/sh after dump old server abills.sql and mysql.sql files to new server then restart. But cannot start my new server and get above issue .
I tried to fix /rescuer/sh fsck -y and mount -a but still same issue.

Please help me how to fix this problem?

BR
Battumur

think HHD is faild