Discount Ninja

Access denied for MYSQL could be several things. 1. Be sure your user has access at 127.0.0.1 (localhost, 127.0.0.1, and % are all different addresses to mysql) 2. Username and or password could be wrong. 3. A firewall/anti-virus/security program could be blocking mysql access. 4. The service MYSQL isn't even running (Very common). 5. Your user doesn't have permission to access your RO database. Those are the most common fixes.

I really hope someone can help me with this. I’ve spend a long time trying to figure out the problem and I've narrowed it down. Using the command “lsof –i” I can see what programs are listening to what ports and addresses. It took some tinkering to get all of the servers to listen appropriately. (key) PROGRAM PID USER FD TYPE DEVICE SIZE/OFF NODE NAME clock-app 2866 ragnarok 21u IPv4 99207 0t0 TCP 192.168.0.10:51311->weather.noaa.gov:http (ESTABLISHED) login-ser 11080 ragnarok 5u IPv4 99226 0t0 TCP localhost:38355->localhost:mysql (ESTABLISHED) login-ser 11080 ragnarok 6u IPv4 99228 0t0 TCP *:6900 (LISTEN) login-ser 11080 ragnarok 7u IPv4 99272 0t0 TCP 192.168.0.10:6900->192.168.0.10:50175 (ESTABLISHED) char-serv 11084 ragnarok 4u IPv4 99270 0t0 TCP *:6121 (LISTEN) char-serv 11084 ragnarok 5u IPv4 99271 0t0 TCP 192.168.0.10:50175->192.168.0.10:6900 (ESTABLISHED) char-serv 11084 ragnarok 6u IPv4 99274 0t0 TCP localhost:6121->localhost:48537 (ESTABLISHED) map-serve 11088 ragnarok 5u IPv4 99263 0t0 TCP *:5121 (LISTEN) map-serve 11088 ragnarok 6u IPv4 99273 0t0 TCP localhost:48537->localhost:6121 (ESTABLISHED) As you can see from the table, all of the servers are connected and listening to the right ports. The real issue is with the char-server. I’m looking at a packet sniffer and it says the program appropriately connects to the login server at the WAN IP. However, after that initial connection, the client is told to look locally on the network that it isn’t a part of. The client attempts server’s LAN address, not the WAN IP. I've tried to force the WAN subnet only and char-server to wan only. It still tells the client to go to the LAN ip. Does anyone know how to get the server to tell the client to keep on the WAN IP?

That's a very old setup. You'll need to use something more up-to-date. Try this one. http://rathena.org/board/topic/63177-ro-open-setup-v291326-last-updated-20131020/

rAthena has set places for custom changes like in mobdb2, or custom NPC's. However, any vanilla edit you make to the server will have to be manually edited again when you update. Like the examples you provided. I've updated a lot of servers over time, I find that keeping a personal log of what you do makes the work go a lot faster next time you do the edits.

It sounds like you may have some client files missing or have the client diffed wrong. I had a similar issue with a bad patched client.

Double check your config for application.php and servers.php. If that looks good, check your SQL database to see if there are any CP_ tables, if so drop them. Next copy your configs elsewhere then retransfer fluxcp over the current one. Move your configs back and then try installing. Hopefully that will resolve your issue.

I'm not sure you can do something like that. But you are able to add skills that do similar things. If you want a monster that hurts itself, self hurting skills like grand cross will injure the monster. This adds really cool affects on the monsters. My custom monsters like to give themselves buffs as their health gets low. Keep in mind the skills will only go off when the map has players on it.

Go to db/pre-re You can adjust cast times in skill_cast_db.txt You can make skills not adjusted by dex or agi in skill_castnodex_db.txt You may want to lower the cast time if you're going to make it a fixed rate though.

In battle.conf // For those who is set, their innate attack element is "not elemental" // (100% versus on all defense-elements) (Note 3) // NOTE: This is the setting that makes it so non-players can hit for full // damage against Ghost-type targets with normal attacks (eg: vs. Ghostring). attack_attr_none: 14 Change this number to 15 so it works on players.

