Installing 7.10.1 with LAMPP 7.2.2.-0(latest) on a fresh Ubuntu 17.10

Iā€™m following the installation manual on the CRM site and my problems are with setting permissions to the folders. When I get to the installation page, it asks me to set permissions to a number of folders in the cache folder, like images, layout, xml, etc.

Thing is, when i use the commands given me by the guide and use the ā€œre-checkā€ option, nothing happens. Iā€™ve tried setting permissions to 777 instead of 755 and 775 like the guide tells me to, and that gives me an OK, but creates a fatal error when installing so itā€™s back to square one. I got it to work once, but I didnā€™t write down what i did exactly and have since forgotten. The machine i got it to work in got reformatted.

Another issue is this command:
sudo chmod -R 775 cache custom modules themes data upload config_override.php

it gives me:
chmod: cannot access ā€˜config_override.phpā€™: No such file or directory

iā€™m on the proper directory.
I just want to know just what am i doing wrong.

I havenā€™t been able to find a guide thatā€™s made specifically for XAMPP through google so Iā€™m kind of stumped here. Iā€™ve been trying and retrying for a while and I just canā€™t find the answer.

Which command did you use for ownerships? I mean the ā€œchownā€ command.

Never mind the error about config_override.php, you can remove that from the chmod command. That file is created by the installer, so it isnā€™t there yet.

Iā€™m guessing what will work for you will be this, typed from the root of your SuiteCRM install:


sudo chown -R www-data:www-data .
sudo chmod -R 755 .
sudo chmod -R 775 cache custom modules themes data upload

But that www-data is for Apache on Ubuntu 16.04, I hope itā€™s the same for 17, but only if youā€™re running Apache. If not, go and find out what your web server username is.

You can see here a few other steps to install smoothly. Youā€™ll have to adapt the PHP module names for your PHP 7.2.

https://suitecrm.com/suitecrm/forum/installation-upgrade-help/11561-installing-on-ubuntu-16-04-1#45976

Yeah, i am running the apache module on XAMPP.

By root, do you mean like /opt/lampp/htdocs/SuiteCRM ? or is there another folder i need to apply these permissions to?

because i already tried these 3 commands, and i still get the same page telling me i need to update folder permissions.

this is the page before and after inputting the 3 commands:
https://i.imgur.com/hdVJKVy.png

Yes, thatā€™s what I mean by the root of your SuiteCRM installation, something like /opt/lampp/htdocs/SuiteCRM

Please post here the result of this command:

ls -al /opt/lampp/htdocs/SuiteCRM

This will give me a quick look at how your permissions really are set.


