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:
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.
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.
[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]
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.
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ā¦
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.
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 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.ā