mysql checkbox missing

Ok,

So i upgraded (From a version that i dont know, but it wasnt the last one 2.2.20) to 2.2.21
I also had RoR installeed manually before...

After the upgrade no mysql ticket is shoing even on old ore new resellers, even on admin. Also i cant see the mysql ticket when i try to add a new reseller.

Thank You !

 

hello falko

I tried ugraded from 2.2.8 to 2.2.21 (on fedora core 5). It was faild becouse old libraries or something like that. but I lost whole /root/ispconfig directory. After upgrade (gcc/make/...) I installed 2.2.21. There was old ispconfig db in MySQL (and all others dbs). After that I was able to login to new 2.2.21 (as admin, I dont use resellers) but mysql button was gone.

Next weekend I did planed upgrade to CentOS, so I moved all (I hope) necessary data and install 2.2.21 from scratch. checkbox is still missing.

here are some pictures and one website db export. I hope it help...

hosting plan I used. There IS a checkbox!


affected website, basic tab. checkbox is missing.


options tab of this site.


db export for this site...
afected_web_export.zip

 

Falko, Till, if you could tell me where the visiblity flag is fetched (database/table) which blocks the display of the mysql checkbox I could have a look at. I cannot send my database due to it's a production site.

All other things are said, except something for the form designer. I checked the visibility flag there and it's set to true. So no idea, why the checkbox is shown for a hosting plan but didn't show up when creating/editing a reseller as admin.

 

This is set in the function web_show() in the file /home/admispconfig/ispconfig/lib/classes/ispconfig_isp_web.lib.php.

 

Can you try this?
Make a backup of your ISPConfig database, then delete the record with the doctype_id 1013 from the doctype table and insert the following record:

Code:

INSERT INTO `doctype` (`doctype_id`, `userid`, `groupid`, `doctype_modul`, `doctype_name`, `doctype_title`, `doctype_def`, `doctype_tree`) VALUES(1013, 1, 0, 'isp', 'isp_web', 'ISP Web', 'O:3:"doc":28:{s:6:"userid";s:1:"1";s:7:"groupid";s:1:"0";s:14:"group_required";s:1:"1";s:5:"modul";s:3:"isp";s:4:"tree";s:1:"1";s:7:"buttons";s:1:"1";s:4:"name";s:7:"isp_web";s:4:"type";s:9:"text/html";s:13:"template_type";s:4:"file";s:13:"template_path";N;s:12:"storage_type";s:2:"db";s:12:"storage_path";s:11:"isp_isp_web";s:10:"form_width";s:3:"450";s:4:"deck";a:8:{i:0;O:4:"deck":5:{s:8:"elements";a:35:{i:0;O:11:"optionField":21:{s:11:"option_type";s:8:"dropdown";s:6:"values";N;s:6:"source";s:2:"db";s:12:"source_table";s:10:"isp_server";s:11:"value_field";s:11:"server_name";s:8:"id_field";s:6:"doc_id";s:9:"css_class";s:0:"";s:4:"size";s:0:"";s:8:"multiple";N;s:5:"order";N;s:4:"name";s:9:"server_id";s:4:"type";s:11:"optionField";s:5:"title";s:6:"Server";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"1";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:1;O:9:"shortText":16:{s:5:"value";s:3:"www";s:9:"css_class";s:0:"";s:9:"maxlength";s:3:"255";s:8:"password";N;s:10:"write_once";N;s:4:"name";s:8:"web_host";s:4:"type";s:9:"shortText";s:5:"title";s:4:"Host";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"10";s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";s:25:"/^[\\\\w0-9\\\\-\\\\.]{0,255}$/";s:10:"reg_fehler";s:53:"Es sind nur folgende Zeichen erlaubt: a-z A-Z 0-9 - .";s:6:"search";s:1:"1";}i:3;O:9:"shortText":16:{s:5:"value";s:0:"";s:9:"css_class";s:0:"";s:9:"maxlength";s:3:"255";s:8:"password";N;s:10:"write_once";N;s:4:"name";s:10:"web_domain";s:4:"type";s:9:"shortText";s:5:"title";s:6:"Domain";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"30";s:7:"visible";s:1:"1";s:8:"required";s:1:"1";s:14:"reg_expression";s:0:"";s:10:"reg_fehler";s:51:"Es sind nur folgende Zeichen erlaubt: a-z A-Z 0-9 -";s:6:"search";s:1:"1";}i:4;O:11:"optionField":21:{s:11:"option_type";s:8:"dropdown";s:6:"values";N;s:6:"source";s:2:"db";s:12:"source_table";s:13:"isp_server_ip";s:11:"value_field";s:9:"server_ip";s:8:"id_field";s:9:"server_ip";s:9:"css_class";s:0:"";s:4:"size";s:0:"";s:8:"multiple";N;s:5:"order";N;s:4:"name";s:6:"web_ip";s:4:"type";s:11:"optionField";s:5:"title";s:10:"IP Adresse";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"1";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";s:1:"1";}i:5;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:7:"web_dns";s:4:"type";s:13:"checkboxField";s:5:"title";s:10:"Create DNS";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:6;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:10:"web_dns_mx";s:4:"type";s:13:"checkboxField";s:5:"title";s:13:"Create DNS-MX";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:7;O:14:"seperatorField":13:{s:5:"width";s:1:"1";s:9:"css_class";s:0:"";s:4:"name";s:2:"t1";s:4:"type";s:14:"seperatorField";s:5:"title";N;s:8:"language";s:2:"de";s:11:"description";N;s:6:"length";i:30;s:7:"visible";i:1;s:8:"required";i:1;s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:8;O:9:"shortText":16:{s:5:"value";s:2:"-1";s:9:"css_class";s:0:"";s:9:"maxlength";s:2:"10";s:8:"password";N;s:10:"write_once";N;s:4:"name";s:12:"web_speicher";s:4:"type";s:9:"shortText";s:5:"title";s:11:"Speicher MB";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"10";s:7:"visible";s:1:"1";s:8:"required";s:1:"1";s:14:"reg_expression";s:18:"/^[0-9\\\\-]{0,10}$/";s:10:"reg_fehler";s:27:"Es sind nur Zahlen erlaubt.";s:6:"search";s:1:"1";}i:9;O:9:"shortText":16:{s:5:"value";s:2:"-1";s:9:"css_class";s:0:"";s:9:"maxlength";s:2:"10";s:8:"password";N;s:10:"write_once";N;s:4:"name";s:11:"web_traffic";s:4:"type";s:9:"shortText";s:5:"title";s:10:"Traffic MB";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"10";s:7:"visible";s:1:"1";s:8:"required";s:1:"1";s:14:"reg_expression";s:17:"/^[0-9\\-]{0,10}$/";s:10:"reg_fehler";s:27:"Es sind nur Zahlen erlaubt.";s:6:"search";N;}i:10;O:11:"optionField":21:{s:11:"option_type";s:8:"dropdown";s:6:"values";a:3:{i:1;s:7:"sperren";i:2;s:15:"benachrichtigen";i:3;s:12:"keine Aktion";}s:6:"source";s:4:"list";s:12:"source_table";s:0:"";s:11:"value_field";s:0:"";s:8:"id_field";s:0:"";s:9:"css_class";s:0:"";s:4:"size";s:0:"";s:8:"multiple";N;s:5:"order";N;s:4:"name";s:27:"web_traffic_ueberschreitung";s:4:"type";s:11:"optionField";s:5:"title";s:22:"Traffic-Überschreitung";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"1";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:11;O:9:"shortText":16:{s:5:"value";s:2:"-1";s:9:"css_class";s:0:"";s:9:"maxlength";s:3:"255";s:8:"password";N;s:10:"write_once";N;s:4:"name";s:13:"web_userlimit";s:4:"type";s:9:"shortText";s:5:"title";s:9:"Max. User";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"10";s:7:"visible";s:1:"1";s:8:"required";s:1:"1";s:14:"reg_expression";s:18:"/^[0-9\\\\-]{0,10}$/";s:10:"reg_fehler";s:27:"Es sind nur Zahlen erlaubt.";s:6:"search";N;}i:12;O:9:"shortText":16:{s:5:"value";s:2:"-1";s:9:"css_class";s:0:"";s:9:"maxlength";s:3:"255";s:8:"password";N;s:10:"write_once";N;s:4:"name";s:15:"web_domainlimit";s:4:"type";s:9:"shortText";s:5:"title";s:11:"Max. Domain";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"10";s:7:"visible";s:1:"1";s:8:"required";s:1:"1";s:14:"reg_expression";s:18:"/^[0-9\\\\-]{0,10}$/";s:10:"reg_fehler";s:27:"Es sind nur Zahlen erlaubt.";s:6:"search";N;}i:13;O:14:"seperatorField":13:{s:5:"width";s:1:"1";s:9:"css_class";s:0:"";s:4:"name";s:2:"t2";s:4:"type";s:14:"seperatorField";s:5:"title";N;s:8:"language";s:2:"de";s:11:"description";N;s:6:"length";i:30;s:7:"visible";i:1;s:8:"required";i:1;s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:14;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:9:"web_shell";s:4:"type";s:13:"checkboxField";s:5:"title";s:13:"Shell Zugriff";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:15;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:7:"web_cgi";s:4:"type";s:13:"checkboxField";s:5:"title";s:11:"CGI Scripte";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:16;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:16:"web_standard_cgi";s:4:"type";s:13:"checkboxField";s:5:"title";s:13:"Standard CGIs";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:17;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:7:"web_php";s:4:"type";s:13:"checkboxField";s:5:"title";s:11:"PHP Scripte";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:18;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:17:"web_php_safe_mode";s:4:"type";s:13:"checkboxField";s:5:"title";s:13:"PHP Safe Mode";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:20;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:8:"web_ruby";s:4:"type";s:13:"checkboxField";s:5:"title";s:4:"Ruby";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:21;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:7:"web_ssi";s:4:"type";s:13:"checkboxField";s:5:"title";s:3:"SSI";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:22;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:7:"web_ftp";s:4:"type";s:13:"checkboxField";s:5:"title";s:10:"FTP Zugang";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:23;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:13:"web_frontpage";s:4:"type";s:13:"checkboxField";s:5:"title";s:9:"Frontpage";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:24;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:9:"web_mysql";s:4:"type";s:13:"checkboxField";s:5:"title";s:5:"MySQL";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:25;O:11:"optionField":21:{s:11:"option_type";s:8:"dropdown";s:6:"values";a:30:{i:1;s:1:"1";i:2;s:1:"2";i:3;s:1:"3";i:4;s:1:"4";i:5;s:1:"5";i:6;s:1:"6";i:7;s:1:"7";i:8;s:1:"8";i:9;s:1:"9";i:10;s:2:"10";i:11;s:2:"11";i:12;s:2:"12";i:13;s:2:"13";i:14;s:2:"14";i:15;s:2:"15";i:16;s:2:"16";i:17;s:2:"17";i:18;s:2:"18";i:19;s:2:"19";i:20;s:2:"20";i:21;s:2:"21";i:22;s:2:"22";i:23;s:2:"23";i:24;s:2:"24";i:25;s:2:"25";i:26;s:2:"26";i:27;s:2:"27";i:28;s:2:"28";i:29;s:2:"29";i:30;s:2:"30";}s:6:"source";s:4:"list";s:12:"source_table";s:0:"";s:11:"value_field";s:0:"";s:8:"id_field";s:0:"";s:9:"css_class";s:0:"";s:4:"size";s:0:"";s:8:"multiple";N;s:5:"order";N;s:4:"name";s:20:"web_mysql_anzahl_dbs";s:4:"type";s:11:"optionField";s:5:"title";s:18:"Anzahl Datenbanken";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"1";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:26;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:7:"web_ssl";s:4:"type";s:13:"checkboxField";s:5:"title";s:3:"SSL";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:27;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:11:"web_anonftp";s:4:"type";s:13:"checkboxField";s:5:"title";s:13:"Anonymous FTP";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:28;O:9:"shortText":16:{s:5:"value";s:2:"-1";s:9:"css_class";s:0:"";s:9:"maxlength";s:3:"255";s:8:"password";N;s:10:"write_once";N;s:4:"name";s:16:"web_anonftplimit";s:4:"type";s:9:"shortText";s:5:"title";s:12:"Anon. FTP MB";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"10";s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";s:18:"/^[0-9\\\\-]{0,10}$/";s:10:"reg_fehler";s:27:"Es sind nur Zahlen erlaubt.";s:6:"search";N;}i:29;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:14:"web_postgresql";s:4:"type";s:13:"checkboxField";s:5:"title";s:10:"postgreSQL";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"0";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:30;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:7:"web_wap";s:4:"type";s:13:"checkboxField";s:5:"title";s:3:"WAP";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:31;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:26:"web_individual_error_pages";s:4:"type";s:13:"checkboxField";s:5:"title";s:26:"Individuelle Fehler-Seiten";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:32;O:9:"shortText":16:{s:5:"value";s:0:"";s:9:"css_class";s:0:"";s:9:"maxlength";s:1:"1";s:8:"password";N;s:10:"write_once";N;s:4:"name";s:6:"status";s:4:"type";s:9:"shortText";s:5:"title";s:6:"Status";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:1:"1";s:7:"visible";s:1:"0";s:8:"required";s:1:"0";s:14:"reg_expression";s:0:"";s:10:"reg_fehler";s:0:"";s:6:"search";N;}i:33;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:18:"web_mailuser_login";s:4:"type";s:13:"checkboxField";s:5:"title";s:14:"Mailuser Login";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:34;O:14:"seperatorField":13:{s:5:"width";s:1:"1";s:9:"css_class";s:0:"";s:4:"name";s:5:"trweb";s:4:"type";s:14:"seperatorField";s:5:"title";N;s:8:"language";s:2:"de";s:11:"description";N;s:6:"length";i:30;s:7:"visible";i:1;s:8:"required";i:1;s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:35;O:8:"longText":18:{s:5:"value";s:0:"";s:12:"storage_type";s:2:"db";s:12:"storage_path";N;s:4:"wrap";s:8:"physical";s:9:"css_class";s:0:"";s:9:"maxlength";N;s:4:"rows";s:1:"5";s:4:"name";s:17:"web_httpd_include";s:4:"type";s:8:"longText";s:5:"title";s:13:"httpd_inc_txt";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"30";s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:36;O:11:"optionField":21:{s:11:"option_type";s:8:"dropdown";s:6:"values";a:3:{i:1;s:5:"aktiv";i:2;s:8:"gesperrt";s:0:"";N;}s:6:"source";s:4:"list";s:12:"source_table";s:0:"";s:11:"value_field";s:0:"";s:8:"id_field";s:0:"";s:9:"css_class";s:0:"";s:4:"size";s:0:"";s:8:"multiple";N;s:5:"order";N;s:4:"name";s:18:"web_traffic_status";s:4:"type";s:11:"optionField";s:5:"title";s:14:"Website-Status";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"1";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}}s:5:"title";s:5:"Basis";s:7:"visible";s:1:"1";s:9:"perm_read";s:1:"r";s:10:"perm_write";s:1:"a";}i:1;O:4:"deck":5:{s:8:"elements";a:1:{i:0;O:11:"attachField":16:{s:5:"value";N;s:7:"doctype";s:4:"1014";s:4:"view";s:4:"list";s:6:"fields";a:6:{s:13:"user_username";s:4:"User";s:9:"user_name";s:5:"Uname";s:10:"user_email";s:5:"Email";s:10:"user_admin";s:5:"Admin";s:18:"user_catchallemail";s:8:"CatchAll";s:0:"";N;}s:9:"css_class";s:2:"t2";s:4:"name";s:4:"user";s:4:"type";s:11:"attachField";s:5:"title";s:4:"User";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";i:1;s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}}s:5:"title";s:12:"User & Email";s:7:"visible";s:1:"1";s:9:"perm_read";s:1:"r";s:10:"perm_write";s:1:"w";}i:2;O:4:"deck":5:{s:8:"elements";a:1:{i:0;O:11:"attachField":16:{s:5:"value";N;s:7:"doctype";s:4:"1015";s:4:"view";s:4:"list";s:6:"fields";a:3:{s:9:"domain_ip";s:2:"IP";s:11:"domain_host";s:4:"Host";s:13:"domain_domain";s:6:"Domain";}s:9:"css_class";s:2:"t2";s:4:"name";s:10:"domain_abh";s:4:"type";s:11:"attachField";s:5:"title";s:7:"Domains";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";i:1;s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}}s:5:"title";s:10:"Co-Domains";s:7:"visible";s:1:"1";s:9:"perm_read";s:1:"r";s:10:"perm_write";s:1:"w";}i:3;O:4:"deck":5:{s:8:"elements";a:10:{i:1;O:11:"optionField":21:{s:11:"option_type";s:8:"dropdown";s:6:"values";a:238:{s:2:"AF";s:11:"Afghanistan";s:2:"AL";s:7:"Albania";s:2:"DZ";s:7:"Algeria";s:2:"AS";s:14:"American Samoa";s:2:"AD";s:7:"Andorra";s:2:"AO";s:6:"Angola";s:2:"AI";s:8:"Anguilla";s:2:"AQ";s:10:"Antarctica";s:2:"AG";s:19:"Antigua and Barbuda";s:2:"AR";s:9:"Argentina";s:2:"AM";s:7:"Armenia";s:2:"AW";s:5:"Aruba";s:2:"AU";s:9:"Australia";s:2:"AT";s:7:"Austria";s:2:"AZ";s:10:"Azerbaijan";s:2:"BS";s:7:"Bahamas";s:2:"BH";s:7:"Bahrain";s:2:"BD";s:10:"Bangladesh";s:2:"BB";s:8:"Barbados";s:2:"BY";s:7:"Belarus";s:2:"BE";s:7:"Belgium";s:2:"BZ";s:6:"Belize";s:2:"BJ";s:5:"Benin";s:2:"BM";s:7:"Bermuda";s:2:"BT";s:6:"Bhutan";s:2:"BO";s:7:"Bolivia";s:2:"BA";s:22:"Bosnia and Herzegovina";s:2:"BW";s:8:"Botswana";s:2:"BV";s:13:"Bouvet Island";s:2:"BR";s:6:"Brazil";s:2:"IO";s:28:"British Ind. Ocean Territory";s:2:"BN";s:17:"Brunei Darussalam";s:2:"BG";s:8:"Bulgaria";s:2:"BF";s:12:"Burkina Faso";s:2:"BI";s:7:"Burundi";s:2:"KH";s:8:"Cambodia";s:2:"CM";s:8:"Cameroon";s:2:"CA";s:6:"Canada";s:2:"CV";s:10:"Cape Verde";s:2:"KY";s:14:"Cayman Islands";s:2:"CF";s:24:"Central African Republic";s:2:"TD";s:4:"Chad";s:2:"CL";s:5:"Chile";s:2:"CN";s:5:"China";s:2:"CX";s:16:"Christmas Island";s:2:"CC";s:23:"Cocos (Keeling) Islands";s:2:"CO";s:8:"Colombia";s:2:"KM";s:7:"Comoros";s:2:"CG";s:5:"Congo";s:2:"CK";s:12:"Cook Islands";s:2:"CR";s:10:"Costa Rica";s:2:"CI";s:13:"Cote D''ivoire";s:2:"HR";s:7:"Croatia";s:2:"CU";s:4:"Cuba";s:2:"CY";s:6:"Cyprus";s:2:"CZ";s:14:"Czech Republic";s:2:"DK";s:7:"Denmark";s:2:"DJ";s:8:"Djibouti";s:2:"DM";s:8:"Dominica";s:2:"DO";s:18:"Dominican Republic";s:2:"TP";s:10:"East Timor";s:2:"EC";s:7:"Ecuador";s:2:"EG";s:5:"Egypt";s:2:"SV";s:11:"El Salvador";s:2:"GQ";s:17:"Equatorial Guinea";s:2:"ER";s:7:"Eritrea";s:2:"EE";s:7:"Estonia";s:2:"ET";s:8:"Ethiopia";s:2:"FK";s:27:"Falkland Islands (Malvinas)";s:2:"FO";s:13:"Faroe Islands";s:2:"FJ";s:4:"Fiji";s:2:"FI";s:7:"Finland";s:2:"FR";s:6:"France";s:2:"GF";s:13:"French Guiana";s:2:"PF";s:16:"French Polynesia";s:2:"TF";s:27:"French Southern Territories";s:2:"GA";s:5:"Gabon";s:2:"GM";s:6:"Gambia";s:2:"GE";s:7:"Georgia";s:2:"DE";s:7:"Germany";s:2:"GH";s:5:"Ghana";s:2:"GI";s:9:"Gibraltar";s:2:"GR";s:6:"Greece";s:2:"GL";s:9:"Greenland";s:2:"GD";s:7:"Grenada";s:2:"GP";s:10:"Guadeloupe";s:2:"GU";s:4:"Guam";s:2:"GT";s:9:"Guatemala";s:2:"GN";s:6:"Guinea";s:2:"GW";s:13:"Guinea-Bissau";s:2:"GY";s:6:"Guyana";s:2:"HT";s:5:"Haiti";s:2:"HM";s:27:"Heard and Mc Donald Islands";s:2:"HN";s:8:"Honduras";s:2:"HK";s:9:"Hong Kong";s:2:"HU";s:7:"Hungary";s:2:"IS";s:7:"Iceland";s:2:"IN";s:5:"India";s:2:"ID";s:9:"Indonesia";s:2:"IR";s:4:"Iran";s:2:"IQ";s:4:"Iraq";s:2:"IE";s:7:"Ireland";s:2:"IL";s:6:"Israel";s:2:"IT";s:5:"Italy";s:2:"JM";s:7:"Jamaica";s:2:"JP";s:5:"Japan";s:2:"JO";s:6:"Jordan";s:2:"KZ";s:10:"Kazakhstan";s:2:"KE";s:5:"Kenya";s:2:"KI";s:8:"Kiribati";s:2:"KP";s:5:"Korea";s:2:"KR";s:5:"Korea";s:2:"KW";s:6:"Kuwait";s:2:"KG";s:10:"Kyrgyzstan";s:2:"LA";s:28:"Lao People''s Democratic Rep.";s:2:"LV";s:6:"Latvia";s:2:"LB";s:7:"Lebanon";s:2:"LS";s:7:"Lesotho";s:2:"LR";s:7:"Liberia";s:2:"LY";s:22:"Libyan Arab Jamahiriya";s:2:"LI";s:13:"Liechtenstein";s:2:"LT";s:9:"Lithuania";s:2:"LU";s:10:"Luxembourg";s:2:"MO";s:5:"Macau";s:2:"MK";s:9:"Macedonia";s:2:"MG";s:10:"Madagascar";s:2:"MW";s:6:"Malawi";s:2:"MY";s:8:"Malaysia";s:2:"MV";s:8:"Maldives";s:2:"ML";s:4:"Mali";s:2:"MT";s:5:"Malta";s:2:"MH";s:16:"Marshall Islands";s:2:"MQ";s:10:"Martinique";s:2:"MR";s:10:"Mauritania";s:2:"MU";s:9:"Mauritius";s:2:"YT";s:7:"Mayotte";s:2:"MX";s:6:"Mexico";s:2:"FM";s:10:"Micronesia";s:2:"MD";s:7:"Moldova";s:2:"MC";s:6:"Monaco";s:2:"MN";s:8:"Mongolia";s:2:"MS";s:10:"Montserrat";s:2:"MA";s:7:"Morocco";s:2:"MZ";s:10:"Mozambique";s:2:"MM";s:7:"Myanmar";s:2:"NA";s:7:"Namibia";s:2:"NR";s:5:"Nauru";s:2:"NP";s:5:"Nepal";s:2:"NL";s:11:"Netherlands";s:2:"AN";s:20:"Netherlands Antilles";s:2:"NC";s:13:"New Caledonia";s:2:"NZ";s:11:"New Zealand";s:2:"NI";s:9:"Nicaragua";s:2:"NE";s:5:"Niger";s:2:"NG";s:7:"Nigeria";s:2:"NU";s:4:"Niue";s:2:"NF";s:14:"Norfolk Island";s:2:"MP";s:24:"Northern Mariana Islands";s:2:"NO";s:6:"Norway";s:2:"OM";s:4:"Oman";s:2:"PK";s:8:"Pakistan";s:2:"PW";s:5:"Palau";s:2:"PS";s:21:"Palestinian Territory";s:2:"PA";s:6:"Panama";s:2:"PG";s:16:"Papua New Guinea";s:2:"PY";s:8:"Paraguay";s:2:"PE";s:4:"Peru";s:2:"PH";s:11:"Philippines";s:2:"PN";s:8:"Pitcairn";s:2:"PL";s:6:"Poland";s:2:"PT";s:8:"Portugal";s:2:"PR";s:11:"Puerto Rico";s:2:"QA";s:5:"Qatar";s:2:"RE";s:7:"Reunion";s:2:"RO";s:7:"Romania";s:2:"RU";s:18:"Russian Federation";s:2:"RW";s:6:"Rwanda";s:2:"SH";s:12:"Saint Helena";s:2:"KN";s:21:"Saint Kitts And Nevis";s:2:"LC";s:11:"Saint Lucia";s:2:"PM";s:25:"Saint Pierre and Miquelon";s:2:"VC";s:26:"St. Vincent and Grenadines";s:2:"WS";s:5:"Samoa";s:2:"SM";s:10:"San Marino";s:2:"ST";s:21:"Sao Tome and Principe";s:2:"SA";s:12:"Saudi Arabia";s:2:"SN";s:7:"Senegal";s:2:"SC";s:10:"Seychelles";s:2:"SL";s:12:"Sierra Leone";s:2:"SG";s:9:"Singapore";s:2:"SK";s:8:"Slovakia";s:2:"SI";s:8:"Slovenia";s:2:"SB";s:15:"Solomon Islands";s:2:"SO";s:7:"Somalia";s:2:"ZA";s:12:"South Africa";s:2:"GS";s:24:"S.Georgia & S.Sandw.Isl.";s:2:"ES";s:5:"Spain";s:2:"LK";s:9:"Sri Lanka";s:2:"SD";s:5:"Sudan";s:2:"SR";s:8:"Suriname";s:2:"SJ";s:26:"Svalbard a. Jan Mayen Isl.";s:2:"SZ";s:9:"Swaziland";s:2:"SE";s:6:"Sweden";s:2:"CH";s:11:"Switzerland";s:2:"SY";s:20:"Syrian Arab Republic";s:2:"TW";s:6:"Taiwan";s:2:"TJ";s:10:"Tajikistan";s:2:"TZ";s:8:"Tanzania";s:2:"TH";s:8:"Thailand";s:2:"TG";s:4:"Togo";s:2:"TK";s:7:"Tokelau";s:2:"TO";s:5:"Tonga";s:2:"TT";s:19:"Trinidad and Tobago";s:2:"TN";s:7:"Tunisia";s:2:"TR";s:6:"Turkey";s:2:"TM";s:12:"Turkmenistan";s:2:"TC";s:24:"Turks and Caicos Islands";s:2:"TV";s:6:"Tuvalu";s:2:"UG";s:6:"Uganda";s:2:"UA";s:7:"Ukraine";s:2:"AE";s:20:"United Arab Emirates";s:2:"GB";s:14:"United Kingdom";s:2:"US";s:13:"United States";s:2:"UM";s:29:"United States Min. Outl. Isl.";s:2:"UY";s:7:"Uruguay";s:2:"UZ";s:10:"Uzbekistan";s:2:"VU";s:7:"Vanuatu";s:2:"VA";s:29:"Vatican City State (Holy See)";s:2:"VE";s:9:"Venezuela";s:2:"VN";s:7:"Vietnam";s:2:"VG";s:24:"Virgin Islands (British)";s:2:"VI";s:21:"Virgin Islands (U.S.)";s:2:"WF";s:25:"Wallis and Futuna Islands";s:2:"EH";s:14:"Western Sahara";s:2:"YE";s:5:"Yemen";s:2:"YU";s:10:"Yugoslavia";s:2:"ZM";s:6:"Zambia";s:2:"ZW";s:8:"Zimbabwe";}s:6:"source";s:4:"list";s:12:"source_table";s:0:"";s:11:"value_field";s:0:"";s:8:"id_field";s:0:"";s:9:"css_class";s:0:"";s:4:"size";s:0:"";s:8:"multiple";N;s:5:"order";N;s:4:"name";s:11:"ssl_country";s:4:"type";s:11:"optionField";s:5:"title";s:4:"Land";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:2;O:9:"shortText":16:{s:5:"value";s:0:"";s:9:"css_class";s:0:"";s:9:"maxlength";s:3:"255";s:8:"password";N;s:10:"write_once";N;s:4:"name";s:9:"ssl_state";s:4:"type";s:9:"shortText";s:5:"title";s:10:"Bundesland";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"30";s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";s:0:"";s:10:"reg_fehler";s:0:"";s:6:"search";N;}i:3;O:9:"shortText":16:{s:5:"value";s:0:"";s:9:"css_class";s:0:"";s:9:"maxlength";s:3:"255";s:8:"password";N;s:10:"write_once";N;s:4:"name";s:12:"ssl_locality";s:4:"type";s:9:"shortText";s:5:"title";s:3:"Ort";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"30";s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";s:0:"";s:10:"reg_fehler";s:0:"";s:6:"search";N;}i:4;O:9:"shortText":16:{s:5:"value";s:0:"";s:9:"css_class";s:0:"";s:9:"maxlength";s:3:"255";s:8:"password";N;s:10:"write_once";N;s:4:"name";s:16:"ssl_organization";s:4:"type";s:9:"shortText";s:5:"title";s:5:"Firma";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"30";s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";s:0:"";s:10:"reg_fehler";s:0:"";s:6:"search";N;}i:5;O:9:"shortText":16:{s:5:"value";s:0:"";s:9:"css_class";s:0:"";s:9:"maxlength";s:3:"255";s:8:"password";N;s:10:"write_once";N;s:4:"name";s:21:"ssl_organization_unit";s:4:"type";s:9:"shortText";s:5:"title";s:9:"Abteilung";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"30";s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";s:0:"";s:10:"reg_fehler";s:0:"";s:6:"search";N;}i:7;O:9:"shortText":16:{s:5:"value";s:3:"365";s:9:"css_class";s:0:"";s:9:"maxlength";s:3:"255";s:8:"password";N;s:10:"write_once";N;s:4:"name";s:8:"ssl_days";s:4:"type";s:9:"shortText";s:5:"title";s:17:"Gültigkeit (Tage)";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:1:"5";s:7:"visible";s:1:"1";s:8:"required";s:1:"1";s:14:"reg_expression";s:0:"";s:10:"reg_fehler";s:0:"";s:6:"search";N;}i:8;O:14:"seperatorField":13:{s:5:"width";s:1:"1";s:9:"css_class";s:0:"";s:4:"name";s:2:"t4";s:4:"type";s:14:"seperatorField";s:5:"title";N;s:8:"language";s:2:"de";s:11:"description";N;s:6:"length";i:30;s:7:"visible";i:1;s:8:"required";i:1;s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:9;O:8:"longText":18:{s:5:"value";s:0:"";s:12:"storage_type";s:2:"db";s:12:"storage_path";N;s:4:"wrap";s:8:"physical";s:9:"css_class";s:0:"";s:9:"maxlength";N;s:4:"rows";s:2:"10";s:4:"name";s:11:"ssl_request";s:4:"type";s:8:"longText";s:5:"title";s:11:"SSL Request";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"30";s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:10;O:8:"longText":18:{s:5:"value";s:0:"";s:12:"storage_type";s:2:"db";s:12:"storage_path";N;s:4:"wrap";s:8:"physical";s:9:"css_class";s:0:"";s:9:"maxlength";N;s:4:"rows";s:2:"10";s:4:"name";s:8:"ssl_cert";s:4:"type";s:8:"longText";s:5:"title";s:14:"SSL Zertifikat";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"30";s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:11;O:11:"optionField":21:{s:11:"option_type";s:8:"dropdown";s:6:"values";a:3:{s:6:"create";s:19:"Zertifikat erzeugen";s:4:"save";s:20:"Zertifikat speichern";s:6:"delete";s:18:"Zertifikat löschen";}s:6:"source";s:4:"list";s:12:"source_table";s:0:"";s:11:"value_field";s:0:"";s:8:"id_field";s:0:"";s:9:"css_class";s:0:"";s:4:"size";s:0:"";s:8:"multiple";N;s:5:"order";N;s:4:"name";s:10:"ssl_action";s:4:"type";s:11:"optionField";s:5:"title";s:6:"Aktion";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}}s:5:"title";s:3:"SSL";s:7:"visible";s:1:"1";s:9:"perm_read";s:1:"r";s:10:"perm_write";s:1:"w";}i:4;O:4:"deck":5:{s:8:"elements";a:4:{i:0;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:8:"web_shop";s:4:"type";s:13:"checkboxField";s:5:"title";s:10:"Shopsystem";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:1;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:14:"web_phpmyadmin";s:4:"type";s:13:"checkboxField";s:5:"title";s:10:"phpmyAdmin";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:2;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:11:"web_webmail";s:4:"type";s:13:"checkboxField";s:5:"title";s:7:"WebMail";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:3;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:13:"web_webalizer";s:4:"type";s:13:"checkboxField";s:5:"title";s:9:"Webalizer";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}}s:5:"title";s:6:"Pakete";s:7:"visible";s:1:"0";s:9:"perm_read";s:1:"r";s:10:"perm_write";s:1:"w";}i:5;O:4:"deck":5:{s:8:"elements";a:2:{i:0;O:11:"pluginField":13:{s:9:"css_class";N;s:7:"options";N;s:4:"name";s:14:"check_webspace";s:4:"type";s:11:"pluginField";s:5:"title";N;s:8:"language";s:2:"de";s:11:"description";N;s:6:"length";i:30;s:7:"visible";i:1;s:8:"required";i:1;s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:1;O:11:"pluginField":13:{s:9:"css_class";N;s:7:"options";N;s:4:"name";s:7:"traffic";s:4:"type";s:11:"pluginField";s:5:"title";N;s:8:"language";s:2:"de";s:11:"description";N;s:6:"length";i:30;s:7:"visible";i:1;s:8:"required";i:1;s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}}s:5:"title";s:9:"Statistik";s:7:"visible";s:1:"1";s:9:"perm_read";s:1:"r";s:10:"perm_write";s:1:"w";}i:6;O:4:"deck":5:{s:8:"elements";a:19:{i:0;O:11:"attachField":16:{s:5:"value";N;s:7:"doctype";s:4:"1029";s:4:"view";s:4:"list";s:6:"fields";a:2:{s:13:"datenbankname";s:13:"Datenbankname";s:13:"datenbankuser";s:13:"Datenbankuser";}s:9:"css_class";s:2:"t2";s:4:"name";s:17:"optionen_db_liste";s:4:"type";s:11:"attachField";s:5:"title";s:11:"Datenbanken";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";i:1;s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:1;O:9:"shortText":16:{s:5:"value";s:0:"";s:9:"css_class";s:0:"";s:9:"maxlength";s:3:"255";s:8:"password";N;s:10:"write_once";N;s:4:"name";s:19:"optionen_mysql_user";s:4:"type";s:9:"shortText";s:5:"title";s:10:"MySQL User";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"30";s:7:"visible";s:1:"0";s:8:"required";s:1:"0";s:14:"reg_expression";s:0:"";s:10:"reg_fehler";s:0:"";s:6:"search";N;}i:2;O:11:"pluginField":13:{s:9:"css_class";N;s:7:"options";N;s:4:"name";s:14:"check_database";s:4:"type";s:11:"pluginField";s:5:"title";N;s:8:"language";s:2:"de";s:11:"description";N;s:6:"length";i:30;s:7:"visible";i:1;s:8:"required";i:1;s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:3;O:9:"shortText":16:{s:5:"value";s:0:"";s:9:"css_class";s:0:"";s:9:"maxlength";s:3:"255";s:8:"password";s:1:"1";s:10:"write_once";N;s:4:"name";s:23:"optionen_mysql_passwort";s:4:"type";s:9:"shortText";s:5:"title";s:14:"MySQL Passwort";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"30";s:7:"visible";s:1:"0";s:8:"required";s:1:"0";s:14:"reg_expression";s:0:"";s:10:"reg_fehler";s:0:"";s:6:"search";N;}i:4;O:13:"checkboxField":13:{s:5:"value";N;s:9:"css_class";s:0:"";s:4:"name";s:28:"optionen_mysql_remote_access";s:4:"type";s:13:"checkboxField";s:5:"title";s:19:"MySQL Remote Access";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"0";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:5;O:9:"shortText":16:{s:5:"value";s:0:"";s:9:"css_class";s:0:"";s:9:"maxlength";s:3:"255";s:8:"password";s:1:"1";s:10:"write_once";N;s:4:"name";s:27:"optionen_frontpage_passwort";s:4:"type";s:9:"shortText";s:5:"title";s:18:"Frontpage Passwort";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"30";s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";s:0:"";s:10:"reg_fehler";s:0:"";s:6:"search";N;}i:6;O:11:"optionField":21:{s:11:"option_type";s:8:"dropdown";s:6:"values";a:2:{i:0;s:19:"externer mailserver";i:1;s:18:"lokaler mailserver";}s:6:"source";s:4:"list";s:12:"source_table";s:0:"";s:11:"value_field";s:0:"";s:8:"id_field";s:0:"";s:9:"css_class";s:0:"";s:4:"size";s:0:"";s:8:"multiple";N;s:5:"order";N;s:4:"name";s:25:"optionen_local_mailserver";s:4:"type";s:11:"optionField";s:5:"title";s:10:"Mailserver";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"1";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:7;O:9:"shortText":16:{s:5:"value";s:3:"30%";s:9:"css_class";s:0:"";s:9:"maxlength";s:3:"255";s:8:"password";N;s:10:"write_once";N;s:4:"name";s:16:"optionen_logsize";s:4:"type";s:9:"shortText";s:5:"title";s:10:"Log-Grösse";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"10";s:7:"visible";s:1:"1";s:8:"required";s:1:"1";s:14:"reg_expression";s:0:"";s:10:"reg_fehler";s:0:"";s:6:"search";N;}i:8;O:8:"longText":18:{s:5:"value";s:139:"index.html\r\nindex.htm\r\nindex.php\r\nindex.php5\r\nindex.php4\r\nindex.php3\r\nindex.shtml\r\nindex.cgi\r\nindex.pl\r\nindex.jsp\r\nDefault.htm\r\ndefault.htm";s:12:"storage_type";s:2:"db";s:12:"storage_path";N;s:4:"wrap";s:8:"physical";s:9:"css_class";s:0:"";s:9:"maxlength";N;s:4:"rows";s:1:"5";s:4:"name";s:24:"optionen_directory_index";s:4:"type";s:8:"longText";s:5:"title";s:14:"DirectoryIndex";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"30";s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:9;O:14:"seperatorField":13:{s:5:"width";s:1:"1";s:9:"css_class";s:0:"";s:4:"name";s:2:"t5";s:4:"type";s:14:"seperatorField";s:5:"title";N;s:8:"language";s:2:"de";s:11:"description";N;s:6:"length";i:30;s:7:"visible";i:1;s:8:"required";i:1;s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:11;O:8:"longText":18:{s:5:"value";s:0:"";s:12:"storage_type";s:2:"db";s:12:"storage_path";N;s:4:"wrap";s:8:"physical";s:9:"css_class";s:0:"";s:9:"maxlength";N;s:4:"rows";s:1:"5";s:4:"name";s:9:"error_400";s:4:"type";s:8:"longText";s:5:"title";s:32:"Fehler 400<br>(Ungültige Syntax)";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"30";s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:12;O:8:"longText":18:{s:5:"value";s:0:"";s:12:"storage_type";s:2:"db";s:12:"storage_path";N;s:4:"wrap";s:8:"physical";s:9:"css_class";s:0:"";s:9:"maxlength";N;s:4:"rows";s:1:"5";s:4:"name";s:9:"error_401";s:4:"type";s:8:"longText";s:5:"title";s:45:"Fehler 401<br>(Autorisierung<br>erforderlich)";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"30";s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:13;O:8:"longText":18:{s:5:"value";s:0:"";s:12:"storage_type";s:2:"db";s:12:"storage_path";N;s:4:"wrap";s:8:"physical";s:9:"css_class";s:0:"";s:9:"maxlength";N;s:4:"rows";s:1:"5";s:4:"name";s:9:"error_403";s:4:"type";s:8:"longText";s:5:"title";s:24:"Fehler 403<br>(Verboten)";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"30";s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:14;O:8:"longText":18:{s:5:"value";s:0:"";s:12:"storage_type";s:2:"db";s:12:"storage_path";N;s:4:"wrap";s:8:"physical";s:9:"css_class";s:0:"";s:9:"maxlength";N;s:4:"rows";s:1:"5";s:4:"name";s:9:"error_404";s:4:"type";s:8:"longText";s:5:"title";s:39:"Fehler 404<br>(Datei nicht<br>gefunden)";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"30";s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:15;O:8:"longText":18:{s:5:"value";s:0:"";s:12:"storage_type";s:2:"db";s:12:"storage_path";N;s:4:"wrap";s:8:"physical";s:9:"css_class";s:0:"";s:9:"maxlength";N;s:4:"rows";s:1:"5";s:4:"name";s:9:"error_405";s:4:"type";s:8:"longText";s:5:"title";s:40:"Fehler 405<br>(Methode nicht<br>erlaubt)";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"30";s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:16;O:8:"longText":18:{s:5:"value";s:0:"";s:12:"storage_type";s:2:"db";s:12:"storage_path";N;s:4:"wrap";s:8:"physical";s:9:"css_class";s:0:"";s:9:"maxlength";N;s:4:"rows";s:1:"5";s:4:"name";s:9:"error_500";s:4:"type";s:8:"longText";s:5:"title";s:41:"Fehler 500<br>(Interner<br>Server-Fehler)";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"30";s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:17;O:8:"longText":18:{s:5:"value";s:0:"";s:12:"storage_type";s:2:"db";s:12:"storage_path";N;s:4:"wrap";s:8:"physical";s:9:"css_class";s:0:"";s:9:"maxlength";N;s:4:"rows";s:1:"5";s:4:"name";s:9:"error_503";s:4:"type";s:8:"longText";s:5:"title";s:47:"Fehler 503<br>(Service ist z.Zt.<br>überlastet)";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";s:2:"30";s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:18;O:14:"seperatorField":13:{s:5:"width";s:1:"1";s:9:"css_class";s:0:"";s:4:"name";s:2:"t6";s:4:"type";s:14:"seperatorField";s:5:"title";N;s:8:"language";s:2:"de";s:11:"description";N;s:6:"length";i:30;s:7:"visible";i:1;s:8:"required";i:1;s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}i:19;O:13:"checkboxField":13:{s:5:"value";s:1:"1";s:9:"css_class";s:0:"";s:4:"name";s:15:"webalizer_stats";s:4:"type";s:13:"checkboxField";s:5:"title";s:15:"Webalizer Stats";s:8:"language";s:2:"de";s:11:"description";s:0:"";s:6:"length";i:30;s:7:"visible";s:1:"1";s:8:"required";s:1:"0";s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}}s:5:"title";s:8:"Optionen";s:7:"visible";s:1:"1";s:9:"perm_read";s:1:"r";s:10:"perm_write";s:1:"w";}i:7;O:4:"deck":5:{s:8:"elements";a:1:{i:0;O:11:"pluginField":13:{s:9:"css_class";N;s:7:"options";N;s:4:"name";s:15:"isp_web_faktura";s:4:"type";s:11:"pluginField";s:5:"title";N;s:8:"language";s:2:"de";s:11:"description";N;s:6:"length";i:30;s:7:"visible";i:1;s:8:"required";i:1;s:14:"reg_expression";N;s:10:"reg_fehler";N;s:6:"search";N;}}s:5:"title";s:7:"Invoice";s:7:"visible";s:1:"1";s:9:"perm_read";s:1:"a";s:10:"perm_write";s:1:"a";}}s:5:"title";s:7:"ISP Web";s:8:"keywords";N;s:11:"description";s:0:"";s:4:"path";N;s:4:"icon";s:0:"";s:5:"cache";s:1:"0";s:8:"permtype";N;s:7:"version";d:1.100000000000000088817841970012523233890533447265625;s:11:"event_class";s:7:"isp_web";s:12:"event_insert";s:10:"web_insert";s:12:"event_update";s:10:"web_update";s:12:"event_delete";s:10:"web_delete";s:10:"event_show";s:8:"web_show";s:11:"wysiwyg_lib";i:0;}', 1);

