[SOLVED] Stecke im Wartungsmodus fest / Stuck in maintenance mode

JessiKath

Joined: 2014-02-17
Posts: 18
Posted: Mon, 2014-02-17 07:23

PROBLEM GELÖST!!!
Lösungsweg unter dem ursprünglichen Beitrag.

Moin,

gestern Abend habe ich Gallery 2.3.2 mit 200 Bildern zur Verarbeitung beschäftigt und wie immer vorher auf der SideAdmin\Wartung die Seite für Besucher in den Wartungsmodus versetzt.
Als ich mal für wenige Minuten draußen, war um frische Luft zu schnappen, viel der Strom aus, der Rechner wurde herunter gefahren (USV).
Nach dem ich den Rechner dann wieder hoch fahren konnte, wollte ich die Zeile,

$gallery->setConfig('mode.maintenance', false);

ändern, so sie dann überhaupt auf $gallery->setConfig('mode.maintenance', url '/maintenance_url.php' ); steht. Dies ist nun nicht der Fall gewesen.

Gibt es eine andere Möglichkeit die Gallery 2.3.2 aus dem Wartungsmodus zu bekommen, als über die config.php?
Wenn ja, wie lautet diese?
Wenn nein, wird da bereits an einer Lösung des Problems gearbeitet?

Grüße,
Jessi'

PROBLEM SOLVED!!!
Approach under this thread.

Hi,

yesterday evening I've upload 200 images to Gallery 2.3.2. I've set the side on admin pages to maintenance mode, that the server is able to process the pictures faster.
I was for a few minutes outside, same time the computer was shut down in case of power fail.
Power comes back, but my access to the side is now impossible.
In config.php the "$ gallery-> setConfig ('mode.maintenance', false);" is correct, no URL is set.

Is there any other way to set the maintenance off?

If yes, what is this?
If not, is there already working on a solution to the problem?

regards,
Jessi '

Approach from Dayo that works on my problem:

Dayo wrote:
...
Alternatively, you can bypass the maintenance mode as admin by using this url:

Quote:
photos.jessika-katharina.net/main.php?g2_view=core.UserAdmin&g2_subView=core.UserLogin&g2_controller=core.UserLogin& g2_form[formName]=UserLogin&g2_form[action][login]=Login&g2_form[username]=admin&g2_form[password]=secret

(replace "secret" with your own password)
(replace admin with your admin username)
--
dakanji.com

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Mon, 2014-02-17 13:27

$gallery->setConfig('mode.maintenance', '/maintenance_url.php');

-s
________________________________
All New jQuery Minislideshow for G2/G3

 
JessiKath

Joined: 2014-02-17
Posts: 18
Posted: Mon, 2014-02-17 20:31

Moin,

danke für die schnelle Antwort, doch so 100% verstehe ich die Information jetzt nicht.
Füge ich es einfach in der Zeile darunter ein?

(Ich werde es versuchen, vermute aber das das wohl nicht gemeint war)

Grüße,
Jess'

 
JessiKath

Joined: 2014-02-17
Posts: 18
Posted: Mon, 2014-02-17 21:47

Vielen Dank für diesen Hilfreichen Tipp, es bringt effektiv nichts...

Ach, vielleicht liegt auch ein Missverständnis vor:

Die Zeile [$gallery->setConfig('mode.maintenance', url '/maintenance_url.php');] bzw. [$gallery->setConfig('mode.maintenance', '/maintenance_url.php');] existiert nur als [$gallery->setConfig('mode.maintenance', false);] und dennoch steckt die Gallery im Wartungsmodus fest, aber das schrieb ich ja bereits,

Quote:
ändern, so sie dann überhaupt auf $gallery->setConfig('mode.maintenance', url '/maintenance_url.php' ); steht. Dies ist nun nicht der Fall gewesen.

demnach kann das ja eigentlich nicht zu Missverständnissen führen.

Auf die Idee mal auf die /main.php?g2_view=core.SiteAdmin&g2_subView=core.AdminMaintenance zu gelangen, bin ich auch bereits gekommen, ebenso erfolglos.

Hat noch jemand andere bzw. ergänzende Lösungsvorschläge?

 
JessiKath

