fetch_updates.sh can't connect to MySQL - SOLVED

+2 votes

Hi,

Just wanted to point out that people may need to add the port number of their MySQL server to the fetch_updates script.

I also believe that using DB_HOST=localhost uses sockets and might also prevent connections(depending on the MySQL configuration).

I changed DB_HOST=127.0.0.1 and then because my port is different to the standard I added

DB_PORT=8889

and then added the --port param to the MYSQL_DB_CMD command.

MYSQL_DB_CMD="$MYSQL -h $DB_HOST --port=$DB_PORT -u $DB_USER -p$DB_PASS $DB_NAME"

This works fine now. Just thought I'd pass it on in case others might have this issue in the future.

asked Apr 16, 2018 in Smartform by BobBob Plater (190 points)

Please log in or register to answer this question.

...