There appears to be no way to create a new source without triggering the "You are not welcome here" error.
I am running a version of PhpGedView that would have been the latest as of May 2019, on a localhost server with PHP 7.3.4. I can get going again by deleting the one row that appears in the pgv_ip_address table, but the error just comes back when I try to create the new source again.
Two questions:
1) How can I disable the test for "You are not welcome here" completely? I'm the only user of a local server, so there is no security threat at all.
2) Would installing the latest SVN version fix this?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Of course, after posting this I tried a couple of other things that did allow me to create the new source. I stopped and restarted the server, then managed to create a new source with the title "test" and then changed the title to the much longer name that I really wanted.
I don't know which of the things that I tried worked, but I would still be interested to know the answers to my original questions.
Last edit: Neil Sponagle 2020-04-03
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Look in the PhpGedView log file. There should be an error message. Certain keywords trigger the SQL injection, which is what you have encountered. Also, if you have Autocomplete enabled, you might trigger the error. (I don't like Autocomplete -- it slows things down significantly.)
Exactly which text did you try to enter? You can e-mail me the log file (don't post it here)., and I'll have a look.
e-mail: gkroll (at) keldine (dot) ca
You should really upgrade PhpgedView to the SVN version (not sure thast this would cure your problem, though). Click on "SVN" at the top of this page and follow the links. You need the "trunk" path. Download the SVN snapshot and unzip on your local computer.
Launch PhpGedView and export the database to a GEDCOM file. No need to download the exported GEDCOM file.
Delete everything in the server's directory where PhpGedView is installed, EXCEPT: file config.php, entire directory /media and entire directory /index. Then upload the extracted SVN snapshot, but not directory /index and directory /media. There is no config.php file in the snapshot. That way, you have an updated installation with the old config.php file and the old data directories with their contents.
Launch PhpGedView, sign in as Admin, and immediately import the previously exported GEDCOM file. Be sure to let PhpGedView delete the database contents, but DO NOT keep media links. This will re-build the indexes. The "keep media links" option is in there to cater to incoming GEDCOMs that don't contain media information. PhpGedView's exported GEDCOM contains all the necessary media stuff.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
There appears to be no way to create a new source without triggering the "You are not welcome here" error.
I am running a version of PhpGedView that would have been the latest as of May 2019, on a localhost server with PHP 7.3.4. I can get going again by deleting the one row that appears in the pgv_ip_address table, but the error just comes back when I try to create the new source again.
Two questions:
1) How can I disable the test for "You are not welcome here" completely? I'm the only user of a local server, so there is no security threat at all.
2) Would installing the latest SVN version fix this?
Of course, after posting this I tried a couple of other things that did allow me to create the new source. I stopped and restarted the server, then managed to create a new source with the title "test" and then changed the title to the much longer name that I really wanted.
I don't know which of the things that I tried worked, but I would still be interested to know the answers to my original questions.
Last edit: Neil Sponagle 2020-04-03
Look in the PhpGedView log file. There should be an error message. Certain keywords trigger the SQL injection, which is what you have encountered. Also, if you have Autocomplete enabled, you might trigger the error. (I don't like Autocomplete -- it slows things down significantly.)
Exactly which text did you try to enter? You can e-mail me the log file (don't post it here)., and I'll have a look.
e-mail: gkroll (at) keldine (dot) ca
You should really upgrade PhpgedView to the SVN version (not sure thast this would cure your problem, though). Click on "SVN" at the top of this page and follow the links. You need the "trunk" path. Download the SVN snapshot and unzip on your local computer.
Launch PhpGedView and export the database to a GEDCOM file. No need to download the exported GEDCOM file.
Delete everything in the server's directory where PhpGedView is installed, EXCEPT: file config.php, entire directory /media and entire directory /index. Then upload the extracted SVN snapshot, but not directory /index and directory /media. There is no config.php file in the snapshot. That way, you have an updated installation with the old config.php file and the old data directories with their contents.
Launch PhpGedView, sign in as Admin, and immediately import the previously exported GEDCOM file. Be sure to let PhpGedView delete the database contents, but DO NOT keep media links. This will re-build the indexes. The "keep media links" option is in there to cater to incoming GEDCOMs that don't contain media information. PhpGedView's exported GEDCOM contains all the necessary media stuff.
The title was "New Waterford and Area Cemetery Society".
You should have received a message with the contents of the log file pgv-202004.log.