Freya SQL choice - Ubuntu 11.04 ?

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
ksmxbg
Posts: 109
Joined: Wed Aug 12, 2009 8:17 am

Freya SQL choice - Ubuntu 11.04 ?

Post by ksmxbg »

What MySQL needed for setup new clean Freya server ?

in Wiki its writen to i must use xampp for linux. Can I use mysql-server builded-in in ubuntu packages (from Ubuntu Software Center as example), or any other version ?

Or its a must for L2J to i use xampp ?

thanks
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: Freya SQL choice - Ubuntu 11.04 ?

Post by jurchiks »

What fool said you need xampp?
You don't need neither Apache or PHP to run l2jserver. I'm not sure about the Ubuntu built-in packages, but read my signature.
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
Sleek
Posts: 112
Joined: Tue Dec 28, 2010 1:11 pm

Re: Freya SQL choice - Ubuntu 11.04 ?

Post by Sleek »

Just install mysql-server from respisotory

Code: Select all

aptitude install mysql-server
That's all you need, then just start configuring it...

If you want to have it visually I recommend phpmyadmin and for that you need apache2

Code: Select all

aptitude install phpmyadmin apache2
ksmxbg
Posts: 109
Joined: Wed Aug 12, 2009 8:17 am

Re: Freya SQL choice - Ubuntu 11.04 ?

Post by ksmxbg »

thanks for answers
jurchiks wrote:What fool said you need xampp?
http://www.l2jserver.com/wiki/index.php ... r_-_Ubuntu
in this guide, ill install lampp (commonly called xampp too, "l" for linux)
ksmxbg
Posts: 109
Joined: Wed Aug 12, 2009 8:17 am

Re: Freya SQL choice - Ubuntu 11.04 ?

Post by ksmxbg »

jurchiks wrote: but read my signature.
so i do all of ur sig :) but server works with lampp and with build-in, i'm just amazed what to delete and with what will be better

so thanks again and i will be glad for any other suggestions for choice of sql for Freya
Sleek
Posts: 112
Joined: Tue Dec 28, 2010 1:11 pm

Re: Freya SQL choice - Ubuntu 11.04 ?

Post by Sleek »

ksmxbg wrote:
jurchiks wrote: but read my signature.
so i do all of ur sig :) but server works with lampp and with build-in, i'm just amazed what to delete and with what will be better

so thanks again and i will be glad for any other suggestions for choice of sql for Freya
Since you are running ubuntu I firstly suggest yo update to 10.10.

And my 2nd suggestion is to use mysql-server with phpmyadmin if you want visually. Lamp is no good for this purpose.
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: Freya SQL choice - Ubuntu 11.04 ?

Post by jurchiks »

ksmxbg wrote: http://www.l2jserver.com/wiki/index.php ... r_-_Ubuntu
in this guide, ill install lampp (commonly called xampp too, "l" for linux)
That doesn't mean you have to do exactly the same. Instead of installing xampp, install just mysql.
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
ksmxbg
Posts: 109
Joined: Wed Aug 12, 2009 8:17 am

Re: Freya SQL choice - Ubuntu 11.04 ?

Post by ksmxbg »

thanks 4 all and it's not important but why msql-server from Ubuntu packages is better from lampp ?
Sleek wrote:Since you are running ubuntu I firstly suggest yo update to 10.10
10.10 have problems with Intel graphic drivers, it's solved in 11.xx (i first test serv/client on one machine)
Sleek
Posts: 112
Joined: Tue Dec 28, 2010 1:11 pm

Re: Freya SQL choice - Ubuntu 11.04 ?

Post by Sleek »

ksmxbg wrote:thanks 4 all and it's not important but why msql-server from Ubuntu packages is better from lampp ?
Sleek wrote:Since you are running ubuntu I firstly suggest yo update to 10.10
10.10 have problems with Intel graphic drivers, it's solved in 11.xx (i first test serv/client on one machine)
Why would you use GUI for linux server?
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: Freya SQL choice - Ubuntu 11.04 ?

Post by jurchiks »

Uhh... linux doesn't mean you absolutely have to use console only.
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
Sleek
Posts: 112
Joined: Tue Dec 28, 2010 1:11 pm

Re: Freya SQL choice - Ubuntu 11.04 ?

Post by Sleek »

jurchiks wrote:Uhh... linux doesn't mean you absolutely have to use console only.
It does not but then you might as well use windows server if you are going to use GUI for your server. You lose performance from GUI.
ksmxbg
Posts: 109
Joined: Wed Aug 12, 2009 8:17 am

Re: Freya SQL choice - Ubuntu 11.04 ?

Post by ksmxbg »

Sleek wrote:Why would you use GUI for linux server?
GUI it's not bad , but terminal is no problem (i was born on terminal :) but this is other topic )... just for protocol lets we talk what is best for Freya

thanks
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: Freya SQL choice - Ubuntu 11.04 ?

Post by jurchiks »

Sleek wrote:It does not but then you might as well use windows server if you are going to use GUI for your server. You lose performance from GUI.
You might lose server peformance, but not your own. Also you can do many things with GUI faster than without, and you can disable it when you don't need it, so...

You can disable GUI on windows too, just end explorer.exe and run cmd.exe and go ahead. But is it more comfortable?
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
ksmxbg
Posts: 109
Joined: Wed Aug 12, 2009 8:17 am

Re: Freya SQL choice - Ubuntu 11.04 ?

Post by ksmxbg »

so gui or cmd .. lets all use what they like more ...

anyway SQL Server version: 5.1.49-1ubuntu8.1 (Ubuntu) it' okay for Freya ? and what about versions of SQL Servers, are they good to be latest, or you can recommend me specific version that is the best one ?
Sleek
Posts: 112
Joined: Tue Dec 28, 2010 1:11 pm

Re: Freya SQL choice - Ubuntu 11.04 ?

Post by Sleek »

ksmxbg wrote:so gui or cmd .. lets all use what they like more ...

anyway SQL Server version: 5.1.49-1ubuntu8.1 (Ubuntu) it' okay for Freya ? and what about versions of SQL Servers, are they good to be latest, or you can recommend me specific version that is the best one ?
Use latest sql server.
Post Reply