Maxime Gamboni - 2014-05-24

Hello,

Sorry for not responding within a reasonable time. Now that I have some time I will reply anyway in case you decide to try FreeSeat again, or for the sake of other people sharing the same issue.

Although it is recommended that FreeSeat has its own three users for security reasons (to contain the potential damage in case a vulnerability is found, as well as avoiding the admin password being written in cleartext in the configuration file), it is possible to run it as a single pre-existing user. Just set all three FreeSeat users (dbuser, systemuser, adminuser) to your pre-existing user, and write your password as password for all three users. Then, when running the sql scripts, simply skip all GRANT statements (assuming your user has the permission to create databases). If you don't have permission to create databases, but have your own pre-existing database, just set the "$dbdb" configuration parameter to the name of your database, then skip the "create database" statement as well.

I'm confused when you say you can't run sql scripts. Scripts are just sequences of commands, so if you can run individual commands then you can run several commands in a row as well... If you can't run individual commands then you can't run FreeSeat, because, well, FreeSeat needs to execute commands to store data and retrieve it later... :)