Is it possible to put on the wiki the database structure to use on Mysql ? A SQL file would be really great !
I tried to export it from sqlite, but the syntax is quite different, and I don't know what indexes or triggers are really needed...
What is the OMYSQL driver? Where can I get it, or can I use another driver? I have murmur running on Centos Linux from the pre-compiled 0.95 binaries.
QMYSQL is Qt's driver for MySQL. The reocmmended database is SQLite3, which is what is used by default if you don't explicitly specify a different databse driver.
... which it seems I've forgotten to add to the default distribution. Grab it from SVN? :)
Thank you. I have tried to configure murmur to use a MySQL database server, but in the example ini file there is no parameter to define the database name. I have tried 'dbDatabase' but it didn't work. I couldn't create the SuperUser account with
./murmur -supw password
How can I set the database name?
database= is the database name :) It's the same parameter as used by sqlite.
OK, thank you.
But the SuperUser can still not register. I get this output:
$ ./murmur -supw
Superuser password set
And the database is unchanged after this execution.
But phpMyAdmin and mysql command line client can login and edit the database.
my configuration looks like this:
$ ./murmur -supw
should look like this:
$ ./murmur -supw blabla
That's what I've executed.
Hm. I assume there actually is a users table etc in that mysql database?
.. And that the table has an entry for SuperUser already?
Sorry, there is no users table but a players table and a player_auth table. But all tables are empty.
Err. I meant players. My bad. I had planned to change it, but never got around to it, so it's now "players" for good :)
If they're empty, murmur fails to add the superuser account. This is done long before the PW is set.
This works fine on my testbox, but that doesn't really mean anything; it's been through all the steps of development.
Does the user you connect as have the necesarry privileges on the database?
Yes the user has full access / rights to the database. I have already inserted a record using phpMyAdmin and murmur login.
Maybe I can set a debug level or something else?
Sorry. I have made a mistake. SuperUser is already in the table.
Would be good if murmur prints in such a case "SuperUser already registered" or something else.
Thank you for your help.
-supw just changes the password of uid 0. You can run it as many times as you want :)
I have used the scripts/mysql.sql to create the database. It does not contain a users table.