Issues With Youtarr Not Booting. "ER_ACCESS_DENIED_NO_PASSWORD_ERROR"

[sargrvb]

Howdy all! Long time data hoarder here hoping to get started with this program. I've written some custom Home Assistant stuff to scrape channels, but it was getting too hard to maintain manually. Hoping this program can fix my problems! Running into a road block! Finally got it installed using git (user error, been a while since I've used git. But now I'm running into this error in docker! Any help here would be appreciated. At first I thought my clock was out of sync or something, causing login issues. But then I noticed a local host / password error? Unsure how this happened / how to fix it. Below are my logs:

2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #1] Channel created
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #1] original dial target is: "unix:///Users/Gravemind/AppData/Local/Docker/run/userAnalyticsOtlpHttp.sock"
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #1] parsed dial target is: resolver.Target{URL:url.URL{Scheme:"unix", Opaque:"", User:(*url.Userinfo)(nil), Host:"", Path:"/Users/Gravemind/AppData/Local/Docker/run/userAnalyticsOtlpHttp.sock", RawPath:"", OmitHost:false, ForceQuery:false, RawQuery:"", Fragment:"", RawFragment:""}}
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #1] Channel authority set to "localhost"
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #1] Resolver state updated: {
"Addresses": [
{
"Addr": "/Users/Gravemind/AppData/Local/Docker/run/userAnalyticsOtlpHttp.sock",
"ServerName": "",
"Attributes": {
"\u003c%!p(networktype.keyType=grpc.internal.transport.networktype)\u003e": "unix"
},
"BalancerAttributes": null,
"Metadata": null
}
],
"Endpoints": [
{
"Addresses": [
{
"Addr": "/Users/Gravemind/AppData/Local/Docker/run/userAnalyticsOtlpHttp.sock",
"ServerName": "",
"Attributes": {
"\u003c%!p(networktype.keyType=grpc.internal.transport.networktype)\u003e": "unix"
},
"BalancerAttributes": null,
"Metadata": null
}
],
"Attributes": null
}
],
"ServiceConfig": null,
"Attributes": null
} (resolver returned new addresses)
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #1] Channel switches to new LB policy "pick_first"
2024-07-04 00:00:00 06:49:14 INFO: [core] [pick-first-lb 0xc0005aa660] Received new config {
"shuffleAddressList": false
}, resolver state {
"Addresses": [
{
"Addr": "/Users/Gravemind/AppData/Local/Docker/run/userAnalyticsOtlpHttp.sock",
"ServerName": "",
"Attributes": {
"\u003c%!p(networktype.keyType=grpc.internal.transport.networktype)\u003e": "unix"
},
"BalancerAttributes": null,
"Metadata": null
}
],
"Endpoints": [
{
"Addresses": [
{
"Addr": "/Users/Gravemind/AppData/Local/Docker/run/userAnalyticsOtlpHttp.sock",
"ServerName": "",
"Attributes": {
"\u003c%!p(networktype.keyType=grpc.internal.transport.networktype)\u003e": "unix"
},
"BalancerAttributes": null,
"Metadata": null
}
],
"Attributes": null
}
],
"ServiceConfig": null,
"Attributes": null
}
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #1 SubChannel #2] Subchannel created
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #1] Channel Connectivity change to CONNECTING
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #1] Channel exiting idle mode
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #1 SubChannel #2] Subchannel Connectivity change to CONNECTING
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #1 SubChannel #2] Subchannel picks a new address "/Users/Gravemind/AppData/Local/Docker/run/userAnalyticsOtlpHttp.sock" to connect
2024-07-04 00:00:00 06:49:14 INFO: [core] [pick-first-lb 0xc0005aa660] Received SubConn state update: 0xc0005aa7e0, {ConnectivityState:CONNECTING ConnectionError:}
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #3] Channel created
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #3] original dial target is: "unix:///Users/Gravemind/AppData/Local/Docker/run/userAnalyticsOtlpHttp.sock"
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #3] parsed dial target is: resolver.Target{URL:url.URL{Scheme:"unix", Opaque:"", User:(*url.Userinfo)(nil), Host:"", Path:"/Users/Gravemind/AppData/Local/Docker/run/userAnalyticsOtlpHttp.sock", RawPath:"", OmitHost:false, ForceQuery:false, RawQuery:"", Fragment:"", RawFragment:""}}
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #3] Channel authority set to "localhost"
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #3] Resolver state updated: {
"Addresses": [
{
"Addr": "/Users/Gravemind/AppData/Local/Docker/run/userAnalyticsOtlpHttp.sock",
"ServerName": "",
"Attributes": {
"\u003c%!p(networktype.keyType=grpc.internal.transport.networktype)\u003e": "unix"
},
"BalancerAttributes": null,
"Metadata": null
}
],
"Endpoints": [
{
"Addresses": [
{
"Addr": "/Users/Gravemind/AppData/Local/Docker/run/userAnalyticsOtlpHttp.sock",
"ServerName": "",
"Attributes": {
"\u003c%!p(networktype.keyType=grpc.internal.transport.networktype)\u003e": "unix"
},
"BalancerAttributes": null,
"Metadata": null
}
],
"Attributes": null
}
],
"ServiceConfig": null,
"Attributes": null
} (resolver returned new addresses)
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #3] Channel switches to new LB policy "pick_first"
2024-07-04 00:00:00 06:49:14 INFO: [core] [pick-first-lb 0xc0005aac60] Received new config {
"shuffleAddressList": false
}, resolver state {
"Addresses": [
{
"Addr": "/Users/Gravemind/AppData/Local/Docker/run/userAnalyticsOtlpHttp.sock",
"ServerName": "",
"Attributes": {
"\u003c%!p(networktype.keyType=grpc.internal.transport.networktype)\u003e": "unix"
},
"BalancerAttributes": null,
"Metadata": null
}
],
"Endpoints": [
{
"Addresses": [
{
"Addr": "/Users/Gravemind/AppData/Local/Docker/run/userAnalyticsOtlpHttp.sock",
"ServerName": "",
"Attributes": {
"\u003c%!p(networktype.keyType=grpc.internal.transport.networktype)\u003e": "unix"
},
"BalancerAttributes": null,
"Metadata": null
}
],
"Attributes": null
}
],
"ServiceConfig": null,
"Attributes": null
}
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #3 SubChannel #4] Subchannel created
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #3] Channel Connectivity change to CONNECTING
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #3] Channel exiting idle mode
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #3 SubChannel #4] Subchannel Connectivity change to CONNECTING
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #3 SubChannel #4] Subchannel picks a new address "/Users/Gravemind/AppData/Local/Docker/run/userAnalyticsOtlpHttp.sock" to connect
2024-07-04 00:00:00 06:49:14 INFO: [core] [pick-first-lb 0xc0005aac60] Received SubConn state update: 0xc0005aacf0, {ConnectivityState:CONNECTING ConnectionError:}
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #1 SubChannel #2] Subchannel Connectivity change to READY
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #3 SubChannel #4] Subchannel Connectivity change to READY
2024-07-04 00:00:00 06:49:14 INFO: [core] [pick-first-lb 0xc0005aa660] Received SubConn state update: 0xc0005aa7e0, {ConnectivityState:READY ConnectionError:}
2024-07-04 00:00:00 06:49:14 INFO: [core] [pick-first-lb 0xc0005aac60] Received SubConn state update: 0xc0005aacf0, {ConnectivityState:READY ConnectionError:}
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #1] Channel Connectivity change to READY
2024-07-04 00:00:00 06:49:14 INFO: [core] [Channel #3] Channel Connectivity change to READY
2024-07-04 06:49:14 Waiting for DB...
2024-07-04 06:49:14 Waiting for DB...
2024-07-04 06:49:14 .240704 13:49:14 mysqld_safe Logging to syslog.
2024-07-04 06:49:14 240704 13:49:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2024-07-04 06:49:15 Unable to initialize the database: ConnectionError [SequelizeConnectionError]: Access denied for user 'root'@'localhost'
2024-07-04 06:49:15 at ConnectionManager.connect (/app/node_modules/sequelize/lib/dialects/mysql/connection-manager.js:102:17)
2024-07-04 06:49:15 at processTicksAndRejections (internal/process/task_queues.js:95:5)
2024-07-04 06:49:15 at async ConnectionManager._connect (/app/node_modules/sequelize/lib/dialects/abstract/connection-manager.js:222:24)
2024-07-04 06:49:15 at async /app/node_modules/sequelize/lib/dialects/abstract/connection-manager.js:174:32
2024-07-04 06:49:15 at async ConnectionManager.getConnection (/app/node_modules/sequelize/lib/dialects/abstract/connection-manager.js:197:7)
2024-07-04 06:49:15 at async /app/node_modules/sequelize/lib/sequelize.js:305:26
2024-07-04 06:49:15 at async Sequelize.authenticate (/app/node_modules/sequelize/lib/sequelize.js:457:5)
2024-07-04 06:49:15 at async Object.initializeDatabase (/app/server/db.js:12:5)
2024-07-04 06:49:15 at async initialize (/app/server/server.js:12:5) {
2024-07-04 06:49:15 parent: Error: Access denied for user 'root'@'localhost'
2024-07-04 06:49:15 at Packet.asError (/app/node_modules/mysql2/lib/packets/packet.js:728:17)
2024-07-04 06:49:15 at ClientHandshake.execute (/app/node_modules/mysql2/lib/commands/command.js:29:26)
2024-07-04 06:49:15 at Connection.handlePacket (/app/node_modules/mysql2/lib/connection.js:481:34)
2024-07-04 06:49:15 at PacketParser.onPacket (/app/node_modules/mysql2/lib/connection.js:97:12)
2024-07-04 06:49:15 at PacketParser.executeStart (/app/node_modules/mysql2/lib/packet_parser.js:75:16)
2024-07-04 06:49:15 at Socket. (/app/node_modules/mysql2/lib/connection.js:104:25)
2024-07-04 06:49:15 at Socket.emit (events.js:400:28)
2024-07-04 06:49:15 at addChunk (internal/streams/readable.js:293:12)
2024-07-04 06:49:15 at readableAddChunk (internal/streams/readable.js:267:9)
2024-07-04 06:49:15 at Socket.Readable.push (internal/streams/readable.js:206:10) {
2024-07-04 06:49:15 code: 'ER_ACCESS_DENIED_NO_PASSWORD_ERROR',
2024-07-04 06:49:15 errno: 1698,
2024-07-04 06:49:15 sqlState: '28000',
2024-07-04 06:49:15 sqlMessage: "Access denied for user 'root'@'localhost'",
2024-07-04 06:49:15 sql: undefined
2024-07-04 06:49:15 },
2024-07-04 06:49:15 original: Error: Access denied for user 'root'@'localhost'
2024-07-04 06:49:15 at Packet.asError (/app/node_modules/mysql2/lib/packets/packet.js:728:17)
2024-07-04 06:49:15 at ClientHandshake.execute (/app/node_modules/mysql2/lib/commands/command.js:29:26)
2024-07-04 06:49:15 at Connection.handlePacket (/app/node_modules/mysql2/lib/connection.js:481:34)
2024-07-04 06:49:15 at PacketParser.onPacket (/app/node_modules/mysql2/lib/connection.js:97:12)
2024-07-04 06:49:15 at PacketParser.executeStart (/app/node_modules/mysql2/lib/packet_parser.js:75:16)
2024-07-04 06:49:15 at Socket. (/app/node_modules/mysql2/lib/connection.js:104:25)
2024-07-04 06:49:15 at Socket.emit (events.js:400:28)
2024-07-04 06:49:15 at addChunk (internal/streams/readable.js:293:12)
2024-07-04 06:49:15 at readableAddChunk (internal/streams/readable.js:267:9)
2024-07-04 06:49:15 at Socket.Readable.push (internal/streams/readable.js:206:10) {
2024-07-04 06:49:15 code: 'ER_ACCESS_DENIED_NO_PASSWORD_ERROR',
2024-07-04 06:49:15 errno: 1698,
2024-07-04 06:49:15 sqlState: '28000',
2024-07-04 06:49:15 sqlMessage: "Access denied for user 'root'@'localhost'",
2024-07-04 06:49:15 sql: undefined
2024-07-04 06:49:15 }
2024-07-04 06:49:15 }
2024-07-04 06:49:15 Failed to initialize the application: ConnectionError [SequelizeConnectionError]: Access denied for user 'root'@'localhost'
2024-07-04 06:49:15 at ConnectionManager.connect (/app/node_modules/sequelize/lib/dialects/mysql/connection-manager.js:102:17)
2024-07-04 06:49:15 at processTicksAndRejections (internal/process/task_queues.js:95:5)
2024-07-04 06:49:15 at async ConnectionManager._connect (/app/node_modules/sequelize/lib/dialects/abstract/connection-manager.js:222:24)
2024-07-04 06:49:15 at async /app/node_modules/sequelize/lib/dialects/abstract/connection-manager.js:174:32
2024-07-04 06:49:15 at async ConnectionManager.getConnection (/app/node_modules/sequelize/lib/dialects/abstract/connection-manager.js:197:7)
2024-07-04 06:49:15 at async /app/node_modules/sequelize/lib/sequelize.js:305:26
2024-07-04 06:49:15 at async Sequelize.authenticate (/app/node_modules/sequelize/lib/sequelize.js:457:5)
2024-07-04 06:49:15 at async Object.initializeDatabase (/app/server/db.js:12:5)
2024-07-04 06:49:15 at async initialize (/app/server/server.js:12:5) {
2024-07-04 06:49:15 parent: Error: Access denied for user 'root'@'localhost'
2024-07-04 06:49:15 at Packet.asError (/app/node_modules/mysql2/lib/packets/packet.js:728:17)
2024-07-04 06:49:15 at ClientHandshake.execute (/app/node_modules/mysql2/lib/commands/command.js:29:26)
2024-07-04 06:49:15 at Connection.handlePacket (/app/node_modules/mysql2/lib/connection.js:481:34)
2024-07-04 06:49:15 at PacketParser.onPacket (/app/node_modules/mysql2/lib/connection.js:97:12)
2024-07-04 06:49:15 at PacketParser.executeStart (/app/node_modules/mysql2/lib/packet_parser.js:75:16)
2024-07-04 06:49:15 at Socket. (/app/node_modules/mysql2/lib/connection.js:104:25)
2024-07-04 06:49:15 at Socket.emit (events.js:400:28)
2024-07-04 06:49:15 at addChunk (internal/streams/readable.js:293:12)
2024-07-04 06:49:15 at readableAddChunk (internal/streams/readable.js:267:9)
2024-07-04 06:49:15 at Socket.Readable.push (internal/streams/readable.js:206:10) {
2024-07-04 06:49:15 code: 'ER_ACCESS_DENIED_NO_PASSWORD_ERROR',
2024-07-04 06:49:15 errno: 1698,
2024-07-04 06:49:15 sqlState: '28000',
2024-07-04 06:49:15 sqlMessage: "Access denied for user 'root'@'localhost'",
2024-07-04 06:49:15 sql: undefined
2024-07-04 06:49:15 },
2024-07-04 06:49:15 original: Error: Access denied for user 'root'@'localhost'
2024-07-04 06:49:15 at Packet.asError (/app/node_modules/mysql2/lib/packets/packet.js:728:17)
2024-07-04 06:49:15 at ClientHandshake.execute (/app/node_modules/mysql2/lib/commands/command.js:29:26)
2024-07-04 06:49:15 at Connection.handlePacket (/app/node_modules/mysql2/lib/connection.js:481:34)
2024-07-04 06:49:15 at PacketParser.onPacket (/app/node_modules/mysql2/lib/connection.js:97:12)
2024-07-04 06:49:15 at PacketParser.executeStart (/app/node_modules/mysql2/lib/packet_parser.js:75:16)
2024-07-04 06:49:15 at Socket. (/app/node_modules/mysql2/lib/connection.js:104:25)
2024-07-04 06:49:15 at Socket.emit (events.js:400:28)
2024-07-04 06:49:15 at addChunk (internal/streams/readable.js:293:12)
2024-07-04 06:49:15 at readableAddChunk (internal/streams/readable.js:267:9)
2024-07-04 06:49:15 at Socket.Readable.push (internal/streams/readable.js:206:10) {
2024-07-04 06:49:15 code: 'ER_ACCESS_DENIED_NO_PASSWORD_ERROR',
2024-07-04 06:49:15 errno: 1698,
2024-07-04 06:49:15 sqlState: '28000',
2024-07-04 06:49:15 sqlMessage: "Access denied for user 'root'@'localhost'",
2024-07-04 06:49:15 sql: undefined
2024-07-04 06:49:15 }
2024-07-04 06:49:15 }

[dialmaster]

Can you give me more details about your system configuration? Are you running this in linux or Windows? If on Windows, WSL or otherwise? Also, since it's the 4th of July I probably won't be looking into this actively today, but I will do my best to help you out.

If you can give me details of exactly what you've done so far to try to set things up, that would be helpful for me to debug.

[sargrvb]

Of course! I installed this on Windows 11 Pro. I originally downloaded the zip and copied the files using Git GUI. If I recall correctly, I downloaded the zip via your github page and unzipped the files to one of my external hard drives. From there, I ran the setup script. Although now that I'm trying to run the setup script again, it's showing "Linux not detected as host OS, setting Plex IP to host.docker.internal". Maybe that's causing my issue? I have a feeling I'm messing up by base install now. Still trying to get the hang of VMs / Docker. Do I have to make it point a docker IP to my internal IP on my computer or something? Maybe I need to initiate WSL? I've worked with WSL in the past, but couldn't exactly figure it out.

To be clear, I have all the prerequisites installed (to my knowledge). I can see the files in docker and attempt a boot (which is how I got those logs from before). Obviously, I'm missing something critical here. But the bottom line is I'm trying to get this to run at boot on windows 11 pro. Really appreciate how quick you were to respond the first time! Hope you had a get Independence Day!

[sargrvb]

I would also like to add this: I reinstalled the docker image just now and still have the same issues. Would the install directory location be a problem if one of the subfolders has square brackets in the name? "A:[Things Photos And Files][6] Office Documents\Youtarr\setup" for example? I will try reinstalling again later. Going to take a break trying to spitball this.

[dialmaster]

Did you run the scripts from Powershell, WSL2 or git bash (or something else)?
I can try to replicate your setup here and debug it myself.
Please give me, as close as you can the step by step for what you did exactly :)
When you ran the app, did you follow the instructions in the README.md? Please give me, as much as you can, the exact steps you followed.
The error you got indicates that the app cannot connect to it's mysql database.