search

opencats / OpenCATS

Applicant Tracking System (maintained code base)
http://www.opencats.org
Other
535 stars 246 forks source link

Resumes not uploading #558

Open ronswift2 opened 2 years ago

ronswift2 commented 2 years ago

Expected behavior and actual behavior.

When applicant applies for a position or staff uploads a candidate resume it is not added to the candidates file

Steps to reproduce the problem.

When applying for any position the resume is not uploaded and the website goes offline.

What version of opencats are you running?

V 0.9.6

Release or downloaded from Git? I restored database and attachments folder contents from v 0.9.3

Downloaded from Git

WAMP or LAMP?

LAMP

What version of PHP and MySQL are you running

php 7.4.2 mariadb 10.3.32

attach appropriate error logs. Please attach [apache/mysql] error/access logs as needed.

tail /var/log/apache2/access.log 69.162.124.229 - - [29/Dec/2021:00:00:06 +0000] "GET / HTTP/1.1" 404 468 "http://careers2.swiftstaffing.com" "Mozilla/5.0+(compatible; UptimeRobot/2.0; http://www.uptimerobot.com/)" 109.248.6.41 - - [29/Dec/2021:00:03:47 +0000] "GET / HTTP/1.0" 404 454 "-" "masscan-ng/1.3 (https://github.com/bi-zone/masscan-ng)" 69.162.124.229 - - [29/Dec/2021:00:05:06 +0000] "GET / HTTP/1.1" 404 468 "http://careers2.swiftstaffing.com" "Mozilla/5.0+(compatible; UptimeRobot/2.0; http://www.uptimerobot.com/)" 69.162.124.229 - - [29/Dec/2021:00:10:06 +0000] "GET / HTTP/1.1" 404 468 "http://careers2.swiftstaffing.com" "Mozilla/5.0+(compatible; UptimeRobot/2.0; http://www.uptimerobot.com/)" 69.162.124.229 - - [29/Dec/2021:00:15:06 +0000] "GET / HTTP/1.1" 404 468 "http://careers2.swiftstaffing.com" "Mozilla/5.0+(compatible; UptimeRobot/2.0; http://www.uptimerobot.com/)" 69.162.124.229 - - [29/Dec/2021:00:20:06 +0000] "GET / HTTP/1.1" 404 468 "http://careers2.swiftstaffing.com" "Mozilla/5.0+(compatible; UptimeRobot/2.0; http://www.uptimerobot.com/)" 114.119.158.34 - - [29/Dec/2021:00:22:26 +0000] "GET /robots.txt HTTP/1.1" 404 505 "-" "Mozilla/5.0 (compatible;PetalBot;+https://webmaster.petalsearch.com/site/petalbot)" 69.162.124.229 - - [29/Dec/2021:00:25:06 +0000] "GET / HTTP/1.1" 404 468 "http://careers2.swiftstaffing.com" "Mozilla/5.0+(compatible; UptimeRobot/2.0; http://www.uptimerobot.com/)" 69.162.124.229 - - [29/Dec/2021:00:30:06 +0000] "GET / HTTP/1.1" 404 468 "http://careers2.swiftstaffing.com" "Mozilla/5.0+(compatible; UptimeRobot/2.0; http://www.uptimerobot.com/)" 69.162.124.229 - - [29/Dec/2021:00:35:06 +0000] "GET / HTTP/1.1" 404 468 "http://careers2.swiftstaffing.com" "Mozilla/5.0+(compatible; UptimeRobot/2.0; http://www.uptimerobot.com/)"

tail /var/log/apache2/error.log PHP Warning: Module 'PDO' already loaded in Unknown on line 0 PHP Warning: Module 'pdo_mysql' already loaded in Unknown on line 0 [Wed Dec 29 00:00:02.275891 2021] [mpm_prefork:notice] [pid 26890] AH00163: Apache/2.4.41 (Ubuntu) OpenSSL/1.1.1f configured -- resuming normal operations [Wed Dec 29 00:00:02.275901 2021] [core:notice] [pid 26890] AH00094: Command line: '/usr/sbin/apache2'

File permissions drwxrwx--- 3 www-data www-data 4096 Dec 24 20:30 upload drwxrwx--- 4 www-data www-data 4096 Dec 20 16:05 attachments drwxrwxr-x 2 www-data www-data 4096 Dec 17 17:05 scripts -rw-rw-r-- 1 www-data www-data 154692 Dec 13 22:42 composer.lock drwxr-xr-x 24 www-data www-data 4096 Dec 13 22:42 vendor -rwxr-xr-x 1 root root 2291189 Dec 13 22:01 composer.phar -rw-r--r-- 1 www-data www-data 104 Dec 13 21:19 INSTALL_BLOCK -rwxr-xr-x 1 www-data www-data 16536 Dec 13 21:19 config.php -rw-rw-r-- 1 www-data www-data 65537 Nov 10 09:10 CHANGELOG.MD -rwxr-xr-x 1 www-data www-data 328 Nov 10 09:10 Error.tpl -rw-rw-r-- 1 www-data www-data 43229 Nov 10 09:10 LICENSE.md -rwxr-xr-x 1 www-data www-data 3824 Nov 10 09:10 QueueCLI.php -rw-rw-r-- 1 www-data www-data 1775 Nov 10 09:10 README.md drwxrwxr-x 2 www-data www-data 4096 Nov 10 09:10 ajax -rw-rw-r-- 1 www-data www-data 3610 Nov 10 09:10 ajax.php drwxrwxr-x 2 www-data www-data 4096 Nov 10 09:10 careers -rwxr-xr-x 1 www-data www-data 2916 Nov 10 09:10 careersPage.css drwxrwxr-x 2 www-data www-data 4096 Nov 10 09:10 ci -rw-rw-r-- 1 www-data www-data 528 Nov 10 09:10 composer.json -rw-rw-r-- 1 www-data www-data 10530 Nov 10 09:10 constants.php drwxrwxr-x 2 www-data www-data 4096 Nov 10 09:10 db drwxrwxr-x 2 www-data www-data 4096 Nov 10 09:10 docker -rwxr-xr-x 1 www-data www-data 1041 Nov 10 09:10 ie.css drwxrwxr-x 11 www-data www-data 12288 Nov 10 09:10 images -rw-rw-r-- 1 www-data www-data 8722 Nov 10 09:10 index.php -rwxr-xr-x 1 www-data www-data 5666 Nov 10 09:10 installtest.php -rwxr-xr-x 1 www-data www-data 48808 Nov 10 09:10 installwizard.php -rw-rw-r-- 1 www-data www-data 333 Nov 10 09:10 issue_template.md drwxrwxr-x 3 www-data www-data 4096 Nov 10 09:10 js drwxrwxr-x 7 www-data www-data 4096 Nov 10 09:10 lib -rwxr-xr-x 1 www-data www-data 25716 Nov 10 09:10 main.css drwxrwxr-x 25 www-data www-data 4096 Nov 10 09:10 modules -rwxr-xr-x 1 www-data www-data 1069 Nov 10 09:10 not-ie.css drwxrwxr-x 3 www-data www-data 4096 Nov 10 09:10 optional-updates -rw-rw-r-- 1 www-data www-data 2310 Nov 10 09:10 rebuild_old_docs.php drwxrwxr-x 2 www-data www-data 4096 Nov 10 09:10 rss drwxrwxr-x 3 www-data www-data 4096 Nov 10 09:10 src drwxrwxr-x 2 www-data www-data 4096 Nov 10 09:10 temp drwxrwxr-x 5 www-data www-data 4096 Nov 10 09:10 test drwxrwxr-x 2 www-data www-data 4096 Nov 10 09:10 wsdl drwxrwxr-x 2 www-data www-data 4096 Nov 10 09:10 xml

ls -lt upload/careerportaladd/ total 244 -rwxrwxrwx 1 www-data www-data 67072 Dec 28 23:29 'Ruth Cybersecurity Resume 1.doc_Copy2.txt' -rwxrwxrwx 1 www-data www-data 67072 Dec 28 23:29 'Ruth Cybersecurity Resume 1.doc_Copy1.txt' -rwxrwxrwx 1 www-data www-data 67072 Dec 28 23:28 'Ruth Cybersecurity Resume 1.doc.txt' -rwxrwxrwx 1 www-data www-data 44 Dec 28 10:03 mV1CG.php.txt -rwxrwxrwx 1 www-data www-data 42 Dec 28 10:02 EBIw5.php.txt -rwxrwxrwx 1 www-data www-data 36 Dec 27 23:48 VyE5q.php.txt -rwxrwxrwx 1 www-data www-data 42 Dec 27 23:02 luptp.php.txt -rwxrwxrwx 1 www-data www-data 44 Dec 26 15:28 DIdlr.php.txt -rwxrwxrwx 1 www-data www-data 84 Dec 26 15:28 DCX8Y.php.txt -rwxrwxrwx 1 www-data www-data 42 Dec 26 15:27 pIvGc.php.txt -rwxrwxrwx 1 www-data www-data 42 Dec 25 09:32 fke1T.php.txt -rwxrwxrwx 1 www-data www-data 46 Dec 25 09:03 1Bx7n.php.txt -rwxrwxrwx 1 www-data www-data 30 Dec 24 20:30 ChJLg.php.txt

ls -lt attachments/ total 12 drwxr-xr-x 6 www-data www-data 4096 Dec 13 15:39 site_180 -rw-r--r-- 1 www-data www-data 2733 Dec 11 17:05 index.html drwxr-xr-x 7 www-data www-data 4096 Dec 11 17:05 site_1 -rw-rw-r-- 1 www-data www-data 0 May 17 2018 index.php

ronswift2 commented 2 years ago

