Cannot create database

[SpazShark]

Hi Mike!

Love this software but when I built this on my Ubuntu 18.04 system in a container it was throwing an error that the database could not be created.

I installed using docker compose by executing this command after downloading the unmodified docker-compose.yml file:
docker-compose -f ~/docker/docker-compose.yml up -d

I'm admittedly new at all this so please tell me if I'm missing something!

[MikeDombo]

Can you please try updating the version of mysql in the docker compose file to version 8. This should look like

mysql:
    image: 'mysql:8'

[SpazShark]

That was fast! Tried it and got this:

ERROR: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client
Fatal error: Uncaught PDOException: PDO::__construct(): The server requested authentication method unknown to the client [caching_sha2_password] in /var/www/html/classes/DB/MySQLDAL.php:78 Stack trace: #0 /var/www/html/classes/DB/MySQLDAL.php(78): PDO->__construct('mysql:host=mysq...', 'root', 'password') #1 /var/www/html/classes/GlobalFunctions.php(237): AudioDidact\DB\MySQLDAL->__construct('mysql:host=mysq...') #2 /var/www/html/header.php(64): AudioDidact\GlobalFunctions::getDAL() #3 /var/www/html/index.php(3): require_once('/var/www/html/h...') #4 {main} Next PDOException: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client in /var/www/html/classes/DB/MySQLDAL.php:78 Stack trace: #0 /var/www/html/classes/DB/MySQLDAL.php(78): PDO->__construct('mysql:host=mysq...', 'root', 'password') #1 /var/www/html/classes/GlobalFunctions.php(237): AudioDidact\DB\MySQLDAL->__construct('mysql:host=mysq...') #2 /var/www/html/header.php(64): AudioDidact\GlobalFunctions::getDAL() #3 /var/www/html/index in /var/www/html/classes/DB/MySQLDAL.php on line 78

[MikeDombo]

Looks like they updated the default authentication. Please change it now to

mysql:
    image: 'mysql:8'
    command: --default-authentication-plugin=mysql_native_password
    ... rest of the config ...

[SpazShark]

First of all thanks for the help here!

The page loads now and I get this at the top of the first page on the site:

"The database needs to be created, this will be completed automatically..."

Attached are the logs that I see for each container:
mysql log.txt
audiodidact log.txt

[MikeDombo]

Does it put that up every time you load the page? It should only show up the first time.

[SpazShark]

Every time I load up the page.

[MikeDombo]

Ok no problem. I just made a change which I'm fairly sure will fix the issue. Docker will rebuild shortly and then if you run docker compose again it should pull down the latest version. If not, you can add --pull to the command and that should get docker compose to look for an update.

[MikeDombo]

The new build is now available.

[SpazShark]

Ok I tried it but not sure if I'm using the pull command correctly. I did this:
docker-compose pull
docker-compose -f ~/docker/docker-compose.yml up -d

It didn't work. Same error as before. So I rolled back the VM to a state before I started installing and just ran the regular docker-compose command:
docker-compose -f ~/docker/docker-compose.yml up -d

Still same problem. Thanks again for helping. :) New Logs attached
Audiodidact.txt
mysql.txt

[MikeDombo]

I'll try on my computer shortly, but I'd try going back to mysql 5.7.

[SpazShark]

Ok went back to mysql 5.7 and the new build appears to be working!

The only issue now is that my RSS feed doesn't seem to be updating when I upload content. However, I can see and play files it under 'Feed Items' on the user page. So whatever updates the RSS feed doesn't seem to be working.

So close!!

[MikeDombo]

OK good. The RSS feed is automatically updated when you add any videos. If adding any of them fails then it will not update the feed. So I don't know why it wouldn't be updated if you can see it on the site. Are you checking the feed yourself, or using podcast app? If you just load the XML yourself it should definitely be up to date, but if you're using an app then many of them cache for quite a while before they will actually update again.

[SpazShark]

Yeah it's weird. I can see files on my account page and play them just fine. However, the feed file just looks like this: <rss xmlns:atom="http://www.w3.org/2005/Atom" xmlns:itunes="http://www.itunes.com/dtds/podcast-1.0.dtd" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" version="2.0"> <channel> <title>AudioDidact</title> <link>http://192.168.200.59/</link> <description> <![CDATA[ Learn by putting audio and video from multiple sources into a portable podcast feed. ]]> </description> <image> <title>AudioDidact</title> <link>http://192.168.200.59/</link> <url> http://192.168.200.59/public/img/favicon/favicon-512x512.png </url> </image> <lastBuildDate>Tue, 08 Oct 2019 03:15:23 +0000</lastBuildDate> <pubDate>Tue, 08 Oct 2019 03:15:23 +0000</pubDate> <atom:link href="http://192.168.200.59/user/michael/feed/" rel="self" type="application/rss+xml"/> <itunes:image href="http://192.168.200.59/public/img/favicon/favicon-512x512.png"/> <itunes:author>Michael Dombrowski</itunes:author> <itunes:category text="Technology"/> <language>en-US</language> <itunes:explicit>yes</itunes:explicit> <sy:updatePeriod>hourly</sy:updatePeriod> <sy:updateFrequency>1</sy:updateFrequency> <ttl>15</ttl> </channel> </rss>

…

________________________________ From: Michael Dombrowski <notifications@github.com> Sent: October 7, 2019 11:22 PM To: MikeDombo/AudioDidact <AudioDidact@noreply.github.com> Cc: SpazShark <michael.smirle@live.ca>; Author <author@noreply.github.com> Subject: Re: [MikeDombo/AudioDidact] Cannot create database (#97) OK good. The RSS feed is automatically updated when you add any videos. If adding any of them fails then it will not update the feed. So I don't know why it wouldn't be updated if you can see it on the site. Are you checking the feed yourself, or using podcast app? If you just load the XML yourself it should definitely be up to date, but if you're using an app then many of them cache for quite a while before they will actually update again. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FMikeDombo%2FAudioDidact%2Fissues%2F97%3Femail_source%3Dnotifications%26email_token%3DAEABAT5GTRBQXDKEGM6FSJLQNP4HNA5CNFSM4I6KELZ2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEASQHLY%23issuecomment-539296687&data=02%7C01%7C%7C975091312a7f4a94713e08d74b9ec114%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637061017517309348&sdata=EaH%2Fa%2BaMe69XvXaOhIECzQFNGFOK1KDVpk8IGDjWvC4%3D&reserved=0>, or mute the thread<https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAEABAT6NECC6NKSWIQTOKVTQNP4HNANCNFSM4I6KELZQ&data=02%7C01%7C%7C975091312a7f4a94713e08d74b9ec114%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637061017517309348&sdata=3CE5HQgKa3uLbUIMJOqjW7xVgsAq%2B7sFqEJS5tr71ds%3D&reserved=0>.

[MikeDombo]

And have you tried putting yet another thing into the feed? That should cause it to be generated again. There is no other way to generate the feed except to put something into it.

[MikeDombo]

The text of the feed is stored in the database, so if there's something wrong with the connection to the database then it won't be able to update it. You may want to check the audiodidact log again to see if there are any errors.