安道生練功房 - 分享經驗，累積智慧

      <Host name="www.ezmatch.tw"

            appBase="webapps/www.ezmatch.tw"

            unpackWARs="true" autoDeploy="true">

        <Alias>ezmatch.tw</Alias>

        <Valve className="org.apache.catalina.valves.FastCommonAccessLogValve"

               directory="logs/www.ezmatch.tw"

               prefix="www.ezmatch.tw_access_log." suffix=".txt"

               pattern="combined" resolveHosts="false"/>

        <Context path="" docBase="" debug="0" reloadable="false" />

      </Host>

      <Host name="www.ezmatch.tw"

            appBase=""

            unpackWARs="true" autoDeploy="true">

        <Alias>ezmatch.tw</Alias>

        <Valve className="org.apache.catalina.valves.FastCommonAccessLogValve"

               directory="logs/www.ezmatch.tw"

               prefix="www.ezmatch.tw_access_log." suffix=".txt"

               pattern="combined" resolveHosts="false"/>

        <Context path="" docBase="webapps/www.ezmatch.tw" debug="0" reloadable="false" />

      </Host>

select * from jforum_users where user_id not in (select session_user_id from jforum_sessions) and user_actkey is not null and date_part('day',current_timestamp-user_regdate) > 90 order by user_id

yum -y install postgresql postgresql-libs postgresql-server

rpm -Uvh postgresql-*.rpm

service postgresql start

chkconfig postgresql on

# "local" is for Unix domain socket connections only

#local   all         all                               ident sameuser

local   all         all         trust

# IPv4 local connections:

#host    all         all         127.0.0.1/32          ident sameuser

host    all         all         127.0.0.1/32          md5

su - postgres

pg_ctl reload

listen_addresses = '*'

tcpip_socket = true

host    all         all         192.168.1.0/24          md5

su - postgres

pg_ctl reload

find -name CVS -exec rm -rf {} ';'

嘗試設定資料庫時發生錯誤. 請檢查帳號、密碼和主機等參數是否正確, 然後再試一次.

java.sql.SQLException: IO 異常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093888)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

RemoveServerHeader=1           ; if 1, remove "Server" header from response

cd ~/download/olat3

sed -i -e "s/instantMessaging.enable=false/instantMessaging.enable=true/" build.properties

sed -i -e "s/instantMessaging.server.name=jabber.andowson.com/instantMessaging.server.name=www.andowson.com/" build.properties

sed -i -e "s/instantMessaging.generateTestUsers=false/instantMessaging.generateTestUsers=ture/" build.properties

sed -i -e "s/instantMessaging.db.name=wildfire/instantMessaging.db.name=openfire/" build.properties

sed -i -e "s/instantMessaging.db.user=wildfire/instantMessaging.db.user=olat/" build.properties

sed -i -e "s/instantMessaging.db.pass=wildfire/instantMessaging.db.pass=olat/" build.properties

ant config-all

cp -rf ~/download/olat3/webapp/WEB-INF/olat_config.xml ~/www/olat/WEB-INF

cd ~/download

wget http://www.igniterealtime.org/downloadServlet?filename=openfire/openfire_3_3_3.tar.gz -O openfire_3_3_3.tar.gz

tar zxvf openfire_3_3_3.tar.gz -C ~

sudo -u postgres psql -c "ALTER USER olat CREATEDB;" template1

sudo -u postgres psql -c "CREATE DATABASE openfire WITH ENCODING 'UNICODE';" -U olat template1    

sudo -u postgres psql -c "ALTER USER olat NOCREATEDB;" template1

sudo -u postgres psql openfire olat -f ~/openfire/resources/database/openfire_postgresql.sql

cp ~/download/olat3/conf/openfire.xml ~/openfire/conf

sed -i -e "s/com.mysql.jdbc.Driver/org.postgresql.Driver/" ~/openfire/conf/openfire.xml

sed -i -e "s/mysql/postgresql/g" ~/openfire/conf/openfire.xml

cd ~/openfire/bin

./openfire start

./openfire stop

./openfire start

tail -5 ~/openfire/logs/info.log

2007.09.22 12:36:25 Publish-Subscribe domain: pubsub.www.andowson.com
2007.09.22 12:36:25 Started server (unencrypted) socket on port: 5269
2007.09.22 12:36:25 Started plain (unencrypted) socket on port: 5222
2007.09.22 12:36:36 Openfire 3.3.2 [Sep 22, 2007 12:36:36 PM]
2007.09.22 12:36:41 Admin console listening at http://www.andowson.com:9090

sudo /etc/init.d/tomcat restart

grep failure messages | awk '{print $13}' | uniq | grep -v tty | cut -d"=" -f2 | sort | grep "\." | uniq | grep -v "192.168.1" >> /tmp/attack.log

Driver={SQL Server};Server=servername;Database=dbname;Uid=username;Pwd=password;

Provider=SQLOLEDB;Data Source=machineName;Initial Catalog=dbname;User ID=username;Password=password;

Driver={SQL Server};Server=192.168.1.68;Database=testdb;Uid=test;Pwd=noOneKnows;

Provider=SQLOLEDB;Data Source=192.168.1.68;Initial Catalog=testdb;User ID=test;Password=noOneKnows;

su - root

su - postgres

psql olat olat -f /tmp/alter_5_1_0_to_5_2_0.sql

exit

exit

sudo -u postgres psql olat olat -f /tmp/alter_5_1_0_to_5_2_0.sql

yum install sudo

# %wheel  ALL=(ALL)       NOPASSWD: ALL

usermod -a -G wheel andowson

TopicModel.selectAllByForumByLimit = SELECT t.*, p.user_id AS last_user_id, p.post_time, (SELECT SUM(p.attach) \

        FROM jforum_posts p \

        WHERE p.topic_id = t.topic_id \

        AND p.need_moderate = 0) AS attach \

        FROM jforum_topics t, jforum_posts p \

        WHERE (t.forum_id = ? OR t.topic_moved_id = ?) \

        AND p.post_id = t.topic_last_post_id \

        AND p.need_moderate = 0 \

        ORDER BY t.topic_type DESC, t.topic_last_post_id DESC \

        OFFSET ? LIMIT ?



TopicModel.selectByUserByLimit = SELECT t.*, p.user_id AS last_user_id, p.post_time, (SELECT SUM(p.attach) \

        FROM jforum_posts p \

        WHERE p.topic_id = t.topic_id \

        AND p.need_moderate = 0) AS attach \

        FROM jforum_topics t, jforum_posts p \

        WHERE p.post_id = t.topic_last_post_id \

        AND t.user_id = ? \

        AND p.need_moderate = 0 \

        AND t.forum_id IN(:fids:) \

        ORDER BY t.topic_last_post_id DESC \

        OFFSET ? LIMIT ?