mariadb connection

[smithjames0]

Hi,

I have a problem with my script starting on boot up. If I start my script from the command prompt it works fine, if I start it from a cron job on boot I get a mysql connection error.

Traceback (most recent call last):
File "/home/pi/CoopControl/server.py", line 53, in <module>
mariadb_connection = mariadb.connect(host="localhost",user='root', password='some password', database='Chicken')
File "/usr/lib/python2.7/dist-packages/mysql/connector/__init__.py", line 179, in connect
return MySQLConnection(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/mysql/connector/connection.py", line 94, in __init__
self.connect(**kwargs)
File "/usr/lib/python2.7/dist-packages/mysql/connector/abstracts.py", line 722, in connect
self._open_connection()
File "/usr/lib/python2.7/dist-packages/mysql/connector/connection.py", line 207, in _open_connection
self._socket.open_connection()
File "/usr/lib/python2.7/dist-packages/mysql/connector/network.py", line 512, in open_connection
errno=2003, values=(self.get_address(), _strioerror(err)))
mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'localhost:3306' (111 Connection refused)

I have changed localhost to 127.0.0.1 and I get the same error, in my script I haven't specified a port number so I am not sure where 3306 has come from. Also why would my connection be refused only when the scripts starting on boot?

Can anyone help??

Regards

[DirkS]

I have changed localhost to 127.0.0.1 and I get the same error, in my script I haven't specified a port number so I am not sure where 3306 has come from. Also why would my connection be refused only when the scripts starting on boot?

Port 3306 is the default for Mysql / mariadb.

Most likely cause is that the DB engine is not yet ready when your script starts.
You could start with a pause / sleep to delay startup of your script

If your script runs in the background you could also make it a systemd service. It is then easy to wait until the DB engine is up and running.

[DougieLawson]

As Dirk says error 111 has three possible causes.

1. Wrong IP, port may be right or wrong
2. Right IP, wrong port
3. Right IP, right port server not listening

You problem is clearly #3.

[smithjames0]

Thanks for your help, I used After=mysql.service


Regards

James