Howto: Editing sqlite database to set default channel for Mumble

In order to set the default channel for your mumble server, from linux command line interface, we would use a tool called “sqlite3“. If you don’t have it installed, simply use “apt-get install sqlite3” or “yum install sqlite3“.

Once you got it, you want to edit your mumble server database. In order to open specific database, we type “sqlite3 database_name.sqlite”. Thus, we use line “sqlite3 mumble-server.sqlite” command to read in our server’s db. It is typically located in your home folder in the sub-folder named .mumble-server or whatever you named it during the installation process. Once we started sqlite3 interface to the database, we check if we selected the right database; by applying command “.databases“. note the dot in front of the command. you can call .help to read help, or .tables to list tables in the database as well.

sqlite> .databases

 seq  name             file

 ---  ---------------  ----------------------------------------------------------

 0    main             /home/luciano/.mumble-server/mumble-server.sqlite

 1    temp

sqlite> .tables

 acl            channel_links  group_members  servers        users

 bans           channels       groups         slog

 channel_info   config         meta           user_info

once you are sure you got the right database (by checking database name, path, and tables contained) you need to insert values. you need one more tiny bit of information – that is the numerical value (id) for the room you wanted to use as default (in our example – wanted room’s name is “Predvorje” ((lobby)) )

you can find that value by using string

 SELECT * FROM channels;

and than read the numerical value for the room you wanted – part of the output I get from my database is here:

1|9|0|=========={ GURU GAMING }=======|1

 1|12|0|============{ FAN PIT }==========|1

 1|26|0|==========={ PREDVORJE }=========|1

 1|17|2|Team A|1

 1|18|2|Team B|1

 1|1|9|Birc|1

so, room that i needed has had an ID value of 26. now I have all the information I need, all that is left is to insert values with this command:

sqlite> INSERT INTO “config” VALUES(1,’defaultchannel’,’26′);

only thing you needed to alter here from this string is the last value – 26 (which is the ID of the channel in MY case, not necessarily in yours).

I hope that this helps you finish configuration of the mumble server.

Tags: howto, mumble, sqlite