Installation CB Connect failed

3 days 1 hour ago #318731 by Abmago
I have discussed your information with my host provider. My host provider supports both innodb and MyISAM. They suggested the following: if the database [of CB Connect] is originally designed for MyISAM, it could be an idea to convert the table to MyISAM type. The current version of SQL is MariaDB 10.2.27-MariaDB (supported till 23 May 2022).

I don't know if this is possible or realistic.
3 days 1 hour ago #318734 by krileon
Do not convert to MyISAM. It is a discontinued storage engine.

The current version of SQL is MariaDB 10.2.27-MariaDB (supported till 23 May 2022).

Joomla nor CB officially support MariaDB, which is a fork of MySQL and it working is just pure luck.

The InnoDB default settings in MySQL 5.7 were applied to MariaDB in version 10.2.2 (which came out 4 years ago). Your host has you on 10.2.27. So they are still using the wrong settings. Below are the necessary settings.

innodb_large_prefix = 1 (on since MariaDB 10.2.2)
innodb_file_per_table = 1 (always on in MariaDB)
innodb_file_format = Barracuda (set since MariaDB 10.2.2)

Below is the defaults for them.

innodb_large_prefix = mariadb.com/kb/en/innodb-system-variables/#innodb_large_prefix
innodb_file_per_table = mariadb.com/kb/en/innodb-system-variables/#innodb_file_per_table
innodb_file_format = mariadb.com/kb/en/innodb-system-variables/#innodb_file_format

The bottom line is your host has their database configured wrong. If those settings have already been correctly set then you probably have the following incorrect as well.

innodb_page_size = 16384

Default as follows.

innodb_page_size = mariadb.com/kb/en/innodb-system-variables/#innodb_page_size

That's the default for innodb_page_size, but some hosts have deliberately halfed it to 8192 to save on storage space and thereby crippling InnoDB. The only thing left after that is to make sure the database tables themselves have the following.

ROW_FORMAT = Dynamic or Compressed


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Templates - CBSubs - Hosting - Forge - Incubator - GroupJive
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM EST to 4:00 PM EST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
2 hours 25 minutes ago #318758 by Abmago
Thank you for your comment and all the detailed information. I have sent the info to my host provider and I have got a reaction. Unfortunately, they are not willing to change the settings, because of the implications for the overall performance and the consequences for other users. They admit that MariaDB is not officially supported by Joomla, but they had good experiences with it till so far... My case is an exception. And so there is no solution for me. I think CB Connect will not work for me, unless I move to another host provider. Maybe I will do this in future. CB Connect is nice, but not as important to me as some other add-ons, like CB Auto Actions or CB Activity.
2 hours 2 minutes ago #318760 by krileon
Unfortunately your only option then would be to move to a better host if they are not willing to correct their settings. It sounds like you maybe on budget hosting, which tend to over crowd servers and to do that they have to reduce settings. They're fine for what they are, cheap hosting, but if you intend to grow your site you'll need to move on eventually.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Templates - CBSubs - Hosting - Forge - Incubator - GroupJive
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM EST to 4:00 PM EST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Moderators: beatnantkrileon
Time to create page: 0.412 seconds

Facebook Twitter LinkedIn