I've had a similar problem in the past, this time I've run into a dead end. I'm using client 2013-08-07 that's been diffed. It matches the same dates in mmo.h, which I have recompiled. I haven't edited the packet lines though. Server is running Linux, CENTOS. My LAN computers can connect to the server just fine. No errors. The server confirms this in the logs. The client XML is pointing to the right area.As the WAN client can log-on to the login server. It can see how many people are connected. However, it times out at they try to go to the char server. The server shows no logs or reports the issue of any WAN connection. This isn't the first server I've used. I have confirmed that the ports are setup correctly, and the firewall is setup. I can even telnet, using the ports 5121, 6121, 6900 to the server using the WAN computer. The WAN computer has access to all of those ports on the server, and the rAthena servers all say they have a strange packet(s) coming from the WAN computer. I still think it's a config issue but I haven't found something that's worked. Char_conf.txt login_ip: 192.168.0.10 //LAN char_ip: WANIP //WAN Map_conf.txt char_ip: 192.168.0.10 //LAN //bind_ip: 192.168.0.10 -not needed? map_ip: WANIP //WAN IP Subnet_athena.conf subnet: 255.0.0.0:WANIP:WANIP subnet: 255.0.0.0:192.168.0.10:192.168.0.10 I have also used: subnet: 255.255.255.0:WANIP:WANIP subnet: 255.255.255.0:192.168.0.10:192.168.0.10 I had a different server working. So I'm really at a loss on what's going on. Any ideas?

Not sure that the post was entirly read but that's OK. My problem was with the subnet. Thanks Brynner.

(Story, you can skip this) Some of my friends wanted me to start a Ragnarok server again. They got spoiled on my server about 3 years ago. They complained to me about every server afterward, heh. Anyways so I started an old school eAthena server. Got it working, everyone could connect. Found out that the third job classes were not available. Oh well... lets move to.... rAthena! Well I basically copied my working config over to the new one. The login, character and map servers all talk to each other, no warning messages or errors. I found my client "20120410" and found a client to patch. "Woo, almost done," so I thought. Username and Password goes in, my login server acknowledges this. I can see my new server with zero people online. However, when I try to connect to my character server. Please wait... "Failed to Connect to Server." Grr. If I can get an error message that's not so generalized I could work with it. My Character server doesn't display anything. Of course it wouldn't until I had a character created. Looking around the forums, I should check and recheck my configurations, right? These are copied from my import folder: char_conf.txt login_ip: 192.168.0.10 login_port: 6900 //bind_ip: 192.168.0.10 char_ip: diro.no-ip.org char_port: 6121 map_conf.txt char_ip: 192.168.0.10 char_port: 6121 //bind_ip: 192.168.0.10 map_ip: diro.no-ip.org map_port: 5121 My subnet: subnet: 255.0.0.0:127.0.0.1:127.0.0.1 subnet: 0.0.0.0:diro.no-ip.org:diro.no-ip.org <- This is a new one after reading some other posts. I'm running CENTOS, 6.3 with the latest updates. My server is using SQL, all users and permissions are set correctly. My ISP want's $40 a month for a single static IP. Pfft. So I'm using dynamic. Portforwarding is set, I poked holes in my firewalls for all the right ports. Don't ask me to go to the loop back IP's. (localhost or 127.0.0.1) My server likes to complain if I do that. Not to mention it didn't work with my eAthena server. What's strange to me is that with the same configuration, my old server worked just fine. I was able to connect behind my router on the LAN and my friends were able to connect on the WAN, through the dynamic IP, through the router and firewall. Copy Pasta should work with the import files, right? Well mostly as I found out. Just need to get the client setup right. But it's something else. I'm not sure what's different with rAthena to have it not work. It could be the config, an isolated incident with my current computer (which would be worse). I suspect that I didn't diff the client right? It's been a while since I've setup a server. So it could be something simple. If it's any modivation to help me out, I can donate or give away some of my old scripts and NPC's that I've worked on through out the years.