No input file specified

peopleinside · 21 Oct 2021, 19:06

@SCoccia thanks for the updates.
Let's wait UVdesk team reply.

peopleinside · 21 Oct 2021, 19:20

@SCoccia Please check if this GitHub topic can be useful for you:
https://github.com/uvdesk/community-skeleton/issues/263

SCoccia · 21 Oct 2021, 20:02

Ok I have resolved the first step (from plesk I have create a user to work in ssh) I have removed all and Installed a clean version, but when I try to connect to db... nothing


  Examining helpdesk setup for any configuration issues:

  [-] Establishing a connection with database server
  [x] Unable to establish a connection with database server

      Unable to connect with your database server, please check the details provided.
      Do you wish to try again? [Y/N]

server: localhost
port: 3306
name db: namedb
name user: name user
password :mypassword

but nothing... not connect..
why?
tnx

peopleinside · 21 Oct 2021, 20:16

@SCoccia do you run something else with the database? I mean you are not using a database for the first time!?
Are you sure credentials works and has inserted correctly?

Usually when I get some database connection error I check if I'm able to login in phpmyadmin with the same relative credentials than I ensure to have inserted correct credentials in the app.. you know sometimes is just enought press wrong one letter in the keyboard.

You can also try to install UVdesk using the web interface just point to your UVdesk folder than public folder.
https://www.uvdesk.com/en/blog/installation-open-source-helpdesk-uvdesk/

Be sure also you have correct file permissions:

Folder permission on setup

.env file in the main root UVdesk folder need to be changed from 664 to 755 (777 only if you still get errors) and set again, after the setup, to 644

var and config folders 755 too than 755 after the setup

If you forget to change the permission from 777 you will have a potential security issue on your server.

SCoccia · 21 Oct 2021, 20:30

Mysql is ok because if I try from shell

mysql -u user -p

and put the password is all ok

I have tryed to set permission to folder and file but nothing not accept...

from web (is the first test) I recevice "No input file specified." in the withe paper...

if I run php bin/console d:s:u --force
I receive this... is normal?

In AbstractMySQLDriver.php line 128:

  An exception occurred in driver: could not find driver


In Exception.php line 18:

  could not find driver


In PDOConnection.php line 39:

  could not find driver


doctrine:schema:update [--complete] [--dump-sql] [-f|--force] [--em [EM]] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--] <command>

peopleinside · 21 Oct 2021, 20:34

@SCoccia I suggest to check you .env file, do you see that in this file the database credentials you inserted in the web wizard has been saved into this file?

If I can remember well when I installed my UVdesk instance I was not able to do by SSH I done it using the web wizard.
Sometimes when I get error in the installation I need remove all (be sure the database is empty), the folder and installing again the folder than not try to install by SSH but by using the web interface. Maybe you can try to set file permission as I mentioned before than run the wizard.

If you get some error in the wizard a screenshot can help maybe to better understand.
If you want try to chat with me and if I want I try to help you with the installation you can look here: https://helpdesk.peopleinside.it/en/blog/uv

peopleinside · 21 Oct 2021, 20:42

@SCoccia said in No input file specified:

No input file specified.

Did you try to search this error in the web?
Maybe you have some server configuration issue?!

Look here for example:
https://stackoverflow.com/questions/14555996/no-input-file-specified
Or just try to do a search on the web
https://www.google.com/search?client=firefox-b-d&q=No+input+file+specified.

SCoccia · 21 Oct 2021, 21:03

ok I have changed from PLESK FASTCGI to FPMngx and now to web I see the installation menu but I have the same problem... not accept the DB connecion

and the login pass are correct...

peopleinside · 21 Oct 2021, 21:07

@SCoccia maybe your .env file has been written already.
I suggest to check if the database is empty, no table in phpmyadmin, erase UVdesk root folder and all files than recreate again the UVdesk folder with the SSH command

composer create-project uvdesk/community-skeleton helpdesk-project

than check file permission and change if necessary, point the browser to the Wizard installation and install.

Sanjeev · 22 Oct 2021, 05:05

@SCoccia @peopleinside

Check here hope it will help.

SCoccia · 22 Oct 2021, 06:49

ok If I remove the code all SQL data are saved but now write that .env file not have permission... I have set 777 but nothing

Sanjeev · 22 Oct 2021, 06:54

@SCoccia

Please enable permission for .env file and reload page again and setup again from step 1.

If still you are facing the issues then you can try manual installation as well.
https://github.com/uvdesk/community-skeleton/issues/290#issuecomment-661113642

SCoccia · 22 Oct 2021, 07:14

First thank you...
secondo the problem is that the password DB have @ and the system not accept it... I have changed and the installation is ok now

THANK YOU

Sanjeev · 22 Oct 2021, 07:31

@SCoccia

Glad to know that.

Would request you take a spare a minute of yours and leave your valuable feedback with us if you liked our product & support.

Raise a GitHub star here - https://github.com/uvdesk/community-skeleton
or just tweet the same by tagging @UVdesk - https://twitter.com/uvdesk

peopleinside · 22 Oct 2021, 08:28

@Sanjeev can be the @ that create issue in database password be fixed and tested?

Sanjeev · 22 Oct 2021, 09:49

@peopleinside

Use the urlencode function to encode a MySQL password containing special chars.

Edit doctrine.yaml file under (config->packages) of your project.

Replace below line:

url: '%env(DATABASE_URL)%'

By new line:

url: '%env(resolve:DATABASE_URL)%'

Hope it will help.

peopleinside · 22 Oct 2021, 09:52

@Sanjeev new UVdesk users will continue to face installing and database issue, maybe there is no way to fix this?
I mean avoid that a new user that use a good database password with special characters will face issue of database wrong password when is not. I have to remember always to say to users that they need check their password that should not have special characters or need follow special instructions?

Sanjeev · 23 Oct 2021, 07:26

@peopleinside

We will check with above solution if it is not effecting any other functionality then will add it with project.

Solved No input file specified