Talk to your Gallery administrator for help fixing this!
Hi Matthew,
I’ve encountered the same thing on a VM of openSUSE Leap 42.3 with Galley 3.1.5.
There was a conversation several weeks back with an individual trying to convert his Galley 2 info to Gallery 3, however they had to have Galley 2 working for Galley 3’s upgrade feature to work.
I have a standalone system running Leap 42.3 ad Galley 2.3.2 with no issues. I was going to just bring that up on one screen and Gallery 31.5 on my ISP and just re-create everything, then saw that it is possible to have G3 import/upgrade G2 data. Original idea was to clone the hard drive and use that on the standalone box and do the upgrade. Decided later to just do everything on my VirtualBox om my iMac, like O do everything else.
Well, I got Leap 42.3 and G2.3.2 working with exception that thumbnail creation doesn’t work (is it that important?!) . I believe it’s because I don’t have GD configured, again, who cares as G3 shouldn’t need to import thumbnails. I next installed G3.1.5 and all went well until I went to sign in as admin and got the same message you did:
:-(
We tried really hard, but it's broken.
Talk to your Gallery administrator for help fixing this!
About as bad as a BSOD as there doesn’t seem to be anything in any log recording what fracked up!
Tried in Chrome & Safari, got same response.
I thought I saw a email about making sure that mySQLi was installed instead of MySQL. Thing is, Leap uses MariaDB as its MySQL replacement and has for quite a while. I’m going to look into seeing if that’s the issue, but I thought MarisDB was fully compatible with all flavors of MySQL, including mySQLi.
Have a great day!
Michael Kupec
--
WHEN USING AN EMAIL PROGRAM to reply to this message, click REPLY TO LIST or REPLY TO ALL so your reply goes out to everyone in the group. If you click REPLY or REPLY TO SENDER Google will *only* send your reply to the original author (not recommended).
To post a NEW MESSAGE to the group, send an new email to:
gallery...@googlegroups.com
To view or sign in to this group on the web, use this URL:
https://groups.google.com/forum/#!forum/gallery-3-users
---
You received this message because you are subscribed to the Google Groups "Gallery 3 Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gallery-3-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/135ee9ce-94ab-4b67-af18-488bbe1ce2d7n%40googlegroups.com.
J.R – and others,
FWIW: I went into my VM that I have a working version of G2 and reset PHP to version 7.0.7-6.1.1 (was 5.5.14118.1) then ran the G3 installer on a fresh copy of on that web server.
It faithfully installed everything including the database and presented me with the new password for admin without a hitch.
Brought up the G3 home page and tried to log in to get the same Oops! message as I had before and as Matthew did.
Opened up the G3 database in phpMyAdmin and I see it faithfully created the admin account with the hashed password.
I wiped the G3 table out of the mySQL database, deleted the Gallery3 directory from the web server and tried with a copy of Gallery 3.0.9 but it crashes when submitting the info for the new SQL table with a HTTP Error 500. Need to delve into logs to see what died or just do another install of 3.1.5 and see why it’s not allowing you to log in with the admin account.
Have a great weekend!
Michael Kupec
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/ffd99c4b-6e44-f44c-1c91-9dde847dfd51%40thepostalzone.com.
BTW: This was done using openSUSE Leap 42.3 – basic install with LAMP package and then upgraded PHP7.
Not certain what else needed to be installed as I always assumed it was just a generic copy of the LAMP environment.
I get time today/tomorrow, I’ll try Gallery 3.1.5 under a VM of current versions of openSUSE, Centos and Debian and see what the results are.
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/006701d8e58f%240a01be00%241e053a00%24%40verizon.net.
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/006701d8e58f%240a01be00%241e053a00%24%40verizon.net.
J.R,
No, this is on a fresh copy of 3.1.5 with no images in its database, thus when opening its home page, it just shows the empty gallery. It’s at that time, when I try to log in as admin with the password it auto generated, it comes up with the Oops! message as listed in my 10/21 email. Maybe that is because PHP7.0.7 that I’m running is buggy and as you said 7.4 is the preferred version.
Wasn’t aware there was a specific version of PHP that was required for the G2 to G3 import, that definitely helps a lot! J
Let me see what it the latest version of openSUSE that has PHP 5.6 and I’ll load that, get my Gallery2 to work under it then, do a fresh install of Galley 3.1.5 in the same browser (in its own directory, naturally) and see how the import works.
My intent here is to successfully get all the G2 info imported into a fresh install of G3 on a VM here at home. Then hopefully back up the G3 and upload it to a working Gallery 3.1.5 on my ISP server.
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/a3375d29-b6ca-3315-ef8b-f112baf4bbf1%40thepostalzone.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/006601d8e653%24f8a708c0%24e9f51a40%24%40verizon.net.
Went into my archives of old openSUSE and found that Leap 15.2 was earliest version that used PHP 7.4 (actually 7.4.6). I figure keep versions as early as possible so Gallery 2 (g2) still works.
Good news is, setting up Gallery 3 works! In G3.1.5, you have two things to do:
Create the database:
And the success page with the new gallery admin password shown:
I was able to click on the “Start Using Galley” and was able to successfully login with the auto generated password. J
A successful login!
Sadly, G2 has issues…
First when creating the G2 database, if all recall with G2, you have to create the actual empty database and name it “gallery2” as seen below in phpMyAdmin:
It’s just an empty database at this time. Next In the G2 setup, you enter the necessary credentials for the database:
This is where it gets messy – when you save to create the database, you get this error:
Fatal error: 'break' not in the 'loop' or 'switch' context in /srv/www/htdocs/gallery2/lib/adodb/adodb-time.inc.php on line 1009
I went into adodb-time-inc.php and just remarked out the condition for checking for proper PHP rev. (I just want this stinking thing to install!!!)
function adodb_tz_offset($gmt,$isphp5)
{
$zhrs = abs($gmt)/3600;
$hrs = floor($zhrs);
/* if ($isphp5) */
return sprintf('%s%02d%02d',($gmt<=0)?'+':'-',floor($zhrs),($zhrs-$hrs)*60);
/* else
return sprintf('%s%02d%02d',($gmt<0)?'+':'-',floor($zhrs),($zhrs-$hrs)*60);
break; */
}
FYI: The value for $isphp5 is defined elsewhere and changing it to “7” doesn’t work.
$isphp5 = PHP_VERSION >= 5;
So with that corrected, the saving of G2 database works.
Of course there’s a couple warnings that after next step, it looks like I need to see what’s up, but ;lets proceed anyway!
I click Continue to proceed:
Next step is creating the admin account with password which I do:
That was successful so I go to step 7, the creation and saving of the config file.
That was successful and so I go to step 8… where all goes to h#!! in a handbasket… L
It’s a huge amount of errors trying to install the core with final one being:
Fatal error: Uncaught Error: Call to a member function getId() on null in /srv/www/htdocs/gallery2/modules/core/classes/helpers/GalleryEntityHelper_simple.class:79 Stack trace: #0 /srv/www/htdocs/gallery2/modules/core/classes/GalleryCoreApi.class(2361): GalleryEntityHelper_simple::loadEntitiesById() #1 /srv/www/htdocs/gallery2/modules/core/classes/helpers/GalleryPermissionHelper_advanced.class(87): GalleryCoreApi::loadEntitiesById() #2 /srv/www/htdocs/gallery2/modules/core/classes/helpers/GalleryPermissionHelper_advanced.class(66): GalleryPermissionHelper_advanced::_postGroupEvent() #3 /srv/www/htdocs/gallery2/modules/core/classes/GalleryCoreApi.class(788): GalleryPermissionHelper_advanced::addGroupPermission() #4 /srv/www/htdocs/gallery2/modules/core/CoreModuleExtras.inc(3281): GalleryCoreApi::addGroupPermission() #5 /srv/www/htdocs/gallery2/modules/core/CoreModuleExtras.inc(353): CoreModuleExtras::_createRootAlbumItem() #6 /srv/www/htdocs/gallery2/modules/core/module.inc(486): CoreModuleExtras::upgrade() #7 /srv/www/htd in /srv/www/htdocs/gallery2/modules/core/classes/helpers/GalleryEntityHelper_simple.class on line 79
Not sure if it’s because I’m using PHP 7.4.6 where I should be using just 7.4 or what’s going on.
I’m suspecting G2 has to be installed with an earlier PHP version like 5.x or 6.x where all will play well, then upgrade PHP to 7.4 so Galley 3 can be installed.
I’ll give that a try later today or this week. Since G2 plays well with Leap 42.3 and its associated PHP version, maybe install it n that then upgrade to 7.4.x so G3 will install and I hopefully can run the G2 to G3 importer.
Cheers!
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/07a6cf8e-d213-dbfb-784f-ed467e9fa858%40thepostalzone.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/008a01d8e711%2402f43a10%2408dcae30%24%40verizon.net.
J.R,
If I understand then, I just need to have G3 running and able to allow the admin account to log in, then maybe do a test of creating an album and adding some pictures. J
If that all works, then I just need read up on the importing of G2 data to G3 and I hopefully should be good to go. Better than rebuilding all those albums and adding images!
Yes, the G2 and G3 are on the same server, each in their own directory (G2 in /srv/www/htdocs/gallery2 and G3 in /srv/www/htdocs/gallery3), and both usng the same database with their data in separate tables(?), well, I can see both when I open phpMyAdmn.
It sounds like G2 doesn’t need to actually run, just G3 needs access to G2’s directories and database.
If G2 has o run on the same server as G3, then I’ll need to do more work to find a version of openSUSE (or another Linux distro) that allows G2 and G3 to both work with PHP 5.6. Oh fun, fun, fun…
If you recall, about a month back, I offered to help straighten out the old site info. Would be nice to see how the old forms could be imported into a new read and searchable forms environment for folks to use. Need to set aside time to chat with you about it and see what improvements can be done on the site to make more friendly.
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/5a7c4b44-efdf-69f9-36db-6381312a9fbc%40thepostalzone.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/00b401d8e815%244b360ba0%24e1a222e0%24%40verizon.net.
J.R,
Sorry for the confusion there – meant that on the single server within MySQL, I have two separate databases, one for each version of Gallery.
Of course for Gallery 2, it’s named gallery2 with all table entries beginning with g2_ and for Gallery 3, its database is named gallery3 with all table entries beginning with g3_.
Had a long day when replying and instead of starting up the VM then going into phpMyAdmin to verify what was database and what was table, I got names messed up.
Since openSUSE Leap 42.3 seems to work with Gallery2 so I can use it to import my current galley2 database and files, I’ll see if I can get PHP 5.6 to run on that OS version, then see if I can get G3 to successfully install.
Let all know when I have time to try hat.
As to getting the old site such that it’s searchable, access to the site would be best. Not sure why the last active member would be balking at that as technically the project is already dead in the eyes of the original development team.
As or getting parts of the site fixed, it would make sense to clone the environment offline and make changes as needed to that. It’s basically what I’m doing in trying to get all my data from G2 to G3. Hopefully it’s not a daunting task, unless someone in the development group really cobbled up the forms part of the web suite.
Have a great day!
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/eebbe9a6-977d-cf0d-22c0-badcc25c982e%40thepostalzone.com.
Evening J.R,
I remember the issues you had with getting small changes done with Bharat so folks wouldn’t keep downloading the broke versions of Gallery3.
FWIW: The actual web site is a no-brainer as it was developed using MediaWiki and with what looks like someone tried inserting some Drupal code into it. That may not have been successful as I don’t see the complete Drupal engine in the files. Anyway, it’s definitely using MediaWiki because of all the references to codex.
Understandable that they shut down adding new users as all lost interest in developing and with keeping hackers out. Unless you implement strong password requirements for EVERYONE, you will suffer the creations’ of the underworld feeling it’s so much fun trying to break in to your environment. As a network security engineer, the organization I worked for over 20 years for had an attack around the same time the Gallery site was put into hibernation.
The attack was simple, a spearfish within an email sent to an admin assistant.
She thought it was from one of our senior officials asking about a trip and opened it.
Embedded was a Trojan crafted by our most friendly folks out of China.
It woke up overnight and pulled more files from our most friendly folks that then ran and sought out AD info which it put into compressed files and sent back to the red horde.
The friendly folks pulled what they needed from those files, info on those who were planning a big business meeting to the most friendly folks (ok it’s China!)
They also gathered all files on presentations and email transcripts our folks had made for planning the trip.
All done with Symantec AV happily running and up to date it’s definitions.
The Trojans just walked right over the AV SW without any alerts.
We only found out by a visit from FBI and Homeland Security to our CIO and VP of IT asking why were we sending over massive ammpounts of data to China.
According to those two organizations, China has the source code to everything MS has developed.
How you ask? Well little Billy Gates GAVE it to them! It was only way China would allow MS to sell any Windopze products in China.
With source code in hand, they piled on thousands of programmers onto the code to find all its flaws and weaknesses.
With that knowledge they wrote code tailored to attack business throughput the US and other countries without alerting and AV software.
It took us about 6 months to clean out all infected computers.
Detection was done via a SEIM (RSA NetWitness) and implementing Palo Alto NG firewalls.
Why am I telling you this? Well, you mentioned the development team basically got frustrated with all the hacking on the site. Odds are, it was because of poor implementation of proper security protocols. For our company the fix was we implemented passwords (we called them passphrases) no shorter than 15 characters. All had to have the required letters, numbers and symbols so password dictionaries would be pretty worthless. If you don’t implement those necessary requirements, then you WILL get hacked! I know how member registration was handled on the Gallery site as I had an account on that site before they locked it down and then hibernated it. Passwords pou;d be as short as 6 characters.
As for anyone offering to help, I would like to get this mess straightened out. It won’t be immediately, but most likely over some time. I actually have free time as I’m currently an unemployed. L My biggest tasks right now are applying for SS disability and Veterans disability because after 10 months of looking, it appears no one wants to hire a 64 year old very experienced network engineer.
if Bharat is tired of hosting it, the site can be rebuilt and published elsewhere.
At this moment, I’m pulling down the site using a Linux based CLI called httrack.
I’ve used this application before to pull down web sites. Static ones like this site are simple to do, just time consuming for the computer, even on a 250Mb FiOS link.
My intent is to rebuild it on a standalone web server here at home, most likely using MediaWiki as that was what’s hosting it now. This is how I’ve always upgraded web sites I’ve helped with. Blow up your test bed with changes, NOT your current active site! Once it’s all working right, push it up on my web site as a subdomain just to verify all works. From there, we can get back with Bharat an see how he’d like to take things further.
All of our time is limited, I understand that. Currently my own priorities with Galley3 are:
1. Get a working Gallery3 site up with all my data from my Gallery2 site
2. Create a new Theme that looks similar to what my original G2 site looked like. I’ve always said the biggest mistake the developers made was getting rid of all the cool themes and ways to present pictures. Just what were they thinking!
3. Help get a new Gallery web site up, either on the original site or have that one shut down and host elsewhere. Make it more secure by using 2FA for everyone with an account on the site using Google’s 2FA app.
FWIW: Here is what my old Gallery2 site looked like. This is a screen shot today off the standalone web server here in my office.
Hope I didn’t bore you with my long rant/chat.
Cheers!
Michael J Kupec
From: gallery...@googlegroups.com <gallery...@googlegroups.com> On Behalf Of J.R.
Sent: Wednesday, October 26, 2022 5:08 AM
To: gallery...@googlegroups.com
Subject: Re: [gallery-3-users] Fresh install of 3.1.5 produces Dang! Something went wrong... on (admin) login
Michael,
--
WHEN USING AN EMAIL PROGRAM to reply to this message, click REPLY TO LIST or REPLY TO ALL so your reply goes out to everyone in the group. If you click REPLY or REPLY TO SENDER Google will *only* send your reply to the original author (not recommended).
To post a NEW MESSAGE to the group, send an new email to:
gallery...@googlegroups.com
To view or sign in to this group on the web, use this URL:
https://groups.google.com/forum/#!forum/gallery-3-users
---
You received this message because you are subscribed to the Google Groups "Gallery 3 Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gallery-3-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/906a4b35-2e50-9cd4-b1f4-67bf1b28c7e7%40thepostalzone.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/00b001d8e9ba%24490df530%24db29df90%24%40verizon.net.
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/a83f346e-b254-b9de-7880-81854ec11913%40thepostalzone.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/140A4E0D-99CA-435E-BBDE-FEBB6DD377D8%40verizon.net.
J.R,
Fortunately that 25 hours of grabbing time was just that httrak app running on my iMac, so no involvement on my part. I was beginning to wonder just how long it would take when it hit the 19 hour mark!
Still trying to grab my head around why the actual site goes to html links for everything on the site.
I used TiKiWiKi at work for a Knowledge Base for our breakfix folks and my network/Linux info (just in case I got hit by a truck, a definite possibility in Washington DC!) It was just like Gallery2/3 in it used a database to track all documents, pictures, files, etc. you added to its environment and pointers to items within the database.
Like: http://192.168.1.20/gallery2/main.php?g2_itemId=1246
Other content management systems with a database packages do similar, like Wikipedia, Drupal, Joomla, and even MediaWiki. Exception to the rule is that MS Crap called SharePoint. That’s another whole disaster in the making! It’s like for some reason, someone on the Gallery Development team extracted pure html files/links out of media wiki and just created one huge web page of files!
I’ve given up on getting openSUSE 42.3 to play with PHP 5.6 It installs Gallery2 and works with 5.5 but Galley3 install hangs. Will look into Centos tonight and through the week to see if maybe they have some early version that uses PHP5.6 and give that a try. AFAIK, it’s just PHP 5.6 that is critical for both gallery versions to work on one installation of Linux. I just need to find one with PHP 5.6. openSUSE folks just jumped over 5.6 when they went from Leap 42.3 to 15.1. (Don’t try to understand the versioning of openSUSE, even their developer ID10Ts can’t explain it well!)
BTW: That “rant” was just how I could explain I understand the security aspect of the breach attempts. To this day that customer has their webmail servers getting hit with random attacks using old SID user info. Of course, whomever is on call has to go in and block the IP address on all their firewalls. I don’t miss having to do that a bit!
Cheers!
Have a great day!
Michael J Kupec
From: gallery...@googlegroups.com <gallery...@googlegroups.com> On Behalf Of J.R.
Sent: Saturday, October 29, 2022 4:52 PM
To: gallery...@googlegroups.com
Subject: Re: [gallery-3-users] Fresh install of 3.1.5 produces Dang! Something went wrong... on (admin) login
Michael,
yikes... your report has convinced me not to even try downloading the old site to my own computer. As you have discovered, there was some weird stuff done during its creation and on-going evolution. Remember, the Gallery website was started back in the year 2000, when dinosaurs roamed the internet. I'm sure all of us wish you well in your effort to modernize it -- you've just earned your own sub-folder in the Gallery Development section of my email archive. Keep us posted.
-- J.R
--
WHEN USING AN EMAIL PROGRAM to reply to this message, click REPLY TO LIST or REPLY TO ALL so your reply goes out to everyone in the group. If you click REPLY or REPLY TO SENDER Google will *only* send your reply to the original author (not recommended).
To post a NEW MESSAGE to the group, send an new email to:
gallery...@googlegroups.com
To view or sign in to this group on the web, use this URL:
https://groups.google.com/forum/#!forum/gallery-3-users
---
You received this message because you are subscribed to the Google Groups "Gallery 3 Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gallery-3-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/008401d8ec80%2496c68030%24c4538090%24%40verizon.net.
On Oct 30, 2022, at 6:02 PM, J.R. <jrl...@thepostalzone.com> wrote:
Michael,
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/d5a9cb5a-332f-c443-0a84-d4b2c039bebb%40thepostalzone.com.
J.R,
Let me clarify a bit better as I was outside by our fire pit and not by my system to grab links:
This link: http://galleryproject.org/ is the site that I snagged using httrak the other day.
Anything on that site that you click on goes to html page that replaced that current page. Like on the main page, there’s an orange box with “About, Features, Screenshots!, etc.”
Click on the “About” and it takes you to http://codex.galleryproject.org/Gallery3:About.html
This just may be how MediaWiki handles a site you build but I thought it would use a HTML string like: http://192.168.1.20/gallery2/main.php?g2_itemId=21
As seen below n my offline Gallery2 page, we’re at URL Address: http://192.168.1.20/gallery2/main.php The mouse pointer was hovering on the “Pictures from family related acivities” .
The URL for that album can be seen in the lower left of the page.
Clicking on that first album on the main page redirects it to http://192.168.1.20/gallery2/main.php?g2_itemId=21, as seen below:
CMS type systems work in a similar fashion in that you load a page via an itemId reference from the database that has info on what the page has stored in the database.
This is a basic way of explaining it, but what I’m getting at, it doesn’t reference a complete HTML file on the website like the Galleryproject site does, but builds the page on the fly from PHP scripts and data from the database and pushes it to your browser. At least how the Gallerypoject page has been done, it wouldn’t be too hard to rebuild it offline here on one of my VM’s.
Michael J Kupec
To view this discussion on the web visit https://groups.google.com/d/msgid/gallery-3-users/FBAF1D51-8D9E-48C9-A661-F325D6FEAB36%40verizon.net.