Jump to content
Mumble forums

murmur_servers table already exists


siva_dashq
 Share

Recommended Posts

Hi guys,


I'll try to put this as brief as i can.

My project is to offer users to rent a mumble server that i host on my server.

I already got the website that is handling user registration and stuff like that, and for now the way i do things is that i execute a script in ssh that creates a new server which port i increment. First i was working with sqlite file but in want to switch to a MySQL server. I changed the config of each mumble consequently, i indicate the port and the name of the DB. The problem is this :


Creating a first server isn't a problem, all tables are correctly created in my DB, but as i'm trying to create a second server (with a different port), i have an issue. I've been checking the logs to see what queries were submitted to my MySql server, and i realized that each time i'm creating a new server, this query is executed :


[CREATE TABLE `murmur_servers`(`server_id` INTEGER PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin]: Table 'murmur_servers' already exists QMYSQL3: Unable to execute s$


Is there a way to indicate that i want a INSERT type of query instead of a CREATE one?


PS : I've been checking few topics about it (there's not much on that matter), and all recommend the use of API ICE (which i'm not familiar with), but i'm really want to avoid the use of it if its possible. If there are really no other ways then i will get some info about it.


Thanks a lot !

Link to comment
Share on other sites

  • 2 months later...
  • Administrators

Using MySQL is not officially supported.

However, if there is a problem with it please create a bug ticket.

If you can provide a patch that would fix it that would be even better.


As MySQL is not being tested (by us) it is very well possible that an issue was introduced at some point.


Regarding Ice, Ice is indeed the recommended way to handle such a use-case.

One Mumble server process can host multiple servers on multiple ports (rather than duplicating ini-files and processes). These can be created via Ice.


If you want to not use Ice, or specifically want one process for each server, that’s fine as well.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...