i recently switched from hdd to ssd and had to reinstall everything, copied over all config files that always worked before as i have with previous re-installs so everything should be the same as the previous setup. everything works except HA wont connect to mysql as it did before, there’s no errors in the logfile or anything, looks like its just ignoring it. all dependecies are installed and all mysql users work.
did i overlook something? anyone else have the same problem? i’m running on debian in a venv.
my config entry in configuration.yaml (comented out for now since its ignoring it anyway) , tried all 3 options without any luck. also tried localhost instead of 127.0.0.1
db_url: mysql://user:[email protected]/homeassistant always worked before.
i fixed the identation and it’s still the same.
i have 3 mysql users, all 3 can connect from whatever ip and they all work correctly so it must be a HA thing or i missed a dependency.
nextcloud on the same machine and both kodi’s on the network can connect to mysql.
i can connect with every user except the nextcloud one from a remote machine on the same network using heidsql.
bind adress is commented out to allow external conections
As you wish but I can see from your lsof output that it isn’t disabled. A little while back there was an issue with Maria where connections to localhost failed if both IPV4 and IPV6 were enabled.
If you want to try again another day PM me and Ill see if I can help.
no special characters in the passwords, 150 is kodi, 160 is the laptop with heidisql and no idea what 247 is.
mysql log:
2019-12-15 13:29:57 0 [Note] InnoDB: Using Linux native AIO
2019-12-15 13:29:57 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-12-15 13:29:57 0 [Note] InnoDB: Uses event mutexes
2019-12-15 13:29:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-15 13:29:57 0 [Note] InnoDB: Number of pools: 1
2019-12-15 13:29:57 0 [Note] InnoDB: Using generic crc32 instructions
2019-12-15 13:29:57 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2019-12-15 13:29:57 0 [Note] InnoDB: Completed initialization of buffer pool
2019-12-15 13:29:57 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-12-15 13:29:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-12-15 13:29:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-12-15 13:29:58 0 [Note] InnoDB: Setting file ‘./ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …
2019-12-15 13:29:58 0 [Note] InnoDB: File ‘./ibtmp1’ size is now 12 MB.
2019-12-15 13:29:59 0 [Note] InnoDB: Waiting for purge to start
2019-12-15 13:29:59 0 [Note] InnoDB: 10.3.18 started; log sequence number 5463701651; transaction id 2629817
2019-12-15 13:29:59 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2019-12-15 13:29:59 0 [Note] Plugin ‘FEEDBACK’ is disabled.
2019-12-15 13:29:59 0 [Note] Server socket created on IP: ‘0.0.0.0’.
2019-12-15 13:29:59 0 [Note] Reading of all Master_info entries succeeded
2019-12-15 13:29:59 0 [Note] Added new Master_info ‘’ to hash table
2019-12-15 13:29:59 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: ‘10.3.18-MariaDB-0+deb10u1’ socket: ‘/run/mysqld/mysqld.sock’ port: 3306 Debian 10
2019-12-15 13:30:02 0 [Note] InnoDB: Buffer pool(s) load completed at 191215 13:30:02
2019-12-15 13:36:00 39 [Warning] IP address ‘192.168.123.150’ could not be resolved: Name or service not known
2019-12-15 13:37:18 57 [Warning] IP address ‘192.168.123.160’ could not be resolved: Name or service not known
2019-12-15 14:32:47 157 [Warning] IP address ‘192.168.123.247’ could not be resolved: Name or service not known
Also do a scan and find out what the missing IP ending in 247 is. It’s always good to know.
Just as a caveat,
I don’t know your experience or your network I’m just trying to help you troubleshoot. and hopefully resolve your issue. My hassio connected (on the same node) without an issue. but I have nextcloud, zoneminder on the same node with no issues.
Would you also have a look at your Maria and tell me the exact format of the hassio user for your DB? for example: [email protected] or hassio@%. You can pm me any info you don’t want to post publicly.
i’ll have a look at that link later.
thx for helping me out already so far.
no internal dns servers and dont really want one.
i did a scan and it didn’t show up but it’s probably just my phone.
i studied networking but i fu**ing hate mysql pretty much as it hates me hehe.
my users are all @%
switching isp’s tommorow cos the modem of the current one doesn’t even do hairpining wich is a pain in the a$$ for nextcloud syncing. ill see how things go tommorow after i redid the modem config.