bug report: issues with installation and update procedure from vhcs

[umaxx]

environment: debian etch (packages and installation as recommended in documentation)

fresh installed ispcp 1.0.0 rc7

running the update script (from vhcs 2.4.7.1) results in some issues:

1. update script works fine until customer regeneration -> trys to "run" regenrate.sql from wrong path /var/www/vhcs... instead of /var/www/ispcp...
-> script failed (though it was nearly finished - just regeneration was missing and restart of services)

-> ticket #1607

2. subdomain_alias table was completly missing - i have no idea if installation went wrong or update - i just added the table manually from debian/db/db.sql

-> fixed in ticket #1605

3. lang_* table was missing too

-> ticket #1608

4. vhcs templates uses ns.domain.tld -> ispcp uses ns1.domain.tld and ns2.domain.tld - which is imho a problem especially if using secondary dns and already registered all domains to ns.domain.tld and ns.secondary-dns.tld - better keep ns.domain.tld in addition to ns1 and ns2 on upgrade path...

-> ticket #1609

5. client/mail_accounts.php is still not working - resulting in a "query was empty" message

-> see below and ticket #1610

6. vhcs migrated "forward" mail addresses are seperated by multiple "^M" linebreak instead of "," resulting in broken aliases file -> the update script should take care of this!

-> ticket #1611

7. using ispCP under admin.domain.tld does not work with secondary dns and domain.tld configured in ispCP, the problem is: there is an "extra" admin.domain.tld.db file created for bind and domain.tld is created from database too. but AXFR is only done for domain.tld (of course).
-> admin.domain.tld need to be configured under domain.tld too (as usual).
-> the whole management of the admin-/gui-domain should not be seperated from the gui itself

-> ticket #1612

8. all migrated (from vhcs) htaccess users are set to status "NULL" in database, setting status by hand to "ok" solves problem

-> ticket #1613

9. webmail addressbooks from vhcs are not migrated to ispcp, the addressbook.ucf files from vhcs are easy to decode, but i have no idea how to add them to ispcps squirrelmail

-> ticket #1614

[umaxx]

(12-30-2008 08:04 AM)umaxx Wrote:  5. client/mail_accounts.php is still not working - resulting in a "query was empty" message

solved by searching the forum...
http://www.isp-control.net/forum/showthr...972&page=2

this seems to be a bug in RC7 (setup or update script).

setting "collation" off all "mail_users" columns to utf8_unicode_ci via pma solves this problem...
pma query:

Code:

ALTER TABLE `mail_users` CHANGE `mail_acc` `mail_acc` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
CHANGE `mail_pass` `mail_pass` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
CHANGE `mail_forward` `mail_forward` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
CHANGE `mail_type` `mail_type` VARCHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
CHANGE `status` `status` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL

[umaxx]

(12-30-2008 08:04 AM)umaxx Wrote:  2. subdomain_alias table was completly missing - i have no idea if installation went wrong or update - i just added the table manually from debian/db/db.sql

this seems to be fiexed with ticket: 1605