index.php returns an empty page

[duncanc]

Hi,

Ubuntu Linux 8.10 64-bit, (Linux 2.6.27-11-generic)
SugarCRM CE 5.2.0a,
Apache/2.2.9 (Ubuntu) PHP/5.2.6-2ubuntu4.1 with Suhosin-Patch
MySQL 5.0.67-0ubuntu6

Everything WAS running fine. System rebooted after a Canonical supplied update to something in Ubuntu. I am suspecting that a required package may have been autoremoved during the update.

Now when attempting to login to SugarCRM, the page returned by index.php is empty - whether run locally from a browser on the server, or run from a separate machine..

MySQL Server is up and the sugarcrm database is accessible and contains data.
phpinfo.php returns the standard extensive list of information as usual.
Apache2 is operational and the usual html test page returns the expected result.

Any suggestions on what to fix, or where to go looking next would be much appreciated.

Thanks

Duncan

[antoniocal]

Start with the sugarcrm.log file in the sugarCRM root dir
If you cant see anithing like an error, you can edit the config.php to get more detail in the logs.

Good look

[duncanc]

Thanks. Log config was set to fatal level. There were no log entries since a failed login attempt on march 5 (wrong password).

I changed the level to debug and restarted. Attempted to get login page again. Still blank. and no additional entries in the log file.

Would have expected something after setting to debug level.

Since I have a backup of the sugarcrm database in mySQL, is there anything to stop me from setting installer_locked => false and rerunning the install, then restoring the sugarcrm database if required?
Does the installer even touch the database if it already exists and contains data?

Thanks
Duncan

[antoniocal]

WARNING! The installer deletes any table in the selected database (it warn you before)

If you have a backup of the database you can:
1) Copy the code to another directory in the httpd home, import the backup in other database in the same Mysql database and point the code to this database (find "database" in the config.php) and see if it runs or do another things.
2) install the backup over your database and try-it (not recomended)
3) make a new fresh instalation and put your database over the new one.

Any case, you have to know that sugar put the "custom" information on the database AND in the code. this means that any change that you make on the studio or by installing new modules with module Loader have code and database changes.

All the database information (or almost) of changes in the structure (new fields or modules principally) can be rebuildt by runing the repair options in admin module.
by the other hand, if you took a fresh instalation code and put you database, all the new "custom" fields and modules and relationships will be "invisible" to this version.

All the above info is irrelevant if you NEVER use the admin module (except to create users and roles)

Any case, you can do a copy of the code and your database and configure it to work on the same instance or in other, so you dont compromise your "production" instace (still if isnt IN production is your last production state )

I hope this help you
Good look
(sorry about my english)

[duncanc]

Thanks for that.
I backed up code and database.
Set the Install option and ran install.php

It tells me:
Database Support was not found. Please make sure you have the necessary drivers for one of the following supported Database Types: MySQL, MS SQLServer, or Oracle. You might need to uncomment the extension in the php.ini file, or recompile with the right binary file, depending on your version of PHP. Please refer to your PHP Manual for more information on how to enable Database Support.
Note: Your php configuration file (php.ini) is located at:
/etc/php5/apache2/php.ini

MySQL is installed and I can clearly use it, but php (or Sugar) apparently cannot. And I maintain that neither the mysql, nor sugar or php configurations were changed, so it takes me back to the original premise that the last ubuntu automatic update was causal.

A check of the packages installed on the ubuntu server revealed that the php5-mysql package version 5.2.6-2ubuntu4.1 was no longer installed. Apparently removed automatically at the last automatic update of the server, presumably because it was determined to be not in use. of course it provides connectivity between php and mysql.

I reinstalled the package and restarted.

Magically everything Sugar is working again.

So apparently a blank login page without any error message or diagnostic, is an indication that the database connectivity is lost.

No apologies for english please, you are perfectly understandable and much better at english than i am at my other languages.

And thanks again for the help.

Duncan

[antoniocal]

The SQLEXPRESS line is ignored when the database is Mysql. thats not the problem.

The other think you can see is the security settings in Mysql. I dont realy think its the problem, but you can try.
The error is "there is not database support" not "the user /pass is incorrect"



So, all ponit to a problem in the Mysql support in your apache/php.
My skills there ar poor... i cant help you in this area, but some questions can help:

One aclaration: the data in your sugarCRM config.php is not what it uses in the install process. Unlike, the data you enter in the install process is the right one.
You are naming your server by localhost, name or IP ? (you can try changing this in the install process)
You have a firewall ?
You have the right permission sets in the dirs, and files ?
You can try tu put a php page in the apache home and connect to any database to tests the mysql support ?

Good look.