Tips for 1and1 customers

[kebabman]

I have a 1and1 managed server (I am now regretting not getting a root Linux server but that's besides the point). I recently wanted to install SugarCRM on it and ran into a few problems which I though I would share.

The first problem was getting the database settings right. Due to the way 1and1 set up their servers the hostname for the mysql server is listed as 'localhost:/tmp/mysql5.sock#. This doesn't work when placed into the Sugar interface during the install. You have to manually edit the install.php and index.php files in the Sugar root directory and place the following line of code after the <?php and 'if(!defined('sugarEntry'))define('sugarEntry', true);' line.

ini_set ( 'mysqli.default_socket' , '/tmp/mysql5.sock' );

This will help you get past the database settings page but then after that you are likely to get a bunch of chmod() errors. This is not technically due to the way 1and1 manages their file system and you can get around it by performing this change to the Sugar code...

Change line 196 of the file /include/utils/sugar_file_utils.php to the following: return true; //chmod($filename, $mode);

All of this is stuff I picked up from these forums in one place (and language) or another but I couldn't find the info listed in one place so I am placing it on here. Hope some people find it useful. I am sure it also applies to other hosts other than 1and1 as well.

[kebabman]

As an addition to this, if you want to use the sugar scheduler you will need to add the same line of code as above to cron.php.

[buxton1]

you are a diamond!

[domsie]

Change line 196 of the file /include/utils/sugar_file_utils.php to the following: return true; //chmod($filename, $mode);

All of this is stuff I picked up from these forums in one place (and language) or another but I couldn't find the info listed in one place so I am placing it on here. Hope some people find it useful. I am sure it also applies to other hosts other than 1and1 as well.

Kebabman

Thanks a lot for the first tip

However, when I edit the utils file, I get the following error:

Parse error: syntax error, unexpected '"' in /homepages/14/database/htdocs/Sugar/SugarCE-Full-5.5.0/include/utils/sugar_file_utils.php on line 53

Fatal error: Class 'LogicHook' not found in /homepages/14/database/htdocs/Sugar/SugarCE-Full-5.5.0/include/utils.php on line 2913

Any ideas?

Thanks
Domsie

[domsie]

Kebabman

Thanks a lot for the first tip

However, when I edit the utils file, I get the following error:

Parse error: syntax error, unexpected '"' in /homepages/14/database/htdocs/Sugar/SugarCE-Full-5.5.0/include/utils/sugar_file_utils.php on line 53

Fatal error: Class 'LogicHook' not found in /homepages/14/database/htdocs/Sugar/SugarCE-Full-5.5.0/include/utils.php on line 2913

Any ideas?

Thanks
Domsie

Kebabman

Don't worry about this query.

I installed Sugar & for some reason the theme didn't load and therefore there was just text showing.

I then changed the permissions of the following folders and subfolders to 777:

/cache/modules/themes

And hey presto, all is good !! )

[willp1203]

I too have a 1and1.com managed server. I was trying to install 5.5CE

I followed the instructions provided by Kebabman:
* I added the line: ini_set ( 'mysqli.default_socket' , '/tmp/mysql5.sock' ); for the files index.php, install.php, cron.php
* I changed line 196 in the file /include/utils/sugar_file_utils.php to return true; //chmod($filename, $mode);

It solved everything and I'm running just fine. You saved me countless hours of debugging. Thank you very much.

[santhush]

Thank you soo much for the info.. HOWEVER I seem to be having an issue POST INSTALLATION...


I get the following error after installation. The installation process worked very smoothly without any errors, however when I try to go to the index page I get the following error.

Warning: mysqli_connect() [function.mysqli-connect]: (00000/1045): Access denied for user: '<USERNAME>@localhost' (Using password: YES) in /DIRECTORYPATH/include/database/MysqliManager.php on line 281
Could not connect to server localhost as <USERNAME>. port . Access denied for user: '<USERNAME>@localhost' (Using password: YES)

My config file says "LOCALHOST" for the host and says "SQLEXPRESS" for the instance.... any ideas?

Thanks!