My noob questions ~ Part Deux

+1 for Navi, it can do scheduled backups as well.

remote sql is way safer than of phpmyadmin or any web base sql management.

not sure if were speaking same language but all you gotta do is run backup that basicly backs up everything..

second point run external backup of you dbo thats ALL you need

done it a million times, never fails

dump that shit like a chick on roids. (this statement actually says everything)

ok I discovered the phpmyadmin that was in the install, realized how much I screwed it up by installing phpmyadmin, and managed to back it out enough to get it working again. At least working well enough to get the mysql stuff exported.

I've got the databases imported, but still have all the same problems with the factions not displaying and with new characters crashing. (Can't make new toons and log into the server.) At least my people can play again though, so that's a minor plus. Going to have to figure out how to fix whatever is wrong with the databases.

Check your permissions when you uploaded. What tool do you use? Winscp?

You messed to much the dabatase, I suggest that you clean it and tell to your players to restart everything from the beginning... It will be better and easier than trying to recovery a realy messed database...

Or, if I were you, just salvage all you can. Salvage some parts of the mysql database, and edit the .sql code a little so that you can just upload to your database.

Quote:

---

Originally Posted by Ozuru

Check your permissions when you uploaded. What tool do you use? Winscp?

---

To copy the original I used...

Code:

---

tar zcf gamedbd_bak.tar.gz /PWServer/gamedbd
tar zcf uniquenamed_bak.tar.gz /PWServer/uniquenamed

---

Then to put them back I copied them to / and used...

Code:

---

tar -xvzf gamedbd_bak.tar.gz
tar -xvzf uniquenamed_bak.tar.gz

---

and it exctracted them back into their respective folders.

I used phpmyadmin to export cpw.sql, dbo.sql, information_schema.sql, mysql.sql, performance_Schema.sql, phpmyadmin.sql, and support.sql from the old server, and then imported them appropriately into the new one.

As far as permissions go, I think that is most likely where I screwed up. I was messing around with things to set up a Samba share and one if the scripts I ran in the wrong spot and it set the permissions to everything to 755. I did try to go back and fix most of it, but I think I may still have something set wrong. (I'm still a Linux noob, I think 777 is like the equivalent of root, but I'm clueless about the rest.)
The permissions I see on everything when I use "ls -l" is "-r-xr-xr-x 1 nobody nogroup" I don't know if that's correct or not though.

And on top of all of that, now my server is freezing up for no reason. It was happening on the old machine so I thought it had to do with how screwed up I got Ubuntu and the other packages. Now it's happening on the new one and all I've done after following 343's install is to copy in the databases and import the stuff through phpmyadmin. I'm beginning to think maybe it's trying to read a database file, or write to one and can't because somewhere I've screwed up the permissions.:*:

Quote:

---

Originally Posted by Souris

This is the kind of reason you should always update a computer no matter what OS it runs: A simple HTML tag will crash 64-bit Windows 7 • The Register

Flaw like this are discovered on nearly daily basis, not updating is making attacker's work easy. A random server on the web get 20000+* port scan/ssh attempt/etc per day, successful attack could mean your server turning into a spam farm for example. Not to mention PW community is not always the nicest and attack amongst servers do exist.

*based on my own logs :p

---

(Sorry to come back to this post everyone, but)

I just really noticed this post and read the link... The thing I find the FUNNIEST is this is in no how related to topic (Linux or PW)... In my opinion it is NOT even a decent example (let alone a good one)... They're talking about a vulnerability in Windows first off. Second off, this vulnerability ONLY exists while running a piece of APPLE software ON the WINDOWS machine... (So CERTAINLY not a LOT of people will be doing this, ie... makes it a more RARE possibility)!

On the other hand you could say "it's a good example" because it just proves that people/someone out there will find a flaw if there is one, no matter how rare it is... Well Ok, technically that is highly probable -- I can safely tell you, running anti virus and making sure to regularly 'update' is NOT going to help that... Because, you're right -- there will always be someone looking for some 'loophole' somewhere, and ya know what, someone WILL find it if it's there... So you can't be bothered with "anti virus" and "updates" they are not 100% necessary...

