My noob questions ~ Part Deux

[343]

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...

[Allisandre]

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

[Romulan]

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...

[Souris]

If you want to try and fix:

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

[tbnanubis]

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