Most visitors online was 11705 , on 26 Apr 2024
"No game server is available to the authorization server.(6)
- Thread starter extaze
- Start date
- Joined
- Jan 13, 2013
- Messages
- 1,186
- Reaction score
- 360
Is this server a private/local, port forwarded, or a dedicated/vps hosted server?
Upvote
0
Upvote
0
Newbie Spellweaver
- Joined
- Jun 19, 2018
- Messages
- 55
- Reaction score
- 14
if local and you will not open server online do not forward any ports on your router if you will do this you need forward only two ports
for login: 2106
and for game: 7777 or (what you want if you will change in configuration)
never forward any other ports a special on UDP protocol.
for login: 2106
and for game: 7777 or (what you want if you will change in configuration)
never forward any other ports a special on UDP protocol.
Upvote
0
Hello guys, i want to add to this thread and say that i have the same exact issue when tried to run this server locally. But the thing is that for some unkinown reason that a gameservers table in Navicat is absent. I knew that this would be a problem, and later it would not let me establish connection, but decided to go along with this for a moment. But i did nothing wrong for it to be like this.
And here's the execution for a game server sql, it even says "Finished succesfully"
I used this server part -
Maybe if someone wise sees this, and can help, i'll appriciate it very much
And here's the execution for a game server sql, it even says "Finished succesfully"
I used this server part -
You must be registered to see links
Maybe if someone wise sees this, and can help, i'll appriciate it very much
Last edited:
Upvote
0
There is video tutorials how to setup 4.7-4.9 Aion on YouTube . Schema is in all cases are same
You missing aion noip patch to your bin32 and bin64. No need to open any ports there or change to another ips. Don't let yourself get more confused from all this answers. On aion noip github you have instruction what commandsneed to be added inside your launcher and wgat files should be deleted from both bin32 and bin64 who can in some cases occur problems as well. Good luck.
Upvote
0
Yes, this is the exact tutorial i used and followed thoroughly (and also was very lucky to find it).
And yes, you were corect that i missed deleting those .dll files from bin 32, bin 64. Also i wrote .bat file exactly like it was in the tutorial.
However i am still missing gameservers table. Which i believe is crucial for connecting to the server. And somehow this fact is completely left ignored.
Btw sql file for Login server executed with errors (no errors in tutorial)
Full log below:
Code:
[SQL] Query al_server_ls start
[ERR] 1067 - Invalid default value for 'time'
[ERR] SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for account_data
-- ----------------------------
DROP TABLE IF EXISTS `account_data`;
CREATE TABLE `account_data` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(45) NOT NULL,
`password` varchar(65) NOT NULL,
`activated` tinyint(1) NOT NULL DEFAULT '1',
`access_level` tinyint(3) NOT NULL DEFAULT '0',
`membership` tinyint(3) NOT NULL DEFAULT '0',
`old_membership` tinyint(3) NOT NULL DEFAULT '0',
`last_server` tinyint(3) NOT NULL DEFAULT '-1',
`last_ip` varchar(20) DEFAULT NULL,
`last_mac` varchar(20) NOT NULL DEFAULT 'xx-xx-xx-xx-xx-xx',
`ip_force` varchar(20) DEFAULT NULL,
`expire` date DEFAULT NULL,
`toll` bigint(13) NOT NULL DEFAULT '0',
`email` varchar(50) DEFAULT NULL,
`question` varchar(50) DEFAULT NULL,
`answer` varchar(50) DEFAULT NULL,
`balance` float DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of account_data
-- ----------------------------
-- ----------------------------
-- Table structure for account_playtime
-- ----------------------------
DROP TABLE IF EXISTS `account_playtime`;
CREATE TABLE `account_playtime` (
`account_id` int(10) unsigned NOT NULL,
`accumulated_online` int(10) unsigned NOT NULL DEFAULT '0',
`lastupdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of account_playtime
-- ----------------------------
-- ----------------------------
-- Table structure for account_rewards
-- ----------------------------
DROP TABLE IF EXISTS `account_rewards`;
CREATE TABLE `account_rewards` (
`uniqId` int(11) NOT NULL AUTO_INCREMENT,
`accountId` int(11) NOT NULL,
`added` varchar(70) NOT NULL DEFAULT '',
`points` decimal(20,0) NOT NULL DEFAULT '0',
`received` varchar(70) NOT NULL DEFAULT '0',
`rewarded` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`uniqId`),
KEY `FK_account_rewards` (`accountId`),
CONSTRAINT `FK_account_rewards` FOREIGN KEY (`accountId`) REFERENCES `account_data` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of account_rewards
-- ----------------------------
-- ----------------------------
-- Table structure for account_time
-- ----------------------------
DROP TABLE IF EXISTS `account_time`;
CREATE TABLE `account_time` (
`account_id` int(11) NOT NULL,
`last_active` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`expiration_time` timestamp NULL DEFAULT NULL,
`session_duration` int(10) DEFAULT '0',
`accumulated_online` int(10) DEFAULT '0',
`accumulated_rest` int(10) DEFAULT '0',
`penalty_end` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`account_id`),
CONSTRAINT `FK_account_time` FOREIGN KEY (`account_id`) REFERENCES `account_data` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of account_time
-- ----------------------------
-- ----------------------------
-- Table structure for banned_ip
-- ----------------------------
DROP TABLE IF EXISTS `banned_ip`;
CREATE TABLE `banned_ip` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`mask` varchar(45) NOT NULL,
`time_end` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `mask` (`mask`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of banned_ip
-- ----------------------------
-- ----------------------------
-- Table structure for banned_mac
-- ----------------------------
DROP TABLE IF EXISTS `banned_mac`;
CREATE TABLE `banned_mac` (
`uniId` int(10) NOT NULL AUTO_INCREMENT,
`address` varchar(20) NOT NULL,
`time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
`details` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`uniId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Rec
[SQL] Finished with error
Upvote
0
be sure your your mysql version are similar like in database file. open in editor and check info and coding
Upvote
0
Thank you very much for the reply. Ufortunately i do not posses required knowledge, there's so much that i still need to know to actually make it work. However i managed to run server locally once, making myself an admin etc. but faced big troubles when i wanted to try to make it public. It seems like no matter how good a tutorial is, there's still more troubles i can find.
But okay, i checked coding in a notepad++ and it says its UTF-8, i hope that's what you meant, but where should i look for a version info in a database file?
Last edited:
Upvote
0
Uniserver will fix your problems
You must be registered to see links
i checked and its work with one from Robson 4.3. to work with xampp or wwhat you using you need to change in mysql ini few things .
Upvote
0
Okay i downloaded Uniserver,
I see that i can change something here: is it here where i need to do changes? gameservers table will appear in my Navicat after this?
Upvote
0
You do same as in tutorial what I sent before. There is used same uniformserver.
Last edited:
Upvote
0
I want to give an update on the issue, it have been resolved by typing a simple string into the file using simple Notepad. And after this Navicat executed .sql file with no issues, and gameservers table appeared, so i could now enter the server easily.
Upvote
0
Newbie Spellweaver
- Joined
- Dec 25, 2023
- Messages
- 5
- Reaction score
- 0
I am taking this error while trying setup Aion 4.6 server, i have gameservers table in my database, but i am still taking this error, who can help me?
Login Server Working
Chat Server Working
Game Server Working
But when i try to login on client, after login taking this error after select the server.
Login Server Working
Chat Server Working
Game Server Working
But when i try to login on client, after login taking this error after select the server.
Upvote
0
Upvote
0
Newbie Spellweaver
- Joined
- Dec 25, 2023
- Messages
- 5
- Reaction score
- 0
Emulator links broken at this video, i found another emulator files but i am not sure is its correct files...
Upvote
0
RaGEZONE Sponsor
