Hi all,
Just some random things I ran into that might help others:
Q: How many databases do I need to create?/Scripts are throwing errors:
Personally I created all 5 of them though I think itemmall2 is just a variation of itemmall, once inside psql, use these commands:
create database "FFAccount";
create database "FFDB1";
create database "FFMember";
create database "itemmall";
create database "itemmall2";
You need to use "" there otherwise, and by default, postgres lowercases them, and they become things like "ffmember", "ffaccount", etc.
Then when you \c to each of them, BEFORE you \i to import the .sqls, use this:
create extension dblink;
This is important because some of the scripts use dblink in order to gather information from the other databases in the postgres instance.
Q: I can connect to ssh but no other service/the client hangs at "logging in" forever:
This is because of iptables, which is a firewall and has some rules set from the getgo, to disable it use:
service iptables stop
Q: My vbox VM has a weird ip like 10.X.X.X/Can't even ping the vbox vm:
Vbox by default uses NAT, but from what I read, nat in vbox is a bit different from vmware's, whereas you can't reach it externally unless it is another vm inside the nat network.
So in order to use the client on the host to access it, you need to modify your network adapter for the VM to be host-only.
If you want to use a different ip (like the 192.168.1.X for the pre-configured files), you need to edit its properties in "File>Preferences...>Network>Host-only Network" on the vbox interface.
After changing those things, you might need to reboot the VM or maybe try running these:
service network restart
ifdown eth0
ifup eth0
Then check the ip using: ifconfig eth0
Q: The log files for the servers are showing an error when trying to connect to the database.
Make sure you configured the pg_hba.conf and postgres.conf as per the first post.
Also, make sure you created the user for your database, if you are using the one that comes configured on the files, it should be something like this:
create role spiritking with superuser login password 'antiroot';
You might not want to make it superuser, if so, you need to grant permissions to it on all databases like:
grant all privileges on database "FFAccount" to spiritking;
Q: I got ingame but when I go to an area or a npc speaks something, there is no text!
That is because, while the translated files come with the server package, they are not already patched by default.
You need to put the files found in the "English Translations" folder inside the "Data/db/" folder. Make sure the server is stopped.
cp -f English\ Translations/* Data/db/