search

MikeDombo / AudioDidact

Make a custom RSS podcast feed from given URLs, or manually upload audio and video files.
https://ytpod.mikedombrowski.com
BSD 3-Clause "New" or "Revised" License
6 stars 0 forks source link

Cannot create database #97

Open SpazShark opened 4 years ago

SpazShark commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

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

SpazShark commented 4 years ago

Every time I load up the page.

MikeDombo commented 4 years ago

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 commented 4 years ago

The new build is now available.

SpazShark commented 4 years ago

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 commented 4 years ago

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

SpazShark commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

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:

AudioDidact http://192.168.200.59/ AudioDidact http://192.168.200.59/ http://192.168.200.59/public/img/favicon/favicon-512x512.png Tue, 08 Oct 2019 03:15:23 +0000 Tue, 08 Oct 2019 03:15:23 +0000 Michael Dombrowski en-US yes hourly 1 15

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 GitHubhttps://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 threadhttps://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 commented 4 years ago

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 commented 4 years ago

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.

SpazShark commented 4 years ago

Ok I'll look at it again tonight and report back!

SpazShark commented 4 years ago

Ok so I quickly built a Ubuntu server in Azure with docker and was able to install everything just fine, including having a successfully updated RSS feed. Then on my home Ubuntu Server (on Hyper-V) I did the same thing and still have the problem of the RSS feed not updating. One thing that I noticed is that in the working version, I see a message of "Successfully Uploaded!" in the progress bar when I upload a file. If I replicate the same upload on my non-working server, it just sits at 100% and I never see the "Successfully Uploaded!" message.