Package upgrade

[kotso]

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.

[BeNe]

With "package" you mean the Hosting Plans ?

Greez BeNe

[kotso]

Yes, Sory

[kilburn]

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).

[kotso]

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)

[kilburn]

Ispcp's documentation link: regenerate the config files howto.