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:
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
click with the right mouse button, and select edit
Normal file
edited file
you will have to change the following names
for
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
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:
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.
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
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
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:
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