+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: Package upgrade (/thread-9647.html)
Package upgrade - kotso - 02-17-2010 04:36 PM
Hello,
I have question regarding packages.
As I guest package in ISPCP Omega is used only in account creation and later changes done with package does not change already existing user created with that package.
So currently I have following case: I have server with ~1200 users and around 5 packages.
I want to change 1 package (actually I have already changed but users under that package was not been updated).
Please advice is there any possibility to automate package upgrade process?
I have more then 300 users under that package and it's almost imposible to edit one by one.
RE: Package upgrade - BeNe - 02-17-2010 04:39 PM
With "package" you mean the Hosting Plans ?
Greez BeNe
RE: Package upgrade - kotso - 02-17-2010 05:09 PM
Yes, Sory
RE: Package upgrade - kilburn - 02-17-2010 05:51 PM
You can write a script to directly modify the corresponding fields in the "ispcp.domain" table. The only pitfall is that you also have to update the "current*" fields of the "ispcp.reseller_props" table (that keep track of the current amount of * assigned by the reseller).
For example, if you add one extra database for a user (update domain set domain_sqld_limit=domain_sqld_limit +1 where domain_id=xxx), you also have to increase by 1 the reseller assigned db count (update reseller_props set current_sql_db_cnt = current_sql_db_cnt + 1 where reseller_id = yyy).
RE: Package upgrade - kotso - 02-17-2010 08:11 PM
Ok, I can do that...
But, I changed bandwidth limit for users and as I see this limit is hard coded in apache configuration file (ispcp.conf)
So if change it in db probably it will not work...
How can I force ISPCP to regenerate apache conf if it's needed (I' sure it is)
RE: Package upgrade - kilburn - 02-17-2010 08:12 PM
Ispcp's documentation link: regenerate the config files howto.