Like Das and I have both said before... If you TRULY want to be safe ~-~ NEVER remove it from the box :thumbup1: !!!!!

add:

Spoiler:

also, did you ever pause to think that, your 'beloved' updates may CREATE 'loopholes', that weren't there prior to the update. Yes, I'm sure they can and do... You also don't think there are people checking the updates right away for these 'new' loopholes...

I'll say it ONE more time:

If you TRULY want to be safe ~-~ NEVER remove it from the box !!!!!

Sorry, now let the topic return to where it was:

:thumbup1:

Quote:

---

I can safely tell you, running anti virus and making sure to regularly 'update' is NOT going to help that... Because, you're right -- there will always be someone looking for some 'loophole' somewhere, and ya know what, someone WILL find it if it's there... So you can't be bothered with "anti virus" and "updates" they are not 100% necessary...

---

This is as stupid as saying "a condom can always break so there is no reason to use one when going around and sleeping with everyone". Security fixes will not be 100% reliable, but if it can prevent 99% of the problems why would you skip it?

Ubuntu Linux 10.04 - Secunia.com (about 3 click away from my link with some curiosity) check the amount of "vendor patched" issues? 175 out of 176 security issues were fixed this year on ubuntu 10.04 (what most recommend to use as server on this forum). You can look at the other stuff which are usually found on a server (apache, tomcat, ssh, mysql, etc) and you will find the situation is the same.

Again: I am not talking about updating to newer version of software/os. For example updating from php 5.2.x to 5.3.x might cause a lot of issues and scripts breakdown; there is no reason to do it if you don't need it. However there will be no change in compatibility between 5.2.1 and 5.2.3, only security and speed improvement and this what I am talking about.

Quote:

---

If you TRULY want to be safe ~-~ NEVER remove it from the box !!!!!

---

to be safe from STD, it would be better to be a nun in a monastery, that's a fact. Now this is not an option, so let's use a condom.

Quote:

---

Originally Posted by Souris

This is as stupid as saying "a condom can always break so there is no reason to use one when going around and sleeping with everyone". Security fixes will not be 100% reliable, but if it can prevent 99% of the problems why would you skip it?

Ubuntu Linux 10.04 - Secunia.com (about 3 click away from my link with some curiosity) check the amount of "vendor patched" issues? 175 out of 176 security issues were fixed this year on ubuntu 10.04 (what most recommend to use as server on this forum). You can look at the other stuff which are usually found on a server (apache, tomcat, ssh, mysql, etc) and you will find the situation is the same.

Again: I am not talking about updating to newer version of software/os. For example updating from php 5.2.x to 5.3.x might cause a lot of issues and scripts breakdown; there is no reason to do it if you don't need it. However there will be no change in compatibility between 5.2.1 and 5.2.3, only security and speed improvement and this what I am talking about.


to be safe from STD, it would be better to be a nun in a monastery, that's a fact. Now this is not an option, so let's use a condom.

---

Actually (as I stated in PM) this is not a personal attack, we are each entitled to our own opinions. Which we clearly DO have different opinions. Switching topics as you have, I never use a condom =X and yes; the only 100% way to be safe from an STD would be to not have sexual intercourse at all...

Aaaannndd.. coming back on-topic...

It took some doing, but here's the permissions from a clean install....

Spoiler:

./gamedbd:
total 7980
-r-xr-xr-x 1 root root 1463107 2011-12-20 02:52 cashstat
-r-xr-xr-x 1 root root 3982 2011-12-20 02:52 cashstat.conf
-r-xr-xr-x 1 root root 28672 2011-12-20 02:52 clsconfig
dr-xr-xr-x 5 root root 4096 2011-12-20 02:52 dbhomewdb
-r-xr-xr-x 1 root root 1246821 2011-12-20 02:52 dbtool
-r-xr-xr-x 1 root root 3188682 2011-12-20 02:52 gamedbd
-r-xr-xr-x 1 root root 2217164 2011-12-20 02:52 gamedbd.conv
-r-xr-xr-x 1 root root 5061 2011-12-20 02:52 gamesys.conf