drwxr-xr-x  20 www-data www-data   4096 mar  5 06:43 .
drwxr-xr-x   6 root     root       4096 mar 11 17:51 ..
-rwxr-xr-x   1 www-data www-data    411 mar  1 14:05 bower.json
drwxr-xr-x   2 www-data www-data   4096 mar  1 14:05 build
drwxrwxr-x   4 www-data www-data   4096 mar  2 05:40 cache
-rwxr-xr-x   1 www-data www-data   3587 mar  1 14:05 campaign_tracker.php
-rwxr-xr-x   1 www-data www-data   3094 mar  1 14:05 CODE_OF_CONDUCT.md
-rwxr-xr-x   1 www-data www-data   1027 mar  1 14:05 composer.json
-rwxr-xr-x   1 www-data www-data 115616 mar  1 23:55 composer.lock
-rwxr-xr-x   1 www-data www-data   5052 mar  1 14:05 cron.php
-rwxr-xr-x   1 www-data www-data   2446 mar  1 14:05 crossdomain.xml
drwxrwxr-x   5 www-data www-data   4096 mar  1 14:05 custom
drwxrwxr-x   3 www-data www-data   4096 mar  1 14:05 data
-rwxr-xr-x   1 www-data www-data   2386 mar  1 14:05 dictionary.php
-rwxr-xr-x   1 www-data www-data  12566 mar  1 14:05 download.php
-rwxr-xr-x   1 www-data www-data   2390 mar  1 14:05 emailmandelivery.php
-rwxr-xr-x   1 www-data www-data   4918 mar  1 14:05 export.php
-rwxr-xr-x   1 www-data www-data 967627 mar  1 14:05 files.md5
-rwxr-xr-x   1 www-data www-data   2808 mar  1 14:05 HandleAjaxCall.php
-rwxr-xr-x   1 www-data www-data   2367 mar  1 14:05 ical_server.php
drwxr-xr-x  58 www-data www-data   4096 mar  1 14:05 include
-rwxr-xr-x   1 www-data www-data   2374 mar  1 14:05 index.php
drwxr-xr-x   6 www-data www-data   4096 mar  1 14:05 install
-rwxr-xr-x   1 www-data www-data  31893 mar  1 14:05 install.php
-rwxr-xr-x   1 www-data www-data   2275 mar  1 14:05 json_server.php
drwxr-xr-x   3 www-data www-data   4096 mar  1 14:05 jssource
drwxr-xr-x   6 www-data www-data   4096 mar  1 14:05 lib
-rwxr-xr-x   1 www-data www-data  34539 mar  1 14:05 LICENSE.txt
-rwxr-xr-x   1 www-data www-data   2313 mar  1 14:05 log_file_restricted.html
-rwxr-xr-x   1 www-data www-data   2376 mar  1 14:05 maintenance.php
drwxr-xr-x   2 www-data www-data   4096 mar  1 14:05 metadata
drwxr-xr-x   3 www-data www-data   4096 mar  1 14:05 ModuleInstall
drwxrwxr-x 119 www-data www-data   4096 mar  1 14:05 modules
-rwxr-xr-x   1 www-data www-data   2886 mar  1 14:05 pdf.php
-rwxr-xr-x   1 www-data www-data    304 mar  1 14:05 php_version.php
-rwxr-xr-x   1 www-data www-data   3758 mar  1 14:05 README.md
-rwxr-xr-x   1 www-data www-data     73 mar  1 14:05 robots.txt
-rwxr-xr-x   1 www-data www-data   3588 mar  1 14:05 run_job.php
drwxr-xr-x  12 www-data www-data   4096 mar  1 14:05 service
drwxr-xr-x   2 www-data www-data   4096 mar  1 14:05 soap
-rwxr-xr-x   1 www-data www-data   3929 mar  1 14:05 soap.php
-rwxr-xr-x   1 www-data www-data   5327 mar  1 14:05 SugarSecurity.php
-rwxr-xr-x   1 www-data www-data    154 mar  1 14:05 sugar_version.json
-rwxr-xr-x   1 www-data www-data   2296 mar  1 14:05 sugar_version.php
-rwxr-xr-x   1 www-data www-data    170 mar  5 06:43 suitecrm_version.php
drwxrwxr-x   4 www-data www-data   4096 mar  1 14:05 themes
-rwxr-xr-x   1 www-data www-data   5839 mar  1 14:05 TreeData.php
drwxrwxr-x   2 www-data www-data   4096 mar  1 14:05 upload
-rwxr-xr-x   1 www-data www-data   2248 mar  1 14:05 vcal_server.php
-rwxr-xr-x   1 www-data www-data   2976 mar  1 14:05 vCard.php
drwxr-xr-x  18 www-data www-data   4096 mar  1 23:55 vendor
drwxr-xr-x   2 www-data www-data   4096 mar  1 14:05 XTemplate
drwxr-xr-x   7 www-data www-data   4096 mar  1 14:05 Zend

hereā€™s everything that it displays.

And what does this give you?

ps -ef | egrep '(httpd|apache2|apache)' | grep -v `whoami` | grep -v root | head -n1 | awk '{print $1}'

And what do you see in your install.log that looks suspicious?

earlier today, i did some reading around and apparently my default apache name was ā€œdaemonā€ (thatā€™s what it led me to believe at first.)

so instead of www-data i used daemon instead, and while it did allow me to continue on with the installation, it gave me a fatal error at the end and the installation fails. the same with setting the permissions to 777. Later i did more reading and apparently daemon is just the name of background processes, so that was wrong.

I deleted the suitecrm server folder and started back from scratch. Though i think there was some setting i didnā€™t change. My apologies for not mentioning earlier on. I just thought it wasnā€™t important since i tried following the install steps from a fully clean ubuntu install and it didnā€™t work.

how to i access that log? I suppose I should mention i only have a basic knowledge of ubuntu. Iā€™m just forced to use it in my case for a special project iā€™m working on.

Just do


sudo chown -R daemon:daemon .
sudo chmod -R 755 .
sudo chmod -R 775 cache custom modules themes data upload

then install, if it throws an error tell me what it is. You can inspect logfiles by typing for example

nano install.log

If the installer is able to proceed further you will have also a suitecrm.log

Pay attention to what time your installing, and what exact time the error occurs, that way you can find your way in the logs more easily.

on the CRM log file:

