How to get the raw query sql in the develop flarum?

nnduy

Do anyone setup successfully to get the raw query sql?

luceos

nnduy can you explain what exactly you are trying to do?

Flarum uses Laravel components behind the scenes, so that includes the Eloquent query builder and models.

nnduy

luceos
As you can see DB::table('users')->toSql() or $query->toSql() after we write the Eloquent query builder and models on the laravel framework. I want to get the sql command to verify exactly.
On the laravel framework I can install barryvdh/laravel-debugbar but the Flarum I can't do it yet.

adrianm

nnduy

for debugging the queries, the MySQL General Log is good, you can set this up in mysql config

This is in my /etc/mysql/mysql.conf.d/mysql.cnf but the actual file might be different for you - seems to be a heap of possible places to put settings for mysql

[mysqld]
general_log_file = /var/log/mysql/mysql/log
general_log = 1

this will log out every query and have a big performance impact so you 100% do not want to have this setting on a production server

nnduy

adrianm
Thank you for your supporting! I've already edited successfully.
One more thing I have to change the permission to make sure that your user has write permission.

SychO

You can also use fof/clockwork