Differences

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

--- unraid:dockers:tomcat [2021/11/27 09:44] – [App Settings] dirk
+++ unraid:dockers:tomcat [2023/08/20 20:14] (current) – [Add football season] dirk
@@ Line 23: / Line 23: @@
 ===== App Settings =====
   * Use similar steps used in VM setup to complete mysql linking etc.
-    * Install Java / Mysql connector<code> sudo apt-get install libmysql-java</code>
+    * Install Java / Mysql connector<code>apt-get install libmysql-java</code>
     * Note: This was not supported in 20.04 at the time and must be installed manually.
       * Download JDBC Driver for Mysql (Connector/J) from https://www.mysql.com/products/connector/
-      * Install the debfile:<code>sudo apt install thatdebfile.deb</code>
+      * ssh into docker:<code>docker exec -it football bash</code>
-    * Create symlink for connector<code>sudo ln -sf /usr/share/java/mysql-connector-java.8.0.27.jar /usr/local/tomcat/lib/mysql-connector-java.jar</code>
+      * Use "cat /etc/os-release" to check what version docker is running
-    * If webinf files need to be compiled:<code>sudo javac -cp /usr/local/tomcat/lib/servlet-api.jar:/usr/local/tomcat/lib/jsp-api.jar util/*.java</code>
+      * Install the debfile:<code>dpkg -i thatdebfile.deb</code>
+    * Create symlink for connector<code>ln -sf /usr/share/java/mysql-connector-java.8.0.27.jar /usr/local/tomcat/lib/mysql-connector-java.jar</code>
+    * In reality, all you need are the .jar files and keep them in the appdata somewhere mapped... then just symlink those into the /usr/local/tomcat/lib/ folder<code>ln -sf /usr/local/tomcat/webapps/jar/mysql-connector-java.X.X.XX.jar /usr/local/tomcat/lib/mysql-connector-java.jar
+ln -sf /usr/local/tomcat/webapps/jar/javax.mail.jar /usr/local/tomcat/lib/javax.mail.jar
+etc</code>
+    * If webinf files need to be compiled:<code>javac -cp /usr/local/tomcat/lib/servlet-api.jar:/usr/local/tomcat/lib/jsp-api.jar:/usr/local/tomcat/lib/javax.activation.jar:/usr/local/tomcat/lib/javax.mail.jar webapps/ROOT/WEB-INF/classes/util/*.java</code>
     * Note: this step is different from Tomcat v9 in VM because paths are different.
     * Note2: MUST CHANGE import javax.servlet.* to import jakarta.servlet.* in all the .java files under the WEB-INF folder before compiling with above.
     * Restart
+==== Add football season ====
+<code>docker cp /mnt/user/backup/webpage/mysql/2023o.csv mysql:/var/lib/mysql-files/</code>
+<code>mysql --local-infile=1 -uUSERNAME -p
+use DB;
+LOAD DATA LOCAL INFILE "2023o.csv" INTO TABLE games_nfl COLUMNS TERMINATED BY ',';
+UPDATE games_nfl SET vscore = NULL where year = 2023;
+UPDATE games_nfl SET hscore = NULL where year = 2023;</code>

brimble.com

User Tools

Site Tools

Differences

Page Tools