sudo apt-get -y install apache2 \
php8.1 \
libapache2-mod-php8.1 \
php8.1-xml \
php8.1-mbstring
wget https://github.com/phpsysinfo/phpsysinfo/archive/v3.4.2.tar.gz
tar xvfz v3.4.2.tar.gz
sudo mv phpsysinfo* /opt/phpsysinfo
sudo cp /opt/phpsysinfo/phpsysinfo.ini.new /opt/phpsysinfo/phpsysinfo.ini
sudo chown -R www-data:www-data /opt/phpsysinfo
sudo ln -s /opt/phpsysinfo /var/www/html
sudo systemctl restart apache2.service
sudo apt-get update
sudo apt-get -y install mariadb-server
sudo mysql -uroot -e "SET PASSWORD = PASSWORD('root'); FLUSH PRIVILEGES;"
mysql -uroot -proot -e "CREATE DATABASE ttrss DEFAULT CHARACTER SET utf8mb4;"
mysql -uroot -proot -e "CREATE USER ttrss@localhost IDENTIFIED BY 'ttrss';"
mysql -uroot -proot -e "GRANT ALL PRIVILEGES ON ttrss.* TO 'ttrss'@'localhost';"
mysql -uroot -proot -e "FLUSH PRIVILEGES;"
sudo apt-get -y install apache2 \
php8.1 \
libapache2-mod-php8.1 \
php8.1-pdo-mysql \
php8.1-common \
php8.1-xml \
php8.1-intl \
php8.1-fileinfo \
php8.1-curl \
php8.1-mbstring \
php8.1-gd
sudo apt-get -y install git
git clone https://git.tt-rss.org/fox/tt-rss.git tt-rss
cp tt-rss/config.php-dist tt-rss/config.php
echo "putenv('TTRSS_DB_HOST=localhost');" >> tt-rss/config.php
echo "putenv('TTRSS_DB_NAME=ttrss');" >> tt-rss/config.php
echo "putenv('TTRSS_DB_USER=ttrss');" >> tt-rss/config.php
echo "putenv('TTRSS_DB_PASS=ttrss');" >> tt-rss/config.php
echo "putenv('TTRSS_SELF_URL_PATH=https://<ホスト名またはIPアドレス>/ttrss');" >> tt-rss/config.php
echo "putenv('TTRSS_DB_TYPE=mysql');" >> tt-rss/config.php
echo "putenv('TTRSS_DB_PORT=3306');" >> tt-rss/config.php
cd tt-rss
./update.php --update-schema
cd ..
sudo mv tt-rss /opt/ttrss
sudo chown -R www-data:www-data /opt/ttrss
sudo sudo ln -s /opt/ttrss/ /var/www/html/
sudo systemctl restart apache2
cat << EOF | sudo tee /etc/systemd/system/ttrss.service
[Unit]
Description=ttrss_backend
After=network.target
[Service]
User=www-data
ExecStart=/opt/ttrss/update_daemon2.php
[Install]
WantedBy=multi-user.target
EOF
sudo systemctl enable ttrss.service
sudo systemctl start ttrss.service
sudo firewall-cmd --add-service=http --permanent
sudo firewall-cmd --reload
sudo setenforce 0
sudo getenforce
sudo sed -i -e 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
sudo dnf -y install httpd \
php \
php-gd \
php-json \
php-mbstring \
php-xml \
php-zip \
php-curl \
unzip
wget -O grav.zip https://getgrav.org/download/core/grav-admin/1.7.37.1
unzip grav.zip
sudo mv grav-admin /opt/grav
sudo ln -s /opt/grav /var/www/html
mkdir grav-skeleton-soraarticle-blog
cd grav-skeleton-soraarticle-blog
wget -O grav-skeleton-soraarticle-blog-v1.1.2.zip https://getgrav.org/download/skeletons/soraarticle-blog/1.1.2
unzip grav-skeleton-soraarticle-blog-v1.1.2.zip
sudo cp -R * /opt/grav
cd /opt/grav/
sudo ./bin/plugin login new-user --user=admin --password=Admin123 --email=admin@localhost.localdomain --permissions=b --fullname=administrator --title=admin --language=en
sudo chown -R apache:apache /opt/grav
cat << EOF | sudo tee -a /etc/httpd/conf.d/grav.conf
<Directory /var/www/html>
Options FollowSymLinks
AllowOverride All
</Directory>
EOF
sudo systemctl restart httpd
sudo firewall-cmd --add-service=http --permanent
sudo firewall-cmd --reload
sudo setenforce 0
sudo getenforce
sudo sed -i -e 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
sudo dnf -y install httpd php php-common php-spl php-hash php-ctype php-json php-mbstring php-zip php-gd php-curl php-xml
wget http://download.dokuwiki.org/src/dokuwiki/dokuwiki-stable.tgz
sudo tar xvfz dokuwiki-stable.tgz --strip-components=1 -C /var/www/html
sudo chown -R apache:apache /var/www/html/
sudo systemctl enable httpd
sudo systemctl restart httpd
sudo apt-get update
sudo apt-get -y install \
apache2 \
php8.1 \
libapache2-mod-php8.1 \
php8.1-mbstring \
php8.1-xml
wget http://download.dokuwiki.org/src/dokuwiki/dokuwiki-stable.tgz
tar xvfz dokuwiki-stable.tgz
sudo mv dokuwiki-2* /var/www/html/dokuwiki
sudo chown -R www-data:www-data /var/www/html/dokuwiki
sudo a2enmod rewrite
sudo systemctl restart apache2
sudo apt-get -y install apache2 \
php7.4 \
libapache2-mod-php7.4 \
php7.4-gd \
php7.4-json \
php7.4-mbstring \
php7.4-xml \
php7.4-zip \
php7.4-curl \
unzip
sudo a2enmod rewrite
wget -O grav.zip https://getgrav.org/download/core/grav-admin/1.7.25
unzip grav.zip
sudo mv grav-admin /opt/grav
sudo ln -s /opt/grav /var/www/html
mkdir -p skeleton-soraarticle
cd skeleton-soraarticle
wget -O grav-skeleton-soraarticle-blog-v1.1.2.zip https://getgrav.org/download/skeletons/soraarticle-blog/1.1.2
unzip grav-skeleton-soraarticle-blog-v1.1.2.zip
sudo cp -R * /opt/grav
cd /opt/grav/
sudo ./bin/gpm install admin -y
sudo ./bin/plugin login new-user --user=admin --password=Admin123 --email=admin@localhost.localdomain --permissions=b --fullname=administrator --title=admin --language=en
sudo chown -R www-data:www-data /opt/grav
cat << EOF | sudo tee -a /etc/apache2/apache2.conf
<Directory /var/www/html>
Options Indexes FollowSymLinks
AllowOverride All
Require all granted
</Directory>
EOF
sudo systemctl restart apache2
sudo firewall-cmd --add-service=http --permanent
sudo firewall-cmd --reload
wget https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo rpm -Uvh pgdg-redhat-repo-latest.noarch.rpm
sudo dnf -qy module disable postgresql
sudo dnf -y update
sudo dnf -y install postgresql14-server postgresql14-devel postgresql14-contrib
sudo systemctl enable postgresql-14
sudo /usr/pgsql-14/bin/postgresql-14-setup initdb
echo "listen_addresses='*'" | sudo tee -a /var/lib/pgsql/14/data/postgresql.conf
sudo sed -i 's/host.*all.*all.*127.0.0.1/#host all all 127.0.0.1/g' /var/lib/pgsql/14/data/pg_hba.conf
sudo sed -i 's|^host.*all.*all.*::1/128|#host all all ::1/128|g' /var/lib/pgsql/14/data/pg_hba.conf
echo "host all all 127.0.0.1/32 password" | sudo tee -a /var/lib/pgsql/14/data/pg_hba.conf
echo "host all all ::1/128 password" | sudo tee -a /var/lib/pgsql/14/data/pg_hba.conf
echo "host all all 192.168.1.0/24 password" | sudo tee -a /var/lib/pgsql/14/data/pg_hba.confsudo systemctl start postgresql-14.service
sudo su - postgres << EOF
psql -c "
alter user postgres with password 'postgres';
create user adminer with password 'adminer';
"
psql -c "
create database adminer owner adminer encoding 'UTF8' lc_collate 'ja_JP.UTF-8' lc_ctype 'ja_JP.UTF-8' template 'template0';
"
EOFsudo dnf install -y httpd \
php \
php-pgsql \
php-mbstring \
php-common
sudo systemctl enable php-fpm
sudo systemctl enable httpd
sudo setenforce 0
sudo getenforce
sudo sed -i -e 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
sudo mkdir -p /opt/adminer
cd /opt/adminer
sudo wget https://github.com/vrana/adminer/releases/download/v4.8.1/adminer-4.8.1.php
sudo mv adminer-4.8.1.php index.php
sudo chown -R apache:apache /opt/adminer
sudo ln -s /opt/adminer /var/www/html
sudo service httpd restart
sudo firewall-cmd --add-service=http --permanent
sudo firewall-cmd --reload
wget https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo rpm -Uvh pgdg-redhat-repo-latest.noarch.rpm
sudo dnf -qy module disable postgresql
sudo dnf -y update
sudo dnf -y install postgresql13-server postgresql13-devel postgresql13-contrib
sudo systemctl enable postgresql-13
sudo /usr/pgsql-13/bin/postgresql-13-setup initdb
echo "listen_addresses='*'" | sudo tee -a /var/lib/pgsql/13/data/postgresql.conf
sudo sed -i 's/host.*all.*all.*127.0.0.1/#host all all 127.0.0.1/g' /var/lib/pgsql/13/data/pg_hba.conf
sudo sed -i 's|^host.*all.*all.*::1/128|#host all all ::1/128|g' /var/lib/pgsql/13/data/pg_hba.conf
echo "host all all 127.0.0.1/32 password" | sudo tee -a /var/lib/pgsql/13/data/pg_hba.conf
echo "host all all ::1/128 password" | sudo tee -a /var/lib/pgsql/13/data/pg_hba.conf
echo "host all all 192.168.1.0/24 password" | sudo tee -a /var/lib/pgsql/13/data/pg_hba.confsudo systemctl start postgresql-13.service
sudo su - postgres << EOF
psql -c "
alter user postgres with password 'postgres';
create user adminer with password 'adminer';
"
psql -c "
create database adminer owner adminer encoding 'UTF8' lc_collate 'ja_JP.UTF-8' lc_ctype 'ja_JP.UTF-8' template 'template0';
"
EOFsudo dnf install -y httpd \
php \
php-pgsql \
php-mbstring \
php-common
sudo systemctl enable php-fpm
sudo systemctl enable httpd
sudo setenforce 0
sudo getenforce
sudo sed -i -e 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
sudo mkdir -p /opt/adminer
cd /opt/adminer
sudo wget https://github.com/vrana/adminer/releases/download/v4.8.1/adminer-4.8.1.php
sudo mv adminer-4.8.1.php index.php
sudo chown -R apache:apache /opt/adminer
sudo ln -s /opt/adminer /var/www/html
sudo service httpd restart
sudo apt-get update
sudo apt-get -y install mariadb-server
sudo mysql -uroot -e "SET PASSWORD = PASSWORD('root'); FLUSH PRIVILEGES;"
mysql -uroot -proot -e "CREATE DATABASE mantisbt DEFAULT CHARACTER SET utf8mb4;"
mysql -uroot -proot -e "CREATE USER mantisbt@localhost IDENTIFIED BY 'mantisbt';"
mysql -uroot -proot -e "GRANT ALL PRIVILEGES ON mantisbt.* TO 'mantisbt'@'localhost';"
mysql -uroot -proot -e "FLUSH PRIVILEGES;"sudo apt-get -y install apache2 \
php7.4 \
libapache2-mod-php7.4 \
php7.4-json \
php7.4-mysql \
php7.4-pdo \
php7.4-cli \
php7.4-mbstring
wget https://sourceforge.net/projects/mantisbt/files/mantis-stable/2.25.2/mantisbt-2.25.2.tar.gz
tar xvfz mantisbt-2.25.2.tar.gz
sudo mv mantisbt-2.25.2 /opt/mantisbt
sudo chown -R www-data:www-data /opt/mantisbt
sudo ln -s /opt/mantisbt /var/www/html
sudo mkdir -p /var/mantisbt
sudo chown -R www-data:www-data /var/mantisbt
sudo systemctl restart apache2
sudo apt-get update
sudo apt-get -y install postgresql-13
echo "listen_addresses='*'" | sudo tee -a /etc/postgresql/13/main/postgresql.conf
sudo sed -i 's/host.*all.*all.*127.0.0.1/#host all all 127.0.0.1/g' /etc/postgresql/13/main/pg_hba.conf
sudo sed -i 's|^host.*all.*all.*::1/128|#host all all ::1/128|g' /etc/postgresql/13/main/pg_hba.conf
echo "host all all 127.0.0.1/32 password" | sudo tee -a /etc/postgresql/13/main/pg_hba.conf
echo "host all all ::1/128 password" | sudo tee -a /etc/postgresql/13/main/pg_hba.conf
echo "host all all 192.168.1.0/24 password" | sudo tee -a /etc/postgresql/13/main/pg_hba.confsudo systemctl restart postgresql.service
sudo su - postgres << EOF
psql -c "
alter user postgres with password 'postgres';
create user adminer with password 'adminer';
"
psql -c "
create database adminer owner adminer encoding 'UTF8' lc_collate 'ja_JP.UTF-8' lc_ctype 'ja_JP.UTF-8' template 'template0';
"
EOFsudo apt-get -y install apache2 \
libapache2-mod-php7.4 \
php7.4-pgsql \
php7.4-common \
php7.4-mbstring
sudo mkdir -p /opt/adminer
cd /opt/adminer
sudo wget https://github.com/vrana/adminer/releases/download/v4.8.1/adminer-4.8.1.php
sudo mv adminer-4.8.1.php index.php
sudo chown -R www-data:www-data /opt/adminer
sudo ln -s /opt/adminer/ /var/www/html/
sudo service apache2 restart
sudo apt-get update
sudo apt-get -y install postgresql-13
echo "listen_addresses='*'" | sudo tee -a /etc/postgresql/13/main/postgresql.conf
sudo sed -i 's/host.*all.*all.*127.0.0.1/#host all all 127.0.0.1/g' /etc/postgresql/13/main/pg_hba.conf
sudo sed -i 's|^host.*all.*all.*::1/128|#host all all ::1/128|g' /etc/postgresql/13/main/pg_hba.conf
echo "host all all 127.0.0.1/32 password" | sudo tee -a /etc/postgresql/13/main/pg_hba.conf
echo "host all all ::1/128 password" | sudo tee -a /etc/postgresql/13/main/pg_hba.conf
echo "host all all 192.168.1.0/24 password" | sudo tee -a /etc/postgresql/13/main/pg_hba.conf
sudo systemctl restart postgresql.service
sudo su - postgres << EOF
psql -c "
alter user postgres with password 'postgres';
create user nextcloud with password 'nextcloud';
"
psql -c "
create database nextcloud owner nextcloud encoding 'UTF8' lc_collate 'ja_JP.UTF-8' lc_ctype 'ja_JP.UTF-8' template 'template0';
"
EOF
sudo apt-get -y install apache2 \
php7.4 \
libapache2-mod-php7.4 \
php7.4-gd \
php7.4-json \
php7.4-pgsql \
php7.4-pdo \
php7.4-curl \
php7.4-mbstring \
php7.4-xml \
php7.4-zip \
php7.4-intl\
php7.4-imagick \
unzip
wget https://download.nextcloud.com/server/releases/nextcloud-22.1.1.zip
unzip nextcloud-22.1.1.zip
sudo mv nextcloud /opt/nextcloud
sudo chown -R www-data:www-data /opt/nextcloud
sudo ln -s /opt/nextcloud /var/www/html
cat << EOF | sudo tee -a /etc/apache2/apache2.conf
<Directory /var/www/html/nextcloud/data>
AllowOverride None
Require all denied
</Directory>
EOF
sudo sed -i 's/output_buffering = 4096/output_buffering = off/' /etc/php/7.4/apache2/php.ini
sudo sed -i 's/memory_limit = 128M/memory_limit = 1024M/' /etc/php/7.4/apache2/php.ini
cd /opt/nextcloud/core/fonts
sudo mv NotoSans-Regular.ttf NotoSans-Regular.ttf.bak
sudo wget -O NotoSansCJKjp-Regular.ttf https://github.com/minoryorg/Noto-Sans-CJK-JP/blob/master/fonts/NotoSansCJKjp-Regular.ttf?raw=true
sudo chown www-data:www-data NotoSansCJKjp-Regular.ttf
sudo ln -s NotoSansCJKjp-Regular.ttf NotoSans-Regular.ttf
sudo service apache2 restart
sudo sed -i "s/);/'allow_local_remote_servers' => true,);/" /opt/nextcloud/config/config.php
sudo service apache2 restart
sudo firewall-cmd --add-service=http --permanent
sudo firewall-cmd --reload
sudo setenforce 0
sudo getenforce
sudo sed -i -e 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
sudo dnf -y install httpd php php-common php-spl php-hash php-ctype php-json php-mbstring php-zip php-gd php-curl php-xml
wget http://download.dokuwiki.org/src/dokuwiki/dokuwiki-stable.tgz
sudo tar xvfz dokuwiki-stable.tgz --strip-components=1 -C /var/www/html
sudo chown -R apache:apache /var/www/html/
sudo systemctl enable httpd
sudo systemctl restart httpd
sudo firewall-cmd --add-service=http --permanent
sudo firewall-cmd --reload
sudo setenforce 0
sudo getenforce
sudo sed -i -e 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
sudo dnf -y install httpd php php-common php-spl php-hash php-ctype php-json php-mbstring php-zip php-gd php-curl php-xml
wget http://download.dokuwiki.org/src/dokuwiki/dokuwiki-stable.tgz
sudo tar xvfz dokuwiki-stable.tgz --strip-components=1 -C /var/www/html
sudo chown -R apache:apache /var/www/html/
sudo systemctl enable httpd
sudo systemctl restart httpd
sudo apt-get -y install apache2 \
php7.4 \
libapache2-mod-php7.4 \
php7.4-mbstring \
php7.4-xml
wget http://download.dokuwiki.org/src/dokuwiki/dokuwiki-stable.tgz
tar xvfz dokuwiki-stable.tgz
mv dokuwiki-2* dokuwiki
sudo mv dokuwiki /var/www/html
sudo chown -R www-data:www-data /var/www/html/dokuwiki
sudo systemctl restart apache2
sudo apt-get update
sudo apt-get -y install postgresql-13
echo "listen_addresses='*'" | sudo tee -a /etc/postgresql/13/main/postgresql.conf
sudo sed -i -e 's|^host.*all.*all.*127\.0\.0\.1\/32.*md5|#host all all 127.0.0.1/32 md5|' /etc/postgresql/13/main/pg_hba.conf
echo "host all all 127.0.0.1/32 password" | sudo tee -a /etc/postgresql/13/main/pg_hba.conf
echo "host all all 192.168.1.0/24 password" | sudo tee -a /etc/postgresql/13/main/pg_hba.confsudo systemctl restart postgresql.service
sudo su - postgres << EOF
psql -c "
alter user postgres with password 'postgres';
create user kanboard with password 'kanboard';
"
psql -c "
create database kanboard owner kanboard encoding 'UTF8' lc_collate 'ja_JP.UTF-8' lc_ctype 'ja_JP.UTF-8' template 'template0';
"
EOFsudo apt-get -y install apache2 \
libapache2-mod-php7.4 \
php7.4-gd \
php7.4-json \
php7.4-pgsql \
php7.4-common \
php7.4-curl \
php7.4-mbstring \
php7.4-xml \
php7.4-zip \
php7.4-intl
wget https://github.com/kanboard/kanboard/archive/v1.2.20.zip
unzip v1.2.20.zip
sudo mv kanboard* /opt/kanboard
sudo cp /opt/kanboard/config.default.php /opt/kanboard/config.php
sudo sed -i -e "s#define('DB_DRIVER', 'sqlite');#define('DB_DRIVER', 'postgres');#" /opt/kanboard/config.php
sudo sed -i -e "s#define('DB_USERNAME', 'root');#define('DB_USERNAME', 'kanboard');#" /opt/kanboard/config.php
sudo sed -i -e "s#define('DB_PASSWORD', '');#define('DB_PASSWORD', 'kanboard');#" /opt/kanboard/config.php
sudo sed -i -e "s#define('DB_HOSTNAME', 'localhost');#define('DB_HOSTNAME', '127.0.0.1');#" /opt/kanboard/config.php
sudo chown -R www-data:www-data /opt/kanboard
sudo ln -s /opt/kanboard/ /var/www/html/
sudo systemctl restart apache2
sudo firewall-cmd --add-service=http --permanent
sudo firewall-cmd --reload
sudo dnf -y install mariadb mariadb-server
sudo systemctl enable mariadb.service
sudo systemctl start mariadb.service
sudo mysql -uroot -e "SET PASSWORD = PASSWORD('root'); FLUSH PRIVILEGES;"
mysql -uroot -proot -e "CREATE DATABASE kanboard DEFAULT CHARACTER SET utf8mb4;"
mysql -uroot -proot -e "CREATE USER kanboard@localhost IDENTIFIED BY 'kanboard';"
※パスワードは適宜変更してください
mysql -uroot -proot -e "GRANT ALL PRIVILEGES ON kanboard.* TO 'kanboard'@'localhost';"
mysql -uroot -proot -e "FLUSH PRIVILEGES;"
sudo dnf install -y httpd \
php \
php-mysqlnd \
php-json \
php-opcache \
php-xml \
php-dom \
php-mbstring \
php-gd \
php-curl
sudo systemctl enable php-fpm
sudo systemctl enable httpd
sudo setenforce 0
sudo getenforce
sudo sed -i -e 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
wget https://github.com/kanboard/kanboard/archive/v1.2.20.zip
unzip v1.2.20.zip
sudo mv kanboard* /opt/kanboard
cp /opt/kanboard/config.default.php /opt/kanboard/config.php
sed -i -e "s#define('DB_DRIVER', 'sqlite');#define('DB_DRIVER', 'mysql');#" /opt/kanboard/config.php
sed -i -e "s#define('DB_USERNAME', 'root');#define('DB_USERNAME', 'kanboard');#" /opt/kanboard/config.php
sed -i -e "s#define('DB_PASSWORD', '');#define('DB_PASSWORD', 'kanboard');#" /opt/kanboard/config.php
sudo chown -R apache:apache /opt/kanboard
sudo ln -s /opt/kanboard/ /var/www/html/
sudo systemctl restart httpd
sudo firewall-cmd --add-service=http --permanent
sudo firewall-cmd --reload
sudo dnf -y install mariadb mariadb-server
sudo systemctl enable mariadb.service
sudo systemctl start mariadb.service
sudo mysql -uroot -e "SET PASSWORD = PASSWORD('root'); FLUSH PRIVILEGES;"sudo dnf install -y httpd \
php \
php-mysqlnd \
php-json \
php-opcache \
php-xml \
php-dom \
php-mbstring \
php-gd \
php-curl
sudo systemctl enable php-fpm
sudo systemctl enable httpd
sudo setenforce 0
sudo getenforce
sudo sed -i -e 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
wget https://files.phpmyadmin.net/phpMyAdmin/5.1.0/phpMyAdmin-5.1.0-all-languages.tar.gz
tar xvfz phpMyAdmin-5.1.0-all-languages.tar.gz
sudo mv phpMyAdmin*-all-languages /opt/phpmyadmin
sudo chown -R apache:apache /opt/phpmyadmin
sudo ln -s /opt/phpmyadmin /var/www/html
cat << EOF | sudo tee /etc/httpd/conf.d/phpmyadmin.conf
<Directory /var/www/html/phpmyadmin/data>
AllowOverride None
Require all denied
</Directory>
EOF
sudo service httpd restart
sudo firewall-cmd --add-service=http --permanent
sudo firewall-cmd --reload
sudo dnf -y install mariadb mariadb-server
sudo systemctl enable mariadb.service
sudo systemctl start mariadb.service
sudo mysql -uroot -e "SET PASSWORD = PASSWORD('root'); FLUSH PRIVILEGES;"
mysql -uroot -proot -e "CREATE DATABASE kanboard DEFAULT CHARACTER SET utf8mb4;"
mysql -uroot -proot -e "CREATE USER kanboard@localhost IDENTIFIED BY 'kanboard';"
mysql -uroot -proot -e "GRANT ALL PRIVILEGES ON kanboard.* TO 'kanboard'@'localhost';"
mysql -uroot -proot -e "FLUSH PRIVILEGES;"
sudo dnf install -y httpd \
php \
php-mysqlnd \
php-json \
php-opcache \
php-xml \
php-dom \
php-mbstring \
php-gd \
php-curl
sudo systemctl enable php-fpm
sudo systemctl enable httpd
sudo setenforce 0
sudo getenforce
sudo sed -i -e 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
wget https://github.com/kanboard/kanboard/archive/v1.2.18.zip
unzip v1.2.18.zip
sudo mv kanboard* /opt/kanboard
cp /opt/kanboard/config.default.php /opt/kanboard/config.php
sed -i -e "s#define('DB_DRIVER', 'sqlite');#define('DB_DRIVER', 'mysql');#" /opt/kanboard/config.php
sed -i -e "s#define('DB_USERNAME', 'root');#define('DB_USERNAME', 'kanboard');#" /opt/kanboard/config.php
sed -i -e "s#define('DB_PASSWORD', '');#define('DB_PASSWORD', 'kanboard');#" /opt/kanboard/config.php
sudo chown -R apache:apache /opt/kanboard
sudo ln -s /opt/kanboard/ /var/www/html/
sudo systemctl restart httpd
sudo localedef -i ja_JP -c -f UTF-8 -A /usr/share/locale/locale.alias ja_JP.UTF-8sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get -y install postgresql-13
echo "listen_addresses='*'" | sudo tee -a /etc/postgresql/13/main/postgresql.conf
sudo sed -i 's/host.*all.*all.*127.0.0.1/#host all all 127.0.0.1/g' /etc/postgresql/13/main/pg_hba.conf
sudo sed -i 's|^host.*all.*all.*::1/128|#host all all ::1/128|g' /etc/postgresql/13/main/pg_hba.conf
echo "host all all 127.0.0.1/32 password" | sudo tee -a /etc/postgresql/13/main/pg_hba.conf
echo "host all all ::1/128 password" | sudo tee -a /etc/postgresql/13/main/pg_hba.conf
echo "host all all 192.168.1.0/24 password" | sudo tee -a /etc/postgresql/13/main/pg_hba.conf
sudo systemctl restart postgresql.service
sudo su - postgres << EOF
psql -c "
alter user postgres with password 'postgres';
create user nextcloud with password 'nextcloud';
"
psql -c "
create database nextcloud owner nextcloud encoding 'UTF8' lc_collate 'ja_JP.UTF-8' lc_ctype 'ja_JP.UTF-8' template 'template0';
"
EOF
sudo apt-get -y install apache2 \
php7.4 \
libapache2-mod-php7.4 \
php7.4-gd \
php7.4-json \
php7.4-pgsql \
php7.4-pdo \
php7.4-curl \
php7.4-mbstring \
php7.4-xml \
php7.4-zip \
php7.4-intl\
php7.4-imagick \
php7.4-bcmath \
php7.4-gmp \
unzip
wget https://download.nextcloud.com/server/releases/nextcloud-20.0.4.zip
unzip nextcloud-20.0.4.zip
sudo mv nextcloud /opt/nextcloud
sudo chown -R www-data:www-data /opt/nextcloud
sudo ln -s /opt/nextcloud /var/www/html
cat << EOF | sudo tee -a /etc/apache2/apache2.conf
<Directory /var/www/html/nextcloud/data>
AllowOverride None
Require all denied
</Directory>
EOF
sudo sed -i 's/output_buffering = 4096/output_buffering = off/' /etc/php/7.4/apache2/php.ini
sudo sed -i 's/memory_limit = 128M/memory_limit = 1024M/' /etc/php/7.4/apache2/php.ini
cd /opt/nextcloud/core/fonts
sudo mv NotoSans-Regular.ttf NotoSans-Regular.ttf.bak
sudo wget -O NotoSansCJKjp-Regular.ttf https://github.com/minoryorg/Noto-Sans-CJK-JP/blob/master/fonts/NotoSansCJKjp-Regular.ttf?raw=true
sudo chown www-data:www-data NotoSansCJKjp-Regular.ttf
sudo ln -s NotoSansCJKjp-Regular.ttf NotoSans-Regular.ttf
sudo service apache2 restart
sudo firewall-cmd --add-service=http --permanent
sudo firewall-cmd --reload
sudo dnf -y install mariadb mariadb-server
sudo systemctl enable mariadb.service
sudo systemctl start mariadb.service
sudo mysql -uroot -e "SET PASSWORD = PASSWORD('root'); FLUSH PRIVILEGES;"
mysql -uroot -proot -e "CREATE DATABASE kanboard DEFAULT CHARACTER SET utf8mb4;"
mysql -uroot -proot -e "CREATE USER kanboard@localhost IDENTIFIED BY 'kanboard';"
mysql -uroot -proot -e "GRANT ALL PRIVILEGES ON kanboard.* TO 'kanboard'@'localhost';"
mysql -uroot -proot -e "FLUSH PRIVILEGES;"
sudo dnf install -y httpd \
php \
php-mysqlnd \
php-json \
php-opcache \
php-xml \
php-dom \
php-mbstring \
php-gd \
php-curl
sudo systemctl enable php-fpm
sudo systemctl enable httpd
sudo setenforce 0
sudo getenforce
sudo sed -i -e 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
wget https://github.com/kanboard/kanboard/archive/v1.2.16.zip
unzip v1.2.16.zip
sudo mv kanboard* /opt/kanboard
cp /opt/kanboard/config.default.php /opt/kanboard/config.php
sed -i -e "s#define('DB_DRIVER', 'sqlite');#define('DB_DRIVER', 'mysql');#" /opt/kanboard/config.php
sed -i -e "s#define('DB_USERNAME', 'root');#define('DB_USERNAME', 'kanboard');#" /opt/kanboard/config.php
sed -i -e "s#define('DB_PASSWORD', '');#define('DB_PASSWORD', 'kanboard');#" /opt/kanboard/config.php
sudo chown -R apache:apache /opt/kanboard
sudo ln -s /opt/kanboard/ /var/www/html/
sudo systemctl restart httpd