Mysql database structure

Help
2007-06-29
2012-10-30
  • Robert Hendrickx

    Hello,

    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...

    Thanks

     
    • erk

      erk - 2007-07-11

      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.

       
      • Thorvald Natvig

        Thorvald Natvig - 2007-07-12

        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.

         
    • Thorvald Natvig

      Thorvald Natvig - 2007-06-30

      scripts/mysql.sql

      ... which it seems I've forgotten to add to the default distribution. Grab it from SVN? :)

       
      • Robert Hendrickx

        Terrific.

        Thanks !

         
      • xylometazolin

        xylometazolin - 2007-07-02

        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?

         
        • Thorvald Natvig

          Thorvald Natvig - 2007-07-02

          database= is the database name :) It's the same parameter as used by sqlite.

           
          • xylometazolin

            xylometazolin - 2007-07-02

            OK, thank you.

            But the SuperUser can still not register. I get this output:
            $ ./murmur -supw
            Superuser password set
            Aborted

            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:

            dbDriver=QMYSQL
            dbUsername=murmur
            dbPassword=password
            dbHost=localhost
            dbPort=3306
            database=murmur

             
            • xylometazolin

              xylometazolin - 2007-07-02

              the line
              $ ./murmur -supw
              should look like this:
              $ ./murmur -supw blabla

              That's what I've executed.

               
            • Thorvald Natvig

              Thorvald Natvig - 2007-07-02

              Hm. I assume there actually is a users table etc in that mysql database?

              .. And that the table has an entry for SuperUser already?

               
              • xylometazolin

                xylometazolin - 2007-07-02

                Sorry, there is no users table but a players table and a player_auth table. But all tables are empty.

                 
                • Thorvald Natvig

                  Thorvald Natvig - 2007-07-02

                  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.

                  Hmmm.

                  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?

                   
                  • xylometazolin

                    xylometazolin - 2007-07-02

                    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?

                     
                    • xylometazolin

                      xylometazolin - 2007-07-02

                      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.

                       
                      • Thorvald Natvig

                        Thorvald Natvig - 2007-07-02

                        -supw just changes the password of uid 0. You can run it as many times as you want :)

                         
                • xylometazolin

                  xylometazolin - 2007-07-02

                  I have used the scripts/mysql.sql to create the database. It does not contain a users table.

                   

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks