[Ascent][Linux]Tutorial - How To Create a Server - Page 6 - RaGEZONE

gspat · 03-28-2008

I don't think I would have gotten as far as I did without your tutorial, but something is not quite right for me yet...

So far it seems as though all is good, but I'm not quite sure...

I don't know if this is a linux issue or not, but my server does not seem to accept any incoming connections...

I posted a question at http://forum.ragezone.com/f114/ascen...nnects-377110/ just in case this isn't linux related.

do you have any ideas?

kerberos2 · 03-28-2008

Code:

13:39 N RemoteConsole: Starting...
13:39 N LogonCommClient: Loading forced permission strings...
13:39 N LogonCommClient: Attempting to connect to logon server...
13:39 N LogonCommClient: Connecting to logonserver on `127.0.0.1:8093`...
13:39 N LogonCommClient: Authenticating...
13:39 N LogonCommClient: Authentication succeeded.
13:39 N LogonCommClient: Registering Realms...
13:39 N LogonCommClient: Realm `Test Realm` registered as realm 1.
13:39 N LogonCommClient: Logonserver latency is 0ms.
Sql query failed due to [Table 'characters.mailbox_insert_queue' doesn't exist], Query: [SELECT * FROM mailbox_insert_queue]
Sql query failed due to [Table 'characters.mailbox_insert_queue' doesn't exist], Query: [SELECT * FROM mailbox_insert_queue]
Sql query failed due to [Table 'characters.mailbox_insert_queue' doesn't exist], Query: [SELECT * FROM mailbox_insert_queue]
Sql query failed due to [Table 'characters.mailbox_insert_queue' doesn't exist], Query: [SELECT * FROM mailbox_insert_queue]
Sql query failed due to [Table 'characters.mailbox_insert_queue' doesn't exist], Query: [SELECT * FROM mailbox_insert_queue]
Sql query failed due to [Table 'characters.mailbox_insert_queue' doesn't exist], Query: [SELECT * FROM mailbox_insert_queue]
Sql query failed due to [Table 'characters.mailbox_insert_queue' doesn't exist], Query: [SELECT * FROM mailbox_insert_queue]

Originally Posted by sebkinne

1: Sql query failed due to [Table 'characters.account_forced_permissions' doesn't exist], Query: [SELECT * FROM account_forced_permissions]

To 1: Update your SQL, easy as that ;-)
regards,
seb

Code:

wow trunk # mysql --version
mysql  Ver 14.12 Distrib 5.0.38, for pc-linux-gnu (i486) using readline 5.2

Sorry :( i cant even connect, i get this error on wow client:

I tried with wow 2.3.3 enUS and 2.4 enUS and I keep getting the same error, any ideas?

sebkinne · 03-28-2008

oh, lol

go into your ascent-logonserver.conf and find the line:
min Build
max Build

set the max build to 9999
done ;)

seb

kerberos2 · 03-28-2008

Originally Posted by sebkinne

oh, lol

go into your ascent-world.conf and find the line:
min Build
max Build

set the max build to 9999
done ;)

seb

Nice!! thanks! for the record, the file is
ascent-logonserver.conf and not ascent-world.conf ... maybe you want to edit your post, im gonna try it :)

Markitos007 · 03-29-2008

Hey!

Seb, great tutorial! Thanks a lot! :D
But I've got some problems. In the logon-server, I get this error:

Code:

Sql query failed due to [Unknown column 'encrypted_password' in 'field list'], Query: [SELECT acct, login, password, encrypted_password, gm, flags, banned, forceLanguage, muted FROM accounts]

Could you please help me solving this error? It seems to be with the sql database, but I have no clue how to create columns or tables on MySQL databases (I'm a complete begginer with MySQL).

Thanks,
Mark.

gspat · 03-29-2008

Originally Posted by Markitos007

Hey!

Seb, great tutorial! Thanks a lot! :D
But I've got some problems. In the logon-server, I get this error:

Code:

Sql query failed due to [Unknown column 'encrypted_password' in 'field list'], Query: [SELECT acct, login, password, encrypted_password, gm, flags, banned, forceLanguage, muted FROM accounts]

Could you please help me solving this error? It seems to be with the sql database, but I have no clue how to create columns or tables on MySQL databases (I'm a complete begginer with MySQL).

Thanks,
Mark.

You just have to update your sql... find the sql folder in the svn you downloaded and add in the sql files to the proper databases...

ie: mysql -u DBUSERNAME -p DBNAME < /path/to/sql/files/XXXX_SQL_FILE_NAME.sql

In your case, find the one called 4156_logon_set_encrypted_passwords.sql

Markitos007 · 03-29-2008

Hi!

Thanks for your reply, I'm about to try it right now!
I'll love you if this works, I'm really desperate to get this working :winky:
I'll post a reply telling you the ressults.

Thanks,
Mark.

Markitos007 · 03-29-2008

Hey

I did the command you told me, but now I got this error:
ERROR 1054 (42S22) at line 1: Unknown column 'encrypted_password' in 'field list'
I'm a complete begginer in MySQL, what should I do?

Regards,
Mark.

sebkinne · 03-29-2008

update the sql db
run the updates

1337Equillbrium · 03-30-2008

Nice Guide.

sebkinne · 03-30-2008

Thank you Equillbrium!, i apreciate to hear this from you

arberb · 03-30-2008

Quote:

checking for cf77... no
checking for fort77... no
checking for fl32... no
checking for af77... no
checking for xlf90... no
checking for f90... no
checking for pgf90... no
checking for pghpf... no
checking for epcf90... no
checking for gfortran... no
checking for g95... no
checking for xlf95... no
checking for f95... no
checking for fort... no
checking for ifort... no
checking for ifc... no
checking for efc... no
checking for pgf95... no
checking for lf95... no
checking for ftn... no
checking whether we are using the GNU Fortran 77 compiler... no
checking whether accepts -g... no
checking the maximum length of command line arguments... 32768
checking command to parse /usr/bin/nm -B output from gcc object... ok
checking for objdir... .libs
checking for ar... ar
checking for ranlib... ranlib
checking for strip... strip
checking if gcc supports -fno-rtti -fno-exceptions... no
checking for gcc option to produce PIC... -fPIC
checking if gcc PIC flag -fPIC works... yes
checking if gcc static flag -static works... yes
checking if gcc supports -c -o file.o... yes
checking whether the gcc linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
configure: creating libtool
appending configuration tag "CXX" to libtool
checking for ld used by g++... /usr/bin/ld -m elf_x86_64
checking if the linker (/usr/bin/ld -m elf_x86_64) is GNU ld... yes
checking whether the g++ linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes
checking for g++ option to produce PIC... -fPIC
checking if g++ PIC flag -fPIC works... yes
checking if g++ static flag -static works... yes
checking if g++ supports -c -o file.o... yes
checking whether the g++ linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
appending configuration tag "F77" to libtool
checking uname -s for detecting host operating system... Linux
checking uname -m for detecting host operating system architecture... x64 feel teh power
checking whether byte ordering is bigendian... no
checking for svn... yes
checking for the pthreads library -lpthreads... no
checking whether pthreads work without any flags... no
checking whether pthreads work with -Kthread... no
checking whether pthreads work with -kthread... no
checking for the pthreads library -llthread... no
checking whether pthreads work with -pthread... yes
checking for joinable pthread attribute... PTHREAD_CREATE_JOINABLE
checking if more special flags are required for pthreads... no
checking for compress in -lz... yes
checking for ftime in -lcompat... no
checking for ssl... configure: error: Cannot find ssl libraries
server:~/ascent/trunk# make
make: *** No targets specified and no makefile found. Stop.
server:~/ascent/trunk# make install
make: *** No rule to make target `install'. Stop.
server:~/ascent/trunk#
server:~/ascent/trunk#

:@ dam it

majestic 888 · 03-31-2008

Hey I get this when I do ./configure

Code:

[root@localhost trunk]# ./configure
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking whether to enable maintainer-specific portions of Makefiles... no
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none needed
checking for style of include used by make... GNU
checking dependency style of gcc... gcc3
checking for g++... g++
checking whether we are using the GNU C++ compiler... yes
checking whether g++ accepts -g... yes
checking dependency style of g++... gcc3
checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking for a sed that does not truncate output... /bin/sed
checking for egrep... grep -E
checking for ld used by gcc... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for /usr/bin/ld option to reload object files... -r
checking for BSD-compatible nm... /usr/bin/nm -B
checking whether ln -s works... yes
checking how to recognise dependent libraries... pass_all
checking how to run the C preprocessor... /lib/cpp
configure: error: C preprocessor "/lib/cpp" fails sanity check
See `config.log' for more details.

sebkinne · 03-31-2008

what os are you running?

seb

majestic 888 · 03-31-2008

Im Running CentOS=\

kerberos2 · 03-31-2008

i almost have it :)

now i can login into the server, but when i want to create a character (after i choose body, gender, character name and all that) when i click the "OK" button ... i got "Disconnected from server"

This is the "world" log:

Code:

request for account information: `KBS` (request 1).
 >> got information packet from logon: `KBS` ID 1 (request 1)
Loaded permissions for 1. (0) : []
13:33 D Auth: KBS from 192.168.2.54:1226 [26ms]
Decompression of addon section of CMSG_AUTH_SESSION succeeded.

[Session] Received unhandled packet with opcode CMSG_REALM_SPLIT_STATE_REQUEST (0x038C)

 >> sending request for account information: `KBS` (request 2).
 >> got information packet from logon: `KBS` ID 1 (request 2)
Loaded permissions for 1. (0) : []
13:33 D Auth: KBS from 192.168.2.54:1227 [23ms]
Decompression of addon section of CMSG_AUTH_SESSION succeeded.

[Session] Received unhandled packet with opcode CMSG_REALM_SPLIT_STATE_REQUEST (0x038C)

sebkinne · 03-31-2008

update your char db.

the output is correct, dont worry

smallfox · 03-31-2008

When i type make, i get this error:

Code:

dyuf@dyuf-desktop:~/Desktop/Server/ascent/trunk$ make
make  all-recursive
make[1]: Entering directory `/home/dyuf/Desktop/Server/ascent/trunk'
Making all in extras
make[2]: Entering directory `/home/dyuf/Desktop/Server/ascent/trunk/extras'
Making all in collision
make[3]: Entering directory `/home/dyuf/Desktop/Server/ascent/trunk/extras/colli
sion'
Making all in collision_dll
make[4]: Entering directory `/home/dyuf/Desktop/Server/ascent/trunk/extras/colli
sion/collision_dll'
make[4]: Nothing to be done for `all'.
make[4]: Leaving directory `/home/dyuf/Desktop/Server/ascent/trunk/extras/collis
ion/collision_dll'
make[4]: Entering directory `/home/dyuf/Desktop/Server/ascent/trunk/extras/colli
sion'
make[4]: Nothing to be done for `all-am'.
make[4]: Leaving directory `/home/dyuf/Desktop/Server/ascent/trunk/extras/collis
ion'
make[3]: Leaving directory `/home/dyuf/Desktop/Server/ascent/trunk/extras/collis
ion'
make[3]: Entering directory `/home/dyuf/Desktop/Server/ascent/trunk/extras'
make[3]: Nothing to be done for `all-am'.
make[3]: Leaving directory `/home/dyuf/Desktop/Server/ascent/trunk/extras'
make[2]: Leaving directory `/home/dyuf/Desktop/Server/ascent/trunk/extras'
Making all in src
make[2]: Entering directory `/home/dyuf/Desktop/Server/ascent/trunk/src'
Making all in ascent-shared
make[3]: Entering directory `/home/dyuf/Desktop/Server/ascent/trunk/src/ascent-s
hared'
g++ -DHAVE_CONFIG_H -I. -I../.. -I/usr/include -I/usr/local/include -I.    -I/us
r/include -I/usr/local/include -pthread -I/usr/include/openssl -DHAVE_SSL -I/usr
/include/mysql -DBIG_JOINS=1  -MT Database.o -MD -MP -MF .deps/Database.Tpo -c -
o Database.o `test -f 'Database/Database.cpp' || echo './'`Database/Database.cpp
Database/Database.cpp: In member function ‘void AsyncQuery::AddQuery(const char*
, ...)’:
Database/Database.cpp:273: error: ‘_TRUNCATE’ was not declared in this scope
Database/Database.cpp:273: error: ‘vsnprintf_s’ was not declared in this scope
Database/Database.cpp:277: error: ‘memcpy_s’ was not declared in this scope
make[3]: *** [Database.o] Error 1
make[3]: Leaving directory `/home/dyuf/Desktop/Server/ascent/trunk/src/ascent-sh
ared'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory `/home/dyuf/Desktop/Server/ascent/trunk/src'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/dyuf/Desktop/Server/ascent/trunk'
make: *** [all] Error 2
dyuf@dyuf-desktop:~/Desktop/Server/ascent/trunk$ make
make  all-recursive
make[1]: Entering directory `/home/dyuf/Desktop/Server/ascent/trunk'
Making all in extras
make[2]: Entering directory `/home/dyuf/Desktop/Server/ascent/trunk/extras'
Making all in collision
make[3]: Entering directory `/home/dyuf/Desktop/Server/ascent/trunk/extras/colli
sion'
Making all in collision_dll
make[4]: Entering directory `/home/dyuf/Desktop/Server/ascent/trunk/extras/colli
sion/collision_dll'
make[4]: Nothing to be done for `all'.
make[4]: Leaving directory `/home/dyuf/Desktop/Server/ascent/trunk/extras/collis
ion/collision_dll'
make[4]: Entering directory `/home/dyuf/Desktop/Server/ascent/trunk/extras/colli
sion'
make[4]: Nothing to be done for `all-am'.
make[4]: Leaving directory `/home/dyuf/Desktop/Server/ascent/trunk/extras/collis
ion'
make[3]: Leaving directory `/home/dyuf/Desktop/Server/ascent/trunk/extras/collis
ion'
make[3]: Entering directory `/home/dyuf/Desktop/Server/ascent/trunk/extras'
make[3]: Nothing to be done for `all-am'.
make[3]: Leaving directory `/home/dyuf/Desktop/Server/ascent/trunk/extras'
make[2]: Leaving directory `/home/dyuf/Desktop/Server/ascent/trunk/extras'
Making all in src
make[2]: Entering directory `/home/dyuf/Desktop/Server/ascent/trunk/src'
Making all in ascent-shared
make[3]: Entering directory `/home/dyuf/Desktop/Server/ascent/trunk/src/ascent-s                              hared'
g++ -DHAVE_CONFIG_H -I. -I../.. -I/usr/include -I/usr/local/include -I.    -I/us                              r/include -I/usr/local/include -pthread -I/usr/include/openssl -DHAVE_SSL -I/usr                              /include/mysql -DBIG_JOINS=1  -MT Database.o -MD -MP -MF .deps/Database.Tpo -c -                              o Database.o `test -f 'Database/Database.cpp' || echo './'`Database/Database.cpp
Database/Database.cpp: In member function ‘void AsyncQuery::AddQuery(const char*                              , ...)’:
Database/Database.cpp:273: error: ‘_TRUNCATE’ was not declared in this scope
Database/Database.cpp:273: error: ‘vsnprintf_s’ was not declared in this scope
Database/Database.cpp:277: error: ‘memcpy_s’ was not declared in this scope
make[3]: *** [Database.o] Error 1
make[3]: Leaving directory `/home/dyuf/Desktop/Server/ascent/trunk/src/ascent-sh                              ared'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory `/home/dyuf/Desktop/Server/ascent/trunk/src'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/dyuf/Desktop/Server/ascent/trunk'
make: *** [all] Error 2
dyuf@dyuf-desktop:~/Desktop/Server/ascent/trunk$

someone can help me plz?

sebkinne · 04-01-2008

redo this:

autoreconf --force --install

./configure

make

make install

tell me if things changed..

seb

beckas · 04-01-2008

Code:

g++ -DHAVE_CONFIG_H -I. -I../.. -I/usr/include -I/usr/local/include -I. 
  -I/usr/include -I/usr/local/include -pthread -I/usr/include/openssl 
-DHAVE_SSL -I/usr/include/mysql -DBIG_JOINS=1  -MT Database.o -MD -MP
 -MF .deps/Database.Tpo -c -o Database.o `test -f 'Database/Database.cpp'
 || echo './'`Database/Database.cpp
Database/Database.cpp: In member function āvoid 
AsyncQuery::AddQuery(const char*, ...)ā:
Database/Database.cpp:273: error: '_TRUNCATE' was not declared in this scope
Database/Database.cpp:273: error: 'vsnprintf_s' was not declared in this scope
Database/Database.cpp:277: error: 'memcpy_s' was not declared in this scope
make[3]: *** [Database.o] Error 1
make[3]: Leaving directory `/home/wow/ascent/trunk/src/ascent-shared'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory `/home/wow/ascent/trunk/src'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/wow/ascent/trunk'
make: *** [all] Error 2

Errors on CentOS 5.1, Debian, FreeBSD 7 with 4289 rev. I think problems with mysql. Any help ?

smallfox · 04-01-2008

Originally Posted by sebkinne

redo this:

autoreconf --force --install

./configure

make

make install

tell me if things changed..

seb

I still have the same error.
I will download the source again and maybe........

sebkinne · 04-01-2008

yea, svn the source..

cos its not you, error in the source..

seb

smallfox · 04-01-2008

it's working now =)

thx

kerberos2 · 04-01-2008

In debian i got this error, im compiling it on gentoo and it doesn't have problems yet

[code]make[2]: Entering directory `/usr/local/games/ascent/trunk/src'
Making all in ascent-shared
make[3]: Entering directory `/usr/local/games/ascent/trunk/src/ascent-shared'
g++ -DHAVE_CONFIG_H -I. -I../.. -I/usr/include -I/usr/local/include -I. -I/usr/include -I/usr/local/include -pthread -I/usr/include/openssl -DHAVE_SSL -I/usr/include/mysql -DBIG_JOINS=1 -MT CrashHandler.o -MD -MP -MF .deps/CrashHandler.Tpo -c -o CrashHandler.o CrashHandler.cpp
mv -f .deps/CrashHandler.Tpo .deps/CrashHandler.Po
g++ -DHAVE_CONFIG_H -I. -I../.. -I/usr/include -I/usr/local/include -I. -I/usr/include -I/usr/local/include -pthread -I/usr/include/openssl -DHAVE_SSL -I/usr/include/mysql -DBIG_JOINS=1 -MT Database.o -MD -MP -MF .deps/Database.Tpo -c -o Database.o `test -f 'Database/Database.cpp' || echo './'`Database/Database.cpp
Database/Database.cpp: In member function

sebkinne · 04-02-2008

re get the source + compile

seb