[Sql Error] login-server_sql does not exist, or can't run

[Orgasmator]

Hi all,

I've been running my own server on my local computer,which is using Win7, about 1,5 weeks. Now, I've come to buy a host and establish it to our players. I've bought a VPS from Frantech company with BuyVM. Which is using RagnarokOS(centOS 5 based).

First of all, I've transferred my entire eathena file from my local computer via SSH. Then I've bought shared SQL and imported main.sql and logs.sql. There's no schemas such as ragnarok or log. I've made a database called omegaros_ragnarok. Then made a username omegaros_root and set all privs available. I checked if my sql is accesable by my host's IP.

I've tried to run athena-start, but it failed with an error such ^M coding. It was coded for Windows so I changed it to Unix with the command "dos2unix". After all spending hours, I've finally managed to start it but now another error occurs that I can't get rid of by myself.

I've assumed it was because of my inter_athena.conf . I've made the proper changes:

I'm aware of the situation that I'm using eAthena and this is rAthena forums. But I'm following up this forum recently and they're almost same. It's nothing about the emulator itself right?

Thanks in advance. Hope someone can help because I'm seriously nervous about it.

Peace.

[DarkIrata]

Recompiled it for Linux?

[en_dev]

on linux command, do make clean then make sql , type it twice if it didnt run at first. let it recompile, then run your server using linux command.

./athena-start start

[Orgasmator]

When I use

make clean

or

 make sql

I get a message like

make: *** No rule to make target 'sql' . Stop.

I tried it both in root and my server's (Omega) folder. Am I missing something?

EDIT:

Recompiled it for Linux?

Frantech's RagnarokOS has "Start my Server, Stop My server, Restart my Server, Recompile My Server" Icons on desktop. Delta told me to use that Recompile Icon but i'm not sure it's working since I did not setup my server from scratch. I don't know how to recompile in any other ways.

Edited June 23, 2012 by Orgasmator

[DarkIrata]

When I use

make clean

or

 make sql

I get a message like

make: *** No rule to make target 'sql' . Stop.

I tried it both in root and my server's (Omega) folder. Am I missing something?

EDIT:

Recompiled it for Linux?

Frantech's RagnarokOS has "Start my Server, Stop My server, Restart my Server, Recompile My Server" Icons on desktop. Delta told me to use that Recompile Icon but i'm not sure it's working since I did not setup my server from scratch. I don't know how to recompile in any other ways.

Recompile it, there should be a .sh file for map, login and char server.

.sh is the linux .exe file.

[Orgasmator]

Recompile it, there should be a .sh file for map, login and char server.

.sh is the linux .exe file.

Yeah I've seen them but I don't know how to recompile in Linux since it doesn't have Microsoft C++ Visual Studio. I think that "Recompile My Server" is not working. Can you tell me the command or any other ways to recompile?

[DarkIrata]

http://rathena.org/board/topic/59529-setting-up-a-centos-vps-w-rathena-vnc/page__hl__%2Brathena+%2Blinux+%2Bcompile

there you should find a tutorial for compile.

[Bahmut]

You have to use:

make clean
./configure --enable-64bit
make sql

if you don't have a 64 bit system just use:

./configure
make sql

For a full guide:

http://rathena.org/wiki/Installation_%28Debian%29 for Debian Systems

http://rathena.org/wiki/Installation_(CentOS) for CentOS

[Orgasmator]

Ok I've managed to configure and recompile. Now my problem is "Can't connect to MySQL server on 172.16.244.119" (111)

My inter_athena.conf is stated at the top. What's the problem now?

[Bahmut]

If the mysql database is on your server you can use localhost instead of the ip address. If you are using another servers mysql database please make sure it allows connections from your game server.

[Orgasmator]

When I use localhost it gives me that socket error. When I use 127.0.0.1 It gives me that "Can't connect to MySQL server error" I'm using shared SQL.

EDIT: Ok now I got you. Understood the basic logic. They've sent me the IP of my sql server with mail. Now another error:

Acces denied for user "omegaros_root"@"209.141.53.199" (using password: YES)

I'm sure omegaros_root has all the privs

What do i do now?

EDIT2: Oooookay! Well, I added the omegaros_root to database again and added my server's IP for the acces again. Now I've one step closer.

New Problem: make_connection: connect failed (socket #5, code 111)!

Problem v456789: make_listen_bind: bind failed (socket #4, code 99)!

What should I change my bind IPs to? I've tried 127.0.0.1 , My LAN IP etc. My LAN IP seems like working. Actually it did about 5 minutes ago. The problem was the main account in log sql table wasn't set properly. I've fixed it, started the server again, now I got bind problem again! Grrrrrrr

^Making a new topic about it.

Edited June 23, 2012 by Orgasmator

[DarkIrata]

Also had problems with that on my root, just use everywhere your WAN (public) ip and it will work

[Orgasmator]

Also had problems with that on my root, just use everywhere your WAN (public) ip and it will work

Thanks for caring my problem but It's still not working. I even made a new topic but no one cares. I'm seriously about to lose my mind!

[chatterboy]

we have same problem of Orgasmator

 

when i try to use this:

//To Start
./athena-start start

 

ERROR:
login-server_sql does not exist, or can't run. Stop.

 

then i try also ./config error message ACCESS NO PERMISSION...

[Problem Solve]

 

I figure it out by my self. ahaha

 

How to fix bad interpreter: No such file or directory when you run ./athena-start
cd /path/to/eathena

rm -f athena-start
wget http://eathena.googlecode.com/svn/trunk/athena-start
chmod a+x athena-start

 

ERROR:
login-server_sql does not exist, or can't run. Stop.

SOL:
chmod a+x configure