Hi,
I have not been able to do anything with my gallery for a couple of years. It needed an update but I could not do it as I don't have access to a local server. (My son was setting up my old computer as one but has been too busy to complete that.)
I have lost all information about my Gallery including my password. The recover password email does not get to me - I probably gave my first ISP address and that address has closed.
I have been feeling rather a dinosaur.
I would like to start again from scratch, with a brand new installation of Gallery, and copy to it the images I still need online.
My Web host does install Gallery but only v2.2.4
Even if I install a new copy of that, it is way out of date. Would I be able to update it etc, via my Host without a php server myself?
Below are the details copied from a previous message here 2 years ago. I don't think they have changed, apart from updating the Browsers.
System Information
Gallery version 2.3
PHP version 5.2.9 cgi
Webserver Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
Database mysqlt 5.0.77-community
Toolkits Thumbnail, Gd
Operating system Linux cp1.hostingserver.net 2.6.18-128.1.10.el5 #1 SMP Thu May 7 10:39:21 EDT 2009 i686
Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10
I now have browsers Firefox, Opera, and Internet Explorer, all installed in early 2011 when this computer was new, and I can't find their version numbers.
Gaynor
Posted: Sat, 2012-03-31 12:19
Posts: 8339
You don't have access to a local server?
Do you have access to the server that hosts your old gallery 2.3?
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
Posts: 426
My son installed my old Gallery.
These days he works in computer stuff all week and prefers to play golf to get some fresh air etc in his spare time.
My old computer is still waiting with only Ubuntu. we'd spent hours on messenger, with me getting Ubuntu set up by his instructions, then got the local server part set up in remote access and I had strict instructions not to add anything to it because I apparently did something wrong and wrecked it.
He was going to come back the next night and complete it, but then got a job interview, got the job, and had heaps of work sorting out the problems at work, so he got overloaded with computer stuff.
Gaynor
Posts: 1642
Hi Gaynor,
Been a while. I remember you doing some great work on PGTheme colourpacks etc back in the day.
Regarding your gallery, if it is still up and running, then it can be updated and your password reset.
The local server angle you mention is a bit confusing as you don't need any local server to run G2 and your browser is not directly relevant.
Can you clarify? I.E., do you run G2 on a remote server (hosted with a commercial host/ISP) or on a computer in your home (local server)?
If hosted somewhere by a host as other parts of your message suggest, then all you need to do is to update as said. As asked above, can you log into the control panel of your host and do you have an FTP program on your local machine?
If you have these, then we can walk through step by step. Otherwise, if you want, you can PM me the control panel details and I'll set it up for you.
FYI, Gallery3 is the latest and greatest now but some of us prefer Gallery2 for various reasons and are sticking with it. In any case, you will need to upgrade to the latest G2 version if you do decide to migrate to G3.
--
dakanji.com
Posts: 426
I do have access to our website host where my Gallery 2.3 is kept.
I have access by File Manager and by FTP
Gaynor
Posts: 1642
Since you have G2.3, you are actually reasonably current and do not need any drastic stuff done.
1. Go to the force password recover page: yoursite/gallery2_folder/?g2_view=core.UserAdmin&g2_subView=core.UserRecoverPasswordAdmin
2. Create a file using notepad on your computer
3. Copy and paste the randomly generated characters from that page to the file
4. Save the file as login.txt to your desktop
5. Use your ftp client to upload the file to the "install" folder of the Gallery2
6. Click "Refresh" on the force password change page.
You should be able to reset your admin password.
Hopefully you remember the admin user name.
Let us know how it goes.
--
dakanji.com
Posts: 426
Yes I did all that but when I had uploaded the login.txt file and clicked Refresh, the refreshed page was just the same one asking for the txt file etc and the refresh button again.
I tried uploading in both systems - the ftp and the host's file manager
Gaynor
Posts: 1642
I see.
In that case, the best bet is to install G2.3.1 and let it take over the old data.
Is your gallery accessed using "yoursite_dot_com" directly or "yoursite_dot_com/gallery_folder"?
Hopefully it is the second as you can rename the current to "yoursite_dot_com/old_gallery_folder" and install v2.3.1 into "yoursite_dot_com/gallery_folder".
Best bet is to use the link in the top right corner of this site to get a copy of v2.3.1 instead of the host's install program.
1. Backup your database using your host's control panel. Most use phpMyAdmin and this allows you to export a database to your local machine.
2. Rename your current G2 folder from "gallery_folder" to "old_gallery_folder"
3. Download v2.3.1 (Minimal Version) and upload to your server and name as "gallery_folder".
4. Copy the any themes you have in "old_gallery_folder/themes" that are not already in "gallery_folder/themes" to that folder.
5. Copy the any modules you have in "old_gallery_folder/modules" that are not already in "gallery_folder/modules" to that folder.
6. Browse to "yoursite_dot_com/gallery_folder" and follow the on screen installation instructions. Make sure you choose "reuse existing database tables" in the database step and point the installer in the appropriate step to your existing g2data folder. When this is done, you will be at v2.3.1.
Try the steps to recover the admin password again when done.
If that still fails, we can look into a script that will allow you to change it directly in the database.
Keep the "old_gallery_folder" around until everything is settled.
--
dakanji.com
Posts: 426
I am taking you up on the offer of private message.
Thanks Dayo.
Gaynor
Posts: 1642
Hi,
I think you should try the steps I outlined as they are tried and tested and there should be no need for me to have to have access to your setup.
I thought perhaps you had a really old installation before but with 2.3.0 to 2.3.1, it should be a piece of cake.
Just follow the steps one by one.
--
dakanji.com
Posts: 8339
the simplest way would be to edit the DB and insert your new email addy since recovery console does not seem to be working.
-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2
Posts: 1642
That will work if emailing is working on the server. Could be worth a try.
I was looking at bringing the G2 version up to date while at things.
--
dakanji.com
Posts: 426
The emailing to get a new password in this website worked.
And the emergency admin email came through, but then the page didn't change after I'd uploaded the txt file and clicked refresh.
I have an idea the installation of my gallery reported something not completely right, but I'm sure I was able to work in it for a while.
I will do the backup this afternoon, onto my husband's computer. I'm using the laptop without much spare space at present and my desktop power unit blew up recently - nice big 500G slave hard-drive I cannot access, and don't know if it was damaged.
Gaynor
Posts: 426
I got the g2.3.1 uploaded and my modules and themes added, and when I tried to authenticate it, I was told my quota was exceeded, So I deleted something elsewhere on my website and then the new authentication worked. In the second stage of installation it told me
Output buffering disabled Warning
Warning: Output buffering is enabled in your PHP by the output_buffering parameter(s) in php.ini. Gallery can function with this setting - downloading files is even faster - but Gallery might be unable to serve large files (e.g. large videos) and run into the memory limit. Also, some features like the progress bars might not work correctly if output buffering is enabled unless ini_set() is allowed.
Gallery file integrity Warning
+ Missing files (80)
+ Modified files (11)
How do I fix these?
Gaynor
Posts: 1642
Copy the list of the missing files to a text file and attach here so we can have a look.
The modified files should be just because of the modules and themes you copied across (Make sure you also copied the themes).
--
dakanji.com
Posts: 426
The quote above is all that was given on that Page2. There was no obvious way to find a list of missing files.
So after reading your comment here, I clicked on the Continue button which just took me to the "installation Type" page 3 and at the top of that it has "Installation 15% complete.
I had first uploaded the minimal version and it had told me that was complete. After that I had uploaded the rest of my modules and themes. and it told me those uploads were complete.
So I don't understand the 15% comment.
It doesn't have any way to show the missing files either.
------
Another interesting thisn is the second option on this P3 - multisite installation.
That would be useful to me with my two sites needing Galleries, and it seems the appropriate time to ask about this.
Gaynor
Posts: 426
Oh Nevermind about the multisite. I have now read the disadvantages and feel it will be less bother to continue uploading the Gallery version twice, especially as I will probably start playing eg working on more themes or something like that.
Gaynor
Posts: 1642
15% refers to the installation process. There are several steps that you go through to complete the installation and the stage where you select the installation type is 15% of the entire process. Just ignore this.
Just keep going through the process.
--
dakanji.com
Posts: 426
Ok I am now on p5
It says I must create a database and put the DB Name in the table, but all the lines are filled in automatically apart from Password.
It already has a DB called gallery2 Do I have to create a new one eg "gallery2.3.1" ?
Gaynor
Posts: 1642
You should use the existing database and the existing g2data.
You might want to print out the steps I posted earlier and tick off the instructions there one by one as you go along.
--
dakanji.com
Posts: 426
Yes I have found the existing DB in a folder Karl called "galleries-data". It looks as if we have 5 sites with galleries between us.
I don't know the passwords for the two I am wanting to update at present.
And yes I have printed out your steps but I have not seen the option "Reuse existing database tables". I did find and point it to the galleries-data folder and the DB for this gallery (..../galleries_data/g2data_piopionz)
It accepted this and gave me the list od DBs in the galleries_data folder.
So the table shows
Database type: MySQL(v3,23,34a and newer)
DB Hostname: localhost
DB Username: (my login name)
DB Password:
DB Name: g2data_piopionz
Table Prefix: g2_
Column Prefix: g_
Would the password be somewhere in my host control panel?
I am sorry to be such a nuisance.
Gaynor
Posts: 1642
The relevant database details for the database can be found in the config.php file for the gallery.
You want to fill in the info for those items you listed from the info in the config.php file. You can use your ftp client to access the file.
Filling in the same info from the config.php file is how you reuse the existing db.
--
dakanji.com
Posts: 426
OK got that done.
It told me I should be upgrading and sent me to the upgrader.
In step 5 it gives me a list of missing plugins (mostly ones that were in my gallery but not in the new one, and I left them out when adding themes and modules because of the quota problem or I don't think I'll need them and I thought I could add them later if I need them.
There is a lot of information on the page below this list Do you need that too?
Each of these items has a check box by it but these are not active.
I don't see any way to go forward from this page.
Gaynor
Posts: 1642
That is a lot of modules and themes you have.
Anyway, I am afraid you need to follow the steps I outlined exactly as outlined for this to work.
The list of missing or incompatible modules shows the following example outcomes of not doing so:
1. Under "Gallery" you have "Core 1.3.0.1". This is actually the main G2.3.1 file set. It looks like that when you copied stuff over from your old gallery, you copied items you wanted but if you look at the instructions, it basically says copy everything that is not already in place. The Core module is the engine of G2 and in your case, it appears like you have over written it with the old version!
2. Under "toolkits", you have gd and imagemagick in the list. These come by default with the minimal file set and again, I suspect you have overwritten the files that came with the package with the old file set.
So I am afraid you have to start from scratch and I'll suggest that you follow the suggested steps exactly as they are written. The themes and modules present in the old installation must be present in the new one. There are ways to get around this but I think it will be too complicated particularly since you have too many modules in place.
Also, when you copy modules and themes over, you must not over write any one already in place.
One last thing, my instructions missed one thing ... You need to run this sql query in phpMyAdmin to disable the urlrewrite module right at the start
UPDATE g2_PluginMap SET g_active=0 WHERE g_pluginId='rewrite';(but you still need to copy the module over and activate it in the admin interface when you are up and running)--
dakanji.com
Posts: 1642
PS. Why not delete the very first "gallery_old" folder you have to free up some space?
--
dakanji.com
Posts: 426
Hi Again,
So I have to
A] delete the "gallery_old"
B]run this sql query in phpMyAdmin to disable the urlrewrite module right at the start UPDATE g2_PluginMap SET g_active=0 WHERE g_pluginId='rewrite';
C] Then go through your list exactly (without thinking I am going to save time by doing something else).
1. Backup your database using your host's control panel. Most use phpMyAdmin and this allows you to export a database to your local machine. [[DONE]]
2. Rename your current G2 folder from "gallery_folder" to "old_gallery_folder"
[[I guess I just delete everything from the now current gallery2 folder]]
3. Download v2.3.1 (Minimal Version) [[DONE]]
and upload to your server and name as "gallery_folder".
4. Copy any themes you have in "old_gallery_folder/themes" that are not already in "gallery_folder/themes" to that folder.
5. Copy the any modules you have in "old_gallery_folder/modules" that are not already in "gallery_folder/modules" to that folder.
6. Browse to "yoursite_dot_com/gallery_folder" and follow the on screen installation instructions. Make sure you choose "reuse existing database tables" in the database step and point the installer in the appropriate step to your existing g2data folder. When this is done, you will be at v2.3.1.
Try the steps to recover the admin password again when done. (Before or after D?)
D] copy the g2_PluginMap SET module over and activate it in the admin interface when you are up and running
I am not sure what this last one means.
Gaynor
Posts: 1642
While you have been at it, I have written a script to allow you to directly change your password. I'll post a link to this shortly.
However, I think you should stick in there and do the upgrade to v2.3.1 ... it is an easy 10 step process
The 10 Easy Steps:
01. Delete the very old "gallery_old"
02. Log into phpMyAdmin and bring up the Gallery2 database. You can find the name of the database in your config.php
03. On the "sql" page, run the following to reduce the size of the database:
-
TRUNCATE `g2_CacheMap`;-
TRUNCATE `g2_FailedLoginsMap`;-
TRUNCATE `g2_Lock`;-
TRUNCATE `g2_RecoverPasswordMap`;-
TRUNCATE `g2_SessionMap`;04. On the same "sql" page, run
UPDATE g2_PluginMap SET g_active=0 WHERE g_pluginId='rewrite';to temporarily disable the rewrite module.05. Go to the "Export" tab and export a copy of your database from phpMyAdmin to your local machine. See how to here
06. Rename your current G2 folder from "gallery_folder" to "old_gallery_folder". Do not delete it, just rename
07. Download v2.3.1 (Minimal Version), upload to your server and name as "gallery_folder".
08. Copy any themes you have in "old_gallery_folder/themes" that are not already in "gallery_folder/themes" to that folder. The new G2 file set will have some themes in the themes folder. These must be left intact. What you want to do is copy other themes that you have in the old installation. When you are done, the "gallery_folder/themes" folder should have folders for all the themes you have in "old_gallery_folder/themes".
09. Copy any modules you have in "old_gallery_folder/modules" that are not already in "gallery_folder/modules" to that folder. The new G2 file set will have some modules in the modules folder. These must be left intact. What you want to do is copy other modules that you have in the old installation. When you are done, the "gallery_folder/modules" folder should have folders for all the modules you have in "old_gallery_folder/modules".
10. Browse to "yoursite_dot_com/gallery_folder" and follow the on screen installation instructions.
- Make sure you reuse your existing database tables in the database setup step. To do this, fill in the database details from the old config.php file. They are listed as "$storeConfig['xyz'] etc.
- Make sure you reuse your existing g2data folder in the storage setup step. To do this, fill in the path to your existing g2data from the old config.php file. It is listed as "$gallery->setConfig('data.gallery.base', '/server/path/to/g2data/'). Use the '/server/path/to/g2data/' string.
- Some modules and themes may be outdated but can be updated later.
- You may see a warning about modified files but there should be none for missing files
When this is done, you will be at v2.3.1.
We can then update the password ... either through the password recovery process (probably will not work but worth a try) or my new shiny script (fingers crossed)!
You can then log in and update modules and themes as needed.
--
dakanji.com
Posts: 1642
PS: The password update script is attached.
It allows you to do either of the following:
1. Reset the G2 admin username and password to "Admin" (for when you don't recollect the admin username)
2. Change the password of any G2 user including the admin user.
Unpack into your gallery2/lib/support folder and run using "yoursite_dot_com/gallery2/lib/support/password_reset.php" for instance.
***Edit***
Attachment removed. Users should normally be able to use the inbuilt processes.
--
dakanji.com
Posts: 426
Looks like I muffed it again! as per your number 6.
I have already deleted the gallery2 files and folder.
All I have in there at present (in the piopionz site) is the copy that was gallery 2 before this weekend and is now 'gallery2-oldAp2012'
Shall I rename it gallery2 again? Or start from scratch again with the downloaded minimal version?
This time I will wait till you answer before I do ANYTHING
Thanks for being so patient.
Gaynor
Posts: 1642
Hi,
If your previous gallery2 folder (i.e., the one you had before your very first post) has already been renamed from your previous attempt, you can just tick off Step 06.
What you need next, Step 07, is a new gallery2 folder with only the new "minimal" G2 files in it. This should be named as whatever the old folder was called before you renamed that folder.
--
dakanji.com
Posts: 426
Hello Dayo,
I have uploaded all the modules and themes from the old gallery2 - that were not in the minimal Gallery 2.
I have checked them against the missing files list I sent you yesterday and although lots have different wording in their names, I have managed to match up almost all of them.
There are two that are missing :-
Photoworks
Add items.
- oh it does have one called Itemadd and one called Photoaccess which are not on the list so I suppose those match up with these two I thought were missing.
So does that mean I am ready to go into my gallery and go through the installer (Number 10)?
Another thing, I forgot to "run this sql query in phpMyAdmin to disable the urlrewrite module right at the start UPDATE g2_PluginMap SET g_active=0 WHERE g_pluginId='rewrite';"
Should I run it before going into my gallery for the installation?
I hope I don't have to go back and start all over again.
The only Module that looks like "url-rewrite" is just called "rewrite"
Well I'll have to go on with this tomorrow. I was up dealing with this and some web work literally all night and it is now nearly 1am again. I need to get sleep or I'll be making mistakes.
Gaynor
Posts: 426
Golly Dayo,
I have just looked at the new script you attached above.
I guess understanding that will need my full concentration when I am wider awake.
I hope you'll tell me how to use it once I have tried the usual password reset method without success.
I have also just noticed, when you said I could tick off number 6, I inadvertently skipped past numbers 3 and 4 - as i had already done the backup the other day.
Should I do those "TRUNCATE ... " instructions now?
If so what does it mean to "run" them?
My computerese is lacking in a lot of basics that little old Grandmas are not expected to be interested in. I was taught what I was expected to need, and then let loose on the computer.
Sort of like picking the sultanas out of a cake and later needing the cake as well.
Gaynor
Posts: 1642
Hi,
Before you go to Step 10, do the following:
- Make sure you reuse your existing database tables in the database setup step by using the database details from the old config.php file.
- Make sure you reuse your existing g2data folder in the storage setup step by using the path to your existing g2data from the old config.php file.
- Some modules and themes may be outdated but can be updated later.
- You may see a warning about modified files but there should be none for missing files
When this is done, you will be at v2.3.1.
We can then update the password ... either through the password recovery process (probably will not work but worth a try) or my new shiny script (fingers crossed)!
To use the script, do the following:
- Upload the password_reset.php file to the "yoursite_dot_com/gallery_folder/lib/support" folder.
- Navigate to "yoursite_dot_com/gallery_folder/lib/support/password_reset.php" with your web browser and follow the on screen instructions. You don't need to look into or touch the code itself to use it.
You can then hopefully log in and update modules and themes as needed.
--
dakanji.com
Posts: 426
Hi Again,
from the config.php
$storeConfig['database'] = '[my login name]_gallery2';
I copied your code:
TRUNCATE `g2_CacheMap`;
TRUNCATE `g2_FailedLoginsMap`;
TRUNCATE `g2_Lock`;
TRUNCATE `g2_RecoverPasswordMap`;
TRUNCATE `g2_SessionMap`;
UPDATE g2_PluginMap SET g_active=0 WHERE g_pluginId='rewrite';
into the sql textbox. clicked "go" and it asked if I really wanted to do it. I clicked "OK"
and it brought up
>
SQL query:
TRUNCATE`g2_CacheMap` ;
MySQL said:
#1146 - Table '[my login name]_gallery2.g2_CacheMap' doesn't exist
<
and had a box containing "Run SQL query/queries on database [my login name]_gallery2: "
--------
I am absolutely not doing anything I don't understand without asking you.
I apologise for my lack of understanding, and I do appreciate your patience with me.
Gaynor
Posts: 426
Oh In the left column of that page I see it has g2ppnz_CacheMap, and similar for all other items in that list.
So do I replace "g2_" with "g2ppnz_" in each line of your code?
Gaynor
Posts: 1642
Correct. You must have set it up this way when originally installed.
"g2_" is just the default which many people just keep.
You might need to change "g_" in the rewrite query though. You can click on one of the tables to see which prefix the table columns have and edit accordingly. Maybe it will be "gppnz_" but you need to check.
--
dakanji.com
Posts: 426
Right, that code became
>
TRUNCATE `g2ppnz_CacheMap`;
TRUNCATE `g2ppnz_FailedLoginsMap`;
TRUNCATE `g2ppnz_Lock`;
TRUNCATE `g2ppnz_RecoverPasswordMap`;
TRUNCATE `g2ppnz_SessionMap`;
UPDATE g2ppnz_PluginMap SET gppnz_active=0 WHERE gppnz_pluginId='rewrite';
<
(I am stating this for future reference & to guide me when I do my other Gallery.)
and clicking GO gave me
> MySQL returned an empty result set (i.e. zero rows).
<
for every line.
Does that make sense?
Do I now go on to the next instruction, ie 'Go to the "Export" tab... ...'
Gaynor
Posts: 1642
OK. Carry on ... almost there.
You might want to have this page handy ... even though a recent installation of phpMyAdmin may look slightly different, the features and processes are still essentially the same.
--
dakanji.com
Posts: 426
Ok I am into the Installer and step2 says
68 missing files
and some modified files that you said don't worry about
Gaynor
Posts: 1642
Attach a list like before.
Click to expand it first.
--
dakanji.com
Posts: 426
I have continued and on p4 it says
>
Storage Setup
Gallery needs a directory to store your images. The directory we chose for you will work, but its location or current name does not provide maximum security. Either select a new directory outside of the document root directory or add a random string to the end of the directory name (e.g. g2data_6de5b28893).
For maximum security you should pick a directory that is not web accessible. If this is not possible, specify a randomized name for this directory.
<
It gives the path "/hsphere/local/home/[my login name]/[my website]/gallery2/g2data"
What does it mean by "Either select a new directory outside of the document root directory" and "pick a directory that is not web accessible" ?
Gaynor
Posts: 1642
Fill in the path to your existing g2data folder from the old config.php file. It is listed as "$gallery->setConfig('data.gallery.base', '/server/path/to/g2data/'). Use the '/server/path/to/g2data/' string.
Ignore the warnings about it being web accessible if they come up.
This can be fixed later.
--
dakanji.com
Posts: 426
Done But I have not found the list of missing files that I got last time.
I have checked earlier in this thread and discovered I was redirected to the Upgrader and it was in step 5 of that where I found that list.
Gaynor
Posts: 426
Ah step 9 of the Installation has a list of plugins etc (attached)
Is this what you need? Though it doesn't say anything about the 68 missing files.
Gaynor
Posts: 1642
Don't worry about that.
Go back into phpMyAdmin and try to run "UPDATE g2ppnz_PluginMap SET gppnz_active=0 WHERE gppnz_pluginId='rewrite';" again before we go further.
PS
Scratch that. Just looked at your site and you don't have rewrite active but the thumbnails are all broken (Shouldn't be happening)
Anyway, try the password recovery step now.
If it works, you can log in and rebuild the thumbs. If not, see the instructions for my script above and try that. I'll suggest using the option where you specifically enter the admin username.
--
dakanji.com
Posts: 426
Does "run" this mean copy it into that text box?
Gaynor
Posts: 1642
Yes it does but no need to. See my edit above.
--
dakanji.com
Posts: 426
Do I finish the installation first? before trying the passwoed recovery?
Gaynor
Posts: 1642
Yes. I thought you had done so.
--
dakanji.com
Posts: 426
Attached list of what it told me after I clicked the "go" on Step 9
Gaynor
Posts: 426
I tried the User name and PW in the config.php work for logging in but that didn't work.
and I have tried the recovery thing several times but ! The page says
To prevent abuse, password recovery requests can not be attempted more than once in a 20 minute period.
Each time I tried it told me I had got the letters in the security section incorrect - but I had checked them
Gaynor