search

uvdesk / community-skeleton

UVdesk Opensource Community Helpdesk Project built for all to make a Full Ticketing Support System along with many more other features.
https://www.uvdesk.com
MIT License
8.53k stars 459 forks source link

Verify-database-credentials 500 error on setup #327

Closed marjys1234 closed 3 years ago

marjys1234 commented 3 years ago

Hello!

I am trying to set up UVdesk, but at the "Database Configuration" setting I type in the correct credentials and the database have all the right permissions, but I get a 500 error and the page does not go further. .env, config and var folder have permission 777.

What should I do?

image image

PeopleInside commented 3 years ago

Hi, please try to use a password for database that not have special characters. Also for email, special characters in email addresses or password are not supported. Let me know if you managed to solve. https://github.com/uvdesk/community-skeleton/issues/276 https://github.com/uvdesk/community-skeleton/issues/325

marjys1234 commented 3 years ago

Thank you for the reply!

By standard cPanel adds "_" between the sitename and database, so ex. "Site_Database".

Is it the "_" that mess up the setup? I only have capital letters and numbers in the database password.

PeopleInside commented 3 years ago

The issue should be not in the database username and seems to me to understand the database password doesn't have any special characters. What version of MySQL are you using?

Are you sure the password you inserted in the setup is correct? Can you login with that credentials on phpmyadmin? To the database users has been assigned all database necessary permissions?

In any case I remind you for support you can use the UVdesk community, I think GitHub should be used for bug only... but for this time let's continue here.

Maybe if those suggestions doesn't help you need a reply from the UVdesk team that may reply in next days,

marjys1234 commented 3 years ago

I could try to make a new database, but I am able to log into phpMyAdmin with the current username and password.

Current version is 5.7.31 - MySQL Community Server

PeopleInside commented 3 years ago

Mysql version seems to be OK. Maybe the issue is not UVdesk but with your PHP!?

Also if the PHP version in this articles are different from yours seems can be useful (not sure is just a suggestion) https://stackoverflow.com/questions/47043351/sessionhandlergc-ps-files-cleanup-dir-permission-denied-13 https://community.dreamfactory.com/t/session-start-ps-files-cleanup-dir-opendir-var-lib-php5-failed-permission-denied-13/935

Usually when I get an error I try to look on Google but be careful if you don't know what you are doing. I'M not part of the UVdesk team and I'm just suggesting things on "user side" as I'm an user like you.

PeopleInside commented 3 years ago

Another personal suggestion is to revert folder and file permission from 777 as soon as possible after the install or in any case to not leave it with 777 permission once you end the day as can be a security issue on my opinion.

marjys1234 commented 3 years ago

I've tried using Google, but I am to afraid to change anything directly with the PHP. I am currently using php 7.2.

I think I am going to reinstall UVdesk, just to check or change to php 7.3

PeopleInside commented 3 years ago

You can wait a response from UVdesk team, you can also in the meantime try to reinstall UVdesk.

@papnoisanjeev I suggest to review the UVdesk guide where you suggest to set files or folders permission to 777.

775 may work as well and be little bit more secure and also you should suggest to revert permission back to the "normal" and safer settings after the setup.

.env file should be, after the setup, 664 other folders seems to be on 775 also for another app... umh I have to investigate if this is safer or not.

marjys1234 commented 3 years ago

Thank you for helping me!

I found out that UVdesk is available in the Softaculous Auto Installer, and that worked for some reason.

Closing the issue

PeopleInside commented 3 years ago

Great, I'm happy reading the issue was resolved. Happy week end!

papnoisanjeev commented 3 years ago

You can wait a response from UVdesk team, you can also in the meantime try to reinstall UVdesk.

@papnoisanjeev I suggest to review the UVdesk guide where you suggest to set files or folders permission to 777.

775 may work as well and be little bit more secure and also you should suggest to revert permission back to the "normal" and safer settings after the setup.

.env file should be, after the setup, 664 other folders seems to be on 775 also for another app... umh I have to investigate if this is safer or not.

@PeopleInside Thanks for this security patch !! We will update permission to 775 in our documentation.