./gamedbd/dbhomewdb:
total 12
dr-xr-xr-x 2 root root 4096 2011-12-20 02:52 backup
dr-xr-xr-x 2 root root 4096 2011-12-20 18:43 dbdata
dr-xr-xr-x 2 root root 4096 2011-12-23 14:26 dblogs

./gamedbd/dbhomewdb/backup:
total 0

./gamedbd/dbhomewdb/dbdata:
total 236
-rw------- 1 root root 8192 2011-12-23 15:47 auction
-rw------- 1 root root 12288 2011-12-23 15:47 base
-rw------- 1 root root 8192 2011-12-23 15:47 city
-rw------- 1 root root 28672 2011-12-23 15:47 clsconfig
-rw------- 1 root root 8192 2011-12-23 15:47 config
-rw------- 1 root root 12288 2011-12-23 15:47 equipment
-rw------- 1 root root 8192 2011-12-23 15:47 factioninfo
-rw------- 1 root root 8192 2011-12-23 15:47 factionname
-rw------- 1 root root 8192 2011-12-23 15:47 friends
-rw------- 1 root root 8192 2011-12-23 15:47 gtask
-rw------- 1 root root 12288 2011-12-23 15:47 inventory
-rw------- 1 root root 8192 2011-12-23 15:47 mailbox
-rw------- 1 root root 8192 2011-12-23 15:47 messages
-rw------- 1 root root 8192 2011-12-23 15:47 order
-rw------- 1 root root 8192 2011-12-23 15:47 rolename
-rw------- 1 root root 8192 2011-12-23 15:47 sellpoint
-rw------- 1 root root 8192 2011-12-23 15:47 shoplog
-rw------- 1 root root 12288 2011-12-23 15:47 status
-rw------- 1 root root 12288 2011-12-23 15:47 storehouse
-rw------- 1 root root 8192 2011-12-23 15:47 task
-rw------- 1 root root 8192 2011-12-23 15:47 translog
-rw------- 1 root root 12288 2011-12-23 15:47 user
-rw------- 1 root root 8192 2011-12-23 15:47 userfaction
-rw------- 1 root root 8192 2011-12-23 15:47 waitdel

./gamedbd/dbhomewdb/dblogs:
total 100
-rw------- 1 root root 102400 2011-12-23 15:47 log.4ef4d5fb

./gdeliveryd:
total 44196
-r-xr-xr-x 1 root root 114484 2011-12-20 02:52 auctionid.txt
-r-xr-xr-x 1 root root 1904 2011-12-20 02:52 domain.sev
-r-xr-xr-x 1 root root 4298 2011-12-20 02:52 filters
-r-xr-xr-x 1 root root 3027 2011-12-20 02:52 gamesys.conf
-r-xr-xr-x 1 root root 45123639 2011-12-20 02:52 gdeliveryd

./uniquenamed:
total 1744
-r-xr-xr-x 1 root root 1971 2011-12-20 02:52 gamesys.conf
dr-xr-xr-x 5 root root 4096 2011-12-20 02:52 uname
-r-xr-xr-x 1 root root 1776488 2011-12-20 02:52 uniquenamed

./uniquenamed/uname:
total 12
dr-xr-xr-x 2 root root 4096 2011-12-20 02:52 backup
dr-xr-xr-x 2 root root 4096 2011-12-20 18:43 dbdata
dr-xr-xr-x 2 root root 4096 2011-12-23 14:28 dblogs

./uniquenamed/uname/backup:
total 0

