CubeCoders / AMP

Issue tracking and documentation for AMP
https://cubecoders.com/AMP
207 stars 38 forks source link

Feature Request: MySQL integration #210

Open Lostepic opened 4 years ago

Lostepic commented 4 years ago

It would be great to MySQL integrated so that you could connect amp to mysql and then have amp creat users a database like how another popular MC panel does.

A lot of game server can use mysql databases for plugins etc so thought it would be good :)

hellot1m commented 4 years ago

I second this! I'm currently using the standard MySQL software but agree this would be super convenient to include it as a feature of AMP. A one stop shop for all server needs. Seems to be the direction AMP is going for. A MySQL option would be a fantastic addition.

PhonicUK commented 4 years ago

This largely depends on what kind of integration is needed. Something that can straight up databases and table schemas would be too much work to be viable. If it just needs to be be able to create a blank database with a set of login details then that's possible.

Lostepic commented 4 years ago

I mean as the other panel does all it needs is the following,

To create a database and a user as well have show these in the panel, also a link to phpmyadmin install.

This could be done with just a option under an instance that we can select press create database and in return we are given the user, pass and link to phpmyadmin.

I suppose we could have this in 2 ways, the first could be a simple settings page that allows us to input MySQL details of a user that can create delete and modify users as needed and an input box for phpmyadmin.

The other would have it all built into the installer so that along with amp, everything will be installed however as this is a feature not everyone will use I believe that it will be better to do the latter and have just a how to on installing MySQL and phpmyadmin etc, hope this helps

hellot1m commented 4 years ago

This largely depends on what kind of integration is needed. Something that can straight up databases and table schemas would be too much work to be viable. If it just needs to be be able to create a blank database with a set of login details then that's possible.

That would plenty. Most of what MySQL is used for with gaming is very basic. Most of the other features aren't really needed.

MjolnirMouse commented 4 years ago

What would the database be used for. Any server info or something because currently ark doesnt utilize db though maybe other supported games do idk

PhonicUK commented 4 years ago

Some Minecraft plugins support using MySQL to store data.

funnycubeguy commented 6 months ago

Why has this not been added yet? Pterodactyl does this and it is free

IceOfWraith commented 6 months ago

Priorities mainly. It's in the plans but takes time to get right.

PhonicUK commented 5 months ago

It's more that there needs to be a general purpose 'service instance' system for stuff that isn't an actual application. Ptero is just a docker frontend so it doesn't care (or know) what's running in those containers. AMP is more sophisticated and needs more information about what the containers are doing.

It does mean that AMPs implementation of this will also be limited to running these kinds of services in Docker containers too rather than try and make them work the way AMP does for the actual applications.