Installation issue with 8.5.0 version - could not connect to DB

sudo chown -R www-data:www-data . is generating a eror message:
chown: incorrect group: www-data:www-data

seems still some rights issues

if you do

id www-data

what is the output ?

uid=33(www-data) gid=33(www-data) groupes=33(www-data)

Check if you have any other program / terminal locking the log files…

weird. the group is www-data (as expected).
And if we use a command similar to yours initial:

find . -type d -exec chown www-data:www-data {} \; && find . -type f -exec chown www-data:www-data {} \;

Does this return ok?

It worked but I had to run it as root user.
I did again ./bin/console suitecrm:app:install but still got last same error message

Please share screenshots that you are doing on terminal. So we could help you more.

I have to say I’m still a bit clueless about this install ran on the terminal

Why don’t you just access the browser and do the install from there? What error shows now, that the file permissions are supposedly correct?

Thanks all for your support (very much appreciated).

I attached screenshot when trying to do it via CLI.

With Web browser, I got a blank screen (nothing is happening). I use http://localhost (redirected to http:://localhost/index.php)

Note: I didn’t mention that there was a message about PHP deprecated (I suppose it should work even if this message is displayed).

What is your PHP version?

If this is just a development server I would reboot it to see if there is something locking your file. If it’s not that, then it must be permissions issues, you probably still don’t have that quite right…

I would rather focus on the blank screen on the browser. That shouldn’t be happening.

Are you using php or php-fpm?

I would tail logs for web server error_log and the php log, and see what errors pop up when trying to open in the browser.
Most likely is there’s a critical php error, but could be something else. The logs should throw you a hint. those logging mechanisms weren’t designed by suitecrm so you’re safe.

Hello.
Actually, issue was on mySQL server. Currently fixing it

Awesome! Share you solutions with us, so it will help others in the future.

Hello all.
Actually, I realized that mySQL wasn’t set properly. It is not stated in installation guide (I thought it was install suiteCRM script to make it) that you need to:

  • set root password (I also granted root access to mysql @localhost ← I don’t know if it is required for suitecrm but just in case)
  • create a database for suiteCRM. I called it ‘CRM’
  • create a user that have all privileges to access to ‘CRM’ database previously created

Clearly, now I see progress when tring to install it from CLI (./bin/console suitecrm:app:install).

However, I still got an error message (see attached picture for more log): “upload File Size | error | Warning: Your PHP configuration should be changed to allow files of at least 6MB to be uploaded.”

Any idea for next step ?

I see these recommendations in plenty of online guides, but I’ve done countless SuiteCRM installs without these steps. The installer does all that for me. And it works. That’s why it’s not added to the official installation guides.

So there must be some other problem or detail that was causing your problems.

However, I still got an error message (see attached picture for more log): “upload File Size | error | Warning: Your PHP configuration should be changed to allow files of at least 6MB to be uploaded.”

SOLUTION:

Hello all.
I’m back again. I restart from scratch install on a new VM, was more carefull at all steps. I’m suspecting I missed first time proper configuration of PHP-FPM.

As I understood this time that I don’t need to create Database in mysql, I haven’t connect to mysql at all (I just installed packages and check that process is started).

Now I succeed to access to install page via Web Browser.
However, I still get an error message. Any idea of what is still missing ?

Please note that my understanding was:

  • I don’t have to create in mysql SuiteCRM Dabase User (I understood suitecrm install script will make it)
  • same for database name

Is my understanding correct? Any guidance?

The mysql installation will always create a root user, I believe. You can use this user in the SuiteCRM installer, that’s what I typically do.

It’s only the creation of the database for SuiteCRM (and its permissions) that I don’t do anything and let the installer do everything for me.

I hope this makes things clearer, in case I wasn’t clear before.

I suggest trying a really simple and short password, with no special characters, just as a test, to eliminate other possible bugs.

Watch this video :desktop_computer: :computer_mouse: :v:

SuiteCRM 8 Upgrade Tutorial Walkthrough Step by Step by Paul Stevens


Suitecrm-8-on-ubuntu Blog


Hello.
I created a user in mysql with all rights access. Could be good to put some tips in documentation that a mysql or mariadb user must be created with example (command line command) on how to create them.

Then, I faced a last issue with minimum size file to be uploaded to be changed. Could be good to explain on how to do it in the documentation (to change it in right php.ini file, which process to restart). I spent time to find the information but now it works !

Thanks all for your support.

2 Likes