Does the MySQL checkbox show up then?

 

No, sadly it doesn't change anything. After inserting the new row into the table I logged in as admin and opened the limits deck of the reseller. It's still invisible.

 

many many thanks falko this works for me

 

This means that for some reason the old doctype weren't replaced with the new ones when you updated.
Please unpack ISPConfig 2.2.21 again; in the install_ispconfig directory, there's an SQL dump named db_ispconfig.sql. Please empty your doctype table, then run all the INSERT ... INTO doctype ... lines from db_ispconfig.sql on your ISPConfig database (you still have the backup of the old db, don't you? - in case anything goes wrong).

 

Thank You Very Much Falko !

But now i get :

Unknown column 'web_ruby' in 'field list'

When i try to modify a site... i think its a database problem...

 

yes, it helps! thanx a lot!

 

This means that the isp_isp_web table is also the old version. Did you modify the database manually prior to the upgrade? Did you get any MySQL errors during the upgrade?

 

No, i didnt get any errors during installation, and i didnt touch the database. But i think the problem is that i upgraded from i really old version of ispconfig(I dont remember the version but was more than 7 months old).

Can i also use the same 'trick' for isp_isp_web like doctype ? Is it safe?

Thank you !

 

Falko, many thanks. While it wasn't working yesterday by replacing that single line I tried again with a fresh import like you stated. Both fields (mySQL and Ruby) are displayed now. I get the same error with 'limit_ruby'. After adding the missing row it's working fine now. Following command I used therefor:

