Bug

[fobicodam]

Reseller: 500 Mb - 2 MySQL
2 sites (whitout databases, 50 mb each)

When try to create the 3rd site:

You have left only 0 database(s) which you can assign to this website.

Maybe you are not looking for the "MySQL" checkbox ?

[falko]

We will check this.

[fobicodam]

Im working a lot right now, when i can find some time ill help you checking some code, i want to learn some php.

[djtremors]

I saw that too and found it to be taking the co-domain as a site as well.. ie.

www.mydomainsite.com (auto adds co-domain mydomainsite.com) = 2 sites.

I think I removed the non www site and it allowed 1 more. I'm not totally sure about this as it was a while and I allowed alot more now anyway.

[fobicodam]

But its not a sites problem, its a database one.

[hamish]

hi all

has anyone fixed this problem yet ?

cheers

hamish

[falko]

Not yet. We're quite busy, but it's in our bugtracker, so we won't forget that. :)

[hamish]

thanks falko - i saw it in the bugtracker and thought i'd check before looking at trying to fix it

hamish

[hamish]

I have tried recreating this bug with Fedora Core 5, ISPConfig ver 2.3.1, MySQL 5.0.22 but could not get it to happen.

I did following:
- created new reseller (500MB disk space, unlimited bandwith, 2 MySQL databases)
- created 6 new sites under reseller with varying amounts of disk space, DNS records but no databases enabled)

worked correctly - no error messages. Sats summary shows 0 of 2 databases used.

Also tried adding extra "A" DNS records to all sites - still no problems adding new sites.

I have updated bugtracker with findings and set to resolved/works for me.

[fobicodam]

:mad: because yo tested it on another Linux version, with a dev ispconfig ? i still have the same problem :mad: i had to set 50 databases to all my resellers to make it work, i hope nobody will sell more than 50 sites before the fix is done :mad:

[hamish]

fobicodam

it wasnt saying it is not an issue in 2.2.5 - i was trying to say that it appears to have been fixed in 2.3.1 (either intentionally or otherwise) :)

if you are unable to wait until 2.3.2 i will have a look at 2.2.5 and see if i can find the problem and get it fixed for the next release (2.2.6 ?)

hamish

[hamish]

I have found the problem and have a fix for it below (nned to edit one file). I have also checked the changes in to the open (dev) release 2.3.1.

You need to edit the following in the file /admispconfig/ispconfig/lib/classes/ispconfig_isp_web.lib.php

on approx line 280 make the code look as follows:

// Datenbanken
// if($reseller["limit_mysql"] == 1 && $reseller["limit_mysql_anzahl_dbs"] >= 0){
if($web["web_mysql"] == 1 && $reseller["limit_mysql_anzahl_dbs"] >= 0){
$datenbankanzahl = $go_api->db->queryOneRecord("SELECT sum(isp_isp_web.web_mysql_anzahl_dbs) as datenbankanzahl from isp_isp_web,isp_nodes where isp_isp_web.doc_id = isp_nodes.doc_id and isp_nodes.groupid = '$resellerid' and isp_nodes.doctype_id = ".$this->web_doctype_id." and isp_isp_web.web_mysql = 1");


on approx line 630 make the code look as follows:

// Datenbanken
// if($reseller["limit_mysql"] == 1 && $reseller["limit_mysql_anzahl_dbs"] >= 0){
if($web["web_mysql"] == 1 && $reseller["limit_mysql_anzahl_dbs"] >= 0){
$datenbankanzahl = $go_api->db->queryOneRecord("SELECT sum(isp_isp_web.web_mysql_anzahl_dbs) as datenbankanzahl from isp_isp_web,isp_nodes where isp_isp_web.doc_id = isp_nodes.doc_id and isp_nodes.groupid = '$resellerid' and isp_nodes.doctype_id = ".$this->web_doctype_id." and isp_isp_web.web_mysql = 1");

hope this helps

[fobicodam]

Thanks, ill check