./uniquenamed/uname/dbdata:
total 32
-rw------- 1 root root 8192 2011-12-23 15:47 config
-rw------- 1 root root 8192 2011-12-23 15:47 uidrole
-rw------- 1 root root 8192 2011-12-23 15:47 unamefaction
-rw------- 1 root root 8192 2011-12-23 15:47 unamerole

./uniquenamed/uname/dblogs:
total 372
-rw------- 1 root root 53248 2011-12-20 22:58 log.4ef11d89
-rw------- 1 root root 20480 2011-12-21 03:12 log.4ef1594f
-rw------- 1 root root 20480 2011-12-21 07:26 log.4ef194d7
-rw------- 1 root root 20480 2011-12-21 11:40 log.4ef1d064
-rw------- 1 root root 20480 2011-12-21 15:54 log.4ef20bee
-rw------- 1 root root 20480 2011-12-21 20:08 log.4ef24778
-rw------- 1 root root 20480 2011-12-22 00:22 log.4ef28304
-rw------- 1 root root 20480 2011-12-22 04:36 log.4ef2be8e
-rw------- 1 root root 20480 2011-12-22 08:50 log.4ef2fa18
-rw------- 1 root root 20480 2011-12-22 13:04 log.4ef335a2
-rw------- 1 root root 20480 2011-12-22 17:18 log.4ef3712e
-rw------- 1 root root 20480 2011-12-22 21:32 log.4ef3acb9
-rw------- 1 root root 20480 2011-12-23 01:46 log.4ef3e844
-rw------- 1 root root 20480 2011-12-23 06:00 log.4ef423d2
-rw------- 1 root root 20480 2011-12-23 10:14 log.4ef45f5c
-rw------- 1 root root 20480 2011-12-23 14:28 log.4ef49aea
-rw------- 1 root root 20480 2011-12-23 15:47 log.4ef4d676

And here's the permissions from my faulty database...

Spoiler:

./gamedbd:
total 7972
-r-xr-xr-x 1 nobody nogroup 1463107 2011-12-15 18:35 cashstat
-r-xr-xr-x 1 nobody nogroup 3982 2011-12-15 18:35 cashstat.conf
-rwxr-xr-x 1 root root 12288 2011-12-15 18:59 clsconfig
dr-xr-xr-x 5 nobody nogroup 4096 2011-12-13 01:53 dbhomewdb
-r-xr-xr-x 1 nobody nogroup 1246821 2011-12-15 18:35 dbtool
-r-xr-xr-x 1 nobody nogroup 3188682 2011-12-15 18:35 gamedbd
-r-xr-xr-x 1 nobody nogroup 2217164 2011-12-15 18:35 gamedbd.conv
-r-xr-xr-x 1 nobody nogroup 5419 2011-12-15 18:35 gamesys.conf
-r-xr-xr-x 1 nobody nogroup 5061 2011-12-15 18:35 gamesys - Copy.conf

./gamedbd/dbhomewdb:
total 12
dr-xr-xr-x 2 nobody nogroup 4096 2011-12-13 01:53 backup
dr-xr-xr-x 2 nobody nogroup 4096 2011-12-15 18:28 dbdata
dr-xr-xr-x 2 nobody nogroup 4096 2011-12-22 07:32 dblogs

./gamedbd/dbhomewdb/backup:
total 0

