Issues with Linux

[ToiletMaster]

Hi guys, currently i'm actually testing a VPS server for Ragnarok online.

 

To be honest, i'm not fond of linux at all especially this is my first time hosting on a VPS Server.

 

Currently from what my knowledge is, Putty is meant as a terminal to connect from client to server.

 

And then using this putty, we should be able to download some screening software such as

 

VNC or x2Go, FreeNX. However right now i'm stuck on choosing the OS that's best fit for RO.

 

Is it possible if someone could guide me along the way? As in posting perhaps some lines or any guides that would help someone that has lack of knowledge towards Linux?

 

 

Thanks,

 

TM

 

------

 

These are the OS that i can select for my VPS, but really not sure on which one to go for.

 

Additional Info:

 

I have root access if that helps.

Edited April 21, 2013 by ToiletMaster

[Digos]

Visual access like VNC isn't needed. You'll use just a SSH client (Putty) and maybe a SFTP client.

 

I use CentOS for about 6 years to host ragnarok servers and it always works fine.

 

So I reccomend CentOS 6.x 64bit and follow this guide http://rathena.org/wiki/Installation_(CentOS) to setup your ragnarok server.

Edited April 21, 2013 by Digos

[ToiletMaster]

Visual access like VNC isn't needed. You'll use just a SSH client (Putty) and maybe a SFTP client.

 

I use CentOS for about 6 years to host ragnarok servers and it always works fine.

 

So I reccomend CentOS 6.x 64bit and follow this guide http://rathena.org/wiki/Installation_(CentOS) to setup your ragnarok server.

Thanks Digos for providing an insight,

 

however correct me if i'm wrong but i would need visual access in order to enter MySQL and check on my map/login/char server is that right?

Currently i'm gonna run on dual OS  (windows 8 + CentOS 6.4) and hopefully this thing out lol, right now it's installing the packages and i guess once i get familiarised with this it shouldn't be any problem on the other side.

Okay here's another update, i manage to rundown most of the things CentOS provides.

 

However currently the only issue i'm facing now would be MySQL settings.

 

How do i enter MySQL inside CentOS? I already followed all the guide but i understand the password is still s1/p1 how do i change that?

Edited April 21, 2013 by ToiletMaster

[Digos]

You have these alternatives:

 

1 - Use mysql client in the terminal

2 - Install PhpMyAdmin and use it from web

3 - Use some mysql gui client like SQLyog (the Community Edition is free http://code.google.com/p/sqlyog/)

 

1)

In the CentOS terminal login the mysql

mysql -u<username> -p<password>

show databases;

use <database name listed above>;

update `login` set `userid` = 'newuseridhere', `user_pass` = 'newuserpasshere' where `userid` = 's1';

 

2)

PhpMyAdmin is a web tool to administrate mysql databases. See how to install and use here http://www.cyberciti.biz/faq/centos-fedora-redhat-linux-installing-phpmyadmin-webtool/ this is the most easily option.

 

3)

You can use this option to connect directly to the mysql server running on your server.

 

I use this one to connect to my mysql databases with a ssh tunnel.

 

 

Some tips:

 

When creating mysql users always define the host allowed to login. (Step 5 in this guide http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html) To allow login from all hosts use % instead of the ip address or hostname.

 

Configure your linux to use ssh keys instead of text passwords (disable the last one) to login as root.

Edited April 22, 2013 by Digos

[ToiletMaster]

Although i'm not at home therefore i can't test directly on this.

 

However, what about installing mySQL Workbench for CentOS 6?

 

I managed to google up some links that provides links to download this.

 

Would it be possible to go for this?

 

On a side note,

 

Thanks for all the support you've given me so far Digos!

Edited April 22, 2013 by ToiletMaster

[Digos]

I guess that you can install it on your pc and connect remotely to your db.

[ToiletMaster]

I guess that you can install it on your pc and connect remotely to your db.

Well i managed to install the MySQL part. However it's slightly different from windows though, as windows MySQL provides a default MySQL Connection already, known as MySQLForExcelConnection something like that, for linux's version, it doesn't have any connections there

 

and i'm getting errors all over the place stating that it can't connect to each other.

 

i'm always getting this error on MySQL, i can't seem to find a way to fix this.

Edited April 23, 2013 by ToiletMaster

[Digos]

Maybe the user doesn't have privilege to be logged in from your IP.

 

If you want allow all IPs to login, create the user as:

 

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

The % above tells that all IP addresses can login

If you want connections only from 192.168.0.1 or localhost put there.

 

See Step 5 in http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html for more details.

Edited April 24, 2013 by Digos

[ToiletMaster]

Maybe the user doesn't have privilege to be logged in from your IP.

 

If you want allow all IPs to login, create the user as:

 

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

The % above tells that all IP addresses can login

If you want connections only from 192.168.0.1 or localhost put there.

 

See Step 5 in http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html for more details.

Hi Digos, I believe i know what might be causing it, but i don't really know to change it.

 

As currently i'm using VMWare to use 2 OS, (Not yet inserting into the VPS as of now),

 

So my windows 8 OS does have mysql running which i believe conflicts my CentOS 6.4 in my VMWare.

 

As it uses my Apache Port automatically, 443 which i had to change manually for it to work. Therefore i think MySQL Workbench would be the same.

 

Only problem is that i can't change it due to permission issues with the folder or perhaps i don't know how ._.