I believe these repeated php warnings when adding candidates with resumes may be part of the issue: [Wed Dec 29 20:36:19.990142 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:36:19.990201 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:36:19.990216 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:38:22.664928 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add [Wed Dec 29 20:38:22.664985 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add [Wed Dec 29 20:38:22.665003 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add

ronswift2 commented 2 years ago

Urgent help needed please respond, thanks

shantadam commented 2 years ago

Hi ronswift2,

Even though I did some analysis around line 192 of /modules/candidates/Add.tpl, my answers may take us to multiple directions.

The issue may probably have nothing to do with the PHP version 7.4 and more on the array key-value reference. However, before we jump-in with conclusions and assumptions, this issue requires more clarification.

Help us get a better picture of the actions you’ve taken, step-by-step, from login to the issue, as such:

Thank you in advance.

Regards, Shant Adam

From: ronswift2 @.> Date: Wednesday, December 29, 2021 at 1:14 PM To: opencats/OpenCATS @.> Cc: Subscribed @.***> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

I believe these repeated php warnings when adding candidates with resumes may be part of the issue: [Wed Dec 29 20:36:19.990142 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:36:19.990201 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:36:19.990216 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:38:22.664928 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add [Wed Dec 29 20:38:22.664985 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add [Wed Dec 29 20:38:22.665003 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1002778603, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVIFZXGO7I6O3H5OBMTUTN23PANCNFSM5K5AWZ6A. You are receiving this because you are subscribed to this thread.Message ID: @.***>

ronswift2 commented 2 years ago

The operating system is Ubuntu Linux 20.04 Browsers: Chromium and Firefox Steps: Log in as administrator and retrieve applicant file. Then select upload resume and attempt to apply resume to applicant file. Shows resume uploaded successfully and when dialog closes no change to file. Also, when an applicant applies to a position online via the careers tab and attaches a resume the applicant file is added to the system without the resume. When the resume is uploaded it appears garbled. When the file is submitted it then shows a blank screen. The candidate that I used to show what is occurring has another entry in their file that shows they applied to another position (i.e. Systems Analyst) and downloaded a resume. Clicking on the download shows the garbled distorted file. The uploaded resume file had a docx extension but was converted to docx.txt. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Tuesday, January 4, 2022 3:55:25 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi ronswift2,

Even though I did some analysis around line 192 of /modules/candidates/Add.tpl, my answers may take us to multiple directions.

The issue may probably have nothing to do with the PHP version 7.4 and more on the array key-value reference. However, before we jump-in with conclusions and assumptions, this issue requires more clarification.

Help us get a better picture of the actions you’ve taken, step-by-step, from login to the issue, as such:

Thank you in advance.

Regards, Shant Adam

From: ronswift2 @.> Date: Wednesday, December 29, 2021 at 1:14 PM To: opencats/OpenCATS @.> Cc: Subscribed @.***> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

I believe these repeated php warnings when adding candidates with resumes may be part of the issue: [Wed Dec 29 20:36:19.990142 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:36:19.990201 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:36:19.990216 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:38:22.664928 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add [Wed Dec 29 20:38:22.664985 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add [Wed Dec 29 20:38:22.665003 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1002778603, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVIFZXGO7I6O3H5OBMTUTN23PANCNFSM5K5AWZ6A. You are receiving this because you are subscribed to this thread.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1005163630 @ github . com>

shantadam commented 2 years ago

Thanks, Ron, for your insights.

After all, Ron, what you described in your last email seems to me that the issue lies within the resume file upload procedure - more specifically the file parsing issue.

I figured the issue was not with the template but with some unknown factor that triggered for the template to break. We can put aside your initially reported issue with /modules/candidates/Add.tpl file on line 192 and, unfortunately, we’ll have to focus back on the app’s initial setup and configuration. Majority of times a file not being parsed as expected has to do with incomplete server parsing module setup, or config.

Now, let me ask you, Ron, the following questions:

Regards, Shant Adam

From: ronswift2 @.> Date: Tuesday, January 4, 2022 at 2:38 PM To: opencats/OpenCATS @.> Cc: Shant Adam @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) The operating system is Ubuntu Linux 20.04 Browsers: Chromium and Firefox Steps: Log in as administrator and retrieve applicant file. Then select upload resume and attempt to apply resume to applicant file. Shows resume uploaded successfully and when dialog closes no change to file. Also, when an applicant applies to a position online via the careers tab and attaches a resume the applicant file is added to the system without the resume. When the resume is uploaded it appears garbled. When the file is submitted it then shows a blank screen. The candidate that I used to show what is occurring has another entry in their file that shows they applied to another position (i.e. Systems Analyst) and downloaded a resume. Clicking on the download shows the garbled distorted file. The uploaded resume file had a docx extension but was converted to docx.txt. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Tuesday, January 4, 2022 3:55:25 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi ronswift2,

Even though I did some analysis around line 192 of /modules/candidates/Add.tpl, my answers may take us to multiple directions.

The issue may probably have nothing to do with the PHP version 7.4 and more on the array key-value reference. However, before we jump-in with conclusions and assumptions, this issue requires more clarification.

Help us get a better picture of the actions you’ve taken, step-by-step, from login to the issue, as such:

Thank you in advance.

Regards, Shant Adam

From: ronswift2 @.> Date: Wednesday, December 29, 2021 at 1:14 PM To: opencats/OpenCATS @.> Cc: Subscribed @.***> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

I believe these repeated php warnings when adding candidates with resumes may be part of the issue: [Wed Dec 29 20:36:19.990142 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:36:19.990201 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:36:19.990216 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:38:22.664928 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add [Wed Dec 29 20:38:22.664985 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add [Wed Dec 29 20:38:22.665003 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1002778603, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVIFZXGO7I6O3H5OBMTUTN23PANCNFSM5K5AWZ6A. You are receiving this because you are subscribed to this thread.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1005163630 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1005223474, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVNVNC5UDPFII3LV3I3UUNZGFANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

ronswift2 commented 2 years ago

I was previously running opencats v9.3 on another server using Ubuntu 16.04. When I installed Opencats v9.6 on Ubuntu 20.04 server I followed the guide. The binary files antiword, pdftotext, html2text and unrtf are all in /usr/bin and found in the installation process (I tried reinstalling these binary programs including poppler-utils and that did not correct the parsing issue). I used the files on Github, https://github.com/opencats/OpenCATS/releases/tag/0.9.6 and followed the install guide for a new setup using Apache2, php7.4 and mysql/mariadb. Upon completion, I copied over the attachments directory and restored the Mysql database from v9.3 to the new version. The server is also running Bitdefender antivirus/malware and the ufw firewall settings are: Status: active

To Action From

22/tcp ALLOW Anywhere 80 ALLOW Anywhere 443 ALLOW Anywhere Anywhere DENY 128.199.5.105 Anywhere DENY 195.54.160.149 Anywhere DENY 190.60.234.22 Anywhere DENY 61.12.67.132 Anywhere DENY 198.187.29.114 Anywhere DENY 64.225.43.102 22/tcp (v6) ALLOW Anywhere (v6) 80 (v6) ALLOW Anywhere (v6) 443 (v6) ALLOW Anywhere (v6)

Here is the .../attachments folder drwxrwx--- 6 www-data www-data 4096 Dec 13 15:39 site_180 drwxrwx--- 7 www-data www-data 4096 Dec 11 17:05 site_1 -rwxrwx--- 1 www-data www-data 0 May 17 2018 index.php It appears nothing has changed since I copied it over from v9.3

I trust that this added information will lead to a fix. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Tuesday, January 4, 2022 7:58:57 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Thanks, Ron, for your insights.

After all, Ron, what you described in your last email seems to me that the issue lies within the resume file upload procedure - more specifically the file parsing issue.

I figured the issue was not with the template but with some unknown factor that triggered for the template to break. We can put aside your initially reported issue with /modules/candidates/Add.tpl file on line 192 and, unfortunately, we’ll have to focus back on the app’s initial setup and configuration. Majority of times a file not being parsed as expected has to do with incomplete server parsing module setup, or config.

Now, let me ask you, Ron, the following questions:

Regards, Shant Adam

From: ronswift2 @.> Date: Tuesday, January 4, 2022 at 2:38 PM To: opencats/OpenCATS @.> Cc: Shant Adam @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) The operating system is Ubuntu Linux 20.04 Browsers: Chromium and Firefox Steps: Log in as administrator and retrieve applicant file. Then select upload resume and attempt to apply resume to applicant file. Shows resume uploaded successfully and when dialog closes no change to file. Also, when an applicant applies to a position online via the careers tab and attaches a resume the applicant file is added to the system without the resume. When the resume is uploaded it appears garbled. When the file is submitted it then shows a blank screen. The candidate that I used to show what is occurring has another entry in their file that shows they applied to another position (i.e. Systems Analyst) and downloaded a resume. Clicking on the download shows the garbled distorted file. The uploaded resume file had a docx extension but was converted to docx.txt. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Tuesday, January 4, 2022 3:55:25 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi ronswift2,

Even though I did some analysis around line 192 of /modules/candidates/Add.tpl, my answers may take us to multiple directions.

The issue may probably have nothing to do with the PHP version 7.4 and more on the array key-value reference. However, before we jump-in with conclusions and assumptions, this issue requires more clarification.

Help us get a better picture of the actions you’ve taken, step-by-step, from login to the issue, as such:

Thank you in advance.

Regards, Shant Adam

From: ronswift2 @.> Date: Wednesday, December 29, 2021 at 1:14 PM To: opencats/OpenCATS @.> Cc: Subscribed @.***> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

I believe these repeated php warnings when adding candidates with resumes may be part of the issue: [Wed Dec 29 20:36:19.990142 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:36:19.990201 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:36:19.990216 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:38:22.664928 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add [Wed Dec 29 20:38:22.664985 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add [Wed Dec 29 20:38:22.665003 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1002778603, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVIFZXGO7I6O3H5OBMTUTN23PANCNFSM5K5AWZ6A. You are receiving this because you are subscribed to this thread.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1005163630 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1005223474, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVNVNC5UDPFII3LV3I3UUNZGFANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1005292094 @ github . com>

shantadam commented 2 years ago

Hi Ron,

One (1) important item that stood out to my attention and sounded alarming from your described actions taken while migrating, i.e.:

Questions:

I would revisit the latter action and make sure nothing is broken in the database.

P.S.: If there are any other items you’ve migrated from the old version to the new one, it’s ought to be double checked.

Regards, Shant Adam

On Jan 5, 2022, at 7:30 AM, ronswift2 @.***> wrote:



I was previously running opencats v9.3 on another server using Ubuntu 16.04. When I installed Opencats v9.6 on Ubuntu 20.04 server I followed the guide. The binary files antiword, pdftotext, html2text and unrtf are all in /usr/bin and found in the installation process (I tried reinstalling these binary programs including poppler-utils and that did not correct the parsing issue). I used the files on Github, https://github.com/opencats/OpenCATS/releases/tag/0.9.6 and followed the install guide for a new setup using Apache2, php7.4 and mysql/mariadb. Upon completion, I copied over the attachments directory and restored the Mysql database from v9.3 to the new version. The server is also running Bitdefender antivirus/malware and the ufw firewall settings are: Status: active

To Action From

22/tcp ALLOW Anywhere 80 ALLOW Anywhere 443 ALLOW Anywhere Anywhere DENY 128.199.5.105 Anywhere DENY 195.54.160.149 Anywhere DENY 190.60.234.22 Anywhere DENY 61.12.67.132 Anywhere DENY 198.187.29.114 Anywhere DENY 64.225.43.102 22/tcp (v6) ALLOW Anywhere (v6) 80 (v6) ALLOW Anywhere (v6) 443 (v6) ALLOW Anywhere (v6)

Here is the .../attachments folder drwxrwx--- 6 www-data www-data 4096 Dec 13 15:39 site_180 drwxrwx--- 7 www-data www-data 4096 Dec 11 17:05 site_1 -rwxrwx--- 1 www-data www-data 0 May 17 2018 index.php It appears nothing has changed since I copied it over from v9.3

I trust that this added information will lead to a fix. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Tuesday, January 4, 2022 7:58:57 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Thanks, Ron, for your insights.

After all, Ron, what you described in your last email seems to me that the issue lies within the resume file upload procedure - more specifically the file parsing issue.

I figured the issue was not with the template but with some unknown factor that triggered for the template to break. We can put aside your initially reported issue with /modules/candidates/Add.tpl file on line 192 and, unfortunately, we’ll have to focus back on the app’s initial setup and configuration. Majority of times a file not being parsed as expected has to do with incomplete server parsing module setup, or config.

Now, let me ask you, Ron, the following questions:

Regards, Shant Adam

From: ronswift2 @.> Date: Tuesday, January 4, 2022 at 2:38 PM To: opencats/OpenCATS @.> Cc: Shant Adam @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) The operating system is Ubuntu Linux 20.04 Browsers: Chromium and Firefox Steps: Log in as administrator and retrieve applicant file. Then select upload resume and attempt to apply resume to applicant file. Shows resume uploaded successfully and when dialog closes no change to file. Also, when an applicant applies to a position online via the careers tab and attaches a resume the applicant file is added to the system without the resume. When the resume is uploaded it appears garbled. When the file is submitted it then shows a blank screen. The candidate that I used to show what is occurring has another entry in their file that shows they applied to another position (i.e. Systems Analyst) and downloaded a resume. Clicking on the download shows the garbled distorted file. The uploaded resume file had a docx extension but was converted to docx.txt. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Tuesday, January 4, 2022 3:55:25 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi ronswift2,

Even though I did some analysis around line 192 of /modules/candidates/Add.tpl, my answers may take us to multiple directions.

The issue may probably have nothing to do with the PHP version 7.4 and more on the array key-value reference. However, before we jump-in with conclusions and assumptions, this issue requires more clarification.

Help us get a better picture of the actions you’ve taken, step-by-step, from login to the issue, as such:

Thank you in advance.

Regards, Shant Adam

From: ronswift2 @.> Date: Wednesday, December 29, 2021 at 1:14 PM To: opencats/OpenCATS @.> Cc: Subscribed @.***> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

I believe these repeated php warnings when adding candidates with resumes may be part of the issue: [Wed Dec 29 20:36:19.990142 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:36:19.990201 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:36:19.990216 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:38:22.664928 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add [Wed Dec 29 20:38:22.664985 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add [Wed Dec 29 20:38:22.665003 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1002778603, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVIFZXGO7I6O3H5OBMTUTN23PANCNFSM5K5AWZ6A. You are receiving this because you are subscribed to this thread.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1005163630 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1005223474, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVNVNC5UDPFII3LV3I3UUNZGFANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1005292094 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1005811869, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVOBUTJ4JBKZG5UYSLLUURPZFANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

ronswift2 commented 2 years ago

All of the old v9.3 data is accessible in v9.6 to include all candidate information, activities and resumes. We can access the old resumes and search on them. The attachments folder from v9.3 was copied over v9.6 install. It is difficult to look at the two versions sql files for changes without knowing specifically what tables to focus on. There is two+ years of applicant data that was migrated from v9.3. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Wednesday, January 5, 2022 11:02:44 AM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Ron,

One (1) important item that stood out to my attention and sounded alarming from your described actions taken while migrating, i.e.:

Questions:

I would revisit the latter action and make sure nothing is broken in the database.

P.S.: If there are any other items you’ve migrated from the old version to the new one, it’s ought to be double checked.

Regards, Shant Adam

On Jan 5, 2022, at 7:30 AM, ronswift2 @.***> wrote:

I was previously running opencats v9.3 on another server using Ubuntu 16.04. When I installed Opencats v9.6 on Ubuntu 20.04 server I followed the guide. The binary files antiword, pdftotext, html2text and unrtf are all in /usr/bin and found in the installation process (I tried reinstalling these binary programs including poppler-utils and that did not correct the parsing issue). I used the files on Github, https://github.com/opencats/OpenCATS/releases/tag/0.9.6 and followed the install guide for a new setup using Apache2, php7.4 and mysql/mariadb. Upon completion, I copied over the attachments directory and restored the Mysql database from v9.3 to the new version. The server is also running Bitdefender antivirus/malware and the ufw firewall settings are: Status: active

To Action From

22/tcp ALLOW Anywhere 80 ALLOW Anywhere 443 ALLOW Anywhere Anywhere DENY 128.199.5.105 Anywhere DENY 195.54.160.149 Anywhere DENY 190.60.234.22 Anywhere DENY 61.12.67.132 Anywhere DENY 198.187.29.114 Anywhere DENY 64.225.43.102 22/tcp (v6) ALLOW Anywhere (v6) 80 (v6) ALLOW Anywhere (v6) 443 (v6) ALLOW Anywhere (v6)

Here is the .../attachments folder drwxrwx--- 6 www-data www-data 4096 Dec 13 15:39 site_180 drwxrwx--- 7 www-data www-data 4096 Dec 11 17:05 site_1 -rwxrwx--- 1 www-data www-data 0 May 17 2018 index.php It appears nothing has changed since I copied it over from v9.3

I trust that this added information will lead to a fix. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Tuesday, January 4, 2022 7:58:57 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Thanks, Ron, for your insights.

After all, Ron, what you described in your last email seems to me that the issue lies within the resume file upload procedure - more specifically the file parsing issue.

I figured the issue was not with the template but with some unknown factor that triggered for the template to break. We can put aside your initially reported issue with /modules/candidates/Add.tpl file on line 192 and, unfortunately, we’ll have to focus back on the app’s initial setup and configuration. Majority of times a file not being parsed as expected has to do with incomplete server parsing module setup, or config.

Now, let me ask you, Ron, the following questions:

Regards, Shant Adam

From: ronswift2 @.> Date: Tuesday, January 4, 2022 at 2:38 PM To: opencats/OpenCATS @.> Cc: Shant Adam @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) The operating system is Ubuntu Linux 20.04 Browsers: Chromium and Firefox Steps: Log in as administrator and retrieve applicant file. Then select upload resume and attempt to apply resume to applicant file. Shows resume uploaded successfully and when dialog closes no change to file. Also, when an applicant applies to a position online via the careers tab and attaches a resume the applicant file is added to the system without the resume. When the resume is uploaded it appears garbled. When the file is submitted it then shows a blank screen. The candidate that I used to show what is occurring has another entry in their file that shows they applied to another position (i.e. Systems Analyst) and downloaded a resume. Clicking on the download shows the garbled distorted file. The uploaded resume file had a docx extension but was converted to docx.txt. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Tuesday, January 4, 2022 3:55:25 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi ronswift2,

Even though I did some analysis around line 192 of /modules/candidates/Add.tpl, my answers may take us to multiple directions.

The issue may probably have nothing to do with the PHP version 7.4 and more on the array key-value reference. However, before we jump-in with conclusions and assumptions, this issue requires more clarification.

Help us get a better picture of the actions you’ve taken, step-by-step, from login to the issue, as such:

Thank you in advance.

Regards, Shant Adam

From: ronswift2 @.> Date: Wednesday, December 29, 2021 at 1:14 PM To: opencats/OpenCATS @.> Cc: Subscribed @.***> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

I believe these repeated php warnings when adding candidates with resumes may be part of the issue: [Wed Dec 29 20:36:19.990142 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:36:19.990201 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:36:19.990216 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:38:22.664928 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add [Wed Dec 29 20:38:22.664985 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add [Wed Dec 29 20:38:22.665003 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1002778603, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVIFZXGO7I6O3H5OBMTUTN23PANCNFSM5K5AWZ6A. You are receiving this because you are subscribed to this thread.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1005163630 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1005223474, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVNVNC5UDPFII3LV3I3UUNZGFANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1005292094 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1005811869, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVOBUTJ4JBKZG5UYSLLUURPZFANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1005855516 @ github . com>

shantadam commented 2 years ago

Hi Ron,

As I figured, your statement “it is difficult to look at the two versions of SQL files for changes” tells me that the old database was ingested without the due diligence of analysis. Especially, on a 2-year data collection.

Unfortunately, migrations are not as simple as theoretically seems like versus applied. My intuition tells me, Ron, your concerning issue lies within your database. Which will call for the painstaking ETL process to analyze each SQL table and probably map accordingly.

If you’re “visual”, I recommend using “MySQL Workbenchhttps://www.mysql.com/products/workbench/”, and “mergehttps://meldmerge.org/” or “kdiffhttp://kdiff3.sourceforge.net/” or “diffusehttp://diffuse.sourceforge.net/”. Otherwise, command line tools “diff3”, “mysql”, “mysqldump”, and “mysqlimport”.

After all, Ron, I highly recommend you do your due diligence to carefully analyze the old database’s dumped SQL files versus the new ones and handle the data ingestion with care. Once you handle the latter procedure then if issue persists, we’d be happy to help further. Thank you.

Regards, Shant Adam

From: ronswift2 @.> Date: Wednesday, January 5, 2022 at 8:34 AM To: opencats/OpenCATS @.> Cc: Shant Adam @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) All of the old v9.3 data is accessible in v9.6 to include all candidate information, activities and resumes. We can access the old resumes and search on them. The attachments folder from v9.3 was copied over v9.6 install. It is difficult to look at the two versions sql files for changes without knowing specifically what tables to focus on. There is two+ years of applicant data that was migrated from v9.3. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Wednesday, January 5, 2022 11:02:44 AM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Ron,

One (1) important item that stood out to my attention and sounded alarming from your described actions taken while migrating, i.e.:

Questions:

I would revisit the latter action and make sure nothing is broken in the database.

P.S.: If there are any other items you’ve migrated from the old version to the new one, it’s ought to be double checked.

Regards, Shant Adam

On Jan 5, 2022, at 7:30 AM, ronswift2 @.***> wrote:

I was previously running opencats v9.3 on another server using Ubuntu 16.04. When I installed Opencats v9.6 on Ubuntu 20.04 server I followed the guide. The binary files antiword, pdftotext, html2text and unrtf are all in /usr/bin and found in the installation process (I tried reinstalling these binary programs including poppler-utils and that did not correct the parsing issue). I used the files on Github, https://github.com/opencats/OpenCATS/releases/tag/0.9.6 and followed the install guide for a new setup using Apache2, php7.4 and mysql/mariadb. Upon completion, I copied over the attachments directory and restored the Mysql database from v9.3 to the new version. The server is also running Bitdefender antivirus/malware and the ufw firewall settings are: Status: active

To Action From

22/tcp ALLOW Anywhere 80 ALLOW Anywhere 443 ALLOW Anywhere Anywhere DENY 128.199.5.105 Anywhere DENY 195.54.160.149 Anywhere DENY 190.60.234.22 Anywhere DENY 61.12.67.132 Anywhere DENY 198.187.29.114 Anywhere DENY 64.225.43.102 22/tcp (v6) ALLOW Anywhere (v6) 80 (v6) ALLOW Anywhere (v6) 443 (v6) ALLOW Anywhere (v6)

Here is the .../attachments folder drwxrwx--- 6 www-data www-data 4096 Dec 13 15:39 site_180 drwxrwx--- 7 www-data www-data 4096 Dec 11 17:05 site_1 -rwxrwx--- 1 www-data www-data 0 May 17 2018 index.php It appears nothing has changed since I copied it over from v9.3

I trust that this added information will lead to a fix. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Tuesday, January 4, 2022 7:58:57 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Thanks, Ron, for your insights.

After all, Ron, what you described in your last email seems to me that the issue lies within the resume file upload procedure - more specifically the file parsing issue.

I figured the issue was not with the template but with some unknown factor that triggered for the template to break. We can put aside your initially reported issue with /modules/candidates/Add.tpl file on line 192 and, unfortunately, we’ll have to focus back on the app’s initial setup and configuration. Majority of times a file not being parsed as expected has to do with incomplete server parsing module setup, or config.

Now, let me ask you, Ron, the following questions:

Regards, Shant Adam

From: ronswift2 @.> Date: Tuesday, January 4, 2022 at 2:38 PM To: opencats/OpenCATS @.> Cc: Shant Adam @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) The operating system is Ubuntu Linux 20.04 Browsers: Chromium and Firefox Steps: Log in as administrator and retrieve applicant file. Then select upload resume and attempt to apply resume to applicant file. Shows resume uploaded successfully and when dialog closes no change to file. Also, when an applicant applies to a position online via the careers tab and attaches a resume the applicant file is added to the system without the resume. When the resume is uploaded it appears garbled. When the file is submitted it then shows a blank screen. The candidate that I used to show what is occurring has another entry in their file that shows they applied to another position (i.e. Systems Analyst) and downloaded a resume. Clicking on the download shows the garbled distorted file. The uploaded resume file had a docx extension but was converted to docx.txt. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Tuesday, January 4, 2022 3:55:25 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi ronswift2,

Even though I did some analysis around line 192 of /modules/candidates/Add.tpl, my answers may take us to multiple directions.

The issue may probably have nothing to do with the PHP version 7.4 and more on the array key-value reference. However, before we jump-in with conclusions and assumptions, this issue requires more clarification.

Help us get a better picture of the actions you’ve taken, step-by-step, from login to the issue, as such:

Thank you in advance.

Regards, Shant Adam

From: ronswift2 @.> Date: Wednesday, December 29, 2021 at 1:14 PM To: opencats/OpenCATS @.> Cc: Subscribed @.***> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

I believe these repeated php warnings when adding candidates with resumes may be part of the issue: [Wed Dec 29 20:36:19.990142 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:36:19.990201 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:36:19.990216 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:38:22.664928 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add [Wed Dec 29 20:38:22.664985 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add [Wed Dec 29 20:38:22.665003 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1002778603, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVIFZXGO7I6O3H5OBMTUTN23PANCNFSM5K5AWZ6A. You are receiving this because you are subscribed to this thread.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1005163630 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1005223474, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVNVNC5UDPFII3LV3I3UUNZGFANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1005292094 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1005811869, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVOBUTJ4JBKZG5UYSLLUURPZFANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1005855516 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1005882947, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVIL3H5BOBLGDAR4OPTUURXJHANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

ronswift2 commented 2 years ago

The documentation did not state that I needed to do a comparison of mysql/mariadb structure when updating using the manual non-gui process. Considering the issue I had previously with job and candidate data lists not showing I should have guessed that there was a change in databases between the two versions, v9.3 and v9.6. Do you offer your services for hire to fix this for me and if so please provide an estimate. The old version v9.3 is still on one of my servers running Ubuntu 16.04 but I am concerned about security issues with opencats on that box. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Wednesday, January 5, 2022 2:05:04 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Ron,

As I figured, your statement “it is difficult to look at the two versions of SQL files for changes” tells me that the old database was ingested without the due diligence of analysis. Especially, on a 2-year data collection.

Unfortunately, migrations are not as simple as theoretically seems like versus applied. My intuition tells me, Ron, your concerning issue lies within your database. Which will call for the painstaking ETL process to analyze each SQL table and probably map accordingly.

If you’re “visual”, I recommend using “MySQL Workbenchhttps://www.mysql.com/products/workbench/”, and “mergehttps://meldmerge.org/” or “kdiffhttp://kdiff3.sourceforge.net/” or “diffusehttp://diffuse.sourceforge.net/”. Otherwise, command line tools “diff3”, “mysql”, “mysqldump”, and “mysqlimport”.

After all, Ron, I highly recommend you do your due diligence to carefully analyze the old database’s dumped SQL files versus the new ones and handle the data ingestion with care. Once you handle the latter procedure then if issue persists, we’d be happy to help further. Thank you.

Regards, Shant Adam

From: ronswift2 @.> Date: Wednesday, January 5, 2022 at 8:34 AM To: opencats/OpenCATS @.> Cc: Shant Adam @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) All of the old v9.3 data is accessible in v9.6 to include all candidate information, activities and resumes. We can access the old resumes and search on them. The attachments folder from v9.3 was copied over v9.6 install. It is difficult to look at the two versions sql files for changes without knowing specifically what tables to focus on. There is two+ years of applicant data that was migrated from v9.3. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Wednesday, January 5, 2022 11:02:44 AM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Ron,

One (1) important item that stood out to my attention and sounded alarming from your described actions taken while migrating, i.e.:

Questions:

I would revisit the latter action and make sure nothing is broken in the database.

P.S.: If there are any other items you’ve migrated from the old version to the new one, it’s ought to be double checked.

Regards, Shant Adam

On Jan 5, 2022, at 7:30 AM, ronswift2 @.***> wrote:

I was previously running opencats v9.3 on another server using Ubuntu 16.04. When I installed Opencats v9.6 on Ubuntu 20.04 server I followed the guide. The binary files antiword, pdftotext, html2text and unrtf are all in /usr/bin and found in the installation process (I tried reinstalling these binary programs including poppler-utils and that did not correct the parsing issue). I used the files on Github, https://github.com/opencats/OpenCATS/releases/tag/0.9.6 and followed the install guide for a new setup using Apache2, php7.4 and mysql/mariadb. Upon completion, I copied over the attachments directory and restored the Mysql database from v9.3 to the new version. The server is also running Bitdefender antivirus/malware and the ufw firewall settings are: Status: active

To Action From

22/tcp ALLOW Anywhere 80 ALLOW Anywhere 443 ALLOW Anywhere Anywhere DENY 128.199.5.105 Anywhere DENY 195.54.160.149 Anywhere DENY 190.60.234.22 Anywhere DENY 61.12.67.132 Anywhere DENY 198.187.29.114 Anywhere DENY 64.225.43.102 22/tcp (v6) ALLOW Anywhere (v6) 80 (v6) ALLOW Anywhere (v6) 443 (v6) ALLOW Anywhere (v6)

Here is the .../attachments folder drwxrwx--- 6 www-data www-data 4096 Dec 13 15:39 site_180 drwxrwx--- 7 www-data www-data 4096 Dec 11 17:05 site_1 -rwxrwx--- 1 www-data www-data 0 May 17 2018 index.php It appears nothing has changed since I copied it over from v9.3

I trust that this added information will lead to a fix. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Tuesday, January 4, 2022 7:58:57 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Thanks, Ron, for your insights.

After all, Ron, what you described in your last email seems to me that the issue lies within the resume file upload procedure - more specifically the file parsing issue.

I figured the issue was not with the template but with some unknown factor that triggered for the template to break. We can put aside your initially reported issue with /modules/candidates/Add.tpl file on line 192 and, unfortunately, we’ll have to focus back on the app’s initial setup and configuration. Majority of times a file not being parsed as expected has to do with incomplete server parsing module setup, or config.

Now, let me ask you, Ron, the following questions:

Regards, Shant Adam

From: ronswift2 @.> Date: Tuesday, January 4, 2022 at 2:38 PM To: opencats/OpenCATS @.> Cc: Shant Adam @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) The operating system is Ubuntu Linux 20.04 Browsers: Chromium and Firefox Steps: Log in as administrator and retrieve applicant file. Then select upload resume and attempt to apply resume to applicant file. Shows resume uploaded successfully and when dialog closes no change to file. Also, when an applicant applies to a position online via the careers tab and attaches a resume the applicant file is added to the system without the resume. When the resume is uploaded it appears garbled. When the file is submitted it then shows a blank screen. The candidate that I used to show what is occurring has another entry in their file that shows they applied to another position (i.e. Systems Analyst) and downloaded a resume. Clicking on the download shows the garbled distorted file. The uploaded resume file had a docx extension but was converted to docx.txt. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Tuesday, January 4, 2022 3:55:25 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi ronswift2,

Even though I did some analysis around line 192 of /modules/candidates/Add.tpl, my answers may take us to multiple directions.

The issue may probably have nothing to do with the PHP version 7.4 and more on the array key-value reference. However, before we jump-in with conclusions and assumptions, this issue requires more clarification.

Help us get a better picture of the actions you’ve taken, step-by-step, from login to the issue, as such:

Thank you in advance.

Regards, Shant Adam

From: ronswift2 @.> Date: Wednesday, December 29, 2021 at 1:14 PM To: opencats/OpenCATS @.> Cc: Subscribed @.***> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

I believe these repeated php warnings when adding candidates with resumes may be part of the issue: [Wed Dec 29 20:36:19.990142 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:36:19.990201 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:36:19.990216 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:38:22.664928 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add [Wed Dec 29 20:38:22.664985 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add [Wed Dec 29 20:38:22.665003 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1002778603, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVIFZXGO7I6O3H5OBMTUTN23PANCNFSM5K5AWZ6A. You are receiving this because you are subscribed to this thread.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1005163630 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1005223474, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVNVNC5UDPFII3LV3I3UUNZGFANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1005292094 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1005811869, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVOBUTJ4JBKZG5UYSLLUURPZFANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1005855516 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1005882947, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVIL3H5BOBLGDAR4OPTUURXJHANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1005999080 @ github . com>

shantadam commented 2 years ago

Hi Ron,

I certainly hear the need for OpenCATS documentation requiring additional migration path procedure guidance. However, the current version is for clean install.

In an ideal scenario a wizard-based application would walkthrough an admin while upgrading and migrating. However, in this case, due to OpenCATS team resource restrains the investment efforts are more focused on resolving pending issues versus support tool development.

As for the data migration support, I would certainly see to be of help to you, Ron. kindly requesting to please send me an email at @.**@.> and I’ll see to share with you a cost-effective estimate. Thank you, Ron.

Regards, Shant Adam Tel: (778) 877-2028

From: ronswift2 @.> Date: Wednesday, January 5, 2022 at 11:47 AM To: opencats/OpenCATS @.> Cc: Shant Adam @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) The documentation did not state that I needed to do a comparison of mysql/mariadb structure when updating using the manual non-gui process. Considering the issue I had previously with job and candidate data lists not showing I should have guessed that there was a change in databases between the two versions, v9.3 and v9.6. Do you offer your services for hire to fix this for me and if so please provide an estimate. The old version v9.3 is still on one of my servers running Ubuntu 16.04 but I am concerned about security issues with opencats on that box. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Wednesday, January 5, 2022 2:05:04 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Ron,

As I figured, your statement “it is difficult to look at the two versions of SQL files for changes” tells me that the old database was ingested without the due diligence of analysis. Especially, on a 2-year data collection.

Unfortunately, migrations are not as simple as theoretically seems like versus applied. My intuition tells me, Ron, your concerning issue lies within your database. Which will call for the painstaking ETL process to analyze each SQL table and probably map accordingly.

If you’re “visual”, I recommend using “MySQL Workbenchhttps://www.mysql.com/products/workbench/”, and “mergehttps://meldmerge.org/” or “kdiffhttp://kdiff3.sourceforge.net/” or “diffusehttp://diffuse.sourceforge.net/”. Otherwise, command line tools “diff3”, “mysql”, “mysqldump”, and “mysqlimport”.

After all, Ron, I highly recommend you do your due diligence to carefully analyze the old database’s dumped SQL files versus the new ones and handle the data ingestion with care. Once you handle the latter procedure then if issue persists, we’d be happy to help further. Thank you.

Regards, Shant Adam

From: ronswift2 @.> Date: Wednesday, January 5, 2022 at 8:34 AM To: opencats/OpenCATS @.> Cc: Shant Adam @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) All of the old v9.3 data is accessible in v9.6 to include all candidate information, activities and resumes. We can access the old resumes and search on them. The attachments folder from v9.3 was copied over v9.6 install. It is difficult to look at the two versions sql files for changes without knowing specifically what tables to focus on. There is two+ years of applicant data that was migrated from v9.3. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Wednesday, January 5, 2022 11:02:44 AM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Ron,

One (1) important item that stood out to my attention and sounded alarming from your described actions taken while migrating, i.e.:

Questions:

I would revisit the latter action and make sure nothing is broken in the database.

P.S.: If there are any other items you’ve migrated from the old version to the new one, it’s ought to be double checked.

Regards, Shant Adam

On Jan 5, 2022, at 7:30 AM, ronswift2 @.***> wrote:

I was previously running opencats v9.3 on another server using Ubuntu 16.04. When I installed Opencats v9.6 on Ubuntu 20.04 server I followed the guide. The binary files antiword, pdftotext, html2text and unrtf are all in /usr/bin and found in the installation process (I tried reinstalling these binary programs including poppler-utils and that did not correct the parsing issue). I used the files on Github, https://github.com/opencats/OpenCATS/releases/tag/0.9.6 and followed the install guide for a new setup using Apache2, php7.4 and mysql/mariadb. Upon completion, I copied over the attachments directory and restored the Mysql database from v9.3 to the new version. The server is also running Bitdefender antivirus/malware and the ufw firewall settings are: Status: active

To Action From

22/tcp ALLOW Anywhere 80 ALLOW Anywhere 443 ALLOW Anywhere Anywhere DENY 128.199.5.105 Anywhere DENY 195.54.160.149 Anywhere DENY 190.60.234.22 Anywhere DENY 61.12.67.132 Anywhere DENY 198.187.29.114 Anywhere DENY 64.225.43.102 22/tcp (v6) ALLOW Anywhere (v6) 80 (v6) ALLOW Anywhere (v6) 443 (v6) ALLOW Anywhere (v6)

Here is the .../attachments folder drwxrwx--- 6 www-data www-data 4096 Dec 13 15:39 site_180 drwxrwx--- 7 www-data www-data 4096 Dec 11 17:05 site_1 -rwxrwx--- 1 www-data www-data 0 May 17 2018 index.php It appears nothing has changed since I copied it over from v9.3

I trust that this added information will lead to a fix. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Tuesday, January 4, 2022 7:58:57 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Thanks, Ron, for your insights.

After all, Ron, what you described in your last email seems to me that the issue lies within the resume file upload procedure - more specifically the file parsing issue.

I figured the issue was not with the template but with some unknown factor that triggered for the template to break. We can put aside your initially reported issue with /modules/candidates/Add.tpl file on line 192 and, unfortunately, we’ll have to focus back on the app’s initial setup and configuration. Majority of times a file not being parsed as expected has to do with incomplete server parsing module setup, or config.

Now, let me ask you, Ron, the following questions:

Regards, Shant Adam

From: ronswift2 @.> Date: Tuesday, January 4, 2022 at 2:38 PM To: opencats/OpenCATS @.> Cc: Shant Adam @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) The operating system is Ubuntu Linux 20.04 Browsers: Chromium and Firefox Steps: Log in as administrator and retrieve applicant file. Then select upload resume and attempt to apply resume to applicant file. Shows resume uploaded successfully and when dialog closes no change to file. Also, when an applicant applies to a position online via the careers tab and attaches a resume the applicant file is added to the system without the resume. When the resume is uploaded it appears garbled. When the file is submitted it then shows a blank screen. The candidate that I used to show what is occurring has another entry in their file that shows they applied to another position (i.e. Systems Analyst) and downloaded a resume. Clicking on the download shows the garbled distorted file. The uploaded resume file had a docx extension but was converted to docx.txt. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Tuesday, January 4, 2022 3:55:25 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi ronswift2,

Even though I did some analysis around line 192 of /modules/candidates/Add.tpl, my answers may take us to multiple directions.

The issue may probably have nothing to do with the PHP version 7.4 and more on the array key-value reference. However, before we jump-in with conclusions and assumptions, this issue requires more clarification.

Help us get a better picture of the actions you’ve taken, step-by-step, from login to the issue, as such:

Thank you in advance.

Regards, Shant Adam

From: ronswift2 @.> Date: Wednesday, December 29, 2021 at 1:14 PM To: opencats/OpenCATS @.> Cc: Subscribed @.***> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

I believe these repeated php warnings when adding candidates with resumes may be part of the issue: [Wed Dec 29 20:36:19.990142 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:36:19.990201 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:36:19.990216 2021] [php7:notice] [pid 3636] [client 192.168.0.39:59982] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates [Wed Dec 29 20:38:22.664928 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add [Wed Dec 29 20:38:22.664985 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add [Wed Dec 29 20:38:22.665003 2021] [php7:notice] [pid 3635] [client 192.168.0.39:59986] PHP Notice: Trying to access array offset on value of type bool in /var/www/html/OpenCATS-master/modules/candidates/Add.tpl on line 192, referer: https://careers3.swiftstaffing.com/index.php?m=candidates&a=add

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1002778603, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVIFZXGO7I6O3H5OBMTUTN23PANCNFSM5K5AWZ6A. You are receiving this because you are subscribed to this thread.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1005163630 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1005223474, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVNVNC5UDPFII3LV3I3UUNZGFANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1005292094 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1005811869, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVOBUTJ4JBKZG5UYSLLUURPZFANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1005855516 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1005882947, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVIL3H5BOBLGDAR4OPTUURXJHANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1005999080 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1006026931, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVP6QIDPKPPSAEZ7PJ3UUSN45ANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

ronswift2 commented 2 years ago

Please contact me about cleaning/repairing my database file.

shantadam commented 2 years ago

Hello Ron,

Kindly, take note, I left a voice message at the office. I look forward to helping you resolve the issue at your earliest convenience. I can be reached at +1 (778) 877-2028 or via email at @.**@.>.

Regards, Shant Adam

From: ronswift2 @.> Date: Monday, January 10, 2022 at 8:44 AM To: opencats/OpenCATS @.> Cc: Shant Adam @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Please contact me about cleaning/repairing my database file.

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1009098700, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVKEOC3PIYVQBGAS6ZTUVMEIJANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

zoomiest2 commented 2 years ago

I also just tried to manually upload a single resume, and although the dialog box would accept the file name of the file I selected, it wouldn't add the resume to the database.

I just installed the new code from GitHub, and imported my own mysqldump backup.

Am I in the same boat as ronswift2?

shantadam commented 2 years ago

Hi Zommiest2,

While the project tends to develop in an ad hoc fashion with multiple community member input sources with an attempt to deliver best of the product’s requirements, some minor and others major, like security and underlying tech upgrades, we do our best with limited resources to validate and verify the functional aspect of the application.

On the flip side, an open source project strives because of its supporting patrons. We certainly appreciate for our active community to reporting on their both good experiences and not so good encountered issues. It certainly is very helpful to have insightful eyes from our users for the betterment of the product.

My understanding, based on my offline chat with Ron, the issue is encountered with external applicants while using the external application user interface to apply for jobs. The problem is indeed related with the resume not being parsed/rendered as expected. However, the cadidate profile is being created successfully.

I have foreseen to invest some time to investigate the latest release around this issue with an attempt to pinpoint the causing factor. However, I will ask that we patient till this weekend. Thank you.

Regards, Shant Adam

On Jan 13, 2022, at 7:34 AM, zoomiest2 @.***> wrote:



I also just tried to manually upload a single resume, and although the dialog box would accept the file name of the file I selected, it wouldn't add the resume to the database.

I just installed the new code from GitHub, and imported my own mysqldump backup.

Am I in the same boat as ronswift2?

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1012248638, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVLCA3XUCE3IKWTD23TUV3WITANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

ronswift2 commented 2 years ago

It is correct that the issue appears when external candidates apply and the resume is not parsed and added to the applicant file. We have also attempted to add the resume to the new applicant file on the back-end as an administrator and that also fails but does not generate an error. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Friday, January 14, 2022 12:31:35 AM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Zommiest2,

While the project tends to develop in an ad hoc fashion with multiple community member input sources with an attempt to deliver best of the product’s requirements, some minor and others major, like security and underlying tech upgrades, we do our best with limited resources to validate and verify the functional aspect of the application.

On the flip side, an open source project strives because of its supporting patrons. We certainly appreciate for our active community to reporting on their both good experiences and not so good encountered issues. It certainly is very helpful to have insightful eyes from our users for the betterment of the product.

My understanding, based on my offline chat with Ron, the issue is encountered with external applicants while using the external application user interface to apply for jobs. The problem is indeed related with the resume not being parsed/rendered as expected. However, the cadidate profile is being created successfully.

I have foreseen to invest some time to investigate the latest release around this issue with an attempt to pinpoint the causing factor. However, I will ask that we patient till this weekend. Thank you.

Regards, Shant Adam

On Jan 13, 2022, at 7:34 AM, zoomiest2 @.***> wrote:

I also just tried to manually upload a single resume, and although the dialog box would accept the file name of the file I selected, it wouldn't add the resume to the database.

I just installed the new code from GitHub, and imported my own mysqldump backup.

Am I in the same boat as ronswift2?

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1012248638, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVLCA3XUCE3IKWTD23TUV3WITANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1012789024 @ github . com>

shantadam commented 2 years ago

I’m taking note of the issue around a candidate’s resume attachment. I will see over the weekend to investigate and report back. It’s a promise.

We’ve taken the app from 2021 to 2022 so far with multiple patches and upgrades, and I’m sure a little more stretch we’ll get it to be a more stable one. We’re appreciative of the interest demonstrated by the users community in the improvement of this wonderful unique product. Thank you.

Regards, Shant Adam

On Jan 14, 2022, at 6:01 AM, ronswift2 @.***> wrote:



It is correct that the issue appears when external candidates apply and the resume is not parsed and added to the applicant file. We have also attempted to add the resume to the new applicant file on the back-end as an administrator and that also fails but does not generate an error. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Friday, January 14, 2022 12:31:35 AM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Zommiest2,

While the project tends to develop in an ad hoc fashion with multiple community member input sources with an attempt to deliver best of the product’s requirements, some minor and others major, like security and underlying tech upgrades, we do our best with limited resources to validate and verify the functional aspect of the application.

On the flip side, an open source project strives because of its supporting patrons. We certainly appreciate for our active community to reporting on their both good experiences and not so good encountered issues. It certainly is very helpful to have insightful eyes from our users for the betterment of the product.

My understanding, based on my offline chat with Ron, the issue is encountered with external applicants while using the external application user interface to apply for jobs. The problem is indeed related with the resume not being parsed/rendered as expected. However, the cadidate profile is being created successfully.

I have foreseen to invest some time to investigate the latest release around this issue with an attempt to pinpoint the causing factor. However, I will ask that we patient till this weekend. Thank you.

Regards, Shant Adam

On Jan 13, 2022, at 7:34 AM, zoomiest2 @.***> wrote:

I also just tried to manually upload a single resume, and although the dialog box would accept the file name of the file I selected, it wouldn't add the resume to the database.

I just installed the new code from GitHub, and imported my own mysqldump backup.

Am I in the same boat as ronswift2?

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1012248638, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVLCA3XUCE3IKWTD23TUV3WITANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1012789024 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1013142451, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVIFL3SPA75WKADZGP3UWAUDXANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

shantadam commented 2 years ago

Hi Ron; Hi Zoomiest2,

Take note, after my voluntary attempt to squeeze-in time for the analysis of the issue in question over the weekend, between my overwhelming business and personal priorities, unfortunately, resulted in unsatisfying outcome.

After all, I figured it’s best to keep you in the loop and not hold you on a string. The latter investigation matter will require more time, at this stage of the analysis, I’m certain that I can’t promise an immediate result from my end.

Your kind understanding is highly appreciated. Thank you.

Regards, Shant Adam

From: Shant Adam @.> Date: Friday, January 14, 2022 at 12:44 PM To: opencats/OpenCATS @.> Cc: opencats/OpenCATS @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) I’m taking note of the issue around a candidate’s resume attachment. I will see over the weekend to investigate and report back. It’s a promise.

We’ve taken the app from 2021 to 2022 so far with multiple patches and upgrades, and I’m sure a little more stretch we’ll get it to be a more stable one. We’re appreciative of the interest demonstrated by the users community in the improvement of this wonderful unique product. Thank you.

Regards, Shant Adam

On Jan 14, 2022, at 6:01 AM, ronswift2 @.***> wrote:  It is correct that the issue appears when external candidates apply and the resume is not parsed and added to the applicant file. We have also attempted to add the resume to the new applicant file on the back-end as an administrator and that also fails but does not generate an error. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Friday, January 14, 2022 12:31:35 AM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Zommiest2,

While the project tends to develop in an ad hoc fashion with multiple community member input sources with an attempt to deliver best of the product’s requirements, some minor and others major, like security and underlying tech upgrades, we do our best with limited resources to validate and verify the functional aspect of the application.

On the flip side, an open source project strives because of its supporting patrons. We certainly appreciate for our active community to reporting on their both good experiences and not so good encountered issues. It certainly is very helpful to have insightful eyes from our users for the betterment of the product.

My understanding, based on my offline chat with Ron, the issue is encountered with external applicants while using the external application user interface to apply for jobs. The problem is indeed related with the resume not being parsed/rendered as expected. However, the cadidate profile is being created successfully.

I have foreseen to invest some time to investigate the latest release around this issue with an attempt to pinpoint the causing factor. However, I will ask that we patient till this weekend. Thank you.

Regards, Shant Adam

On Jan 13, 2022, at 7:34 AM, zoomiest2 @.***> wrote:

I also just tried to manually upload a single resume, and although the dialog box would accept the file name of the file I selected, it wouldn't add the resume to the database.

I just installed the new code from GitHub, and imported my own mysqldump backup.

Am I in the same boat as ronswift2?

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1012248638, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVLCA3XUCE3IKWTD23TUV3WITANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1012789024 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1013142451, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVIFL3SPA75WKADZGP3UWAUDXANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

ronswift2 commented 2 years ago

What if any next steps are planned. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Monday, January 17, 2022 1:05:12 AM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Ron; Hi Zoomiest2,

Take note, after my voluntary attempt to squeeze-in time for the analysis of the issue in question over the weekend, between my overwhelming business and personal priorities, unfortunately, resulted in unsatisfying outcome.

After all, I figured it’s best to keep you in the loop and not hold you on a string. The latter investigation matter will require more time, at this stage of the analysis, I’m certain that I can’t promise an immediate result from my end.

Your kind understanding is highly appreciated. Thank you.

Regards, Shant Adam

From: Shant Adam @.> Date: Friday, January 14, 2022 at 12:44 PM To: opencats/OpenCATS @.> Cc: opencats/OpenCATS @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) I’m taking note of the issue around a candidate’s resume attachment. I will see over the weekend to investigate and report back. It’s a promise.

We’ve taken the app from 2021 to 2022 so far with multiple patches and upgrades, and I’m sure a little more stretch we’ll get it to be a more stable one. We’re appreciative of the interest demonstrated by the users community in the improvement of this wonderful unique product. Thank you.

Regards, Shant Adam

On Jan 14, 2022, at 6:01 AM, ronswift2 @.***> wrote:

It is correct that the issue appears when external candidates apply and the resume is not parsed and added to the applicant file. We have also attempted to add the resume to the new applicant file on the back-end as an administrator and that also fails but does not generate an error. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Friday, January 14, 2022 12:31:35 AM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Zommiest2,

While the project tends to develop in an ad hoc fashion with multiple community member input sources with an attempt to deliver best of the product’s requirements, some minor and others major, like security and underlying tech upgrades, we do our best with limited resources to validate and verify the functional aspect of the application.

On the flip side, an open source project strives because of its supporting patrons. We certainly appreciate for our active community to reporting on their both good experiences and not so good encountered issues. It certainly is very helpful to have insightful eyes from our users for the betterment of the product.

My understanding, based on my offline chat with Ron, the issue is encountered with external applicants while using the external application user interface to apply for jobs. The problem is indeed related with the resume not being parsed/rendered as expected. However, the cadidate profile is being created successfully.

I have foreseen to invest some time to investigate the latest release around this issue with an attempt to pinpoint the causing factor. However, I will ask that we patient till this weekend. Thank you.

Regards, Shant Adam

On Jan 13, 2022, at 7:34 AM, zoomiest2 @.***> wrote:

I also just tried to manually upload a single resume, and although the dialog box would accept the file name of the file I selected, it wouldn't add the resume to the database.

I just installed the new code from GitHub, and imported my own mysqldump backup.

Am I in the same boat as ronswift2?

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1012248638, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVLCA3XUCE3IKWTD23TUV3WITANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1012789024 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1013142451, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVIFL3SPA75WKADZGP3UWAUDXANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1014169916 @ github . com>

shantadam commented 2 years ago

Glad to hear back from you, Ron.

Not to be discouraged. My email was simply to keep you in the loop of my progress.

My initial analysis was not satisfactory enough for me and it required more time off my plate.

However, let’s not drop hopes, I will invest time throughout this week, as time permits, to see a resolution to this blocker issue. Let’s aim till end of this upcoming weekend. Would this ease some concerns?

Regards, Shant Adam

From: ronswift2 @.> Date: Monday, January 17, 2022 at 1:12 PM To: opencats/OpenCATS @.> Cc: Shant Adam @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) What if any next steps are planned. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Monday, January 17, 2022 1:05:12 AM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Ron; Hi Zoomiest2,

Take note, after my voluntary attempt to squeeze-in time for the analysis of the issue in question over the weekend, between my overwhelming business and personal priorities, unfortunately, resulted in unsatisfying outcome.

After all, I figured it’s best to keep you in the loop and not hold you on a string. The latter investigation matter will require more time, at this stage of the analysis, I’m certain that I can’t promise an immediate result from my end.

Your kind understanding is highly appreciated. Thank you.

Regards, Shant Adam

From: Shant Adam @.> Date: Friday, January 14, 2022 at 12:44 PM To: opencats/OpenCATS @.> Cc: opencats/OpenCATS @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) I’m taking note of the issue around a candidate’s resume attachment. I will see over the weekend to investigate and report back. It’s a promise.

We’ve taken the app from 2021 to 2022 so far with multiple patches and upgrades, and I’m sure a little more stretch we’ll get it to be a more stable one. We’re appreciative of the interest demonstrated by the users community in the improvement of this wonderful unique product. Thank you.

Regards, Shant Adam

On Jan 14, 2022, at 6:01 AM, ronswift2 @.***> wrote:

It is correct that the issue appears when external candidates apply and the resume is not parsed and added to the applicant file. We have also attempted to add the resume to the new applicant file on the back-end as an administrator and that also fails but does not generate an error. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Friday, January 14, 2022 12:31:35 AM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Zommiest2,

While the project tends to develop in an ad hoc fashion with multiple community member input sources with an attempt to deliver best of the product’s requirements, some minor and others major, like security and underlying tech upgrades, we do our best with limited resources to validate and verify the functional aspect of the application.

On the flip side, an open source project strives because of its supporting patrons. We certainly appreciate for our active community to reporting on their both good experiences and not so good encountered issues. It certainly is very helpful to have insightful eyes from our users for the betterment of the product.

My understanding, based on my offline chat with Ron, the issue is encountered with external applicants while using the external application user interface to apply for jobs. The problem is indeed related with the resume not being parsed/rendered as expected. However, the cadidate profile is being created successfully.

I have foreseen to invest some time to investigate the latest release around this issue with an attempt to pinpoint the causing factor. However, I will ask that we patient till this weekend. Thank you.

Regards, Shant Adam

On Jan 13, 2022, at 7:34 AM, zoomiest2 @.***> wrote:

I also just tried to manually upload a single resume, and although the dialog box would accept the file name of the file I selected, it wouldn't add the resume to the database.

I just installed the new code from GitHub, and imported my own mysqldump backup.

Am I in the same boat as ronswift2?

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1012248638, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVLCA3XUCE3IKWTD23TUV3WITANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1012789024 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1013142451, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVIFL3SPA75WKADZGP3UWAUDXANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1014169916 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1014888581, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVOFE3DAWLP6D626SB3UWSA23ANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

ronswift2 commented 2 years ago

Thanks that addresses my concerns. One thing that I have noticed is that the system is adding a .txt extension to uploaded resume files with (doc, docx, pdf or rtl) extensions. That is strange behavior. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Monday, January 17, 2022 4:50:42 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Glad to hear back from you, Ron.

Not to be discouraged. My email was simply to keep you in the loop of my progress.

My initial analysis was not satisfactory enough for me and it required more time off my plate.

However, let’s not drop hopes, I will invest time throughout this week, as time permits, to see a resolution to this blocker issue. Let’s aim till end of this upcoming weekend. Would this ease some concerns?

Regards, Shant Adam

From: ronswift2 @.> Date: Monday, January 17, 2022 at 1:12 PM To: opencats/OpenCATS @.> Cc: Shant Adam @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) What if any next steps are planned. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Monday, January 17, 2022 1:05:12 AM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Ron; Hi Zoomiest2,

Take note, after my voluntary attempt to squeeze-in time for the analysis of the issue in question over the weekend, between my overwhelming business and personal priorities, unfortunately, resulted in unsatisfying outcome.

After all, I figured it’s best to keep you in the loop and not hold you on a string. The latter investigation matter will require more time, at this stage of the analysis, I’m certain that I can’t promise an immediate result from my end.

Your kind understanding is highly appreciated. Thank you.

Regards, Shant Adam

From: Shant Adam @.> Date: Friday, January 14, 2022 at 12:44 PM To: opencats/OpenCATS @.> Cc: opencats/OpenCATS @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) I’m taking note of the issue around a candidate’s resume attachment. I will see over the weekend to investigate and report back. It’s a promise.

We’ve taken the app from 2021 to 2022 so far with multiple patches and upgrades, and I’m sure a little more stretch we’ll get it to be a more stable one. We’re appreciative of the interest demonstrated by the users community in the improvement of this wonderful unique product. Thank you.

Regards, Shant Adam

On Jan 14, 2022, at 6:01 AM, ronswift2 @.***> wrote:

It is correct that the issue appears when external candidates apply and the resume is not parsed and added to the applicant file. We have also attempted to add the resume to the new applicant file on the back-end as an administrator and that also fails but does not generate an error. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Friday, January 14, 2022 12:31:35 AM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Zommiest2,

While the project tends to develop in an ad hoc fashion with multiple community member input sources with an attempt to deliver best of the product’s requirements, some minor and others major, like security and underlying tech upgrades, we do our best with limited resources to validate and verify the functional aspect of the application.

On the flip side, an open source project strives because of its supporting patrons. We certainly appreciate for our active community to reporting on their both good experiences and not so good encountered issues. It certainly is very helpful to have insightful eyes from our users for the betterment of the product.

My understanding, based on my offline chat with Ron, the issue is encountered with external applicants while using the external application user interface to apply for jobs. The problem is indeed related with the resume not being parsed/rendered as expected. However, the cadidate profile is being created successfully.

I have foreseen to invest some time to investigate the latest release around this issue with an attempt to pinpoint the causing factor. However, I will ask that we patient till this weekend. Thank you.

Regards, Shant Adam

On Jan 13, 2022, at 7:34 AM, zoomiest2 @.***> wrote:

I also just tried to manually upload a single resume, and although the dialog box would accept the file name of the file I selected, it wouldn't add the resume to the database.

I just installed the new code from GitHub, and imported my own mysqldump backup.

Am I in the same boat as ronswift2?

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1012248638, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVLCA3XUCE3IKWTD23TUV3WITANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1012789024 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1013142451, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVIFL3SPA75WKADZGP3UWAUDXANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1014169916 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1014888581, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVOFE3DAWLP6D626SB3UWSA23ANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1014909950 @ github . com>

ronswift2 commented 2 years ago

Attached are the resume files that were uploaded to the server and not applied to the database. They all have a txt extension added and some were php files with dubious content. I thought that this might be helpful in looking at the problem. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Monday, January 17, 2022 4:50:42 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Glad to hear back from you, Ron.

Not to be discouraged. My email was simply to keep you in the loop of my progress.

My initial analysis was not satisfactory enough for me and it required more time off my plate.

However, let’s not drop hopes, I will invest time throughout this week, as time permits, to see a resolution to this blocker issue. Let’s aim till end of this upcoming weekend. Would this ease some concerns?

Regards, Shant Adam

From: ronswift2 @.> Date: Monday, January 17, 2022 at 1:12 PM To: opencats/OpenCATS @.> Cc: Shant Adam @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) What if any next steps are planned. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Monday, January 17, 2022 1:05:12 AM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Ron; Hi Zoomiest2,

Take note, after my voluntary attempt to squeeze-in time for the analysis of the issue in question over the weekend, between my overwhelming business and personal priorities, unfortunately, resulted in unsatisfying outcome.

After all, I figured it’s best to keep you in the loop and not hold you on a string. The latter investigation matter will require more time, at this stage of the analysis, I’m certain that I can’t promise an immediate result from my end.

Your kind understanding is highly appreciated. Thank you.

Regards, Shant Adam

From: Shant Adam @.> Date: Friday, January 14, 2022 at 12:44 PM To: opencats/OpenCATS @.> Cc: opencats/OpenCATS @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) I’m taking note of the issue around a candidate’s resume attachment. I will see over the weekend to investigate and report back. It’s a promise.

We’ve taken the app from 2021 to 2022 so far with multiple patches and upgrades, and I’m sure a little more stretch we’ll get it to be a more stable one. We’re appreciative of the interest demonstrated by the users community in the improvement of this wonderful unique product. Thank you.

Regards, Shant Adam

On Jan 14, 2022, at 6:01 AM, ronswift2 @.***> wrote:

It is correct that the issue appears when external candidates apply and the resume is not parsed and added to the applicant file. We have also attempted to add the resume to the new applicant file on the back-end as an administrator and that also fails but does not generate an error. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Friday, January 14, 2022 12:31:35 AM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Zommiest2,

While the project tends to develop in an ad hoc fashion with multiple community member input sources with an attempt to deliver best of the product’s requirements, some minor and others major, like security and underlying tech upgrades, we do our best with limited resources to validate and verify the functional aspect of the application.

On the flip side, an open source project strives because of its supporting patrons. We certainly appreciate for our active community to reporting on their both good experiences and not so good encountered issues. It certainly is very helpful to have insightful eyes from our users for the betterment of the product.

My understanding, based on my offline chat with Ron, the issue is encountered with external applicants while using the external application user interface to apply for jobs. The problem is indeed related with the resume not being parsed/rendered as expected. However, the cadidate profile is being created successfully.

I have foreseen to invest some time to investigate the latest release around this issue with an attempt to pinpoint the causing factor. However, I will ask that we patient till this weekend. Thank you.

Regards, Shant Adam

On Jan 13, 2022, at 7:34 AM, zoomiest2 @.***> wrote:

I also just tried to manually upload a single resume, and although the dialog box would accept the file name of the file I selected, it wouldn't add the resume to the database.

I just installed the new code from GitHub, and imported my own mysqldump backup.

Am I in the same boat as ronswift2?

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1012248638, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVLCA3XUCE3IKWTD23TUV3WITANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1012789024 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1013142451, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVIFL3SPA75WKADZGP3UWAUDXANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1014169916 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1014888581, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVOFE3DAWLP6D626SB3UWSA23ANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1014909950 @ github . com>

ronswift2 commented 2 years ago

Please provide an update on this issue. We may need to move to another platform if we can not get this resolved soon. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Monday, January 17, 2022 4:50:42 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Glad to hear back from you, Ron.

Not to be discouraged. My email was simply to keep you in the loop of my progress.

My initial analysis was not satisfactory enough for me and it required more time off my plate.

However, let’s not drop hopes, I will invest time throughout this week, as time permits, to see a resolution to this blocker issue. Let’s aim till end of this upcoming weekend. Would this ease some concerns?

Regards, Shant Adam

From: ronswift2 @.> Date: Monday, January 17, 2022 at 1:12 PM To: opencats/OpenCATS @.> Cc: Shant Adam @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) What if any next steps are planned. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Monday, January 17, 2022 1:05:12 AM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Ron; Hi Zoomiest2,

Take note, after my voluntary attempt to squeeze-in time for the analysis of the issue in question over the weekend, between my overwhelming business and personal priorities, unfortunately, resulted in unsatisfying outcome.

After all, I figured it’s best to keep you in the loop and not hold you on a string. The latter investigation matter will require more time, at this stage of the analysis, I’m certain that I can’t promise an immediate result from my end.

Your kind understanding is highly appreciated. Thank you.

Regards, Shant Adam

From: Shant Adam @.> Date: Friday, January 14, 2022 at 12:44 PM To: opencats/OpenCATS @.> Cc: opencats/OpenCATS @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) I’m taking note of the issue around a candidate’s resume attachment. I will see over the weekend to investigate and report back. It’s a promise.

We’ve taken the app from 2021 to 2022 so far with multiple patches and upgrades, and I’m sure a little more stretch we’ll get it to be a more stable one. We’re appreciative of the interest demonstrated by the users community in the improvement of this wonderful unique product. Thank you.

Regards, Shant Adam

On Jan 14, 2022, at 6:01 AM, ronswift2 @.***> wrote:

It is correct that the issue appears when external candidates apply and the resume is not parsed and added to the applicant file. We have also attempted to add the resume to the new applicant file on the back-end as an administrator and that also fails but does not generate an error. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Friday, January 14, 2022 12:31:35 AM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Zommiest2,

While the project tends to develop in an ad hoc fashion with multiple community member input sources with an attempt to deliver best of the product’s requirements, some minor and others major, like security and underlying tech upgrades, we do our best with limited resources to validate and verify the functional aspect of the application.

On the flip side, an open source project strives because of its supporting patrons. We certainly appreciate for our active community to reporting on their both good experiences and not so good encountered issues. It certainly is very helpful to have insightful eyes from our users for the betterment of the product.

My understanding, based on my offline chat with Ron, the issue is encountered with external applicants while using the external application user interface to apply for jobs. The problem is indeed related with the resume not being parsed/rendered as expected. However, the cadidate profile is being created successfully.

I have foreseen to invest some time to investigate the latest release around this issue with an attempt to pinpoint the causing factor. However, I will ask that we patient till this weekend. Thank you.

Regards, Shant Adam

On Jan 13, 2022, at 7:34 AM, zoomiest2 @.***> wrote:

I also just tried to manually upload a single resume, and although the dialog box would accept the file name of the file I selected, it wouldn't add the resume to the database.

I just installed the new code from GitHub, and imported my own mysqldump backup.

Am I in the same boat as ronswift2?

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1012248638, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVLCA3XUCE3IKWTD23TUV3WITANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1012789024 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1013142451, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVIFL3SPA75WKADZGP3UWAUDXANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1014169916 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1014888581, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVOFE3DAWLP6D626SB3UWSA23ANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1014909950 @ github . com>

shantadam commented 2 years ago

Dear Ron,

After all, I’m afraid to inform you that an immediate solution is not possible at the time being. Thank you.

Regards, Shant Adam

From: ronswift2 @.> Date: Tuesday, January 25, 2022 at 9:00 AM To: opencats/OpenCATS @.> Cc: Shant Adam @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) Please provide an update on this issue. We may need to move to another platform if we can not get this resolved soon. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Monday, January 17, 2022 4:50:42 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Glad to hear back from you, Ron.

Not to be discouraged. My email was simply to keep you in the loop of my progress.

My initial analysis was not satisfactory enough for me and it required more time off my plate.

However, let’s not drop hopes, I will invest time throughout this week, as time permits, to see a resolution to this blocker issue. Let’s aim till end of this upcoming weekend. Would this ease some concerns?

Regards, Shant Adam

From: ronswift2 @.> Date: Monday, January 17, 2022 at 1:12 PM To: opencats/OpenCATS @.> Cc: Shant Adam @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) What if any next steps are planned. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Monday, January 17, 2022 1:05:12 AM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Ron; Hi Zoomiest2,

Take note, after my voluntary attempt to squeeze-in time for the analysis of the issue in question over the weekend, between my overwhelming business and personal priorities, unfortunately, resulted in unsatisfying outcome.

After all, I figured it’s best to keep you in the loop and not hold you on a string. The latter investigation matter will require more time, at this stage of the analysis, I’m certain that I can’t promise an immediate result from my end.

Your kind understanding is highly appreciated. Thank you.

Regards, Shant Adam

From: Shant Adam @.> Date: Friday, January 14, 2022 at 12:44 PM To: opencats/OpenCATS @.> Cc: opencats/OpenCATS @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) I’m taking note of the issue around a candidate’s resume attachment. I will see over the weekend to investigate and report back. It’s a promise.

We’ve taken the app from 2021 to 2022 so far with multiple patches and upgrades, and I’m sure a little more stretch we’ll get it to be a more stable one. We’re appreciative of the interest demonstrated by the users community in the improvement of this wonderful unique product. Thank you.

Regards, Shant Adam

On Jan 14, 2022, at 6:01 AM, ronswift2 @.***> wrote:

It is correct that the issue appears when external candidates apply and the resume is not parsed and added to the applicant file. We have also attempted to add the resume to the new applicant file on the back-end as an administrator and that also fails but does not generate an error. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Friday, January 14, 2022 12:31:35 AM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Zommiest2,

While the project tends to develop in an ad hoc fashion with multiple community member input sources with an attempt to deliver best of the product’s requirements, some minor and others major, like security and underlying tech upgrades, we do our best with limited resources to validate and verify the functional aspect of the application.

On the flip side, an open source project strives because of its supporting patrons. We certainly appreciate for our active community to reporting on their both good experiences and not so good encountered issues. It certainly is very helpful to have insightful eyes from our users for the betterment of the product.

My understanding, based on my offline chat with Ron, the issue is encountered with external applicants while using the external application user interface to apply for jobs. The problem is indeed related with the resume not being parsed/rendered as expected. However, the cadidate profile is being created successfully.

I have foreseen to invest some time to investigate the latest release around this issue with an attempt to pinpoint the causing factor. However, I will ask that we patient till this weekend. Thank you.

Regards, Shant Adam

On Jan 13, 2022, at 7:34 AM, zoomiest2 @.***> wrote:

I also just tried to manually upload a single resume, and although the dialog box would accept the file name of the file I selected, it wouldn't add the resume to the database.

I just installed the new code from GitHub, and imported my own mysqldump backup.

Am I in the same boat as ronswift2?

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1012248638, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVLCA3XUCE3IKWTD23TUV3WITANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1012789024 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1013142451, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVIFL3SPA75WKADZGP3UWAUDXANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1014169916 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1014888581, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVOFE3DAWLP6D626SB3UWSA23ANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1014909950 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1021406253, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVPH3CGGS5NVR5BJC2LUX3JKLANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

ronswift2 commented 2 years ago

I appreciate your support and follow up. Thanks

Ron Swift President 410-788-7011

Celebrating 33 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Tuesday, January 25, 2022 2:20:46 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Dear Ron,

After all, I’m afraid to inform you that an immediate solution is not possible at the time being. Thank you.

Regards, Shant Adam

From: ronswift2 @.> Date: Tuesday, January 25, 2022 at 9:00 AM To: opencats/OpenCATS @.> Cc: Shant Adam @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) Please provide an update on this issue. We may need to move to another platform if we can not get this resolved soon. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Monday, January 17, 2022 4:50:42 PM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Glad to hear back from you, Ron.

Not to be discouraged. My email was simply to keep you in the loop of my progress.

My initial analysis was not satisfactory enough for me and it required more time off my plate.

However, let’s not drop hopes, I will invest time throughout this week, as time permits, to see a resolution to this blocker issue. Let’s aim till end of this upcoming weekend. Would this ease some concerns?

Regards, Shant Adam

From: ronswift2 @.> Date: Monday, January 17, 2022 at 1:12 PM To: opencats/OpenCATS @.> Cc: Shant Adam @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) What if any next steps are planned. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Monday, January 17, 2022 1:05:12 AM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Ron; Hi Zoomiest2,

Take note, after my voluntary attempt to squeeze-in time for the analysis of the issue in question over the weekend, between my overwhelming business and personal priorities, unfortunately, resulted in unsatisfying outcome.

After all, I figured it’s best to keep you in the loop and not hold you on a string. The latter investigation matter will require more time, at this stage of the analysis, I’m certain that I can’t promise an immediate result from my end.

Your kind understanding is highly appreciated. Thank you.

Regards, Shant Adam

From: Shant Adam @.> Date: Friday, January 14, 2022 at 12:44 PM To: opencats/OpenCATS @.> Cc: opencats/OpenCATS @.>, Comment @.> Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558) I’m taking note of the issue around a candidate’s resume attachment. I will see over the weekend to investigate and report back. It’s a promise.

We’ve taken the app from 2021 to 2022 so far with multiple patches and upgrades, and I’m sure a little more stretch we’ll get it to be a more stable one. We’re appreciative of the interest demonstrated by the users community in the improvement of this wonderful unique product. Thank you.

Regards, Shant Adam

On Jan 14, 2022, at 6:01 AM, ronswift2 @.***> wrote:

It is correct that the issue appears when external candidates apply and the resume is not parsed and added to the applicant file. We have also attempted to add the resume to the new applicant file on the back-end as an administrator and that also fails but does not generate an error. Thanks

Ron Swift President 410-788-7011

Celebrating 32 years in business, 1989 - Present "Staffing, IT Services and Web Development" Certified Minority Business Enterprise by the State of MD (MDOT) and Baltimore City

From: "notifications" @.> To: "opencats/OpenCATS" @.> Cc: "Ron Swift" @.>, "Author" @.> Sent: Friday, January 14, 2022 12:31:35 AM Subject: Re: [opencats/OpenCATS] Resumes not uploading (Issue #558)

Hi Zommiest2,

While the project tends to develop in an ad hoc fashion with multiple community member input sources with an attempt to deliver best of the product’s requirements, some minor and others major, like security and underlying tech upgrades, we do our best with limited resources to validate and verify the functional aspect of the application.

On the flip side, an open source project strives because of its supporting patrons. We certainly appreciate for our active community to reporting on their both good experiences and not so good encountered issues. It certainly is very helpful to have insightful eyes from our users for the betterment of the product.

My understanding, based on my offline chat with Ron, the issue is encountered with external applicants while using the external application user interface to apply for jobs. The problem is indeed related with the resume not being parsed/rendered as expected. However, the cadidate profile is being created successfully.

I have foreseen to invest some time to investigate the latest release around this issue with an attempt to pinpoint the causing factor. However, I will ask that we patient till this weekend. Thank you.

Regards, Shant Adam

On Jan 13, 2022, at 7:34 AM, zoomiest2 @.***> wrote:

I also just tried to manually upload a single resume, and although the dialog box would accept the file name of the file I selected, it wouldn't add the resume to the database.

I just installed the new code from GitHub, and imported my own mysqldump backup.

Am I in the same boat as ronswift2?

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1012248638, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVLCA3XUCE3IKWTD23TUV3WITANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1012789024 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1013142451, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVIFL3SPA75WKADZGP3UWAUDXANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1014169916 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1014888581, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVOFE3DAWLP6D626SB3UWSA23ANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1014909950 @ github . com>

— Reply to this email directly, view it on GitHubhttps://github.com/opencats/OpenCATS/issues/558#issuecomment-1021406253, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AA53AVPH3CGGS5NVR5BJC2LUX3JKLANCNFSM5K5AWZ6A. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub , or unsubscribe . Triage notifications on the go with GitHub Mobile for iOS or Android . You are receiving this because you authored the thread. Message ID: <opencats/OpenCATS/issues/558/1021526545 @ github . com>

RussH commented 2 years ago

So - I have installed and run version 0.9.4 and it's working as expected (uploads work fine). I'll source v0.9.4-3 and see if the security patch disrupted the functionality. The v0.9.4-3 security patch was to address an exploit specifically for resume uploads via the career portal, so it's the most likely culprit.

RussH commented 2 years ago

Hi @ronswift2 I've tested 0.9.6 from releases in the docker image and this works but there are a few permissions problems that need to be amended due to how docker is working - so if you check these facets in your installation you'll find the problem you have, too

Firstly - make sure you have the extras (PDFtoTEXT, etc) installed, and the path to them is correct in config.php check what users apache is running as, (usually www-data) and chown the upload and attachments directories to the same www-data:www-data

(quick and dirty fix in docker-test as docker apache is running as root - make all the files owned by root, and chmod 777 for attachments and upload.. DO NOT DO THIS ON ANYTHING BUT A TEST SYSTEM!)

This has the effect in a standard docker deployment of 0.9.6 of allowing resume upload and attachments when applying for the vacancies.

you can see the application in activities tab

image