./gamedbd/dbhomewdb/dbdata:
total 580
-rw-rw-rw- 1 root root 8192 2011-12-22 10:56 auction
-rw-rw-rw- 1 root root 28672 2011-12-22 10:56 base
-rw-rw-rw- 1 root root 12288 2011-12-22 10:56 city
-rw-rw-rw- 1 root root 12288 2011-12-22 10:56 clsconfig
-rw-rw-rw- 1 root root 8192 2011-12-22 10:56 config
-rw-rw-rw- 1 root root 24576 2011-12-22 10:56 equipment
-rw-rw-rw- 1 root root 268443648 2011-12-22 10:56 factioninfo
-rw-rw-rw- 1 root root 268443648 2011-12-22 10:56 factionname
-rw-rw-rw- 1 root root 12288 2011-12-22 10:56 friends
-rw-rw-rw- 1 root root 268443648 2011-12-22 10:56 gtask
-rw-rw-rw- 1 root root 24576 2011-12-22 10:56 inventory
-rw-rw-rw- 1 root root 268443648 2011-12-22 10:56 mailbox
-rw-rw-rw- 1 root root 268443648 2011-12-22 10:56 messages
-rw-rw-rw- 1 root root 8192 2011-12-22 10:56 order
-rw-rw-rw- 1 root root 268443648 2011-12-22 10:56 rolename
-rw-rw-rw- 1 root root 8192 2011-12-22 10:56 sellpoint
-rw-rw-rw- 1 root root 77824 2011-12-22 10:56 shoplog
-rw-rw-rw- 1 root root 28672 2011-12-22 10:56 status
-rw-rw-rw- 1 root root 16384 2011-12-22 10:56 storehouse
-rw-rw-rw- 1 root root 16384 2011-12-22 10:56 task
-rw-rw-rw- 1 root root 8192 2011-12-22 10:56 translog
-rw-rw-rw- 1 root root 12288 2011-12-22 10:56 user
-rw-rw-rw- 1 root root 12288 2011-12-22 10:56 userfaction
-rw-rw-rw- 1 root root 12288 2011-12-22 10:56 waitdel

./gamedbd/dbhomewdb/dblogs:
total 100
-rw------- 1 root root 102400 2011-12-22 10:56 log.4ef32376

./uniquenamed:
total 1744
-r-xr-xr-x 1 root root 1971 2011-12-15 18:35 gamesys.conf
dr-xr-xr-x 5 nobody nogroup 4096 2011-12-13 01:53 uname
-r-xr-xr-x 1 root root 1776488 2011-12-15 18:35 uniquenamed

./uniquenamed/uname:
total 12
dr-xr-xr-x 2 nobody nogroup 4096 2011-12-13 01:53 backup
dr-xr-xr-x 2 nobody nogroup 4096 2011-12-15 18:35 dbdata
dr-xr-xr-x 2 nobody nogroup 4096 2011-12-22 07:29 dblogs

./uniquenamed/uname/backup:
total 0

./uniquenamed/uname/dbdata:
total 44
-r-xr-xr-x 1 root root 8192 2011-12-22 10:56 config
-r-xr-xr-x 1 root root 12288 2011-12-22 10:56 uidrole
-r-xr-xr-x 1 root root 12288 2011-12-22 10:56 unamefaction
-r-xr-xr-x 1 root root 12288 2011-12-22 10:56 unamerole

