My server ip 148.251.251.xx but zoneserver and any server files have 192.168.xx ip how to change ?Originally Posted by Lam Nguyen
My server ip 148.251.251.xx but zoneserver and any server files have 192.168.xx ip how to change ?
have you try the AKtools?
Hey how to install it correctly i dont know (
do service iptables stop
hey someone can help me i cant install nothing inside that
install inside what?
How can i even start up my own server without the centos stuff or any vm ?
then now i cant change password for the user postgress .
Got it fixed
Last edited by PancakeBimmer; 17-09-16 at 09:14 PM.
Hello!
When i create a database, and i try to import the files with \i 'path to file'; i gor an error saying that psql:/root/Aura-Kingdom-Server/Aura-Kingdom-Server/SQL/FFDB1.sql:11420: ERROR:
role "eperty123" does not exist
thats the copy-paste from my command line. Can someone Help me with this error please?
You are getting the error because path to the sql file is wrong.
Once you figure out the correct path you may also face permission denied error. In that case you will have to set read rights for everyone on sql files.
So I am in a bit of a bind. I didn't manage to get very far into the setup process due to my unique network architecture. I currently tether to my phone for internet. My pserver is a physical, dedicated machine I have on my own home network which is isolated from the internet.
When attempting to install postgresql, it fails, stating that it is unable to resolve mirror.centos.org. I figured that if I just downloaded the file the instructions were having me install from the URL, move the install file to the /home directory and run yum install from there, I would be good. I was mistaken. The install failed for the exact same reason, unable to resolve that mirror.
I attempted to set my tether up on my pserver host, however I then ran into issues with the virtual adapter not wanting to play nice with the other virtual adapter (My tether). So now I am kind of stuck. I am very detail oriented and seldom run into an issue I cannot figure out myself. I follow instructions to the letter, so now I am literally stuck on this step. I refuse to move forward and accomplish other things out of sequence.
Do you have any ideas as to how to get postgresql installed onto this VM on my segregated network? I cannot even install the version of postgresql that comes with the OS by default as a starting point as the yum command seems to reach out to the mirror server and non resolution of that mirror halts the install.
So after some digging I was able to get a copy of the tuan565 vbox file to work with. However the server side portion of it was already completed. For the sake of my own education, I blew away the tuan565 server files and continued following along with the steps. I was unable to get Navicat due to my slow internet. However because I am somewhat competent at using bare bones, CLI SQL queries, I was able to work around this using pgsql's native SQL functionality (Thank you Fiesta PServer administration).
Because I am using Hyckers's files, and eperty123's tutorial, I had to make some changes to the db names in a few of the game files in order to get them to work with the already installed tuan565 dbs. However I've hit a little bit of a block. Hyckers files work on the 192.168.1.X network (My already established internal range) so I guess I don't need to hex edit them. I'm pretty sure I am missing something however I cannot see what it is for the life of me.
Main.Log:
2016/09/27 11:09:32 [Desc]MinSleepPeriod : 0.001548
2016/09/27 11:09:46 [Desc]LoginServer IP: 192.168.1.146(192.168.1.146), Port 6543
2016/09/27 11:09:48 [Desc]WorldServer IP: 192.168.1.146, Port 5567
2016/09/27 11:12:28 [Desc]ZoneServer IP: 192.168.1.146, Port 10021
2016/09/27 11:12:29 [Desc]connect ErrCode[10035]
Error.Log
2016/09/27 11:57:38 [Desc][LOGIN]
2016/09/27 11:57:46 [Desc][SELECT WORLD SERVER]
2016/09/27 11:57:48 [Desc][CHARACTER MANAGEMENT]
2016/09/27 11:57:52 [Desc]BS Init Queue!
2016/09/27 11:57:52 [Desc]BS Init Queue Finish!
2016/09/27 11:57:52 [Desc]BS start!
2016/09/27 11:57:52 [Desc]BS start Finish!
2016/09/27 11:57:52 [Desc]BS Start Event!
2016/09/27 11:57:52 [Desc]BS Start Even Finish!
2016/09/27 11:57:53 [Desc]Cannot Connect to ZoneSever
2016/09/27 11:57:56 [Desc]BS Stop!
2016/09/27 11:57:56 [Desc]BS Stop Finish!
2016/09/27 11:57:56 [Desc]Free CZone begin...
2016/09/27 11:57:56 [Desc]Free CZone end...
2016/09/27 11:57:57 [Desc]DESTORY APP
What I get from this is that I cannot connect tot he Zone Server. That much I understand. However it's WHY I cannot connect that I do not understand. "serverstatus" in FFDB1 is set to my LAN ip (192.168.1.x) on ext_ip. Never touched the ports or int_ip. "worlds" in FFAccount has the right IPs and ports. My client side files are correctly configured.
Connect.ini
Server=192.168.1.146,6543
I've been awake for over 24h just having fun and trying to get this put together, but I am afraid I have reached my body's physical limits here. If anyone has any ideas, please feel free to chime in.
look the tuts
So, disregard my posts for help. After much toiling and struggling with this game, I finally got it to work.
The solution? Eperty123's files.
Hyckers files probably work, but for some reason unknown to me, they wouldn't work.
Tuan565 release didn't work at all for me (It was missing a crazy amount of files and did a database check for files serverside which caused the launcher to stop working.)
My solution?
Tuan565 vbox image, blow away the entire Tuan565 release (To givemyself the postgresql foundation I was unable to get offline)
Once the Tuan565 release was wiped out, and the database scrubbed out, I followed the Eperty123 guide to the letter (As I have done with the three other attempted configurations) and this time, it worked.
I think I am going to create a general guide for problems and solutions and some linux/SQL noobie stuff. Maybe it will pull away the low effort posts from this thread to make room for weird, one off issues. I will get that guide up tomorrow. The more help the better I guess.
Reply With Quote