[quote]dom 11 mar 2018 23:58:58 CET [27337][-none-][FATAL] Query Failed: CREATE DATABASE testDB CHARACTER SET utf8 COLLATE utf8_general_ci: MySQL error 1044: Access denied for user ā€˜ā€™@ā€˜localhostā€™ to database ā€˜testDBā€™
dom 11 mar 2018 23:58:58 CET [27337][-none-][FATAL] Could not connect to DB server localhost as iacDB. port : Access denied for user ā€˜ā€™@ā€˜localhostā€™ to database ā€˜testDBā€™[/quote]

on the install.log:

on the browser:
https://i.imgur.com/S1ApLYx.png

Check the credentials youā€™re using to access the database.

Host should be localhost
User and password should be something that you can use to login to ā€œmysqlā€ from the command-line, and get root access in there.
You donā€™t create a database for suitecrm, the installer does it for you. If you already have one, delete it first.

Iā€™m sorry, iā€™m not following. When i try to install SuiteCRM with just the apache XAMPP module running, it wont connect to the database. I have to turn on the mysql module on it for it to work. https://i.imgur.com/jKMw1eR.png

When i manage to get to the admin/db creation page, it asks for a database name, admin name etc. I fill everything in, press next and it just brings me to the same ā€œFatal error: Uncaught Exception: Could not connect to the database. Please refer to suitecrm.log for details (2)ā€ page.

the only thing i change is the DB name (suiteDB) and username (iacDB), admin stays the same, and all i do is profide a password and an email which are required fields.

the crm.log file says:

is iacDB wrong? should it have been daemon instead? Or does it need to be ā€œadminā€?

I have only done the minimal steps required on this new fresh install (why i took so long to get back to you). Installed ā†’ Updated Software ā†’ Downloaded XAMPP and SuiteCRM from the official download pages

and then followed suitecrm installation instructions, though i swapped www-data for daemon as we worked out in this thread. I have not touched anything regarding mysql or have any prior databases to this fresh OS install.

Sorry, is it XAMPP or LAMPP? Or are they the same thing? I thought XAMPP was a Windows thing.

Exactly which OS are you running? And which versions of Apache, MySQL and PHP? I should have asked all this at the beginning.

I think you have a XAMPP problem, not a SuiteCRM problem. You need to get your PHP connected to your database.

You can try mysql credentials from the command-line by doing something like this

mysql -u iacDB -p

Make sure you have a pair of credentials that work so you can give those to the SuiteCRM installer. If it still fails check PHP modules or other stuff regarding the coupling of PHP and database.

I also note your error message doesnā€™t say the port number, maybe itā€™s confused about which port to use? You should just leave it at the default and type host ā€œlocahostā€ without any port.

XAMPP and LAMPP are the same thing. (x means cross platform). Apache is 2.4.29, MariaDB is 10.1.30(seems to be the mysql equivalent) PHP is 7.2.2.

The ā€œhostnameā€ is the default ā€œlocalhostā€ and the ā€œURL of CRM instanceā€ is http://localhost. i donā€™t think iā€™ve not messed with any port settings.

When i try that command it says:

Iā€™m sorry, I donā€™t know how to fix it. I advise you to look for help on the XAMPP forums, if there are any. Thereā€™s no point in trying the SuiteCRM installer when you canā€™t even connect to your databaseā€¦

No problem mate.

I got it to work, itā€™s not ideal but Bitnami (the XAMPP guys) have a suite CRM module. So i guess iā€™ll have to use that for the time being until i do a non-xampp config.

Have you seen my Ubuntu 16.04 install notes? If youā€™re using Ubuntu, all these packages are really easy to install, you donā€™t need no XAMPP and no Bitnami, just a few apt-gets. I do it all in less than 10 minutes including download times. It shouldnā€™t be too different in 17.04.

Iā€™ll check that out soon. I wanted to make it work with xampp cause thats what i was tasked with.

Apologies for the double post and necro, but where might I see those notes? I tried doing it manually without xampp and when I go to the domain Iā€™ve set up it doesnā€™t connect. Iā€™m at my witā€™s end. Maybe iā€™m just bad at following simple instructions, but I havenā€™t been able to get it to work. i just want something thatā€™s a close to LAMPP as possible.

I gave you the link a few posts ago :slight_smile:

Here it is again

https://suitecrm.com/suitecrm/forum/installation-upgrade-help/11561-installing-on-ubuntu-16-04-1#45976

I replaced ā€œindex.htmlā€ on /var/www/html/ with the one provided by suite crm because it told me to do that on the page, but when i replace it it says ā€œtThis directory must be writable by the webserver user.ā€