Joined: 2014-02-17
Posts: 18
Posted: Sun, 2014-04-06 11:13

Und?

Wird es noch einen brauchbaren Lösungsansatz geben, welcher den Wartungsmodus in der MySQL-Datenbank oder wo auch immer der Wartungsmodus über die Adminoberfläche ausgelöst und eingetragen wird?

Grüße,
Jess'

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Mon, 2014-04-07 20:52

The proper syntax:
$gallery->setConfig('mode.maintenance', false);
config.php line ~160

-s
________________________________
All New jQuery Minislideshow for G2/G3

 
JessiKath

Joined: 2014-02-17
Posts: 18
Posted: Wed, 2014-04-09 17:44

My config.php @line 159/195 since beginning of this thread:
$gallery->setConfig('mode.maintenance', false);
Effect: http://photos.jessika-katharina.net/ nothing...

Gibt es noch einen anderen Lösungsansatz?
Wie bereits geschrieben, ich habe die Seite über den Adminbereich in den Wartungsmodus mit URL gesetzt und mein Browser ist, bevor ich diesen dort wieder beenden konnte, abgestürzt. Seit dem hängt die Seite im Wartungsmodus fest.
Ich habe nie etwas in der config.php geändert und Veränderungen diese sind effektlos.

Is there a different approach?
As already written, I've set the page in the Admin area to maintenance mode with URL and my browser, before I could finish it there again, crashed. Since the site is stuck in maintenance mode.
I have never changed anything in the config.php and changes at this file didn't show any effects.

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Wed, 2014-04-09 19:23

Try:
UPDATE g2_PluginParameterMap SET g_parameterValue='' WHERE g_parameterName='mode.maintenance.lastUrl';

-s
________________________________
All New jQuery Minislideshow for G2/G3

 
JessiKath

Joined: 2014-02-17
Posts: 18
Posted: Thu, 2014-04-10 12:05

Thanks,

inside the config.php or which other file or command-line? "Replace" the other line or added (before~after)?

Jk

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Thu, 2014-04-10 12:22

You need to execute that sql query in phpMyAdmin or which ever database tool your host provides.

-s
________________________________
All New jQuery Minislideshow for G2/G3

 
JessiKath

Joined: 2014-02-17
Posts: 18
Posted: Thu, 2014-04-10 13:18

run: UPDATE g2_PluginParameterMap SET g_parameterValue='' WHERE g_parameterName='mode.maintenance.lastUrl';
Error: #1146 - Table '[Username]_[Tablename].g2_PluginParameterMap' doesn't exist
But a table without .g2 exists.

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Thu, 2014-04-10 13:29

are you executing that from within your gallery2 database?
or did you choose a prefix other than g2_?

-s
________________________________
All New jQuery Minislideshow for G2/G3

 
JessiKath

Joined: 2014-02-17
Posts: 18
Posted: Thu, 2014-04-10 14:05

