Differences

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

--- linux:slack_4app [2025/01/12 13:20] – [Apache (web server) Setup] azman
+++ linux:slack_4app [2025/01/12 13:40] (current) – azman
@@ Line 40: / Line 40: @@
   * start daemon ''rc.mysqld''
   * run <code>/usr/bin/mysql_secure_installation</code>
+  * create specific database for specific app <code>create database app_db;</code>
+  * create specific user for specific app and grant all access <code>grant all privileges on app_db.* to 'user_app'@'localhost' identified by 'pass_app';</code>
+  * just formality, run <code>flush privileges;</code>
+  * to additionally create specific user for specific app <code>create user 'user_app'@'localhost' identified by 'pass_app';</code>
+  * recover root password:
+  * stop daemon ''rc.mysqld''
+  * run <code>
+# mysqld_safe --skip-grant-tables &
+# mysql -u root
+$ mysql -uroot -p
+mysql> use mysql;
+mysql> update user set password=PASSWORD('<newpass>') where User='root';
+mysql> flush privileges;
+mysql> exit
+</code>
+Backup a DB:<code>mysqldump -p -u user userdb > userapp-$(date +%Y%m%d%H%M%S).sql</code>
+===== TeXLive Install/Setup =====
+The default tetex is usable, but it is no longer maintained and some new packages are not available.
+{{page>linux:app_texlive&noheader}}
+===== rsync server =====
+  * create ''rsyncd.conf'' in etc <file text rsync.conf>
+max connections = 2
+log file = /var/log/rsync.log
+timeout = 300
+[share]
+comment = Shared Stuff
+path = /home/share
+read only = yes
+list = yes
+hosts allow = 192.168.3.0/24
+uid = nobody
+gid = nobody
+#auth users = pub
+#secrets file = etc/rsyncd.secrets
+</file>
+    * modify subnet mask address for host allow accordingly
+  * in ''inetd.conf'' (etc), insert <code>rsync	stream	tcp	nowait	root	/usr/bin/rsync	rsync --daemon</code>
+  * in ''services'' (etc), insert <code>rsync	873/tcp</code>
+  * create ''rsyncd.secrets'' in etc <file text rsyncd.secrets>
+pub:pub
+</file>
+  * start rsync daemon<code>/usr/bin/rsync --daemon --config=etc/rsyncd.conf</code>
+===== Steam on Slack64 (in chroot32) =====
+on an x86_64 machine,
+  * install libtxc_dxtn package from slackbuilds.org (64-bit)
+  * use 'slackroot' to create 32-bit chroot environment (chroot32)
+    * target for desktop
+  * ssh into localhost to enter chroot32 as normal user
+    * remember to run 'preproot' (as root) prior to that
+    * ... and 'preproot --release' when done
+  * install packages
+    * install alien_bob's steamclient package
+    * install libtxc_dxtn package from slackbuilds.org (32-bit)
+  * run 'linux32' to create an official 32-bit environment
+  * run 'steam -tcp'