Changeset 32749 for other-projects
- Timestamp:
- 2019-02-07T16:18:35+13:00 (5 years ago)
- Location:
- other-projects/the-macronizer/trunk/src
- Files:
-
- 4 edited
Legend:
- Unmodified
- Added
- Removed
-
other-projects/the-macronizer/trunk/src/java/util/MacroniserLogFileProcessor.java
r32745 r32749 58 58 59 59 sqlAccess.makeConnection(); 60 61 System.out.println("Sending " + extractedEntries.size() + " entries to DB..."); 60 62 61 63 //loop through all entries -
other-projects/the-macronizer/trunk/src/java/util/MySQLAccess.java
r32746 r32749 60 60 private String PASSWORD; //= "pinky"; 61 61 62 private final String PROPS_FILENAME = " mysql.properties"; // set to "properties/mysql.properties" for IntelliJ62 private final String PROPS_FILENAME = "classes/mysql.properties"; // set to "classes/mysql.properties" for IntelliJ 63 63 64 64 //Makes a connection to the server -
other-projects/the-macronizer/trunk/src/scripts-and-sql/cron.txt
r32747 r32749 23 23 24 24 #* 0 * * * /PATH/TO/macronLogToDB.bash > /dev/null 25 26 ## Stdout goes to the .out file and stderr will go to an .err file 25 27 * 0 * * * /PATH/TO/macronLogToDB.bash > /PATH/TO/macronLogToDB.out 26 28 -
other-projects/the-macronizer/trunk/src/scripts-and-sql/macronLogToDB.bash
r32747 r32749 18 18 19 19 ################################### 20 macronlogs_folder=/home/wjkw1/comp520/MacroniserLogs/tmp /#/home/wjkw1/comp520/MacroniserLogs/logs #/Scratch/wjkw1/macron-restoration/web/logs20 macronlogs_folder=/home/wjkw1/comp520/MacroniserLogs/tmp #/home/wjkw1/comp520/MacroniserLogs/logs #/Scratch/wjkw1/macron-restoration/web/logs 21 21 #macronLogToDBjar= 22 22 exec_folder=/home/wjkw1/IdeaProjects/LogFileExtraction/out/production/LogFileExtraction … … 26 26 [email protected] #[email protected] 27 27 jars_folder=/Scratch/wjkw1/mysql-connector-java-8.0.14 #/Scratch/wjkw1/macron-restoration/web/WEB-INF/lib 28 mysqlprops_folder=/Scratch/wjkw1/ properties #/Scratch/wjkw1/macron-restoration/web/WEB-INF/classes28 mysqlprops_folder=/Scratch/wjkw1/classes #/Scratch/wjkw1/macron-restoration/web/WEB-INF/classes 29 29 30 echo "HELLO WORLD" 30 echo "" 31 echo "In script $0 to process macron.log.* files" 32 echo " Note that any logfile named exactly 'macron.log' (instead of matching macron.log.*) will not be processed" 31 33 32 34 # get rid of any old error files … … 43 45 mkdir -p $reprocess_folder 44 46 45 pushd $macronlogs_folder > /dev/null 47 46 48 # "Bash does carry out filename expansion [1] -- a process known as globbing" 47 49 # https://www.tldp.org/LDP/abs/html/globbingref.html … … 50 52 # Correct glob use: 51 53 # Always use for-loop, prefix glob, check if exists file. 52 for logfile in ./macron.log.* ; do # Use ./* ... NEVER bare *53 if [ -e "$logfile" ] ; then # Check whether file exists.54 echo "****** $0 scriptprocessing $logfile"54 for logfile in $macronlogs_folder/macron.log.* ; do # Use ./* ... NEVER bare * [EDIT: if in current folder?] 55 if [ -e "$logfile" ] ; then # Check whether file exists. 56 echo "****** processing $logfile" 55 57 56 58 # https://askubuntu.com/questions/625224/how-to-redirect-stderr-to-a-file 57 59 58 # this works: java -cp /Scratch/wjkw1/mysql-connector-java-8.0.14/mysql-connector-java-8.0.14.jar:/Scratch/wjkw1/properties/mysql.properties:. util.MacroniserLogFileProcessor /home/wjkw1/comp520/MacroniserLogs/tmp/macron.log59 #java -cp $jars_folder/mysql-connector-java-8.0.14.jar:$mysqlprops_folder:. util.MacroniserLogFileProcessor $logfile > /dev/null 2>> $errfile60 61 echo "java -cp $exec_folder:$jars_folder/mysql-connector-java-8.0.14.jar:$mysqlprops_folder:. util.MacroniserLogFileProcessor $logfile > /dev/null 2>> $errfile"62 java -cp $exec_folder:$jars_folder/mysql-connector-java-8.0.14.jar:$mysqlprops_folder:. util.MacroniserLogFileProcessor $logfile63 60 echo "Running command:" 61 echo " java -cp .:$exec_folder:$jars_folder/mysql-connector-java-8.0.14.jar:$mysqlprops_folder util.MacroniserLogFileProcessor $logfile 2>> $errfile" 62 echo "" 63 java -cp .:$exec_folder:$jars_folder/mysql-connector-java-8.0.14.jar:$mysqlprops_folder util.MacroniserLogFileProcessor $logfile 2>> $errfile 64 65 64 66 # The above returns 0 on success, -1 on failure 65 67 # if 0, then move $logfile to processed_folder … … 82 84 # Correct glob use: 83 85 # Always use for-loop, prefix glob, check if exists file. 84 for file in ./macron.log.* ; do # Use ./* ... NEVER bare *85 if [ -e "$file" ] ; then # Check whether file exists.86 echo "$file"87 fi88 done86 #for file in ./macron.log.* ; do # Use ./* ... NEVER bare * 87 # if [ -e "$file" ] ; then # Check whether file exists. 88 # echo "$file" 89 # fi 90 #done 89 91 90 echo "GOODBYE" 92 echo "Finished processing macron.log.* files" 93 echo "" 91 94 92 95 # If error file exists and has non-zero size, send email … … 102 105 fi 103 106 104 popd105 107 106 108 # Cronjob: https://stackoverflow.com/questions/8938120/how-to-run-cron-once-daily-at-10pm
Note:
See TracChangeset
for help on using the changeset viewer.