Mysql database layout for version 1.1

Help
2007-10-21
2012-10-30
  • Florian Unglaub

    Florian Unglaub - 2007-10-21

    Hello,

    i found a sql-file for version 1.0 in the SVN but nothing for 1.1 and it looks like some tables were changed. Any chance to get an instruction somewhere for the current version?

    Regards.

     
    • Florian Unglaub

      Florian Unglaub - 2007-10-21

      Ok, i deleted my database and recreated it with 'create database murmur;'. Starting murmur just gives me:

      <W>2007-10-21 17:27:01.519 Initializing settings from /home/ts/murmur/murmur.ini
      Enter PEM pass phrase:
      <W>2007-10-21 17:27:04.384 QString::arg: Argument missing: SELECT count() FROM players,
      <W>2007-10-21 17:27:04.384 QString::arg: Argument missing: SELECT count(
      ) FROM players,
      <F>2007-10-21 17:27:08.083 SQL Prepare Error [INSERT INTO %1log (server_id, msg) VALUES(?,?)]: Table 'murmur.log' doesn't exist QMYSQL3: Unable to prepare statement

       
      • Thorvald Natvig

        Thorvald Natvig - 2007-10-21

        Uh. QMYSQL3? What version of MySQL are you using?

         
    • Florian Unglaub

      Florian Unglaub - 2007-10-21

      Yast says 5.0.18

       
      • Thorvald Natvig

        Thorvald Natvig - 2007-10-21

        I'm unable to replicate this.

        Could you start with a fresh database (without any tables) and run murmur with '-fg -v' and post the entire output here? Also post the mysql log if you have it. Also, I'm taking you've built this from source. Which version of Qt did you use?

         
    • Florian Unglaub

      Florian Unglaub - 2007-10-22

      I just compiled murmur from svn and it works like a charm.

       
    • gabrielcz

      gabrielcz - 2007-11-06

      Hi there... BY THE WAY ! :)
      I compiled from source and when it finished I realize that we don't need to recompile from source, it just need to add a line like this to the INI file.

      dbPrefix=XX <-- where XX means whatever you want.

      I know, maybe its stupid, but i was there recompiling all murmur for nothing, so, pherhaps another one can read this and solve soon that me.

      Regards.

       
    • Thorvald Natvig

      Thorvald Natvig - 2007-10-21

      MySQL database creation has moved into ServerDB.cpp. Byond setting up the database you don't need to configure any tables manually.

       
    • Florian Unglaub

      Florian Unglaub - 2007-10-21

      Ok, i droped the db, created a new one.

      ts@server128:~/murmur> ./murmur.x86 -fg -v
      <W>2007-10-21 17:40:59.144 Initializing settings from /home/ts/murmur/murmur.ini
      Enter PEM pass phrase:
      <D>2007-10-21 17:41:01.638 SQL Prepare Error [SELECT value FROM %1meta WHERE keystring = 'version']: Table 'murmur.meta' doesn't exist QMYSQL3: Unable to prepare statement
      <D>2007-10-21 17:41:01.638 SQL Error [SELECT value FROM meta WHERE keystring = 'version']: Table 'murmur.meta' doesn't exist QMYSQL3: Unable to prepare statement
      <W>2007-10-21 17:41:01.638 QString::arg: Argument missing: SELECT count() FROM players,
      <W>2007-10-21 17:41:01.639 QString::arg: Argument missing: SELECT count(
      ) FROM players,
      segmentation fault.

      I didn't build murmur from source, i downloaded the static version. It runs fine with SQLite.

       
      • Thorvald Natvig

        Thorvald Natvig - 2007-10-21

        Bug found and fixed. Seems I need to stop testing only the the most complex setups and also test the quite normal ones.

        This will be fixed in 1.1.1. In the meantime use either SQLite or set dbPrefix to something. The problem is that MySQL doesn't like a table called "log", but if it ends up as 'mumble_log' or something similar then everything is fine.

         

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

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks