SQL issues

[dmelvin]

So, my setup is a bit different that others. I'm using a raspberry pi with a headless raspbian install.

I built the LAMP stack myself with Apache2, MySQL, and PHP5

Here is what I get when I try to load the webpage. "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY time DESC' at line 4"

Going through the setup, I did notice a discrepency when setting up the SQL database.

"GRANT USAGE, FILE TO 'steve'@'localhost';" would not work, I got back wrong Syntax.

I do know (by looking at mobile data usage after a test trip) that torque is uploading to the server. So at least I've got that going for me.

I am not SQL or PHP savvy. So any help would be appreciated.

Thanks, Denton

[econpy]

Others have run this setup using Raspbian on an RPi, so I suspect you have some simple errors going on here. Take a look at your Apache error log to get a bit more direction: /etc/log/apache2/error.log

Also, if you want to see if your data was being logged, why not just open an MySQL terminal and run:

USE torque;
SELECT * from raw_logs;

If it returns results, then your data logging is working. Check these out and go from there.

[dmelvin]

I get "empty set" from the MySQL terminal. :-(

/etc/log is not there.

Perhaps I should nuke it and try it again?

[econpy]

Whoops, my bad -- it's /var/log/apache2/error.log. But either way, you have more than one issue with your server if you don't even have any data in your database. Check that your settings are correct in the app first and get a LAMP stack working properly. If you run into issues that have to do with this repo specifically, then I can help.

[xXAzazelXx]

Hey guys,

Im very new to this and dont know SQL :(

When i follow your guide and at very start when i try to create database I get the same error.

---

GRANT USAGE, FILE TO 'azazel'@'localhost';

mysql> GRANT USAGE, FILE 'azazel'@'localhost';

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''azazel'@'localhost'' at line 1

Everything above worked fine.

mysql> CREATE DATABASE torque; Query OK, 1 row affected (0.24 sec)

mysql> CREATE USER 'azazel'@'localhost' IDENTIFIED BY 'blablabla'; Query OK, 0 rows affected (0.00 sec)

Any ideas? :)

[robermf]

Hey guys,

Im very new to this and dont know SQL :(

When i follow your guide and at very start when i try to create database I get the same error.

GRANT USAGE, FILE TO 'azazel'@'localhost';

mysql> GRANT USAGE, FILE 'azazel'@'localhost';

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''azazel'@'localhost'' at line 1

Everything above worked fine.

mysql> CREATE DATABASE torque; Query OK, 1 row affected (0.24 sec)

mysql> CREATE USER 'azazel'@'localhost' IDENTIFIED BY 'blablabla'; Query OK, 0 rows affected (0.00 sec)

Any ideas? :)

Same problem here :)

[grantovius]

It appears the correct syntax is GRANT USAGE, FILE ON *.* TO 'user'@'localhost'; You have to state the database scope, and it has to be all since the "FILE" privilege is global. https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_file

I'm just starting out trying to set it up on a Centos7 VM and ran into the same issue but adding the *.* made it run correctly.