Deprecated Darkstar fourms

• Performed standard server install with SSH & LAMP options.
  (I know LAMP was not necessary just for MySQL. I may revise this at a later date)
  Added user ffxi.

sudo passwd

apt-get update
apt-get upgrade
reboot

apt-get -fy install automake cpp:i386 g++:i386 gawk gcc:i386 liblua5.1-0-dev liblua5.1-0-dev:i386 libmysqlclient-dev:i386 libtool:i386 subversion

apt-get -fy install automake cpp g++ gawk gcc liblua5.1-0-dev libmysqlclient-dev libtool subversion

cd /usr/lib/i386-linux-gnu/
ln -s liblua5.1.so liblua.so

svn co http://onetimexi.googlecode.com/svn/trunk /home/ffxi/dsp

Download Linux dssearch patch here: (Can we get this posted to the GoogleCode downloads?)
download/file.php?id=820

cd /home/ffxi/dsp
chmod a+x autogen.sh
./autogen.sh
./configure LIBS=-lpthread
make

mysql -u root -p
mysql> CREATE DATABASE dspdb;
mysql> GRANT ALL PRIVILEGES ON dspdb.* TO dspdb_user@localhost IDENTIFIED BY 'dspdb_password';
mysql> quit

cd /home/ffxi/dsp/sql
for f in *.sql; do echo -n "Importing $f into the database..."; mysql dspdb -u dspdb_user -pdspdb_password < $f && echo "Success"; done

 nano /etc/init/dsconnect.conf

root@ffxi:/home/ffxi/dsp# cat /etc/init/dsconnect.conf
# DSConnect

description     "Start DS Lobby Login Server"

stop on stopping dsp

script
        cd /home/ffxi/dsp
        ./dsconnect
end script

respawn

root@ffxi:/home/ffxi/dsp# cat /etc/init/dsp.conf
# DSP FFXI Server...

description     "Start DSP FFXI Server"

start on started networking
stop on stopping networking
stop on starting shutdown

pre-start script
      start dsconnect
      start dsgame
      start dssearch
end script

start dsp -or- restart dsp -or- restart dgame

apt-get install phpmyadmin

lautan wrote:Thats some great stuff. I have some cool scripts that'll update the server and such. I can share if you're interested.

• MySQL DB backup strategies, replication, flat-file, etc?
  MySQL table diff'ing on svn updates? I'm assuming most people don't blow away their char_vars and AH on sql svn changes...
  Configs, settings.lua, src mod diff'ing. Also assuming most people wouldn't reset all modded EXP rates, etc.
  Better Ubuntu Upstart scripts with rotated logs so's I can 'tail -f' while I'm attempting to chat with some stone-faced npc.
  Inspect that dssearch.diff file and inquire as to why that may not be in the svn source.
  Additionally, I'd like to find\build a linux based AHbot service similar to: viewtopic.php/?f=16&t=19 or viewtopic.php?f=16&t=1116

bluekirby0 wrote:Of the core developers, only lautan and I work with Linux at all, and only lautan uses it as his primary development platform. I think it is also fairly safe to assume more servers out in the wild are running on windows boxes, although if you are trying to set up a server on a VPS a linux box will cut your resource requirements immensely.

For database backups there are several strategies you can use, but I haven't messed with any myself since as a developer I don't really mind blowing away my entire database frequently.

More friendly upgrade options are something that can be looked at in the long-term, but I wouldn't personally devote the resources to it at this stage of the project.

The search server diff basically does a direct replacement of network functions that are windows-only with ones that are anything-other-than-windows-compatible using pre-processor macros. While they technically don't break windows compiles in any way, the guy who technically owns this project disagreed with my approach to it so I've kept it separate as a patch until the day comes when someone feels like rewriting the highly stable network code (as you can guess, its kind of silly IMO to rewrite it when the patch works flawlessly).

AH bots are fairly easy to build...just pick your coding language of choice, find a mysql interface for it, and set up your queries. All most of them do is inject pre-defined info into the auction house's table. If you wanted to get fancy you could scrape info from ffxiah.com and base prices off of actual retail sales history.

lautan wrote:

Code: Select all

#!/bin/bash

for file in `find sql -name '*.sql' -mtime 0`
# for file in `find sql -name '*.sql'`
do
	if [[ "$file" != *char* ]]
	then
   	    	echo "Migrating $file"
	 	cat $file | mysql -u dspdb -p dspdb --password=ffxi
	fi 
done

echo "update zone_settings set zoneip = '642354';" | mysql dspdb -u dspdb --password=ffxi

I use this script to migrate the db after svn update. It will find all changed sql files and run them. Opptionally you can ignore char tables.

• Keep a separate trunk version DB with no acct/char data
  Apply all sql updates to TrunkDB
  Use mysqldiff or mysqldbcompare to generate a diff between blank TrunkDB and the production DB???
  Apply diff to Prod. (Profit!)

Update SQL svn:
cd /home/ffxi/dsp
svn up sql

Truncate (Empty) SVN DB:
mysqladmin -f -u root -p{SN4RF} drop dspdb_svn
mysqladmin -f -u root -p{SN4RF} create dspdb_svn

Upload to SVN DB:
cd /home/ffxi/dsp/sql/
for f in *.sql; do echo -n "Importing $f into the database..."; mysql dspdb_svn -u dsp_user -p{SN4RF} < $f && echo "Success"; done

Dump DBs:
cd ..
mysqldump -u root -p{SN4RF} dspdb_svn > dspdb_svn.sql
mysqldump -u root -p{SN4RF} dspdb > dspdb.sql

Diff dumps:
diff -u --from-file=dspdb_svn.sql dspdb.sql > sqldiff1.diff

-=-=-= Source Update / Rebuild -=-=-=

update dsp:
cd /home/ffxi/dsp
svn diff > patches/svn/`svn info | grep -oP "(?<=Revision: )[^ ]*"`_`date +"%Y%m%d_%H%M%S"`.diff
svn revert . --recursive
>>TODO: Interactively apply most recent diff. 

FWIW:

--list all diff'd files:
svn diff | grep -oP "(?<=Index: )[^ ]*"

--list all diff'd files with revision:
svn diff | grep -oP "(?<=--- )[^ ]*.*"