./uniquenamed/uname/dblogs:
total 2768
-rw------- 1 nobody nogroup 176128 2011-12-15 18:35 log.4ede463f
-rw------- 1 nobody nogroup 45056 2011-12-15 18:35 log.4ede8649
-rw------- 1 nobody nogroup 106496 2011-12-15 18:35 log.4edec1d1
-rw------- 1 nobody nogroup 20480 2011-12-15 18:35 log.4edefd59
-rw------- 1 nobody nogroup 20480 2011-12-15 18:35 log.4edf38e1
-rw------- 1 nobody nogroup 102400 2011-12-15 18:35 log.4edf7469
-rw------- 1 nobody nogroup 20480 2011-12-15 18:35 log.4ee05bbd
-rw------- 1 nobody nogroup 40960 2011-12-15 18:35 log.4ee09745
-rw------- 1 nobody nogroup 45056 2011-12-15 18:35 log.4ee0d2cd
-rw------- 1 nobody nogroup 36864 2011-12-15 18:35 log.4ee10e55
-rw------- 1 nobody nogroup 94208 2011-12-15 18:35 log.4ee14e3c
-rw------- 1 nobody nogroup 20480 2011-12-15 18:35 log.4ee18c76
-rw------- 1 nobody nogroup 20480 2011-12-15 18:35 log.4ee1c7fe
-rw------- 1 nobody nogroup 36864 2011-12-15 18:35 log.4ee20386
-rw------- 1 nobody nogroup 65536 2011-12-15 18:35 log.4ee23f3c
-rw------- 1 nobody nogroup 45056 2011-12-15 18:35 log.4ee285a3
-rw------- 1 nobody nogroup 32768 2011-12-15 18:35 log.4ee2c12b
-rw------- 1 nobody nogroup 20480 2011-12-15 18:35 log.4ee2fcb3
-rw------- 1 nobody nogroup 20480 2011-12-15 18:35 log.4ee3383b
-rw------- 1 nobody nogroup 45056 2011-12-15 18:35 log.4ee373c3
-rw------- 1 nobody nogroup 73728 2011-12-15 18:35 log.4ee3af4b
-rw------- 1 nobody nogroup 40960 2011-12-15 18:35 log.4ee3f094
-rw------- 1 nobody nogroup 40960 2011-12-15 18:35 log.4ee42c29
-rw------- 1 nobody nogroup 20480 2011-12-15 18:35 log.4ee467b1
-rw------- 1 nobody nogroup 36864 2011-12-15 18:35 log.4ee4a339
-rw------- 1 nobody nogroup 61440 2011-12-15 18:35 log.4ee4e0ba
-rw------- 1 nobody nogroup 61440 2011-12-15 18:35 log.4ee51c42
-rw------- 1 nobody nogroup 20480 2011-12-15 18:35 log.4ee557ca
-rw------- 1 nobody nogroup 20480 2011-12-15 18:35 log.4ee59352
-rw------- 1 nobody nogroup 36864 2011-12-15 18:35 log.4ee5cedb
-r-xr-xr-x 1 nobody nogroup 20480 2011-12-15 18:35 log.4ee7025c
-rw------- 1 root root 20480 2011-12-15 18:35 log.4ee78c38
-rw------- 1 root root 36864 2011-12-15 18:35 log.4ee7c7c2
-rw------- 1 root root 20480 2011-12-15 18:35 log.4ee8062f
-rw------- 1 root root 40960 2011-12-15 18:35 log.4ee841bd
-rw------- 1 root root 20480 2011-12-15 18:35 log.4ee87d49
-rw------- 1 root root 36864 2011-12-15 18:35 log.4ee8b8d3
-rw------- 1 root root 86016 2011-12-15 18:35 log.4ee9055c
-rw------- 1 root root 36864 2011-12-15 18:35 log.4ee9444f
-rw------- 1 root root 20480 2011-12-15 18:35 log.4ee97ff9
-rw------- 1 root root 20480 2011-12-15 18:35 log.4ee9bb84
-rw------- 1 root root 77824 2011-12-15 18:35 log.4eea0681
-rw------- 1 root root 20480 2011-12-15 18:35 log.4eea4312
-rw------- 1 root root 36864 2011-12-15 23:04 log.4eea7e9d
-rw------- 1 root root 20480 2011-12-16 03:18 log.4eeac342
-rw------- 1 root root 20480 2011-12-16 07:32 log.4eeafecb
-rw------- 1 root root 20480 2011-12-16 11:46 log.4eeb3a55
-rw------- 1 root root 20480 2011-12-16 16:00 log.4eeb75e0
-rw------- 1 root root 110592 2011-12-16 20:14 log.4eebb16a
-rw------- 1 root root 20480 2011-12-17 00:28 log.4eebecf6
-rw------- 1 root root 20480 2011-12-17 04:42 log.4eec2881
-rw------- 1 root root 20480 2011-12-17 08:56 log.4eec640b
-rw------- 1 root root 40960 2011-12-17 13:10 log.4eec9f95
-rw------- 1 root root 20480 2011-12-17 17:24 log.4eecdb1f
-rw------- 1 root root 20480 2011-12-17 21:38 log.4eed16a8
-rw------- 1 root root 20480 2011-12-18 01:52 log.4eed5234
-rw------- 1 root root 20480 2011-12-18 06:06 log.4eed8dc2
-rw------- 1 root root 20480 2011-12-18 10:20 log.4eedc94e
-rw------- 1 root root 20480 2011-12-18 14:34 log.4eee04d9
-rw------- 1 root root 40960 2011-12-18 18:49 log.4eee4063
-rw------- 1 root root 20480 2011-12-18 23:03 log.4eee7bef
-rw------- 1 root root 20480 2011-12-19 03:17 log.4eeeb77b
-rw------- 1 root root 20480 2011-12-19 07:31 log.4eeef304
-rw------- 1 root root 20480 2011-12-19 11:45 log.4eef2e8f
-rw------- 1 root root 20480 2011-12-19 15:59 log.4eef6a18
-rw------- 1 root root 20480 2011-12-19 20:13 log.4eefa5a4
-rw------- 1 root root 20480 2011-12-20 00:27 log.4eefe12f
-rw------- 1 root root 20480 2011-12-20 04:41 log.4ef01cb8
-rw------- 1 root root 20480 2011-12-20 08:55 log.4ef05842
-rw------- 1 root root 20480 2011-12-20 13:09 log.4ef093d0
-rw------- 1 root root 20480 2011-12-20 17:23 log.4ef0cf5a
-rw------- 1 root root 20480 2011-12-20 21:37 log.4ef10ae3
-rw------- 1 root root 20480 2011-12-21 01:51 log.4ef1466d
-rw------- 1 root root 20480 2011-12-21 06:05 log.4ef181f9
-rw------- 1 root root 20480 2011-12-21 10:19 log.4ef1bd83
-rw------- 1 root root 40960 2011-12-21 14:33 log.4ef1f90d
-rw------- 1 root root 20480 2011-12-21 18:47 log.4ef23499
-rw------- 1 root root 20480 2011-12-21 23:01 log.4ef27023
-rw------- 1 root root 20480 2011-12-22 03:15 log.4ef2abad
-rw------- 1 root root 20480 2011-12-22 07:29 log.4ef2e738
-rw------- 1 root root 20480 2011-12-22 10:56 log.4ef322c3

