Confluence

# 定时备份
#0 0 * * * /opt/gitlab/bin/gitlab-rake gitlab:backup:create

## 定时同步时钟
*/15 * * * * nohup /usr/sbin/ntpdate 172.16.108.69 >> /var/log/ntp.log &

## 定时备份
35 1 * * * nohup rsync -av /var/opt/gitlab/backups/* kvm11:/mnt/backup/gitlab/ >> /var/log/gitbak.log &

## 定时清理
45 2 * * * nohup find /var/opt/gitlab/backups/ -mtime +2 -name "*.tar" -exec rm -f {} \; >> /var/log/gitclean.log &

————————————————————
confluence重置admin密码

复方法：

1. 运行此sql 找到你的管理员帐户：


select u.id, u.user_name, u.active from cwd_user u
join cwd_membership m on u.id=m.child_user_id join cwd_group g on m.parent_id=g.id join cwd_directory d on d.id=g.directory_id
where g.group_name = 'confluence-administrators' and d.directory_name='Confluence Internal Directory';
并记住管理员帐户的id



2. 运行此sql, 恢复管理员密码为 admin


update cwd_user set credential =
'x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A=='
where id=xxxxxx;
注意此处xxxxxx 为上一步的 id



如果你的密码是{PKCS5S2}前缀开头的，则用下面这个sql:


update cwd_user set credential =
'{PKCS5S2}ltrb9LlmZ0QDCJvktxd45WgYLOgPt2XTV8X7av2p0mhPvIwofs9bHYVz2OXQ6/kF'
where id=xxxxxx;
这个管理员密码为 Ab123456



如果使用hsql，请用下面语句登录hsql数据库

java -cp /opt/atlassian/confluence/WEB-INF/lib/hsqldb-2.3.0.jar org.hsqldb.util.DatabaseManager -user sa -url jdbc:hsqldb:/data/confluence/data/database/confluencedb


java -cp hsqldb-2.3.0.jar org.hsqldb.util.DatabaseManager -user sa -url jdbc:hsqldb:confluencedb