Within.
Otherwise: #1046 - No database selected
{I think my prefix is photos_. I'll try it to change it.}
UPDATE photos_PluginParameterMap SET g_parameterValue='' WHERE g_parameterName='mode.maintenance.lastUrl'
Was executed, but no effect to the maintenance-mode.

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Thu, 2014-04-10 14:14

Can you browse the photos_PluginParameterMap table and confirm core mode.maintenance.lastUrl is indeed empty?

config.php and PluginParameterMap are the only places this can be set.

You can also make sure you clear your caches http://photos.jessika-katharina.net/lib/support/

-s
________________________________
All New jQuery Minislideshow for G2/G3

 
JessiKath

Joined: 2014-02-17
Posts: 18
Posted: Fri, 2014-04-11 16:17

http://photos.jessika-katharina.net/config.php:

<?php
@ini_set('display_errors', 0);
if (!isset($gallery) || !method_exists($gallery, 'setConfig')) {
    exit;
}
$gallery->setConfig('setup.password', '*');
$gallery->setConfig('data.gallery.base', '/home/photos-data');
$storeConfig['type'] = 'mysqli';
$storeConfig['hostname'] = 'localhost';
$storeConfig['database'] = '*';
$storeConfig['username'] = '*';
$storeConfig['password'] = '*';
$storeConfig['schema'] = '';
$storeConfig['tablePrefix'] = 'photos_';
$storeConfig['columnPrefix'] = 'g_';
$storeConfig['usePersistentConnections'] = false;
$gallery->setConfig('storage.config', $storeConfig);
$gallery->setDebug(false);
$gallery->setProfile(false);
$gallery->setConfig('mode.maintenance', false);
$gallery->setConfig('mode.embed.only', false);
$gallery->setConfig('allowSessionAccess', false);
$gallery->setConfig('galleryBaseUrl', '');
$gallery->setConfig('baseUri', 'http://photos.jessika-katharina.net/main.php');
?>

phpMyAdmin -> photos_PluginParameterMap:module core 0 mode.maintenance.lastUrl
http://photos.jessika-katharina.net/lib/support/:

Successfully deleted page cache
Deleting dir: /home/photos-data/cache/entity
Recreating dir: /home/photos-data/cache/entity
Deleting dir: /home/photos-data/cache/module
Recreating dir: /home/photos-data/cache/module
Deleting dir: /home/photos-data/cache/theme
Recreating dir: /home/photos-data/cache/theme
Deleting dir: /home/photos-data/smarty/templates_c
Recreating dir: /home/photos-data/smarty/templates_c
Deleting dir: /home/photos-data/tmp
Recreating dir: /home/photos-data/tmp
Deleting dir: /home/photos-data/cache/repository
Recreating dir: /home/photos-data/cache/repository
Removed 0 install/upgrade log files
Deleting dir: /home/photos-data/cache/derivative
Recreating dir: /home/photos-data/cache/derivative
 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Fri, 2014-04-11 16:15

I guess the last possibility would be to check your .htaccess

-s
________________________________
All New jQuery Minislideshow for G2/G3

 
JessiKath

Joined: 2014-02-17
Posts: 18
Posted: Fri, 2014-04-11 16:21

.htaccess:

RewriteEngine on
#{gallerySection}
RewriteCond %{HTTP_REFERER} !^http://photos.jessika-katharina.net/.*$      [NC]
RewriteCond %{HTTP_REFERER} !^http://photos.jessika-katharina.net$      [NC]
RewriteCond %{HTTP_REFERER} !^http://www.photos.jessika-katharina.net/.*$      [NC]
RewriteCond %{HTTP_REFERER} !^http://www.photos.jessika-katharina.net$      [NC]
 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Fri, 2014-04-11 16:50

grab a fresh copy of index.php and main.php and replace your current versions

-s
________________________________
All New jQuery Minislideshow for G2/G3

 
JessiKath

Joined: 2014-02-17
Posts: 18
Posted: Sat, 2014-04-12 11:42

Done... This is extremely screwed.

 
JessiKath

Joined: 2014-02-17
Posts: 18
Posted: Sat, 2014-04-12 12:13

I've searched the whole SQL datatables for the word "wartung", that's within the redirect URL, but:

Suchergebnisse für "wartung" mindestens eines der Wörter:0 Treffer in gal1_SequenceEventLog	 	 
0 Treffer in photos_AccessMap	 	 
0 Treffer in photos_AccessSubscriberMap	 	 
0 Treffer in photos_AlbumItem	 	 
0 Treffer in photos_AnimationItem	 	 
0 Treffer in photos_CacheMap	 	 
0 Treffer in photos_ChildEntity	 	 
0 Treffer in photos_DataItem	 	 
0 Treffer in photos_Derivative	 	 
0 Treffer in photos_DerivativeImage	 	 
0 Treffer in photos_DerivativePrefsMap	 	 
0 Treffer in photos_DescendentCountsMap	 	 
0 Treffer in photos_Entity	 	 
0 Treffer in photos_EventLogMap	 	 
0 Treffer in photos_ExifPropertiesMap	 	 
0 Treffer in photos_ExternalIdMap	 	 
0 Treffer in photos_FactoryMap	 	 
0 Treffer in photos_FailedLoginsMap	 	 
0 Treffer in photos_FileSystemEntity	 	 
0 Treffer in photos_Group	 	 
0 Treffer in photos_Item	 	 
0 Treffer in photos_ItemAttributesMap	 	 
0 Treffer in photos_ItemHiddenMap	 	 
0 Treffer in photos_Lock	 	 
0 Treffer in photos_MaintenanceMap	 	 
0 Treffer in photos_MimeTypeMap	 	 
0 Treffer in photos_MovieItem	 	 
0 Treffer in photos_PermalinksMap	 	 
0 Treffer in photos_PermissionSetMap	 	 
0 Treffer in photos_PhotoItem	 	 
0 Treffer in photos_PluginMap	 	 
0 Treffer in photos_PluginPackageMap	 	 
0 Treffer in photos_PluginParameterMap	 	 
0 Treffer in photos_RatingCacheMap	 	 
0 Treffer in photos_RatingMap	 	 
0 Treffer in photos_RecoverPasswordMap	 	 
0 Treffer in photos_RssMap	 	 
0 Treffer in photos_Schema	 	 
0 Treffer in photos_SequenceEventLog	 	 
0 Treffer in photos_SequenceId	 	 
0 Treffer in photos_SequenceLock	 	 
0 Treffer in photos_SessionMap	 	 
0 Treffer in photos_SubscriptionMap	 	 
0 Treffer in photos_TkOperatnMap	 	 
0 Treffer in photos_TkOperatnMimeTypeMap	 	 
0 Treffer in photos_TkOperatnParameterMap	 	 
0 Treffer in photos_TkPropertyMap	 	 
0 Treffer in photos_TkPropertyMimeTypeMap	 	 
0 Treffer in photos_UnknownItem	 	 
0 Treffer in photos_User	 	 
0 Treffer in photos_UserGroupMap	 	 
0 Treffer in photos_WatermarkImage

I'll download the whole gallery files and scan the files for, but find nothing.

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Sat, 2014-04-12 12:31

The only other thing I can think of is something more server related like apache or DNS redirect.
I'll ping Dayo and see if he has any ideas.

-s
________________________________
All New jQuery Minislideshow for G2/G3

 
JessiKath

Joined: 2014-02-17
Posts: 18
Posted: Sat, 2014-04-12 13:15

DNS redirect of photos.jessika-katharina.net is set to /photos/
I will look for the apache redirect rules in a few hours, but I've never change them before.

 
Dayo

Joined: 2005-11-04
Posts: 1642
Posted: Sat, 2014-04-12 16:03

Hi,

Dont understand the first few posts in German but from google translate, it seems you had it in maintenance mode, lost power and it is now stuck in maintenance? Is that the case?

--
dakanji.com

 
JessiKath

Joined: 2014-02-17
Posts: 18
Posted: Sat, 2014-04-12 18:07

Hi,

yes, that's correct.
I've trying to translate the opening post.
Sorry about my rusty English. :D

 
Dayo

Joined: 2005-11-04
Posts: 1642
Posted: Sun, 2014-04-13 02:34

Thanks for the translation. Need to brush up on my German!

There isnt any other way to switch maintenance on or off.

One thing is unclear from what you wrote about power going off.
Are you hosting the website at home? That is, is the actual computer at your home the one serving the website or do you have an account with a web host?
--
dakanji.com

 
JessiKath

Joined: 2014-02-17
Posts: 18
Posted: Sun, 2014-04-13 11:06

I've shrinked the informations a little bit, because of freaking misunderstandable translations.
I think, if you don't use this language for more than a few times, that's not the right way, it's only wasted time. ;)
Other way, I need to brush up MY English, it's more usable for all! :D

Back to topic.

That's very *grmpf*, what's going wrong?
My server is hosted outside in UK, my home computer, attention ironic, is hosted in my kitchen with an little UPS, it's online over an cable-modem.
While I'm uploaded some pictures in maintenance.mode, while I went out for a few minutes, the powerlines failing. In case of this, my computer shuts down normal way to hibernate mode. But the upload process wasn't finished and the maintenance mode was still enabled.
After the powerlines back online (2 hours), I can start up my computer back online. But I can't access the webside to restore the gallery out of maintenance mode.

I's the only way reinstall the gallery and load up all the photos again?

 
Dayo

Joined: 2005-11-04
Posts: 1642
Posted: Sun, 2014-04-13 19:11

Ok.

Let us focus on your server as your home machine does not display your site.

Can't you edit the config.php on the web server ... the same way you did to put it to maintenance mode?

Alternatively, you can bypass the maintenance mode as admin by using this url:

Quote:
photos.jessika-katharina.net/main.php?g2_view=core.UserAdmin&g2_subView=core.UserLogin&g2_controller=core.UserLogin& g2_form[formName]=UserLogin&g2_form[action][login]=Login&g2_form[username]=admin&g2_form[password]=secret

(replace "secret" with your own password)
(replace admin with your admin username)
--
dakanji.com

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Sun, 2014-04-13 19:35

@Dayo, I know you are traveling, but please read through the thread.
We tried that already - and much more.
I would not have asked for your suggestions if it were that simple.

Although, I was not able to get to an admin login screen before.

-s
________________________________
All New jQuery Minislideshow for G2/G3

 
JessiKath

Joined: 2014-02-17
Posts: 18
Posted: Sun, 2014-04-13 20:43

WOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOW!!!!!

THAT WAS IT!!!

Thank's you a lot!!!

WOW!!!

For all others, they stucked in maintenance mode, try this workaround:

Dayo wrote:
...
Alternatively, you can bypass the maintenance mode as admin by using this url:

Quote:
photos.jessika-katharina.net/main.php?g2_view=core.UserAdmin&g2_subView=core.UserLogin&g2_controller=core.UserLogin& g2_form[formName]=UserLogin&g2_form[action][login]=Login&g2_form[username]=admin&g2_form[password]=secret

(replace "secret" with your own password)
(replace admin with your admin username)
--
dakanji.com

Dayo, thank U very much!!! It works!!!
Yes, I'm able to edit the config.php, but I'm not use this way to enter maintenance mode.
But the "Alternative"-Way is working!!! You can verifying it. :D
WOW, I'm very happy!

Und nun noch mal das ganze auf Deutsch:

Du steckst im Wartungsmodus fest? Ein Ändern der config.php und der SQL Werte nichts gebracht hat, versucht den Lösungsweg von Dayo, der funktioniert auf jeden Fall!!!

 
Dayo

Joined: 2005-11-04
Posts: 1642
Posted: Sun, 2014-04-13 20:48

Wayne,

I am working through based on my understanding of the info Jessi has given to me.
So I have given two options because it seemed one of them may have been tried but I couldnt be sure.
In any case I am not sure what the fuss is about.

Jessi,

Hopefully, you can log in as admin and hope that helps.
Perhaps you ticked something to switch to maintenance mode in G2 admin.
I dont have access to my installation to check but vaguely remember that there is an option in the G2 admin.I normally use the config.php myself.
Anyway, I think once you are logged in as admin, you should be able to proceed.
Let us know.

--
dakanji.com

 
Dayo

Joined: 2005-11-04
Posts: 1642
Posted: Sun, 2014-04-13 20:55

Great news.

To others coming across this, if you can post in english on the main boards, pls do.
I dont think we have any German speaking regular contributors anymore.

--
dakanji.com

 
JessiKath

Joined: 2014-02-17
Posts: 18
Posted: Sun, 2014-04-13 20:56

It's solved!
I was able to log in as admin and switch the maintenance mode off, but we have not try this way before.
I didn't know this way before, thats was the reason for my fuss. Sorry.

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Sun, 2014-04-13 21:17

I'd be interested in knowing which DB field is changed in maintenance mode. I had tried a direct admin url and was redirected. I had also searched the DB for any maintenance reference to no avail.

-s
________________________________
All New jQuery Minislideshow for G2/G3

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Sun, 2014-04-13 21:19
Quote:
I dont think we have any German speaking regular contributors anymore.

I think XCOM still watches, but no longer full time.

@JessiKath your English was fine :)

-s
________________________________
All New jQuery Minislideshow for G2/G3

 
JessiKath

Joined: 2014-02-17
Posts: 18
Posted: Sun, 2014-04-13 21:57

@suprsidr thank U, but I think my grammatic is not so fine. :D

I'll try to contribute sometimes, but it's hard to follow every thing in this forum.

But now I know, who I can ask in case of a problem, I'm not able to solved by my self.