Upgrading from a fully working version of PGV 4.1.6 to 4.2.3, following upgrade instructions to the letter results in what appears to be a fully working upgraded site, except an installation wizard dialog keeps appearing in random places - sometime but not always on home page, other times under various tab headings for individuals - eg "tree: tab.
Activating installation wizard, with config.php unlocked results in warnings at step 1
"Checking for ability to change timelimit:
Unable to change time limit.
You may not be able to run all functions on large databases with many individuals.
Your maximum time limit is 10
Checking for ability to change memory limit:
Unable to change memory limit.You may not be able to run all functions on large databases with many individuals.
Your current memory limit is 24M"
Then at step 2, I get "Your current database configuration is bad. Please check your database connection parameters and configure again.
SQLSTATE Access denied for user 'b13_368692'@'192.168.0.115' (using password: YES) "
The database settings are what were correct and working for PGV 4.1.6
If I bypass this step and click on step 6, save configuration, the website freezes with message "website unavailable", and step 7 generates "Fatal error: Uncaught exception 'PDOException' with message 'No Connection Established'.
My server supports:
PHP version 5.2.10
and MySQL version 5.0.84
Any help most appreciated!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
> The database settings are what were correct and working
Did your browser "helpfully" fill in the DB password field for you? I find that FF tends to insert my PGV user login password on this form, overwriting the DB password. (The different number of asterisks is the only giveaway). Check what has been saved in your config.php file.
If PGV cannot connect to the DB, it redirects to the install wizard. The install wizard checks to see if it has been previously configured. If it has, you get a "site down" message. If it hasn't, you go through the installation steps.
If you're being sent to the wizard, then either $CONFIGURED has been set back to false in config.php, or all the admin users have been deleted.
10 seconds and 24MB are quite low limits. Can you increase them? We normally recommend 32MB as the minimum memory limit.
Perhaps (clutching at straws), PGV is running out of memory, and failing to update config.php properly?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You were right on the nail! - the previously working database password was being "helpfully" overwritten by the browser.
Yes those limits do seem low, but are the maximum allowed by Byethost.com under their free hosting plan. Luckily, my database is still pretty small & I have few active users - though very frustrating not being able to use the automatic backup to zip function due to the memory limit (at least if media files are included)
For cheapskates like myself, would be great if there was a another low memory zipping algorithm possible, even if slower.?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Oh Uh! - problem has not fully resolved - even though I can successfully complet the configuration wizard & tables are successfully generated & configuration is saved, when I log back in, I am still always presented with the installation wizard again. If I again "successfully" complete it again, the problem still recurs next time I log in.
Something seems not to be "taking"!
Cheers
Paul
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Permissions on the Config.php? Open it in a text editor and see if the data is preserved. Probably not. Must be 777 for setup, then after configured, OK to change to 444.
-Stephen
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi - thanks - checked that, but still happens even when saving to a 777 config.php file. Config file on server contains the updated database log in info that works (or al least says it does when working through the wizard) - but this just doesn't seem to stop the wizard reappearing every time.
Text is pasted below - not sure if it holds any clues?:
<?php
/**
* Main configuration file required by all other files in PGV
*
* The variables in this file are the main configuration variable for the site
* Gedcom specific configuration variables are stored in the config_gedcom.php file.
* Site administrators may edit these settings online through the editconfig.php file.
*
* phpGedView: Genealogy Viewer
* Copyright (C) 2002 to 2003 John Finlay and Others
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*
* @package PhpGedView
* @subpackage Admin
* @see editconfig.php
* @version $Id: config.dist 2091 2007-10-30 16:19:34Z yalnifj $
*/
if (preg_match("/\Wconfig.php/", $_SERVER)>0) {
print "Got your hand caught in the cookie jar.";
exit;
}
$DBTYPE='mysql'; //- type of database to connect when using the PEAR:DB module
$DBHOST='sql104.byethost13.com'; //- Host where MySQL database is kept
$DBUSER='b13_368692'; //- MySQL database User Name
$DBPASS='thipradr'; //- MySQL database User Password
$DBNAME='b13_368692_1'; //- The MySQL database name where you want PHPGedView to build its tables
$DBPERSIST=false; //- Use persistent database connections
$TBLPREFIX='pgv_'; //- prefix to include on table names
$INDEX_DIRECTORY='./index/'; //- Readable and Writeable Directory to store index files (include the trailing "/")
$AUTHENTICATION_MODULE = "authentication.php"; //- File that contains authentication functions
$PGV_STORE_MESSAGES=true; //- allow messages sent to users to be stored in the PGV system
$PGV_SIMPLE_MAIL=true; //- allow admins to set this so that they can override the name <emailaddress> combination in the emails
$USE_REGISTRATION_MODULE=true; //- turn on the user self registration module
$REQUIRE_ADMIN_AUTH_REGISTRATION=true; //- require an admin user to authorize a new registration before a user can login
$ALLOW_USER_THEMES=true; //- Allow user to set their own theme
$ALLOW_CHANGE_GEDCOM=true; //- A true value will provide a link in the footer to allow users to change the gedcom they are viewing
$LOGFILE_CREATE='monthly'; //- set how often new log files are created, "none" turns logs off, "daily", "weekly", "monthly", "yearly"
$LOG_LANG_ERROR = false; //- Set if non-existing language variables should be written to a logfile
$PGV_SESSION_SAVE_PATH=''; //- Path to save PHP session Files - DO NOT MODIFY unless you know what you are doing
//- leaving it blank will use the default path for your php configuration as found in php.ini
$PGV_SESSION_TIME='9999'; //- number of seconds to wait before an inactive session times out
$SERVER_URL='http://www.kingfamily.byethost13.com/'; //- the URL used to access this server
$LOGIN_URL=''; //- the URL to use to go to the login page, use this value if you want to redirect to a different site when users login, useful for switching from http to https
$MAX_VIEWS='20'; //- the maximum number of page views per xx seconds per session
$MAX_VIEW_TIME='1'; //- the number of seconds in which the maximum number of views must not be reached
$PGV_MEMORY_LIMIT='24M'; //- the maximum amount of memory that PGV should be allowed to consume
$ALLOW_REMEMBER_ME=true; //- whether the users have the option of being remembered on the current computer
$CONFIG_VERSION = "4.0"; //- the version this config file goes to
$DIRECTORY_MODE = "ldap"; //- User info stored in db or ldap directory
$COMMIT_COMMAND=''; //- Choices are empty string, cvs or svn
$DBPORT=''; // new config variable
$DB_UTF8_COLLATION=false; // new config variable
$PGV_SMTP_PORT='25'; // new config variable
$PGV_SMTP_ACTIVE=false; // new config variable
$PGV_SMTP_HOST=''; // new config variable
$PGV_SMTP_HELO=''; // new config variable
$PGV_SMTP_AUTH=false; // new config variable
$PGV_SMTP_AUTH_USER='admin'; // new config variable
$PGV_SMTP_AUTH_PASS='bomber'; // new config variable
$PGV_SMTP_SSL='none'; // new config variable
$PGV_SMTP_FROM_NAME=''; // new config variable
$CONFIGURED=true;
require_once("includes/session.php");
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Paul - I deleted your previous post. You had included your database username and password.
However, it will still have been sent to mailing lists and archives. You should change your DB password as soon as you can.
Before it went, I believe I saw $CONFIGURED=true at the end.
If you are being redirected to the install wizard, then either this variable is false, or you have no administration users. Are you able to look in the DB (e.g. using phpMyAdmin), and confirm whether a user exists in the pgv_users table with the "u_canadmin" column set to Y
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi - thanks fisharebest - I checked, and yes there are admin users showing in the table. I can also log in within PGV as administrator & do all the normal things - but something is still triggering that wizard every time log out & log in again (and yes, have tried clearing browser cache)
Cheers
Paul
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi again - I wonder if there is some kid of timeout while a check for a valid configuration is being done? I note the site takes 20 seconds or more to complete loading of the welcome page - probably a bit longer than under PGV 4.1.6 …?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Paul
Politely, find a new host. 24mb of memory in today's environment is teeny-weeny and PGV 4.2.3 will generally not perform in such an environment. While it may serve certain pages, searching, charts and reports will almost always hit the limit with any GEDCOM of significant size (+500 INDIs).
-Stephen
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi - So can I assume this is most likely caused by memory limnitation?
I did not strike this issue with PGV 4.1.6, so may need to downgrade software to less memory hungry version.
Which version is the most recent that would not struggle with the 24 M limitation?
Alternatively does anyone know of another host with larger memory limit for free hosting plans?
Not really worth paying to host a site visited almost exclusively by myself - with access by relatives maybe once or twice a year!
Cheers
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Paul
I would certainly not recommend a down-grade as the software has security holes and there are so many more features in 4.2+. If you are the primary user and load is quite small, why use a host at all? "Host" the site on your own computer. There are excellent all-in-one packages for installation of Apache/PHP/MySQL available for every platform. XAMPP, LAMPP, MAMP.
-Stephen
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
H i am trying a new host with larger memory limit (x10hosting.com) - but have struck same issue
phpgedview gives me "SQLSTATE Access denied for user…" on configuration wizard database screen. This time I checked & all database details & password do seem to correspond to the database settings on this host, but no luck.
What else might prevent successful access?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi - yes I created the database using the host ISP "cpanel" utility, and am carefully using the same database name, user name & password on PGV that I gave it on host.. I can access & nominally interrogate the database using host cpanel tools - though currently it is empty/ 0kb in size
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
One thing I am wondering about is the "PDO drivers" mentioned beside the link to the PGV installation guide - I searched high & low & found no mention of these on any documentation or Cpanel utility screens with the ISP. could this be the issue?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Upgrading from a fully working version of PGV 4.1.6 to 4.2.3, following upgrade instructions to the letter results in what appears to be a fully working upgraded site, except an installation wizard dialog keeps appearing in random places - sometime but not always on home page, other times under various tab headings for individuals - eg "tree: tab.
Activating installation wizard, with config.php unlocked results in warnings at step 1
"Checking for ability to change timelimit:
Unable to change time limit.
You may not be able to run all functions on large databases with many individuals.
Your maximum time limit is 10
Checking for ability to change memory limit:
Unable to change memory limit.You may not be able to run all functions on large databases with many individuals.
Your current memory limit is 24M"
Then at step 2, I get "Your current database configuration is bad. Please check your database connection parameters and configure again.
SQLSTATE Access denied for user 'b13_368692'@'192.168.0.115' (using password: YES) "
The database settings are what were correct and working for PGV 4.1.6
If I bypass this step and click on step 6, save configuration, the website freezes with message "website unavailable", and step 7 generates "Fatal error: Uncaught exception 'PDOException' with message 'No Connection Established'.
My server supports:
PHP version 5.2.10
and MySQL version 5.0.84
Any help most appreciated!
> The database settings are what were correct and working
Did your browser "helpfully" fill in the DB password field for you? I find that FF tends to insert my PGV user login password on this form, overwriting the DB password. (The different number of asterisks is the only giveaway). Check what has been saved in your config.php file.
If PGV cannot connect to the DB, it redirects to the install wizard. The install wizard checks to see if it has been previously configured. If it has, you get a "site down" message. If it hasn't, you go through the installation steps.
If you're being sent to the wizard, then either $CONFIGURED has been set back to false in config.php, or all the admin users have been deleted.
10 seconds and 24MB are quite low limits. Can you increase them? We normally recommend 32MB as the minimum memory limit.
Perhaps (clutching at straws), PGV is running out of memory, and failing to update config.php properly?
Hi Fisharebest
You were right on the nail! - the previously working database password was being "helpfully" overwritten by the browser.
Yes those limits do seem low, but are the maximum allowed by Byethost.com under their free hosting plan. Luckily, my database is still pretty small & I have few active users - though very frustrating not being able to use the automatic backup to zip function due to the memory limit (at least if media files are included)
For cheapskates like myself, would be great if there was a another low memory zipping algorithm possible, even if slower.?
Oh Uh! - problem has not fully resolved - even though I can successfully complet the configuration wizard & tables are successfully generated & configuration is saved, when I log back in, I am still always presented with the installation wizard again. If I again "successfully" complete it again, the problem still recurs next time I log in.
Something seems not to be "taking"!
Cheers
Paul
Permissions on the Config.php? Open it in a text editor and see if the data is preserved. Probably not. Must be 777 for setup, then after configured, OK to change to 444.
-Stephen
Hi - thanks - checked that, but still happens even when saving to a 777 config.php file. Config file on server contains the updated database log in info that works (or al least says it does when working through the wizard) - but this just doesn't seem to stop the wizard reappearing every time.
Text is pasted below - not sure if it holds any clues?:
<?php
/**
* Main configuration file required by all other files in PGV
*
* The variables in this file are the main configuration variable for the site
* Gedcom specific configuration variables are stored in the config_gedcom.php file.
* Site administrators may edit these settings online through the editconfig.php file.
*
* phpGedView: Genealogy Viewer
* Copyright (C) 2002 to 2003 John Finlay and Others
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*
* @package PhpGedView
* @subpackage Admin
* @see editconfig.php
* @version $Id: config.dist 2091 2007-10-30 16:19:34Z yalnifj $
*/
if (preg_match("/\Wconfig.php/", $_SERVER)>0) {
print "Got your hand caught in the cookie jar.";
exit;
}
$DBTYPE='mysql'; //- type of database to connect when using the PEAR:DB module
$DBHOST='sql104.byethost13.com'; //- Host where MySQL database is kept
$DBUSER='b13_368692'; //- MySQL database User Name
$DBPASS='thipradr'; //- MySQL database User Password
$DBNAME='b13_368692_1'; //- The MySQL database name where you want PHPGedView to build its tables
$DBPERSIST=false; //- Use persistent database connections
$TBLPREFIX='pgv_'; //- prefix to include on table names
$INDEX_DIRECTORY='./index/'; //- Readable and Writeable Directory to store index files (include the trailing "/")
$AUTHENTICATION_MODULE = "authentication.php"; //- File that contains authentication functions
$PGV_STORE_MESSAGES=true; //- allow messages sent to users to be stored in the PGV system
$PGV_SIMPLE_MAIL=true; //- allow admins to set this so that they can override the name <emailaddress> combination in the emails
$USE_REGISTRATION_MODULE=true; //- turn on the user self registration module
$REQUIRE_ADMIN_AUTH_REGISTRATION=true; //- require an admin user to authorize a new registration before a user can login
$ALLOW_USER_THEMES=true; //- Allow user to set their own theme
$ALLOW_CHANGE_GEDCOM=true; //- A true value will provide a link in the footer to allow users to change the gedcom they are viewing
$LOGFILE_CREATE='monthly'; //- set how often new log files are created, "none" turns logs off, "daily", "weekly", "monthly", "yearly"
$LOG_LANG_ERROR = false; //- Set if non-existing language variables should be written to a logfile
$PGV_SESSION_SAVE_PATH=''; //- Path to save PHP session Files - DO NOT MODIFY unless you know what you are doing
//- leaving it blank will use the default path for your php configuration as found in php.ini
$PGV_SESSION_TIME='9999'; //- number of seconds to wait before an inactive session times out
$SERVER_URL='http://www.kingfamily.byethost13.com/'; //- the URL used to access this server
$LOGIN_URL=''; //- the URL to use to go to the login page, use this value if you want to redirect to a different site when users login, useful for switching from http to https
$MAX_VIEWS='20'; //- the maximum number of page views per xx seconds per session
$MAX_VIEW_TIME='1'; //- the number of seconds in which the maximum number of views must not be reached
$PGV_MEMORY_LIMIT='24M'; //- the maximum amount of memory that PGV should be allowed to consume
$ALLOW_REMEMBER_ME=true; //- whether the users have the option of being remembered on the current computer
$CONFIG_VERSION = "4.0"; //- the version this config file goes to
$DIRECTORY_MODE = "ldap"; //- User info stored in db or ldap directory
$COMMIT_COMMAND=''; //- Choices are empty string, cvs or svn
$DBPORT=''; // new config variable
$DB_UTF8_COLLATION=false; // new config variable
$PGV_SMTP_PORT='25'; // new config variable
$PGV_SMTP_ACTIVE=false; // new config variable
$PGV_SMTP_HOST=''; // new config variable
$PGV_SMTP_HELO=''; // new config variable
$PGV_SMTP_AUTH=false; // new config variable
$PGV_SMTP_AUTH_USER='admin'; // new config variable
$PGV_SMTP_AUTH_PASS='bomber'; // new config variable
$PGV_SMTP_SSL='none'; // new config variable
$PGV_SMTP_FROM_NAME=''; // new config variable
$CONFIGURED=true;
require_once("includes/session.php");
Paul - I deleted your previous post. You had included your database username and password.
However, it will still have been sent to mailing lists and archives. You should change your DB password as soon as you can.
Before it went, I believe I saw $CONFIGURED=true at the end.
If you are being redirected to the install wizard, then either this variable is false, or you have no administration users. Are you able to look in the DB (e.g. using phpMyAdmin), and confirm whether a user exists in the pgv_users table with the "u_canadmin" column set to Y
Hi - thanks fisharebest - I checked, and yes there are admin users showing in the table. I can also log in within PGV as administrator & do all the normal things - but something is still triggering that wizard every time log out & log in again (and yes, have tried clearing browser cache)
Cheers
Paul
Hi again - I wonder if there is some kid of timeout while a check for a valid configuration is being done? I note the site takes 20 seconds or more to complete loading of the welcome page - probably a bit longer than under PGV 4.1.6 …?
Your memory limit seems small
$PGV_MEMORY_LIMIT='24M'; //- the maximum amount of memory that PGV should be allowed to consume
Also the file appeared to end prematurely … not with a $CONFIGURED=true …
It ended with
$PGV_SMTP_SSL='none'; // new config variable
$PGV_
Mark
Hi - sadly, the 24 M memory limit is trhe maximum the host will allow.
He last line definitely does include $CONFIGURED=true
The last three lines of config.php again are:
$PGV_SMTP_SSL='none'; // new config variable
$PGV_SMTP_FROM_NAME=''; // new config variable
$CONFIGURED=true;
require_once("includes/session.php");
Cheers
Paul
Politely, find a new host. 24mb of memory in today's environment is teeny-weeny and PGV 4.2.3 will generally not perform in such an environment. While it may serve certain pages, searching, charts and reports will almost always hit the limit with any GEDCOM of significant size (+500 INDIs).
-Stephen
Hi - So can I assume this is most likely caused by memory limnitation?
I did not strike this issue with PGV 4.1.6, so may need to downgrade software to less memory hungry version.
Which version is the most recent that would not struggle with the 24 M limitation?
Alternatively does anyone know of another host with larger memory limit for free hosting plans?
Not really worth paying to host a site visited almost exclusively by myself - with access by relatives maybe once or twice a year!
Cheers
Paul
I would certainly not recommend a down-grade as the software has security holes and there are so many more features in 4.2+. If you are the primary user and load is quite small, why use a host at all? "Host" the site on your own computer. There are excellent all-in-one packages for installation of Apache/PHP/MySQL available for every platform. XAMPP, LAMPP, MAMP.
-Stephen
H i am trying a new host with larger memory limit (x10hosting.com) - but have struck same issue
phpgedview gives me "SQLSTATE Access denied for user…" on configuration wizard database screen. This time I checked & all database details & password do seem to correspond to the database settings on this host, but no luck.
What else might prevent successful access?
Did you create the database? PGV can only create tables within an already-existing database.
Hi - yes I created the database using the host ISP "cpanel" utility, and am carefully using the same database name, user name & password on PGV that I gave it on host.. I can access & nominally interrogate the database using host cpanel tools - though currently it is empty/ 0kb in size
hostname?
My ISP runs its db on a separate host.
One thing I am wondering about is the "PDO drivers" mentioned beside the link to the PGV installation guide - I searched high & low & found no mention of these on any documentation or Cpanel utility screens with the ISP. could this be the issue?
Hi - MySQL server hostname is mysql-boru.x10hosting.com - I tried using this, as well as "localhost" - neither worked.