Dear all,
i am trying to install Projector in my host without success. I am in Italy and using Aruba server (if somebody uses it please let me know).
I followed the instructions
collation is set at UTF8mb4_general_ci,
php version 8.3, everything is "green" but I have the red blocking state
SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'SqlXXXXX'@'%' to database 'sqlXXXXX_4'
dsn = mysql:host=XXXXXXX;port=3306;dbname=sqlXXXXX_4
i am struggling with this setup and I am not seeing any solution, neither with Aruba support center.
do you have any suggestion?
Thanks in advance and best regards
I would like to share with you the solution adopted thanks to a support from the ARUBA support (Italy).It seems that the ..tool/configCheck.php is forcing the lowercase of the DbName. this created some troubles to the server (although UTF8mb4_general_ci was selected in PHPMyAdmin).
at line 43 I modified the file
- from $param['DbName']=pq_strtolower($param['DbName']);
- to //$param['DbName']=pq_strtolower($param['DbName']);
Now the application is working pretty good.
best regards
Please note that DB in not expected to exist.
So convertion to lowercase is done to enforce compatibility (including with postgresql)
Hello Babynus,
my provider has set as name of the DBs Sqlxxxxx. The name of the DB and the User are the same. there is no possibility to change it. after a week of check with the support of my hosting provider we found out this solution. it worked and it seems it is going very well now.
so I preferred to share it with you all in case some people from Aruba service provider are coming to ProjeQtOr.
best regards