Hello All,
I have a mariadb on CEntOS 7.3 with non-standard datadir and socket.
The configuration is implemented via drop in files.
[root@tweety ~]# cat /etc/my.cnf.d/tweety.cnf
[mysqld]
datadir=/mnt/services/DBs/mysql
socket=/mnt/services/DBs/mysql/mysql.sock
[client]
socket=/mnt/services/DBs/mysql/mysql.sock
The weewx configuration is:
[[MySQL]]
driver = weedb.mysql
# The host where the database is located
host = *localhost*
# The user name for logging in to the host
user = weewx
# The password for the user name. Put in quotes to guard against
parsing errors.
password = *****
I keep on getting an error on weewx launch:
engine: Database OperationalError exception: (2002, "Can't connect to local
MySQL server through socket '/var/lib/mysql/mysql.sock' (2)")
Tried to 'setenforce 0' but I get the same error.
Tried to add the non-standard socket in the /etc/my.cnf main config file
still no luck.
The only way to make it work is to change the weewx.conf to force it use
the TCP/IP connector instead of the default socket connector.
[[MySQL]]
# The host where the database is located
host = *127.0.0.1*
Is the socket location hard coded in the weedb.mysql?
Is there something else I am doing wrong or missed in the documentation?
Is there something that should be changed in the code or added in the
documentation?
Thank you for your time.
--
You received this message because you are subscribed to the Google Groups
"weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
