[This problem always happen when reboot]

There's a permanent solution. Auto starts mysql after reboot. 

chkconfig --level 2345 mysqld onchkconfig --level 2345 mysqld on

side note: restarting a linux box doesn't solve any problems.

[How can i set CentOS to support over 1024 concurrent connection?]

As far as I know, Dell blade servers has a built in at least 2 network cards. Have your hosting plug in another extra cat5 cable, then bond the two network cards for faster network connection.

[check files: command not found error]

Have you tried

make clean && make sql

[Database Clean]

Don't forget to re-create the 's' account

[What software did you make for make android/ios apps?]

I'd go for unity3d for android games.

[Help :(]

Use the user zypherro when compiling. If the problem persists, do a

chmod -R 775 /path/to/trunk
chown -R zypherro:zypherro /path/to/trunk

[Possible to connect to another DB?]

Currently facing a problem with vote for points; I can't seem to point my 2nd server to my 1st server's vote for points' table, which is in the 1st database.

 

Is it possible to point my npc script to the 1st server? I tried putting db_name.v4p_table but it goes like 1st_db.db_name.v4p

 

Thanks!

[[Server OS] WinServer or Linux]

It is actually a user preference. Windows and Linux has it's difference.

But I would choose Linux over Windows because it's easy to maintain and debug, plus memory allocation is good.

[Ragnarok Urban Legend, Believe it or not?]

Good read. However, what do you guys think, was the ghost stuck in-game or the ghost was playing on a physical computer? 

[Block account ID from playing. (Multiple Server)]

So, currently I have two running servers in a VPS. They share 1 login database.

I want to restrict a GM account from the 1st server from playing in the 2nd server.

Basically, when that account ID logged in (after choosing a character) to the 2nd server. It kicks that account out.

 

Big thanks!

[help install phpmyadmin.]

It's just a matter of permissions. Change the folder permission to 744.

chmod -R 744 /path/to/folder

You might need to find phpmyadmin.conf to change 

<Directory "/path/to/phpmyadmin">
    Options Indexes FollowSymLinks MultiViews
    AllowOverride all
        Order Deny,Allow
        Allow from all
</Directory>

to this:

 

<Directory "/path/to/phpmyadmin">
    Options Indexes FollowSymLinks MultiViews
    AllowOverride all
        Order Deny,Allow
    Deny from all
    Allow from 127.0.0.1
</Directory>

 

Restart apache to apply changes.

 

Side note: Never use root as an owner for web pages, specially dynamic ones.

You might as well set your password to welcome123

[What is the best firewall "CSF" or "IPTABLES"?]

CaioVictor,

 

Weird. Can you specify your server specs? Maybe your RAM is failing. Do you have other services running in your server other than your emulator and MySQL?

You could do a top to see what's eating your RAM.

 

Also, do you have custom cron jobs to check your emulator's services?

[2 servers in 1 IP address with different rates.]

You can also do a 1 login, char & 2 map servers. More info here: http://rathena.org/wiki/Multiple_Servers

[Flux MySQL Port]

It's commented out. Remove "//" 

 

//  'Port'       => 3306
 

[What is the best firewall "CSF" or "IPTABLES"?]

Are you sure that you're receiving attacks? Maybe it's just a faulty svn version(?)

Could you paste here your crash dumps?

[Map-Server Crash - no crash dumps / logs]

Have you tried, bt full <core file>

Make sure there was a generated core file

do a ls -lhrt to see the latest updated file, usually the core file is the last one after a server crash

[Costume Sets? Super saiyan 2?]

Here http://www.mediafire.com/download/u91p2n6x5cl566g/Saiyan_Hair_ani.rar

[Goku Hair, MVP basketball hat and other new items]

Saiyan Sprite http://www.mediafire.com/download/u91p2n6x5cl566g/Saiyan_Hair_ani.rar

[How to change MySQL Password/phpmyadmin Linux]

Actually, If you have never set a root password for MySQL server, the server does not require a password at all for connecting as root. To setup root password for first time, use mysqladmin command at shell prompt as follows:

 

mysqladmin -u root password NEWPASSWORD

However, if you want to change (or update) a root password, then you need to use the following command:

mysqladmin -u root -p'oldpassword' password newpass

Source: Nixcraft

[VPS Inquiry]

Have you tried BuyVM.net (Frantech)? They have live chat to assist you right away.

[Base ATK not stacking]

Had this problem after updating my SVN to 17402++

Solved my problem by reverting back to 17401

[Web hosting or VPS needed ?]

Yes it's possible, but I think it's not advisable to host your DB on a shared web hosting.

 

If you want to secure back ups, do a crontab that dumps your sql files to a database outside your VPS

[Need normal jobchanger with 3rdjob/baby also]

http://svn.code.sf.net/p/rathena/svn/trunk/npc/custom/jobmaster.txt

[Web hosting or VPS needed ?]

I suggest you host your flux on a webhost, then have it point to your VPS' MySQL

 

Exception Details
Error: PDOException
Message: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '116.xxx.212.xxx' (4)

 

It might be permission thing, I usually do 'setsebool -P httpd_can_network_connect=1' if I'm on Linux

[@ECALL Delay]

What do you mean?

This script save the guild id of the leader in a variable attached to the npc (variable reseted when @reload script)

What I meant was, when a guild master disconnects after he/she casts an e-call. The variable will reset and he can use e-call again. Is this possible?