Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#11 2020-05-15 21:59:44

amordecosmos
Member
From: London (Hometown: Vancouver)
Registered: 2004-08-03
Posts: 71
Website

Re: Can't connect to DigitalOcean managed databases

I’ve come back to this.

I can now connect to the Digital Ocean Managed Database using a stock Textpattern 4.8 (no need to edit the config) as long as I create a MySQL 5 user on their MySQL 8 setup.

So I go through the setup as usual – then this happens:

Storage engine MyISAM is disabled (Table creation is disallowed). in /var/www/html/textpattern/lib/txplib_db.php on line 450

Digital Ocean Managed Database only uses the InnoDB engine for reasons.

Can I get past this?

Offline

#12 2020-05-16 10:02:53

gaekwad
Admin
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 3,077

Re: Can't connect to DigitalOcean managed databases

What happens if you replace the two occurrences of MyISAM to InnoDB /textpattern/lib/txplib_db.php and re-run the setup?

Offline

#13 2020-05-16 10:34:05

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 9,644
Website

Re: Can't connect to DigitalOcean managed databases

If that works – and I suspect it will – I can patch this today so you can specify the storage engine in config.php.


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#14 2020-05-16 13:09:29

amordecosmos
Member
From: London (Hometown: Vancouver)
Registered: 2004-08-03
Posts: 71
Website

Re: Can't connect to DigitalOcean managed databases

What happens if you replace the two occurrences of MyISAM to InnoDB /textpattern/lib/txplib_db.php and re-run the setup?

It works terrifically and sets up exactly as one expects.

Thank you.

Offline

#15 2020-05-16 14:35:18

gaekwad
Admin
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 3,077

Re: Can't connect to DigitalOcean managed databases

amordecosmos wrote #323010:

It works terrifically and sets up exactly as one expects.

Great! Thanks for being a guinea pig.

Offline

#16 2020-05-16 14:49:26

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 9,644
Website

Re: Can't connect to DigitalOcean managed databases

Brilliant, thank you for testing. Patched for the imminent 4.8.1. When you download/copy ‘n’ paste your config.php file, add:

$txpcfg['dbengine'] = 'InnoDB';

to override the default MyISAM table type.

EDIT: Longer term, would it make sense to add this to the db collection step during setup? A dropdown of supported engines? I’ve no idea what the other types are for, nor if they’d even work with Txp. But perhaps we could offer a choice between MyISAM (default) and InnoDB at the very least.

Last edited by Bloke (2020-05-16 14:56:20)


The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.

Txp Builders – finely-crafted code, design and Txp

Offline

#17 2020-05-16 14:55:56

gaekwad
Admin
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 3,077

Re: Can't connect to DigitalOcean managed databases

…and here are some basic examples in docs.

Offline

Board footer

Powered by FluxBB