why
"USE sys;"
"USE ispcp" should fit.
You want to do the changes in the ispcp database, wouldn't you?
And: I'd try first to regenerate only the domains, then - in a second step, the subdomains..
always see whats going on...
Maybe (I'm not sure, since I never did this all manually) you have to add some lines in the fresh file (from tpl). Start with this one (extracted from your above):
Code:
# httpd Data BEGIN.
#
# wget-hack prevention
#
<IfModule mod_rewrite.c>
RewriteEngine on
RewriteCond %{HTTP_USER_AGENT} ^LWP::Simple
RewriteRule ^/.* http://%{REMOTE_ADDR}/ [L,E=nolog:1]
</IfModule>
#
# Log processing.
#
LogFormat "%B" traff
LogFormat "%v %b %h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" ispcplog
CustomLog "| /var/www/ispcp/engine/ispcp-apache-logger" ispcplog
ErrorLog "| /var/www/ispcp/engine/ispcp-apache-logger -e"
#
# mod_cband configuration
#
<IfModule mod_cband.c>
CBandScoreFlushPeriod 10
CBandRandomPulse On
</IfModule>
#
# let the customer decide what charset he likes to use
#
AddDefaultCharset Off
#
# Header End
#
# httpd [with __MY_IP__] virtual host entry BEGIN.
NameVirtualHost with __MY_IP__:80
# httpd [{DMN_GRP}] dmn group entry BEGIN.
# httpd [{DMN_GRP}] dmn group entry END.
# httpd [{ALS_NAME}] als entry BEGIN.
# httpd [{ALS_NAME}] als entry END.
# httpd [with __MY_IP__] virtual host entry END.
# httpd [{IP}] virtual host entry BEGIN.
# httpd [{IP}] virtual host entry END.
# httpd Data END.
good luck
/J