During installation (after creating config), the error "Site is currently unavailable" appears.
Does anyone know what can be wrong ?
There where no errors before ?
Jan
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
sql is already started. Because the error is part of the installation and comes up after creating the table, even after the first part of the configuration.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Stephen
That "site is unavailable" message comes up when someone tries to access the site when you're part way through importing the GEDCOM.
Your advice is sound in general, but this particular "error" appears to be an intentional feature of PGV, and not a product of an underlying service.
Mark
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Mark
Thanks for the compliment. I was aware that this is a PGV generated page, not the system, but also I have received this page on more than several occasions and each time my Apache-php-Sql setup is simply confused, perhaps with caching or other issues, and a simple restart resolved the issues.
If Jan has completed the INSTALL.PHP (Config) procedure and imported his gedcom, and is still receiving this page, I've found a restart is most helpful. If he has not finished installation - he needs to do so as the page is a warning too that the procedure is incomplete.
-Stephen
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi - I have same issue, and am wondering how one "restarts" a database?
My database & website are hosted by a remote web hosting service. - I have poked around on the C-panel page associated with my account and can see my database there (unchanged since it was last working) - but no obvious way to "restart " it ?
I even tried to delete it completely and recreate it (tried using same and different database names) in the hope this would trigger the installation wizard in my PhPGedView website that would let me configure and rebuild database - but even after clearing browser cache I still get same "Site is Currently Unavailable" message when ever I go to website url.
What might I be doing wrong?
Cheers
Paul
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
That error message actually results from PGV being unable to connect to the database.
Don't forget that PGV DOES NOT create the database itself - it will, however, create the necessary tables within an already-existing database as part of the install routine. You have to create the database using a tool such as "cpanel" or "phpmyadmin", or have your ISP do it for you.
You need to verify that your database connection information is correct, and that the database userid and password actually have full rights to create and modify database tables. This userid is NOT the same as the PGV Admin userid.
If necessary, replace the "config.php" file with a fresh copy from your downloaded PGV install file set. You could also manually edit "config.php" and change the $CONFIGURED value (near the bottom) to "false", and then re-launch PGV. This should cause the install wizard to start. When manually editing "config.php", be sure to save it as a plain text file. Also, while you're setting up the site, this file MUST have full read/write/modify (777) permissions.
When you're stepping through the install wizard's various pages, be sure to use the "next" button, instead of stepping through them by using the navigation menu to the left.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thanks for that - I found & changed the $configured toggle in the script as described & can now get the wizard going - but although I am fairly sure I have used all the right info in the relevant config wizard database fields, it now gives me error
"SQLSTATE Lost connection to MySQL server at 'reading initial communication packet', system error: 111"
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Paul
If this is so, then you have an internet connection issue between your server and your PGV installation. Chances are you have not specified the IP for your host 127.0.0.0
Here's but one thread about the necessity and method of doing this: http://www.webdeveloper.com/forum/showthread.php?t=184281
Stephen
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi - thanks - I tried "127.0.0.1" - no change (same message), and then I tried "localhost" and error changes to SQLSTATE Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
If I use "127.0.0.0" I get SQLSTATE Can't connect to MySQL server on '127.0.0.0' (101)
Initially I had been using "sql4.byethost13.com" which was the setting (or so I I thought) that worked until today.
Cheers
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
sock is more often located in a /tmp directory, especially for the 127.0.0.1/localhost configuration (sorry for the typo, but the link help was correct). Sorry but your issues are not with PGV but rather your SQL config and I will be unable to help. PGV needs to have a database available, with a known user and pw with proper DB rights to create and modify tables.
-stephen
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi - thanks - I gave up on that ISP based on my sudden inability to connect with database, found another host and have everything transferred & working nicely - except I have no idea how to transfer users across.
While I cannot establish a database connection on old host, I still do have ftp access to files. Is there any file I can copy or any other process I can go through that would allow me to recreate the user list & editing permissions etc on new host without access to the original database connection?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Paul
Like all but a very few details, PGV keeps most data in the database. You'll have to ask support for a SQL-dump to be sent to you, assuming you can not gain access. Control panel? phpMyAdmin? as these run locally - one or the other should still have access to your DB. Then, you can import the user-db into your existing db, as well as messages, favorites, blocks to recover those setings as well. Without either their assistance or your own data-dump (assuming that you don't have a recent backup, which you SHOULD), your user data is gone and you'll have to send emails to all your registered users using the copies of the registration emails you received.
-Stephen
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Stephen - thanks very much for such a fast reply!
Sadly, I unthinkingly deleted and recreated my database with new one with known user name & password in a final attempt to achieve a connection - it worked, however my users were lost with the original database..
However I did make a back up of it while back, so will investigate reimporting the users table from that - or post a message on first host directing users to go to new host & sign up again (new host seems to be faster & better anyway as free hosts go - allowing larger memory space for script execution etc)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Back on 10 JAN 2010, I lost my HD in a crash. I had backed up the GEDCOM on 01 JAN 2010, so I only lost 94 changes in data and a majority (78) I was able to reconstruct from other sources, including a log of the changes. However, I lost the SQL-DB too. My most recent copy was JULY 2009, actually on an older machine that was replaced with the new one. I recovered the users, messages, blocks tables and a few other tidbits from a SQL dump and then reviewed my emails. I wrote each user who I had approved (18 of them) between 01 AUG and 10 JAN, explaining that we had lost their registration due to a computer HD malfunction and would they please register. All but one did so. (BTW< the HD now is a redundant 3-drive mirror with a nightly clone to a 4th drive and an hourly Time-Machine backup on all four - so this can't happen again. It is for this reason I was able to supply a specific answer to your problem so easily. It won't happen to me again!
Stephen
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Oops - look like my database backup is a single sql file,
I can delete table & recreate my current database version fresh with no tables, then reimport all tables from the backup - but backup is nearly 2 years old, and I only want the user table - is there a clever way to import only selected tables from a backup? (not seeing any obvious way in ISP c-panel)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Answered my own question - just create new empty database, import entire backup database into it, export only required "user" table, delete "user" table from current database & import replacement…
I have done the same with the "news" table, and everything now seems to be great, if a bit out of date.
Are there any other tables I would want from old sql backup?
Cheers
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
During installation (after creating config), the error "Site is currently unavailable" appears.
Does anyone know what can be wrong ?
There where no errors before ?
Jan
Jan
Restart your server, being sure that the underlying support programs launch before accessing PGV, especially your mySQL database.
-Stephen
Well,
sql is already started. Because the error is part of the installation and comes up after creating the table, even after the first part of the configuration.
Yes
I know, but it can get 'confused' by the installation process. Don't do as I suggest (from much experience) if you don't wish to....Stephen
Stephen
That "site is unavailable" message comes up when someone tries to access the site when you're part way through importing the GEDCOM.
Your advice is sound in general, but this particular "error" appears to be an intentional feature of PGV, and not a product of an underlying service.
Mark
Mark
Thanks for the compliment. I was aware that this is a PGV generated page, not the system, but also I have received this page on more than several occasions and each time my Apache-php-Sql setup is simply confused, perhaps with caching or other issues, and a simple restart resolved the issues.
If Jan has completed the INSTALL.PHP (Config) procedure and imported his gedcom, and is still receiving this page, I've found a restart is most helpful. If he has not finished installation - he needs to do so as the page is a warning too that the procedure is incomplete.
-Stephen
Hi - I have same issue, and am wondering how one "restarts" a database?
My database & website are hosted by a remote web hosting service. - I have poked around on the C-panel page associated with my account and can see my database there (unchanged since it was last working) - but no obvious way to "restart " it ?
I even tried to delete it completely and recreate it (tried using same and different database names) in the hope this would trigger the installation wizard in my PhPGedView website that would let me configure and rebuild database - but even after clearing browser cache I still get same "Site is Currently Unavailable" message when ever I go to website url.
What might I be doing wrong?
Cheers
Paul
That error message actually results from PGV being unable to connect to the database.
Don't forget that PGV DOES NOT create the database itself - it will, however, create the necessary tables within an already-existing database as part of the install routine. You have to create the database using a tool such as "cpanel" or "phpmyadmin", or have your ISP do it for you.
You need to verify that your database connection information is correct, and that the database userid and password actually have full rights to create and modify database tables. This userid is NOT the same as the PGV Admin userid.
If necessary, replace the "config.php" file with a fresh copy from your downloaded PGV install file set. You could also manually edit "config.php" and change the $CONFIGURED value (near the bottom) to "false", and then re-launch PGV. This should cause the install wizard to start. When manually editing "config.php", be sure to save it as a plain text file. Also, while you're setting up the site, this file MUST have full read/write/modify (777) permissions.
When you're stepping through the install wizard's various pages, be sure to use the "next" button, instead of stepping through them by using the navigation menu to the left.
Thanks for that - I found & changed the $configured toggle in the script as described & can now get the wizard going - but although I am fairly sure I have used all the right info in the relevant config wizard database fields, it now gives me error
"SQLSTATE Lost connection to MySQL server at 'reading initial communication packet', system error: 111"
Paul
If this is so, then you have an internet connection issue between your server and your PGV installation. Chances are you have not specified the IP for your host 127.0.0.0
Here's but one thread about the necessity and method of doing this:
http://www.webdeveloper.com/forum/showthread.php?t=184281
Stephen
Hi - thanks - I tried "127.0.0.1" - no change (same message), and then I tried "localhost" and error changes to SQLSTATE Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
If I use "127.0.0.0" I get SQLSTATE Can't connect to MySQL server on '127.0.0.0' (101)
Initially I had been using "sql4.byethost13.com" which was the setting (or so I I thought) that worked until today.
Cheers
sock is more often located in a /tmp directory, especially for the 127.0.0.1/localhost configuration (sorry for the typo, but the link help was correct). Sorry but your issues are not with PGV but rather your SQL config and I will be unable to help. PGV needs to have a database available, with a known user and pw with proper DB rights to create and modify tables.
-stephen
Hi - thanks - I gave up on that ISP based on my sudden inability to connect with database, found another host and have everything transferred & working nicely - except I have no idea how to transfer users across.
While I cannot establish a database connection on old host, I still do have ftp access to files. Is there any file I can copy or any other process I can go through that would allow me to recreate the user list & editing permissions etc on new host without access to the original database connection?
Paul
Like all but a very few details, PGV keeps most data in the database. You'll have to ask support for a SQL-dump to be sent to you, assuming you can not gain access. Control panel? phpMyAdmin? as these run locally - one or the other should still have access to your DB. Then, you can import the user-db into your existing db, as well as messages, favorites, blocks to recover those setings as well. Without either their assistance or your own data-dump (assuming that you don't have a recent backup, which you SHOULD), your user data is gone and you'll have to send emails to all your registered users using the copies of the registration emails you received.
-Stephen
Hi Stephen - thanks very much for such a fast reply!
Sadly, I unthinkingly deleted and recreated my database with new one with known user name & password in a final attempt to achieve a connection - it worked, however my users were lost with the original database..
However I did make a back up of it while back, so will investigate reimporting the users table from that - or post a message on first host directing users to go to new host & sign up again (new host seems to be faster & better anyway as free hosts go - allowing larger memory space for script execution etc)
Back on 10 JAN 2010, I lost my HD in a crash. I had backed up the GEDCOM on 01 JAN 2010, so I only lost 94 changes in data and a majority (78) I was able to reconstruct from other sources, including a log of the changes. However, I lost the SQL-DB too. My most recent copy was JULY 2009, actually on an older machine that was replaced with the new one. I recovered the users, messages, blocks tables and a few other tidbits from a SQL dump and then reviewed my emails. I wrote each user who I had approved (18 of them) between 01 AUG and 10 JAN, explaining that we had lost their registration due to a computer HD malfunction and would they please register. All but one did so. (BTW< the HD now is a redundant 3-drive mirror with a nightly clone to a 4th drive and an hourly Time-Machine backup on all four - so this can't happen again. It is for this reason I was able to supply a specific answer to your problem so easily. It won't happen to me again!
Stephen
Oops - look like my database backup is a single sql file,
I can delete table & recreate my current database version fresh with no tables, then reimport all tables from the backup - but backup is nearly 2 years old, and I only want the user table - is there a clever way to import only selected tables from a backup? (not seeing any obvious way in ISP c-panel)
Answered my own question - just create new empty database, import entire backup database into it, export only required "user" table, delete "user" table from current database & import replacement…
I have done the same with the "news" table, and everything now seems to be great, if a bit out of date.
Are there any other tables I would want from old sql backup?
Cheers
The blocks table describes how the site default Welcome page should look. It does the same thing for each user's personalized Portal page.
And MESSAGES, as mentioned before, if you retain internal messages.
Stephen
Thanks everybody for your help!