Setting up a Debian Linux VPS Issue

[Hero192]

Hello,

I have got a vps debian linux, but I have no idea how to add MTA into it and how to add resources..etc

Please give me a hand,

I am using puTTY SSH.

Untill now I did this

wget http://github.com/multitheftauto/mtasa-blue

but I don't know the next things..

[S.L.C]

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.

• Getting a precompiled package
  
• Installing and Running MTASA Server on GNU Linux

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.

[Hero192]

Now I had installed MTA but How to add my resources into it?

[S.L.C]

Again, the wiki is your friend. Introduction to Resources.

[Hero192]

Again, the wiki is your friend. Introduction to Resources.

I want to know how to add resources to the vps

[S.L.C]

Download WinSCP. Add your VPS, connect into it. and manage your files.

[Hero192]

I still have one issue, when I close the PuTTY SSH Client, the server goes off, what I have to do?

[S.L.C]

Damn, it's like a never ending cycle down here. Just stick to playing people if you can't google or haven't touched a server in your life.

[Hero192]

Damn, it's like a never ending cycle down here. Just stick to playing people if you can't google or haven't touched a server in your life.

Man, I appreciate your help and don't forget I am new with that,

also, Can I just know does this Linux Screen has a programme to download or I'll just add some codes to the puTTY Client SSH?

thanks in advance

[S.L.C]

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.

[Hero192]

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

[S.L.C]

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

Dunno. But if you really have to ask me that... I'd say there's plenty.

[Hero192]

I don't know why I even that I installed the linux screen onto the puTTY, and when I Close the puTTY the server goes down, why I always have to keep this in my computer?

What can I do please?

btw, special thanks to S.L.C

[S.L.C]

You don't have to just install Screen. You also need to open a session in Screen and then start the server in that Screen session. And then detach from that screen session. Which let's it run in the background for you to attach later. As described in that guide with also contains a brief

. Did you even read that guide or you simply ignored it like everyone else does.

[Hero192]

By the way, what I have to do, for installing xampp in linux debian 8.1 to connect to database?

I tried but I failed

[S.L.C]

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.

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.

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.

[Hero192]

You're really a good person I appreciate your hard works !!

going to try that

[Hero192]

there's no folder / file named mysql, I have no idea about what I have to do in this case

shall I create it or i have to get it from somewhere?

[S.L.C]

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.

[Hero192]

Bro, shall I follow that step by step like how you wrote them in below? because that looks interesting

[S.L.C]

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.

[Hero192]

Alright, thanks again I'll go ahead and try the second option

[Hero192]

I tried all what you told me and I was about to success,

but I faced an error,

NOTE: host ip... (IS ME)

Anyone can help me?

[S.L.C]

...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.