mysql checkbox missing

Till, my mySQL version is "mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (x86_64) using readline 5.2". While I was searching for ENGINE meanwhile I read that TYPE is only an alias right now for ENGINE and will be obsolete in the future. So no idea, why exactly these tables show the upgrade problem. I did a diff between the database structure of .19 and .21 to see which tables have been changed.

 

Importing the db_ispconfig.sql from the .21 release doesn't show up any error when doing the import via phpmyadmin. Perhaps it fails while upgrading the database and having different types for these tables? I'm not able to verify this on my box due to it's a production system and no test installation is available atm.

 

I had the same problem with no Mysql checkbox and no databases showing in the options tab. I went from 2.2.6 to 2.2.21.

Falkos "replace doctype 1013 fix" solved the no checkbox problem.

 

I also had to do this:

ALTER TABLE `isp_isp_web` ADD `web_ruby` char( 1 ) default NULL;

Seems to me that the suggestion that the sql is buggy in a previous post may be correct.

Regards
Cambo

 

Till or Falko, will this be fixed in the next version?

 

It'S already fixed in SVN according to Till.

 

Hi, I had the same problem when upgrading to 2.2.21, and for me the tips in this thread also fixed (most of) the problems.
I say "most of" because one problem still persists, and that is that the database listings in ISP Site -> Options for each site is gone.

Is there a fix for this problem too?

EDIT: This applies only to existing databases, newly created ones shows up like they should. And of course the problem is because I had to recreate all site databases in PhpMyAdmin since my upgrading to ISPConfig 2.2.21 was done at the same time as moving to a new web server.
So I'll rephrase my question: Is there a way which I can make DB's created in PhpMyAdmin visible under ISP Site -> Options?

Regards
cbakken

 

I found a solution for the problem in my last post.

I created new databases with the same password as the original ones, and altered db names and users in table isp_isp_datenbank so they became the same as the originals.

Afterwards I deleted the newly created db's.

It works like a charm now, but does anyone see a problem with this approach?

Regards
cbakken

 

Should be ok.

 

Still got the same problem!?!

Hi Falko
Just wanted to let you know that there is still a problem with this doctype issue.

I have just done a fresh install, Perfect Mandriva Spring 2008, and ISPConfig *.22 on new hardware.

I got the error 'The requested document type does not exist.' in Management -> Settings and ISP Manager -> Reseller

I fixed that by copying my doctype table over from another server that I had already upgraded to .22 (also had the same problem when upgrading but managed to fix it).

There is no Mysql checkbox when adding a Reseller, but it allows me to put the number of databases. I have put 30 there.

When I try to add a new website, the Mysql checkbox is there, which I tick and select 1 in the amount field. but when I go to the next page, it says 'not allowed to add mysql databases'

I tried the replace doctype 1013 fix on page 3 of this thread, still no joy.

I tried a re-install, same result.

Any suggestions??

Thanks
Cambo

 

Did you set

Code:

default-character-set = latin1

in /etc/my.cnf, as shown on http://www.howtoforge.com/perfect-server-mandriva-2008.1-p5 ?

 

Hi Falko
I thought I had but when I checked it was utf8.
I think what happened is that skip-networking wasn't in my.cnf so I forgot to save to change it.
I have changed it now and restarted mysql. It all seems to be working.
Thanks
Cambo

 

Hi,
I've had the problem a few weeks ago.
The doctype crack helped, but suddenly I have the same problem again and the doctype Statement doesn't help anymore.

When I go the a web ISPconfig deletes its Database.
I allready lost a few, and I can't install them again.

 

I got it back, it disappeared when I disabled the frontpage extensions.
Is this bug now fixed?
Which latin1 charset has to be set and where?

 

phpmyadmin says: MySQL charset: UTF-8 Unicode (utf8)

I can't find default_charset in my my.cf (ubuntu)

 

Same issue

Hi guys,

I am having the exact same issue as described. I had one of my servers fail so I installed centOS 5.3 on a new system installed ISPConfig on the new server then copied over all the config files including the databases. First thing I noticed was the missing mysql checkbox in the site form, and in the reseller form. I was ok with that for the time being, until today after trying to setup a new domain, after saving it wiped out 2 of my databases, after looking the recycling bin I found it there, restored it but it did not restore back to disk or anywhere that I could find. It is not longer in the Recyling Bin or anywhere else. Luckily I had a backup so I was able to restore it from backup, but I am thinking this will happen again if I add another site. Any input is helpful.

Thanks

Paul

 

missing mysql

Hi Paul
Yes I found that will be the case. If you edit one of your current sites with ISPConfig not having the mysql checkbox available, it will remove your current db(s) associated with that site, so you need to be careful until you resolve this issue.
There is a resolution, as I had the same problem, but have fixed it now.
See my 2 posts on this page http://www.howtoforge.com/forums/showthread.php?t=20439&page=5 and refer to Falkos post here - http://www.howtoforge.com/forums/showpost.php?p=109399&postcount=25
That's what solved my "no mysql checkbox" issues.
Regards
Cambo