Jump to content

Setting up a Debian Linux VPS Issue


Recommended Posts

Not sure where you got that idea but that's not the road you want to take. Somehow you skipped the first two links in the wiki and reached to the building part which isn't really meant for server owners unless they want to tweak or develop stuff.

Although I find the wiki to be pretty straight forward about the installation so I'm not sure that that's the problem here.

And if you still don't manage to install it then you should probably stick to playing. Most people do that.

I've never even tried an MTA server or even to play for that matter. But the wiki was so clear and specific about doing things that it took me a few minutes to adjust.

Link to comment
apt-get install screen 

I get that you're new but for the love of god man. Learn the basics first and then move on to what you're trying to do. Otherwise you're on a straight path to ignore questions everywhere.

Thanks you alot !!, so I think it's the last action? I mean I am done?

or is there still something that I don't know

Link to comment

What I'm about to recommend is a major security issue and I wouldn't recommend it to anyone that wants a secure server. But the reason I will recommend this to you is that the thought of you setting up a web server with PHP enabled and setting up a phpMyAdmin instance is giving me chills right now. The only other way I'd know to help is to install some control panel on the VPS or via team-viewer. So let's begin.

Edit the file located in /etc/mysql/my.cnf and change the port to a random number that is different than the default port. Then edit the address to which the MySQL server binds to the IP address assigned to your VPS.

Untitled.jpg

After you edit and save the file. Restart your server via the following command line:

service mysql restart 

Or simply reboot your VPS.

Also, be sure to update the IP address and port you set in the my.cnf file in your Lua code as well.

After you've done that you can connect to your MySQL server from the outside world (that's why this is a security issue!). And you can do that with the HeidiSQL software. So download that, install it and open it. Then add your server and connect to it.

Untitled.jpg

You can create databases/tables and execute SQL queries after you connect to your MySQL server. Please note that some MySQL installations disable root connections from the outside world. So if your server happens to have that enabled then you can try to connect as much as you want but you'll fail every time. You must either enable root authentication from the outside world (bad idea!) or create a new MySQL user and use that.

Link to comment

Have you installed the MySQL server? There are two options. The one from the official repositories or the more recent one from the Dotdeb repositories.

Official:

Do an upgrade first:

sudo apt-get upgrade && sudo apt-get dist-upgrade 

And install the MySQL server:

sudo apt-get install mysql-server mysql-client 

Dotdeb:

If you want to have the latest MySQL server (might not be a good idea seeing how the MySQl plugin/module seems to require some older libraries) you can install it from the Dotdeb repositories.

First add the repositories:

sudo echo -e "\n\n# DotDeb Repositories" | sudo tee -a /etc/apt/sources.list 
sudo echo -e "deb [url=http://packages.dotdeb.org]http://packages.dotdeb.org[/url] wheezy all " | sudo tee -a /etc/apt/sources.list 
sudo echo -e "deb-src [url=http://packages.dotdeb.org]http://packages.dotdeb.org[/url] wheezy all " | sudo tee -a /etc/apt/sources.list 

Fetch and install the GnuPG key:

wget [url=http://www.dotdeb.org/dotdeb.gpg]http://www.dotdeb.org/dotdeb.gpg[/url] && sudo apt-key add dotdeb.gpg && sudo rm -f dotdeb.gpg 

Do an update:

sudo apt-get update 

Install the MySQL server:

sudo apt-get install mysql-server mysql-client 

Secure the MySQL installation:

sudo /usr/bin/mysql_secure_installation 

Answer with (Y)es to everything except when asked if you want to disable remote connection with root user. Because you actually want that in this case. Normally you disable that as well but you need it for now.

Link to comment

Follow whichever you want. The official server is a bit more outdated but promises more stability. Although that stability might only be applicable to MTA (from what I've seen so far). Where as the second option installs a more recent version but you should be careful about not breaking compatibility with MTA. Personally, I'd go with the second option because I'm more used to it and I know what to expect. And if the second option poses any issues you can always remove it and install the official version instead.

Link to comment
...Please note that some MySQL installations disable root connections from the outside world. So if your server happens to have that enabled then you can try to connect as much as you want but you'll fail every time. You must either enable root authentication from the outside world (bad idea!) or create a new MySQL user and use that.

I mentioned this issue already. Google for something such as "debian allow remote mysql connection". Some of those guides should tell you how to create users that allow you to connect from remote hosts.

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...