nick@Vaxis:~$ ssh artemis Linux artemis 5.10.0-28-amd64 #1 SMP Debian 5.10.209-2 (2024-01-31) x86_64 The programs included with the Debian GNU/Linux system are free software; the exact distribution terms for each program are described in the individual files in /usr/share/doc/*/copyright. Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent permitted by applicable law. Last login: Thu Nov 21 11:53:21 2024 from 136.168.38.41 nick@artemis:~$ mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A BWelcome to the MariaDB monitor. Commands end with ; or \g. BBYour MariaDB connection id is 105058 Server version: 10.3.38-MariaDB-0+deb10u1 Debian 10 BBCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. BBType 'help;' or '\h' for help. Type '\c' to clear the current input statement. BMariaDB [nick]> show grants for nclark@localhost; +---------------------------------------------------------------------------------------------------------------+ | Grants for nclark@localhost | +---------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO `nclark`@`localhost` IDENTIFIED BY PASSWORD '*5DF6028BB3B06E0021F535470DCD7E3F41512120' | | GRANT ALL PRIVILEGES ON `gamereviews`.* TO `nclark`@`localhost` | | GRANT ALL PRIVILEGES ON `nclark`.* TO `nclark`@`localhost` | +---------------------------------------------------------------------------------------------------------------+ B3 rows in set (0.000 sec) BB BMariaDB [nick]> [1]+ Stopped mysql nick@artemis:~$ cat misc/grades/3420/f24/group group_output/ groups_3420/ nick@artemis:~$ cat misc/grades/3420/f24/groups_3420/groups recipeheaven: vle hrocha agonzalezcej vfigueroa animaltierlist: montiveros bbarrios iperez gamereviews: dbenavides nclark jcornejo jsweeny tortas: mwehrmeyer eroblestena melvir cschmiedel moviebuffs: tbrown mgarris djimenezgarc teamdudes: dgutierrez dcarter smonungolh akoli datavaultpros: alittle lrojo aceballos swapspot: bruiz ggregory smahal gamblingindexorg: jpompa ipitts pluhar bams: dbaird ccontreras cmorenoyanes mdapito winnersclub: kanaya hjonasdottir nick@artemis:~$ fgs mysql MariaDB [nick]> create database if not exists `gamereviews`; BQuery OK, 0 rows affected, 1 warning (0.000 sec) BB BMariaDB [nick]> show warnings; +-------+------+------------------------------------------------------+ | Level | Code | Message | +-------+------+------------------------------------------------------+ | Note | 1007 | Can't create database 'gamereviews'; database exists | +-------+------+------------------------------------------------------+ B1 row in set (0.000 sec) BB BMariaDB [nick]> exit BBye Bnick@artemis:~$ cd scripts nick@artemis:~/scripts$ ls -l total 44 -rw-r--r-- 1 nick nick 2430 Nov 13 13:46 add_pw.php -rwxr-xr-x 1 nick nick 409 Apr 22 2024 backitup.sh -rw-r--r-- 1 nick nick 23325 Oct 21 13:12 companyf24_2024-10-21_13-12-15.dump.sql -rwxr-xr-x 1 nick nick 2016 Mar 4 2024 insertgenerator_v2.py -rw-r--r-- 1 nick nick 497 Nov 21 13:06 recreate_db.sql -rw-r--r-- 1 nick nick 2355 Apr 24 2024 update_pw.php nick@artemis:~/scripts$ mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A BWelcome to the MariaDB monitor. Commands end with ; or \g. BBYour MariaDB connection id is 105066 Server version: 10.3.38-MariaDB-0+deb10u1 Debian 10 BBCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. BBType 'help;' or '\h' for help. Type '\c' to clear the current input statement. BMariaDB [nick]> source recreate_db.sql; BQuery OK, 0 rows affected, 1 warning (0.000 sec) BB BBQuery OK, 0 rows affected, 1 warning (0.000 sec) BB BBQuery OK, 0 rows affected, 1 warning (0.000 sec) BB BBQuery OK, 0 rows affected, 1 warning (0.000 sec) BB BBQuery OK, 0 rows affected, 1 warning (0.000 sec) BB BBQuery OK, 0 rows affected, 1 warning (0.000 sec) BB BBQuery OK, 0 rows affected, 1 warning (0.000 sec) BB BBQuery OK, 0 rows affected, 1 warning (0.000 sec) BB BBQuery OK, 0 rows affected, 1 warning (0.000 sec) BB BBQuery OK, 0 rows affected, 1 warning (0.000 sec) BB BBQuery OK, 0 rows affected, 1 warning (0.000 sec) BB BMariaDB [nick]> exit BBye Bnick@artemis:~/scripts$ mysql < recreate_db.sql nick@artemis:~/scripts$ vim recreate_db.sql 4;2m"recreate_db.sql" [noeol][dos] 11L, 497B▽ zzm cWelcome back, Toothmangcreate database if not exists `recipeheaven`; create database if not exists `animaltierlist`;create database if not exists `gamereviews`;create database if not exists `tortas`; create database if not exists `moviebuffs`; create database if not exists `teamdudes`; create database if not exists `datavaultpros`; create database if not exists `swapspot`; create database if not exists `gamblingindexorg`; create database if not exists `bams`; create database if not exists `winnersclub`; 4;m"recreate_db.sql"/[dos]113L,F524B/written: 200hu2/11 1h 3/12 2hd4/13 3hi5/14 4hd6/15 5h 7/16 6hi8/17 7ht9/18 8h!20/19~9h"1/20 Ah;2/21 Bh^[ 1/Ah::x ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ [1] Toothmang ~/scripts/recreate_db.sql Type=SQL Line: 1 Column: 1/45 Byte: 1h 9%p$ Line: 1 Column: 45/45 Byte: 2DhG Line: 11 Column: 1/44 Byte: 1C6h 100%$ 44/F1ha -- INSERT --5/2h[+]2 1/0 4h3 6hs2/1 7he3/2 8hl4/3 9he5/4 Ahc6/5 Bh Adios, Cowboy 4;mnick@artemis:~/scripts$ mysqle exit BBye Bnick@artemis:~/scripts$ crontab -e 4;2m"/tmp/crontab.kxXuwE/crontab" 28L, 1031B▽ zzm cWelcome back, Toothmang# Edit this file to introduce tasks to be run by cron. # # Each task to run has to be defined through a single line# indicating with different fields when the task will be run # and what command to run for the task # # To define the time you can provide concrete values for # minute (m), hour (h), day of month (dom), month (mon), # and day of week (dow) or use '*' in these fields (for 'any'). # # Notice that tasks will be started based on the cron's system # daemon's notion of time and timezones. # # Output of the crontab jobs (including errors) is sent through # email to the user the crontab file belongs to (unless redirected). # # For example, you can run a backup of all your user accounts # at 5 a.m every week with: # 0 5 * * 1 tar -zcf /var/backups/home.tgz /home/ # # For more information see the manual pages of crontab(5) and cron(8) # # m h dom mon dow command #*/5 * * * * cd /home/fac/nick/backups ; ./backitup.sh 55 23 * * * cd /home/fac/nick/backups/all ; ./all.sh #55 23 * * * ./backitup.sh nick [1] Toothmang /tmp/crontab.kxXuwE/crontab Type=CRONTAB Line: 1 Column: 1/54 Byte: 1h 3%p$ Line: 1 Column: 54/54 Byte: 36h~@k ~@k 2 2/2 9h 7%~@k Line: 3 Column: 58/58 Byte: 74h 10%~@k 4 60/60 Byte: B1h 14%~@k 5 38/38 Byte: D8h 17%~@k 6 2/2 Bh 21%~@k Line: 7 Column: 56/56 Byte: 114h 25%~@k 8 4Dh 28%~@k 9 63/63 8Dh 32%~@k Line: 10 2/2 90h 35%~@k 1 62/62CFh 39%~@k 2 40/40 F8h 42%~@k 3 2/2 Bh 46%~@k 2 40/40 8h 42%~@k 1 62/62 CFh 39%~@k 2 40/40 F8h 42%~@k 3 2/2 Bh 46%~@k 4 63/63 Byte: 23Bh 50%~@k 5 8/68 80h 53%~@k 6 2/2 3h 57%~@k 7 61/61 C1h 60%~@k 8 27/27 DDh 64%~@k 9 49/49 Byte: 30Fh 67%~@k 20 2/2 12h 71%~@k ()1 69/69 58h 75%~@k (8)2 2/2 Bh 78%~@k 3 28/28 78h 82%~@k 4 54/54 AFh 85%~@k 5 0-1/0 B1h 89%~@k 6 52/52 E5h 92%~@k 7 0-1/0 7h 96%~@k Line: 28 Column: 31/31 Byte: 406h 100%~@k ~@k ~@k ~@k Line: 27 Column: 0-1/0 Byte: 3E7h 96%~@k 6 52/52 5h 92%~@k 5 0-1/0 B1h 89%~@k 6 52/52 E5h 92%a -- INSERT --3/6h[+]7 1/0 7h 93%8 8h*2/1 9h/3/2 Ah14/3 Bh55/4 Ch6/5 Dh*7/6 Eh8/7 Fh*9/8 F0h10/9 1h*11/10 2h2/11 3h*3/12 4h4/13 5hc5/14 6hd6/15 7h 7/16 8hs8/17 9hc9/18 Ahe20/19 Bhr1/20 Chi2/21 Dhp3/22 Eht4/23 Fh3/22 Eh2/21 Dh1/20 Ch0/19 Bh19/18 Ahr20/19 Bhi1/20 Chp2/21 Dht3/22 Ehs4/23 Fh 5/24 Byte: 400h;6/25 1h 7/26 2hm8/27 3hy9/28 4hs30/29 5hq1/30 6hl2/31 7h 3/32 8h<4/33 9h 5/34 Ahr6/35 Bhe7/36 Chc8/37 Dhr9/38 Ehe40/39 Fha1/40 10ht2/41 1he3/42 2h_4/43 3hd5/44 4hb6/45 5h.7/46 6hs8/47 7hq9/48 8hl50/49 9h 9 1/0 Ah 96% 4;m"crontab.kxXuwE/crontab"n30L,i1082B0written: 32/31 Byte: 43Ah 100% Line: 29 Column: 1/0 Byte: 41Ah 96%8 50/49 9h 93%^[ 49/8h::x Adios, Cowboy 4;mcrontab: installing new crontab nick@artemis:~/scripts$ crontab -e 4;2m"/tmp/crontab.p7PInQ/crontab" 30L, 1082B▽ zzm cWelcome back, Toothmang# Edit this file to introduce tasks to be run by cron. # # Each task to run has to be defined through a single line# indicating with different fields when the task will be run # and what command to run for the task # # To define the time you can provide concrete values for # minute (m), hour (h), day of month (dom), month (mon), # and day of week (dow) or use '*' in these fields (for 'any'). # # Notice that tasks will be started based on the cron's system # daemon's notion of time and timezones. # # Output of the crontab jobs (including errors) is sent through # email to the user the crontab file belongs to (unless redirected). # # For example, you can run a backup of all your user accounts # at 5 a.m every week with: # 0 5 * * 1 tar -zcf /var/backups/home.tgz /home/ # # For more information see the manual pages of crontab(5) and cron(8) # # m h dom mon dow command #*/5 * * * * cd /home/fac/nick/backups ; ./backitup.sh 55 23 * * * cd /home/fac/nick/backups/all ; ./all.sh */15 * * * * cd scripts ; mysql < recreate_db.sql 4;mos,oCowboy /tmp/crontab.p7PInQ/crontab Type=CRONTAB Line: 1 Column: 1/54 Byte: 1h 3%p~@k Line: 2 Column: 1/2 Byte: 38h 6%~@k Line: 3 Column: 1/58 Byte: 3Bh 10%~@k 4 60 Byte: 76h 13%~@k 5 38 Byte: B3h 16%~@k 6 1/2 Byte: DAh 20%~@k 7 1/56 Dh 23%~@k Line: 8 Column: 1/56 Byte: 116h 26%~@k 9 63 4Fh 30%~@k Line: 10 1/2 8F3%~@k 1 1/6292h 36%~@k 2 40 D1h 40%~@k 3 1/2 FAh 43%~@k 4 1/63 Dh 46%~@k 5 8 Byte: 23Dh 50%~@k 6 1/2 82h 53%~@k 7 1/61 5h 56%~@k 8 27 C3h 60%~@k 9 49 DFh 63%~@k 20 1/2 Byte: 311h 66%~@k 1 1/69 4h 70%~@k 2 1/2 5Ah 73%~@k 3 1/28 Dh 76%~@k 4 54 7Ah 80%~@k 5 0-1/0 B1h 83%~@k 6 1/52 2h 86%^[ ::x 4;mNo modification made nick@artemis:~/scripts$ cd https://artemis.cs.csub.edu/~nick/3420/movies/fetch.php3420/movies/fetch.php nick@artemis:~$ curl https://artemis.cs.csub.edu/~nick/3420/movies/fetch.php?movietitle=Akira [{"movieId":"1274","title":"Akira (1988)","year":"1988","genres":"Action|Adventure|Animation|Sci-Fi"},{"movieId":"6270","title":"Akira Kurosawa's Dreams (Dreams) (1990)","year":"1990","genres":"Drama|Fantasy"}]nick@artemis:~$ nick@artemis:~$ https://artemis.cs.csub.edu/~nick/3420/movies/fetch.phpmis.cs.csub.edu/~nick/3420/movies/fetch.php [{"movieId":"1274","title":"Akira (1988)","year":"1988","genres":"Action|Adventure|Animation|Sci-Fi"},{"movieId":"6270","title":"Akira Kurosawa's Dreams (Dreams) (1990)","year":"1990","genres":"Drama|Fantasy"}]nick@artemis:~$ nick@artemis:~$ nick@artemis:~$ cd public_html/3420/movies nick@artemis:~/public_html/3420/movies$ mv .notyet/movie.php . nick@artemis:~/public_html/3420/movies$ exit logout Connection to artemis.cs.csub.edu closed. nick@Vaxis:~$ exit exit