ALTER TABLE `isp_isp_reseller` ADD `limit_ruby` char( 1 ) default '1';

Falko, it seems that all database field updates are missing? Could the upgrade from .19 to .21 be the cause? Should we ever upgrade to the next version?

Henrik

 

When logged in as a reseller the missing 'web_ruby' column is shown. Following command fixes it:

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

After that everything works.

Henrik

 

Falko, the database import file contains errors for the .21 release. All tables which are affected have no Type identifier. Instead 'Engine' was added. This should be the problem why the tables weren't updated.

879c881
< ) TYPE=MyISAM;
---
> ) ENGINE=MyISAM;

Following tables are affected:
* isp_isp_reseller
* isp_isp_web
* isp_isp_web_template
* isp_server

Henrik

 

my msql version :

Server version: 5.0.27


Thank You!

 

Guys,

I'm having an even worse problem than creating databases. My customer's databases were all deleted when I saved a change to an e-mail user in their domain. I've lost their gallery2 database, jinzora database and their wordpress database. All their databases are gone now. And they are pissed. I can see a problem with creating a new database because you can't click on the check box, but this is freakin ridiculous. How the f do I fix this??????

What information can I get to you ASAP to fix this. I hate having customer problems that I shouldn't have!!! HELP!!

 

OK, I got things kindof fixed by the database update with the doctype and adding the web_ruby attribute. Then I got back into my sites, and the databases showed up. But, no access to them. I ended up deleting them using the ispconfig panel, after dumping them to disk. My idea was to recreate them within ispconfig so that things were in sync. But, the naming conventions are different. The database name was web8_db1, but ispconfig creates it as web8db1 (no underbar). The same holds for the user, web8_u1 and now web8u1. I've gone through and updated the jinzora configuration files (config.php) and the wordpress configuration files (config.php) to use the new naming convention and that works. BUT GALLERY2 is puking. Or actually, it's never loading. I am using gallery2 codebase and do not want to re-install. Any ideas on how to fix this? And why the naming convention change??? Is that a bug???

 

Take a look here: http://www.howtoforge.com/forums/showthread.php?t=19593