Differences

This shows you the differences between two versions of the page.

--- computers:truenas:famp [25-Oct-2021 11:38] – [Create a Database for your Web Site] Steve Joynt
+++ computers:truenas:famp [02-Feb-2025 16:14] (current) – external edit 127.0.0.1
@@ Line 23: / Line 23: @@
 DNS_IP="${GATEWAY_IP:?}"       # IP address of your DNS server (usually the same as the internet gateway)
 PHP_VER="74"                   # Which version of PHP you want to install (for PHP v7.4 specify "74")
 </code>
-. Delete any old jail with the same name - e.g. if you're setting this same jail up again. Most people do not need to perform this step. Be careful you don't delete a jail that you still want to keep!
+. Delete any old jail with the same name - e.g. if you're setting this same jail up again. Most people do not need to perform this step. **Be careful you don't delete a jail that you still want to keep!**
 <code>
 iocage destroy --force "${JAIL_NAME:?}"
 </code>
@@ Line 44: / Line 46: @@
   defaultrouter6=none \
   resolver="nameserver ${DNS_IP:?}"
 </code>
@@ Line 50: / Line 53: @@
 jexec "ioc-${JAIL_NAME:?}" /bin/sh -c \
   "echo \"${LAN_IP:?}  ${DOMAIN_NAME:?}  ${DOMAIN_NAME%%.*}\" >> /etc/hosts"
 </code>
@@ Line 56: / Line 60: @@
 jexec "ioc-${JAIL_NAME:?}" \
   pkg update
 </code>
@@ Line 65: / Line 70: @@
   -j "ioc-${JAIL_NAME:?}" \
   -install apache24
 </code>
@@ Line 71: / Line 77: @@
 jexec "ioc-${JAIL_NAME:?}" /bin/sh -c \
   "echo \"ServerName ${DOMAIN_NAME:?}\" >> /usr/local/etc/apache24/httpd.conf"
 </code>
@@ Line 77: / Line 84: @@
 jexec "ioc-${JAIL_NAME:?}" \
   sysrc apache24_enable=YES
 </code>
@@ Line 83: / Line 91: @@
 jexec "ioc-${JAIL_NAME:?}" \
   service apache24 start
 </code>
@@ Line 92: / Line 101: @@
   -j "ioc-${JAIL_NAME:?}" \
   install mysql80-client mysql80-server
 </code>
@@ Line 98: / Line 108: @@
 jexec "ioc-${JAIL_NAME:?}" \
   sysrc mysql_enable=YES
 </code>
@@ Line 104: / Line 115: @@
 jexec "ioc-${JAIL_NAME:?}" \
   service mysql-server start
 </code>
@@ Line 109: / Line 121: @@
 <code>
 echo "M${RANDOM}y${RANDOM}S${RANDOM}Q${RANDOM}L"
 </code>
@@ Line 115: / Line 128: @@
 jexec "ioc-${JAIL_NAME:?}" \
   mysql_secure_installation
 </code>
@@ Line 128: / Line 142: @@
 jexec "ioc-${JAIL_NAME:?}" \
   mysql_config_editor set --host=localhost --user=root --password
 </code>
 Use the random password generated at step 4.
@@ Line 158: / Line 173: @@
     php${PHP_VER:?}-pecl-redis      \
     php${PHP_VER:?}-SimpleXML
 </code>
@@ Line 164: / Line 180: @@
 jexec "ioc-${JAIL_NAME:?}" \
   cp /usr/local/etc/php.ini-production /usr/local/etc/php.ini
 </code>
 You may want to amend the configuration manually
@@ Line 169: / Line 186: @@
 jexec "ioc-${JAIL_NAME:?}" \
   vi /usr/local/etc/php.ini
 </code>
@@ Line 186: / Line 204: @@
 </IfModule>
 END
 </code>
@@ Line 192: / Line 211: @@
 jexec "ioc-${JAIL_NAME:?}" \
   apachectl configtest
 </code>
@@ Line 198: / Line 218: @@
 jexec "ioc-${JAIL_NAME:?}" \
   apachectl restart
 </code>
@@ Line 208: / Line 229: @@
 DB_PASS="M${RANDOM}y${RANDOM}S${RANDOM}Q${RANDOM}L"
 set | grep "^DB_"
 </code>
 Make a note of this information. You'll need to configure your web site with the same details.
@@ Line 215: / Line 237: @@
 echo "CREATE USER '${DB_USER:?}'@'localhost' IDENTIFIED BY '${DB_PASS:?}' ;" \
 | jexec "ioc-${JAIL_NAME:?}" mysql
 </code>
@@ Line 221: / Line 244: @@
 echo "CREATE DATABASE \`${DB_NAME:?}\` CHARACTER SET utf8 COLLATE utf8_unicode_ci ;" \
 | jexec "ioc-${JAIL_NAME:?}" mysql
 </code>
@@ Line 227: / Line 251: @@
 echo "GRANT ALL ON ${DB_NAME:?}.* TO '${DB_USER:?}'@'localhost' ;" \
 | jexec "ioc-${JAIL_NAME:?}" mysql
 </code>
@@ Line 235: / Line 260: @@
 jexec "ioc-${JAIL_NAME:?}" \
   ln -s /usr/local/www/apache24/data /www
 </code>
@@ Line 240: / Line 266: @@
 <code>
 cd /mnt/*/iocage/jails/${JAIL_NAME:?}/root/www
 </code>