Quota/Limit MSSQL Database

Question

6.44K views05 - 09 - 2017

0

King-Dude 10 21 - 10 - 2016 0 Comments

Multiserver setup Windows 2016 and MSSQL 2016 Web.

I have set 5 database and 5 User limit in Hosting Plan and it showing 0 of 5 in SolidCP both on users and databases.(I have several user and databases, still 0 of 5)

And i can create more than 5 databases and/or users.

9 Answers

score 0 · Answer 1 · 2016-10-24T19:01:36+00:00

Hello,

I have fixed this issue in my recent commit.

To address this issue you will need to update your portal and enterprise (with database update) to resolve.

Current 1.1.1 update zips have the fix

You can download them here: http://installer.solidcp.com/Files/1.1.1/

(the zips have -update behind them)

i will be releasing a v1.1.2 update in a couple of days aswell so you can use the automated update script aswell.

Regards,

Marco

score 0 · Answer 2 · 2017-08-12T14:53:04+00:00

Hello

We have installed the new Version 1.1.2 and still facing same problem.

Every quotas are controlled perfectly except the SQL Server quotas.

SolidCp can not apply the limitation we have set in hosting plan for the sql server.

We create many users and databases in a customer,but still it counted as 0 in quotas report.

Please check this issue as soon as possible.

score 0 · Answer 3 · 2017-08-12T15:14:21+00:00

Hello,

The latest version is v1.2.1 which shouldn’t have this issue anymore (i believe it was fixed somewhere around v1.2.0)

Regards,

Marco

score 0 · Answer 4 · 2017-08-24T16:32:34+00:00

Thanks for your reply.

We have this issue in this version.

What should we do now?

score 0 · Answer 5 · 2017-08-25T23:23:43+00:00

do you mean you have updated to 1.2.1 and still have the issue?

or you have the issue in 1.1.2 but don’t want to update currently?

score 0 · Answer 6 · 2017-08-27T14:48:14+00:00

We have the issue in v1.1.2.

As you said you would releas a v1.1.2 update in a couple of days,we want to resolve the issue in 1.1.2.

For,now we can not perform update to v1.2,is there any special patch for v1.12?

score 0 · Answer 7 · 2017-08-27T16:24:42+00:00

Hmm, no you will have to go through all commits to find the specific commit that has the fix for it, as it’s made quite a long time ago i can’t tell which commit it was anymore

I would simply recommend to update to the latest version (as your quite a bit behind currently).

score 0 · Answer 8 · 2017-09-03T05:47:53+00:00

It seems that there is noway to install a specific patch?

As you know reinstalling SolidCp is a complicated process. I have over 300 domains and databases on my server. Can you give me a full detailed manual for upgrading SolidCp?

Server reliability and customers domains setting are very important for us

Thanks

score 0 · Answer 9 · 2017-09-05T13:44:30+00:00

Well for this issue i’m fairly sure it was a SQL variable that was off, only problem is finding the fix means going long back between tons of commits which makes it nearly impossible to find.

to update there’s several methods, an automated powershell method, aswell as manual ways here: https://solidcp.com/kb/update/

Quota/Limit MSSQL Database

9 Answers

Search questions

Question stats

Other Questions