Forum GLPI-Project

jwrobbins

Member

Registered: 2007-11-28

Posts: 27

Blank screen on login after database restore

Hello,

I recently had a server failure and I am in the process of restoring GLPI to its previous state. I have a database backup and I downloaded the GLPI version I had been using before the crash, version 0.70.2. I have restored the database and I am attempting to log into GLPI but after I enter my credentials it takes me to a blank page, even the page source is empty. I tried logging in against the LDAP server and a local GLPI user with no success.

I am not sure what to try now. I am open to suggestions.

--Specs--
GLPI 0.70.2
MySQL 5.0.51
Apache 2.2.8
PHP 5.2.4 (memory_limit = 32M)
Ubuntu 8.04 LTS (linux 2.6.24)

wawa

GLPI-DEV

From: Montpellier / France

Registered: 2006-07-03

Posts: 6,019

Website

Re: Blank screen on login after database restore

hello
it may be a problem of rights
do you have write access to config/ and files/ ?
is files/ owned by www-data ?

jwrobbins

Member

Registered: 2007-11-28

Posts: 27

Re: Blank screen on login after database restore

Thank you for your reply. I am not sure its an issue of rights. However, I did check and here are the directories in question:

drwxrwxrwx  2 jrobbins www-data  4096 2008-07-16 13:58 config
drwxrwxrwx 17 www-data www-data  4096 2008-07-11 11:25 files

jrobbins@intra-svr:/srv/helpdesk/files$ ls -l
total 64
drwxrwxrwx 18 www-data www-data 4096 2008-02-19 10:13 _cache
drwxr-xr-x  2 www-data www-data 4096 2008-06-20 16:40 CONFIG
drwxrwxrwx  2 www-data www-data 4096 2008-07-16 16:00 _cron
drwxr-xr-x  2 www-data www-data 4096 2008-03-18 10:21 DOC
drwxrwxrwx  2 www-data www-data 4096 2008-02-19 10:13 _dumps
drwxr-xr-x  2 www-data www-data 4096 2008-07-11 11:25 EXP
drwxrwxrwx  2 www-data www-data 4096 2008-07-16 13:23 _lock
drwxrwxrwx  2 www-data www-data 4096 2008-02-19 10:13 _log
drwxrwxrwx  2 jrobbins www-data 8192 2008-07-15 14:20 PDF
drwxrwxrwx  3 www-data www-data 4096 2008-06-10 09:47 _plugins
drwxrwxrwx  2 jrobbins www-data 4096 2008-03-07 17:00 RTF
drwxrwxrwx  2 www-data www-data 4096 2008-07-16 13:57 _sessions
drwxr-xr-x  2 www-data www-data 4096 2008-06-13 15:29 TXT
drwxrwxrwx  2 www-data www-data 4096 2008-02-19 10:13 _uploads
drwxr-xr-x  2 www-data www-data 4096 2008-04-25 09:04 XLS

jrobbins@intra-svr:/srv/helpdesk/config$ ls -l
total 28
-rwxrwxrwx 1 jrobbins www-data  2713 2008-02-19 10:13 based_config.php
-rwxrwxrwx 1 jrobbins www-data   163 2008-07-16 13:58 config_db.php
-rwxrwxrwx 1 jrobbins www-data  7024 2008-02-19 10:13 config.php
-rwxrwxrwx 1 jrobbins www-data 10758 2008-02-19 10:13 define.php

Everything looks fairly wide open though..

tsmr

GLPI-DEV

From: Rennes

Registered: 2005-08-26

Posts: 11,632

Website

Re: Blank screen on login after database restore

php5-ldap ?

---

Xavier Caillaud
Blog GLPI Infotel

jwrobbins

Member

Registered: 2007-11-28

Posts: 27

Re: Blank screen on login after database restore

This is an excellent suggestion, and I indeed did not have php5-ldap installed. However, this did not solve my problem. I installed the package, restarted apache and I am still getting a blank page on login.

Nothing is being logged in apache either so I am troubleshooting blind. Is there any way to enable logging in GLPI if you can't get into the GUI?

tsmr

GLPI-DEV

From: Rennes

Registered: 2005-08-26

Posts: 11,632

Website

Re: Blank screen on login after database restore

with phpmyadmin -> debug=2 in glpi_config table

---

Xavier Caillaud
Blog GLPI Infotel

wawa

GLPI-DEV

From: Montpellier / France

Registered: 2006-07-03

Posts: 6,019

Website

Re: Blank screen on login after database restore

do you have php5-mysql too ?

jwrobbins

Member

Registered: 2007-11-28

Posts: 27

Re: Blank screen on login after database restore

Alright, I kept tweaking things until it finally worked. I had to delete everything in the files/_cache directory. GLPI was finding something it didn't like in there I suppose.

Just to recap. Here is how I recovered from a server meltdown. This assumes you have backups of both your MySQL database and entire GLPI directory:
1. Reinstalled Apache, PHP, and MySQL and any related modules (don't forget php5-ldap if you authenticate against AD!)
2. Downloaded and un-archive the same version of GLPI as I had before the server crash
3. Ensure proper permission on config and files directory.
4. Restore the MySQL database and any user permissions from the most recent backup (you did back up didn't you???)
5. From the backup of the original GLPI directory, restore the contents of the original config directory to the new config directory.
6. Check that I can log in
7. From the backup of the original GLPI directory, restore the contents of the original files directory to the new files directory.
8. Check that I can log
9. Finally I copied over any other custom modifications I made from the backup directory to the new directory
10. Check that I can log
---

This is in no way an official howto... Just what I did to get back up and running. YMMV