+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Update/Upgrade (/forum-44.html)
+--- Thread: bug report: issues with installation and update procedure from vhcs (/thread-5289.html)
bug report: issues with installation and update procedure from vhcs - umaxx - 12-30-2008 08:04 AM
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
RE: bug report: issues with installation and update procedure from vhcs - umaxx - 12-31-2008 08:27 PM
(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/showthread.php?tid=4972&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 NULLRE: bug report: issues with installation and update procedure from vhcs - umaxx - 01-18-2009 11:07 PM
(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