./uniquenamedbak:
total 1744
-r-xr-xr-x 1 root root 1971 2011-12-15 18:35 gamesys.conf
dr-xr-xr-x 5 root root 4096 2011-12-15 08:05 uname
-r-xr-xr-x 1 root root 1776488 2011-12-15 18:35 uniquenamed

./uniquenamedbak/uname:
total 12
dr-xr-xr-x 2 root root 4096 2011-12-15 08:05 backup
dr-xr-xr-x 2 root root 4096 2011-12-15 08:05 dbdata
dr-xr-xr-x 2 root root 4096 2011-12-15 08:05 dblogs

./uniquenamedbak/uname/backup:
total 0

./uniquenamedbak/uname/dbdata:
total 44
-r-xr-xr-x 1 root root 8192 2011-12-15 18:35 config
-r-xr-xr-x 1 root root 12288 2011-12-15 18:35 uidrole
-r-xr-xr-x 1 root root 12288 2011-12-15 18:35 unamefaction
-r-xr-xr-x 1 root root 12288 2011-12-15 18:35 unamerole

./uniquenamedbak/uname/dblogs:
total 1764
-rw------- 1 root root 176128 2011-12-15 18:35 log.4ede463f
-rw------- 1 root root 45056 2011-12-15 18:35 log.4ede8649
-rw------- 1 root root 106496 2011-12-15 18:35 log.4edec1d1
-rw------- 1 root root 20480 2011-12-15 18:35 log.4edefd59
-rw------- 1 root root 20480 2011-12-15 18:35 log.4edf38e1
-rw------- 1 root root 102400 2011-12-15 18:35 log.4edf7469
-rw------- 1 root root 20480 2011-12-15 18:35 log.4ee05bbd
-rw------- 1 root root 40960 2011-12-15 18:35 log.4ee09745
-rw------- 1 root root 45056 2011-12-15 18:35 log.4ee0d2cd
-rw------- 1 root root 36864 2011-12-15 18:35 log.4ee10e55
-rw------- 1 root root 94208 2011-12-15 18:35 log.4ee14e3c
-rw------- 1 root root 20480 2011-12-15 18:35 log.4ee18c76
-rw------- 1 root root 20480 2011-12-15 18:35 log.4ee1c7fe
-rw------- 1 root root 36864 2011-12-15 18:35 log.4ee20386
-rw------- 1 root root 65536 2011-12-15 18:35 log.4ee23f3c
-rw------- 1 root root 45056 2011-12-15 18:35 log.4ee285a3
-rw------- 1 root root 32768 2011-12-15 18:35 log.4ee2c12b
-rw------- 1 root root 20480 2011-12-15 18:35 log.4ee2fcb3
-rw------- 1 root root 20480 2011-12-15 18:35 log.4ee3383b
-rw------- 1 root root 45056 2011-12-15 18:35 log.4ee373c3
-rw------- 1 root root 73728 2011-12-15 18:35 log.4ee3af4b
-rw------- 1 root root 40960 2011-12-15 18:35 log.4ee3f094
-rw------- 1 root root 40960 2011-12-15 18:35 log.4ee42c29
-rw------- 1 root root 20480 2011-12-15 18:35 log.4ee467b1
-rw------- 1 root root 36864 2011-12-15 18:35 log.4ee4a339
-rw------- 1 root root 61440 2011-12-15 18:35 log.4ee4e0ba
-rw------- 1 root root 61440 2011-12-15 18:35 log.4ee51c42
-rw------- 1 root root 20480 2011-12-15 18:35 log.4ee557ca
-rw------- 1 root root 20480 2011-12-15 18:35 log.4ee59352
-rw------- 1 root root 53248 2011-12-15 18:35 log.4ee5cedb
-r-xr-xr-x 1 root root 20480 2011-12-15 18:35 log.4ee7025c
-rw------- 1 root root 20480 2011-12-15 18:35 log.4ee78c38
-rw------- 1 root root 36864 2011-12-15 18:35 log.4ee7c7c2
-rw------- 1 root root 20480 2011-12-15 18:35 log.4ee8062f
-rw------- 1 root root 40960 2011-12-15 18:35 log.4ee841bd
-rw------- 1 root root 20480 2011-12-15 18:35 log.4ee87d49
-rw------- 1 root root 36864 2011-12-15 18:35 log.4ee8b8d3
-rw------- 1 root root 86016 2011-12-15 18:35 log.4ee9055c
-rw------- 1 root root 36864 2011-12-15 18:35 log.4ee9444f
-rw------- 1 root root 20480 2011-12-15 18:35 log.4ee97ff9
-rw------- 1 root root 20480 2011-12-15 18:35 log.4ee9bb84

So now to compare and figure out how to fix it cause I'm sure I've screwed something up with permissions

So I think I need to change the nobody's to root.... and also change the permissions on some stuff. Google FTW, I'll figure out how

I hope you could find a fix... But well I personnaly suggest to start a fresh and clean characters database to be sure that there will be nothing that may corrupt your server again...

If you want to try and fix:

Code:

---

chown root:root -R uniquenamed
chown root:root -R gamedbd
chmod u+rwX,g-w+rX,o-rwx -R uniquenamed/
chmod u+rwX,g-w+rX,o-rwx -R gamedbd/
chmod u+x,g-x uniquenamed/uniquenamed
chmod u+x,g-x gamedbd/gamedbd

---

Should be pretty self explanatory. No guaranty on effectiveness blahblah

chown should be enough, as the gamedb tends to set chmod flags itself