Hello to all,
I would be grateful if anyone knows how to solve a problem by running a sql query through a scritpt at system startup.

The script is written in bash as follows:


#!/bin/bash

query_result=$(mysql -NB -u dbuser -p'dbpwd' -DDATABASE -e "SELECT name FROM users ORDER BY id;")
echo "Result: "$query_result >/tmp/ppp.txt


If I run the script manually (typing ./script.sh), the query returns the list of data in the database.
If performed automatically during startup (adding a line in /etc/rc.local file) , it only return "Result:" (the string made by echo command in the script...)

Some idea ?
thanks

Try using an absolute path to mysql. It’s likely that the script doesn’t know where it is when run from the init file..

Thank you,
I tried to write the script in the following way:

but the problem persists

#!/bin/bash

query_result=$(/usr/bin/mysql -NB -u dbuser -p'dbpwd' -DDATABASE -e "SELECT name FROM users ORDER BY id;")
echo "Result: "$query_result >/tmp/ppp.txt

Hmmm.
Is DATABASE an obfuscation for your post, or is that a variable that exists in your CLI environment?
If the latter, it's not present in the environment when run from the init file...either populate within the script, or use the actual database name there.

Oh. Please put code and output examples in [code] tags...
PS You're sure that mysql is at /usr/bin/mysql? Mine is at /bin/mysql

You might want to start mysqld beforehand.

1 members found this post helpful.

Yeah!!!
Adding this command "/etc/init.d/mysql start" before the script as:

/etc/init.d/mysql start
query_result_b=$(/usr/bin/mysql -NB -u root -p'root' -DAUTOCONTROLLER -e "SELECT dev_mac_address FROM bt_devices_enabled ORDER BY id;")
echo "Dopo :"$query_result_b >/tmp/ppp.txt


Worked!

Thank very much!!!