cancel
Showing results for 
Search instead for 
Did you mean: 

Can not see old Plus files in new hosting area

bobpullen
Community Gaffer
Community Gaffer
Posts: 16,811
Thanks: 4,842
Fixes: 314
Registered: ‎04-04-2007

Re: Can not see old Plus files in new hosting area

@appleshaw definitely still a problem there. Leave it with me.
Edit: By the way, I've reset your FTP password to match your Control Panel login so I could replicate the problem.

Bob Pullen
Plusnet Product Team
If I've been helpful then please give thanks ⤵

appleshaw
Grafter
Posts: 32
Registered: ‎03-07-2008

Re: Can not see old Plus files in new hosting area

Fingers crossed
appleshaw
Grafter
Posts: 32
Registered: ‎03-07-2008

Re: Can not see old Plus files in new hosting area

Success!
Can see that the public directory contains the old phpgedview files. Have not seen if things are working or if I can instal webtrees but things look good
Thanks
appleshaw
Grafter
Posts: 32
Registered: ‎03-07-2008

Re: Can not see old Plus files in new hosting area

The transfer does not seem to have included the MySQL. Not a large problem as I will be resetting things using a new MySQL database, which does show in thr directory listing.
However starting webtrees setup leads to a request for Server Name, with suggestion of  'localhost'. This works for other sites I have used but Plus old CGI used humbug etc.
Which Server name should I try?
bobpullen
Community Gaffer
Community Gaffer
Posts: 16,811
Thanks: 4,842
Fixes: 314
Registered: ‎04-04-2007

Re: Can not see old Plus files in new hosting area

Should be sorted now.

Bob Pullen
Plusnet Product Team
If I've been helpful then please give thanks ⤵

appleshaw
Grafter
Posts: 32
Registered: ‎03-07-2008

Re: Can not see old Plus files in new hosting area

No change today.  The phpgedview files have been transferred but I do not know where the MySQL files are on the new system. I suspect not transferred as the only database I can see, both in MySQL and in the database directory, is the one I created a few days ago.
If I access the transferred php file I get the setup wizard. Second stage asks for  Database Host, with suggestion localhost and Database Name. As I am moving away from PhpGedView it is not important for me that the database does not seem to be there. Others might need it. As I have not accessed the PGV files on the old platform for some time (too slow and could not be upgraded) it is a minor problem.
On the new system using webtrees setup I get to a similar stage, asking  for information, hopefully shown in image. I copied database name from MySQL and local server as localhost.
Error message is
SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13
Humbug was just that ie did not work
bobpullen
Community Gaffer
Community Gaffer
Posts: 16,811
Thanks: 4,842
Fixes: 314
Registered: ‎04-04-2007

Re: Can not see old Plus files in new hosting area

Let me get back to Hostopia about the database. Regarding the host name, I'd suggest using the FQDN sql5c51a.megasqlservers.eu rather than localhost. Having said that, I'd avoid making any changes yourself until we've had change to restore your database content.

Bob Pullen
Plusnet Product Team
If I've been helpful then please give thanks ⤵

bobpullen
Community Gaffer
Community Gaffer
Posts: 16,811
Thanks: 4,842
Fixes: 314
Registered: ‎04-04-2007

Re: Can not see old Plus files in new hosting area

@appleshaw, Hostopia tell me that they've migrated your database content now. Ltt me know if you've anything else that needs looking at.

Bob Pullen
Plusnet Product Team
If I've been helpful then please give thanks ⤵

appleshaw
Grafter
Posts: 32
Registered: ‎03-07-2008

Re: Can not see old Plus files in new hosting area

Using MySQL Manager the only database that I see is one that I created last week.
I can not see anything else using FileZilla.
If I try to log in to the old PGV site I get the setup wizard, which asks for 'Database Host', suggests 'localhost' and 'Database Name' and also 'Database Table Prefix' which it suggests should be 'pgv_'.
webtrees will ask for similar information
I am not too worried if the PGV data is lost as I can use backups. I do nee to know how to connect to the MySQL database in webtrees
appleshaw
Grafter
Posts: 32
Registered: ‎03-07-2008

Re: Can not see old Plus files in new hosting area

Apologies for missing information in previous message. The database that I created in MySQL now has a large number of files with names starting pgi_, as suggested by the PGV setup wizard. Presumably I can enter this database name into the wizard, but I still need a name for 'Database Host'. Could try 'localhost'.
spraxyt
Aspiring Legend
Posts: 10,063
Thanks: 673
Fixes: 75
Registered: ‎06-04-2007

Re: Can not see old Plus files in new hosting area

The Database Host name on Hostopia should be sql5c51a.megasqlservers.eu . localhost will not work.
David
appleshaw
Grafter
Posts: 32
Registered: ‎03-07-2008

Re: Can not see old Plus files in new hosting area

I tried localhost and as predicted this does not work. Then the correct Host but the two error messages are
Your current database configuration is bad. Please check your database connection parameters and configure again.
SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
Your current database configuration is bad. Please check your database connection parameters and configure again.
SQLSTATE[42000] [1044] Access denied for user 'ccgiapples447956'@'%' to database ' FamilyHistory_ccgiapples447956'
I copied the user name and full database name from MySQL Manager. These possibly contain extra prefix characters.
The one field I did not supply to the wizard was Database Port, as I hpoed that a default would be used
appleshaw
Grafter
Posts: 32
Registered: ‎03-07-2008

Re: Can not see old Plus files in new hosting area

Using the Host name I have run the webtrees wizard and got to the page where it says
Click here for PhpGedView to webtrees transfer wizard
Not sure if it is safe to do this if the PhpGedView is not fully set up
spraxyt
Aspiring Legend
Posts: 10,063
Thanks: 673
Fixes: 75
Registered: ‎06-04-2007

Re: Can not see old Plus files in new hosting area

Do you have a backup copy of the PGV tables in the unlikely event that the webtrees transfer wizard damages them? Similarly for files if you think the wizard is likely to change those.
If it can't find the information it needs a well behaved application should issue an error message and stop, Have you any reason to suspect that webtrees is not well behaved?
David
appleshaw
Grafter
Posts: 32
Registered: ‎03-07-2008

Re: Can not see old Plus files in new hosting area

I will download the pgv_ files as backup and see what happens. webtrees is a fork of PGV and so things should be OK. At the worst I have the original data loaded and not much update happened on the site