[Resolved]Aion Can't connect to authorization server

03/15/2013 04:14 synysterA7X#1
Hello, My name is synyster and am Brazilian, I can not speak English, and for creating this topic, I'm using google translator ^ ^

have you ever encountered this error one day: Can not connect to authorization server

The solution is simple and easy, you just change the port number of mysql from 3306 to 3316 or leave 3306, this attempt to min was a success, and this topic is totally original, not takes any source other topic,

something else.

a tutorial here for you guys.
if you editing the server this page: [Only registered and activated users can see links. Click Here To Register...]
ing case and is a mistake, I have a suggestion to give,
you will have to edit the file "AION_DB_installer_celestial"
example

click with the right mouse button, and select edit


Normal file
Code:
@echo off

set ctime=%TIME:~0,2%
echo Ashen Aion [r0ck7y]


echo.
set /p svr=What is your MySQL host name?       [press [enter] for: "127.0.0.1"] : 
if %svr%. == . set svr=127.0.0.1

set /p user=What is your MySQL user name?       [press [enter] for: "root"]      : 
if %user%. == . set user=root

set /p pass=What is your MySQL password?        [press [enter] for: "aion"]      : 
if %pass%. == . set pass=aion

set /p port=What is your MySQL port?            [press [enter] for: "3316"]      : 
if %port%. == . set port=3316

set /p aionls=What is your AionLS database name?  [press [enter] for: "aj_login"]    : 
if %aionls%. == . set aionls=aj_login

set /p aiongs=What is your AionGS database name?  [press [enter] for: "aj_server"]    : 
if %aiongs%. == . set aiongs=aj_server

set mysql=..\..\AIONEmulator\usr\local\mysql\bin
set aionlsdbpath="..\Database\LS"
set aiongsdbpath="..\Database\GS"

goto checkpaths


:checkpaths
if not exist %mysql%\mysql.exe goto mysqlpatcherror
if not exist %mysql%\mysqldump.exe goto mysqlpatcherror
if not exist %aionlsdbpath% goto aiondbpatherror
if not exist %aiongsdbpath% goto aiondbpatherror
REM if not exist %aiongsdropspath% goto aiondbpatherror
goto createdb


:mysqlpatherror
echo.
echo "mysql.exe" next to the installer NOT found!
pause.
exit.


:aiondbpatherror
echo.
echo Aion Database Files NOT found!
echo conatct me at epvp!
pause.
exit.

:createdb
echo.
echo Create Database if not exist (ignore the error) ...
%mysql%\mysql -q -s -h %svr% --user=%user% --password=%pass% --port=%port% --execute="create database %aionls% character set utf8 COLLATE utf8_general_ci;"
%mysql%\mysql -q -s -h %svr% --user=%user% --password=%pass% --port=%port% --execute="create database %aiongs% character set utf8 COLLATE utf8_general_ci;"
echo.
goto importdb


:importdb
echo.
echo This will import the NEW database. [gonna delete the old one]
set /p yesno=Do you wish to continue? (y/n) 
if %yesno% neq y if %yesno% neq Y goto done
if %yesno% neq . goto done %yesno% n goto exit
if %yesno% neq N goto exit


echo.
echo Importing Aj-Login database ...
for %%i in (%aionlsdbpath%\*.sql) do if %%i neq %aionlsdbpath%\*.sql) if %%i neq %aionlsdbpath%\*.sql) if %%i neq %aionlsdbpath%\*.sql) echo %%i & %mysql%\mysql -q -s -h %svr% --user=%user% --password=%pass% --port=%port% %aionls% < %%i

echo.
echo Importing Aj-Server database ...
for %%i in (%aiongsdbpath%\*.sql) do if %%i neq %aiongsdbpath%\*.sql) if %%i neq %aiongsdbpath%\*.sql) if %%i neq %dbpath%\*.sql) echo %%i & %mysql%\mysql -q -s -h %svr% --user=%user% --password=%pass% --port=%port% %aiongs% < %%i


goto DBID


:DBID
echo.
echo Changing GameServer ID in the Database ...
%mysql%\mysql -q -s -h %svr% --user=%user% --password=%pass% --port=%port% %aiongs% --execute="USE %aionls%; INSERT INTO `gameservers` (`id`, `mask`, `password`) VALUES ('100', '127.0.0.1', 'aion');"

goto done


:done
echo.
echo.
echo Finished.
echo.
pause.

:exit
echo.
pause.
click with the right mouse button, and select edit

Normal file

edited file

you will have to change the following names

Code:
set / p pass = What is your MySQL password? [press [enter] for: "aion"]:
if% pass%. ==. Set Pass = aion

set / p port = What is your MySQL port? [press [enter] for: "3316"]:
if% port%. ==. set port = 3316
for

Code:
set / p pass = What is your MySQL password? [press [enter] for: "YOUR MYSQL PASSWORD"]:
if% pass%. ==. Set Pass = YOUR MYSQL PASSWORD

set / p port = What is your MySQL port? [press [enter] for: "3306"]:
if% port%. ==. set port = 3306
Observer that the number 3316 was changed to 3306 (the door of your mysql)

and only this ^ ^
follows the rest of the tutorial page:

and do not forget to always check the archives:

AionServer \ AIONEmulator \ LoginServer \ config \ network \ database
AionServer \ AIONEmulator \ LoginServer \ config \ network \ network

and

AionServer \ AIONEmulator \ game \ config \ default
AionServer \ AIONEmulator \ game \ config \ ipconfig

do not forget to put the ip 127.0.0.1
and password correct, if not change after the implementation of the "Celestial.bat 1ST.Install Database"

ANOTHER SUGGESTION

TURN OFF WINDOWS FIREWALL




follow the tutorial on this page: [Only registered and activated users can see links. Click Here To Register...]

I hope the google translator helped

Press the Thanks button if helped

Credits go to:

SynysterA7x by the help topic, and the effort to find a solution and shares it
AionCelestial Dev Team @ assembla.com/spaces/celestialcore-3-0-3-5/wiki
Dwarfpicker [the whole project is his work i only added a few things ] @ Easy-Emu Community
:handsdown: