View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - after new LAMP install on Debian, "access denied" error (different than earlier - ProjeQtOr
 

after new LAMP install on Debian, "access denied" error (different than earlier

More
02 Aug 2018 17:44 #1 by brett
after new LAMP install on Debian, "access denied" error (different than earlier was created by brett
Hello - brand new to ProjeQtOr, and mostly database and server technology...

Using Debian, I installed the LAMP by using this (and I went ahead and installed phpmyadmin, which seems to work),

lamp server on debian

I, of course, also installed all required extensions;

readme.txt

and then I unzipped the latest stable (v7.1.4) into my /var/www/html/ such that the folder projeqtor was in there.

But when I go to http://localhost/projeqtor, I see the error: (same, but with different font/size/? if I use 127.0.0.1)
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'

ERROR : Call to a member function query() on null

I also see a flash of a square box that looks like it might start to work... but only for maybe a 1/4 of a second... so I can't say what it actually is.

I have played around with ownership and permissions, followed a few unsuccessful things on stackexchange, but have no luck. I'm wondering if the server is misconfigured.

Here is some information about it:
sudo mysql --user=root mysql

MariaDB [mysql]> SELECT User FROM mysql.user;
+------------+
| User       |
+------------+
| sbh        |
| phpmyadmin |
| root       |
| sbh        |
+------------+
4 rows in set (0.00 sec)

MariaDB [mysql]> SELECT host, user, password FROM mysql.user;
+-----------+------------+-------------------------------------------+
| host      | user       | password                                  |
+-----------+------------+-------------------------------------------+
| localhost | root       |                                           |
| localhost | sbh        | *BB02B395B86BC71636D4E7804F0ECB7B4B5338D9 |
| %         | sbh        | *BB02B395B86BC71636D4E7804F0ECB7B4B5338D9 |
| localhost | phpmyadmin | *8604C23DDC65D4425C70AB5E74A6A531C926CC4C |
+-----------+------------+-------------------------------------------+
4 rows in set (0.01 sec)

MariaDB [mysql]> SELECT User, Db, Host from mysql.db;
+------------+------------+-----------+
| User       | Db         | Host      |
+------------+------------+-----------+
| sbh        | newdb      | localhost |
| phpmyadmin | phpmyadmin | localhost |
+------------+------------+-----------+
2 rows in set (0.00 sec)
MariaDB [mysql]> show grants for 'sbh'@'localhost';
+------------------------------------------------------------------------------------------------------------+
| Grants for sbh@localhost                                                                                   |
+------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'sbh'@'localhost' IDENTIFIED BY PASSWORD '*BB02B395B86BC71636D4E7804F0ECB7B4B5338D9' |
| GRANT ALL PRIVILEGES ON `newdb`.* TO 'sbh'@'localhost'                                                     |
+------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

MariaDB [mysql]> show grants for 'phpmyadmin'@'localhost';
+----------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for phpmyadmin@localhost                                                                                                              |
+----------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' IDENTIFIED BY PASSWORD '*8604C23DDC65D4425C70AB5E74A6A531C926CC4C' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `phpmyadmin`.* TO 'phpmyadmin'@'localhost'                                                                           |
+----------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

Here are my file ownership/permissions in the apache web folder (I actually just unzipped the file and copied it there and then had to change the permissions and ownership):
sbh@astra:~/SW/projeQtOr$ ll /var/www/html
total 4
drwxr-xr-x 18 www-data www-data 4096 Aug  1 22:22 projeqtor
sbh@astra:~/SW/projeQtOr$ ll /var/www/html/projeqtor/
total 152
drwxr-xr-x  4 www-data www-data  4096 Aug  1 22:22 docs
drwxr-xr-x  2 www-data www-data  4096 Aug  1 22:22 deploy
drwxr-xr-x  9 www-data www-data  4096 Aug  1 22:22 files
drwxr-xr-x  4 www-data www-data  4096 Aug  1 22:22 manual
drwxr-xr-x  5 www-data www-data  4096 Aug  1 22:22 test
drwxr-xr-x 22 www-data www-data  4096 Aug  1 22:22 external
drwxr-xr-x  3 www-data www-data  4096 Aug  1 22:22 plugin
drwxr-xr-x  2 www-data www-data  4096 Aug  1 22:22 .settings
-rw-r--r--  1 www-data www-data  4050 Aug  1 22:22 index.php
drwxr-xr-x  5 www-data www-data  4096 Aug  1 22:22 mobile
-rw-r--r--  1 www-data www-data  2700 Aug  1 22:22 .project
drwxr-xr-x  2 www-data www-data  4096 Aug  1 22:22 .externalToolBuilders
-rw-r--r--  1 www-data www-data   174 Aug  1 22:22 .buildpath
-rw-r--r--  1 www-data www-data    84 Aug  1 22:22 svn-commit.tmp
-rw-r--r--  1 www-data www-data    84 Aug  1 22:22 svn-commit.2.tmp
-rw-r--r--  1 www-data www-data 22761 Aug  1 22:22 ProjeQtOr_PHP.xml
-rw-r--r--  1 www-data www-data   104 Aug  1 22:22 .htaccess
-rw-r--r--  1 www-data www-data  4286 Aug  1 22:22 favicon.ico
drwxr-xr-x  2 www-data www-data  4096 Aug  1 22:22 api
drwxr-xr-x  2 www-data www-data  4096 Aug  1 22:22 db
drwxr-xr-x  3 www-data www-data 20480 Aug  1 22:22 tool
drwxr-xr-x  7 www-data www-data  4096 Aug  1 22:22 view
drwxr-xr-x  4 www-data www-data 20480 Aug  1 22:22 model
drwxr-xr-x  4 www-data www-data  4096 Aug  1 22:22 report

I use primarily Firefox and cleared the cache clear cache and here is the log file (not sure why the time doesn't match up to my correct system clock).

sbh@astra:~/SW/projeQtOr$ cat /var/www/html/projeqtor/files/logs/projeqtor_20180802.log

2018-08-02 16:19:50.998 => 0.000 ***** ERROR ***** [] EXCEPTION *****
2018-08-02 16:19:50.998 => 0.000 ***** ERROR ***** [] on file '/var/www/html/projeqtor/model/persistence/Sql.php' at line (92)
2018-08-02 16:19:50.998 => 0.000 ***** ERROR ***** [] cause = Call to a member function query() on null
2018-08-02 16:19:50.998 => 0.000 ***** ERROR ***** []    => #0 /var/www/html/projeqtor/model/persistence/SqlElement.php (3417) -> query()
2018-08-02 16:19:50.998 => 0.000 ***** ERROR ***** []    => #1 /var/www/html/projeqtor/model/persistence/SqlElement.php (2975) -> getFormatList()
2018-08-02 16:19:50.998 => 0.000 ***** ERROR ***** []    => #2 /var/www/html/projeqtor/model/persistence/SqlElement.php (2299) -> getDataType()
2018-08-02 16:19:50.998 => 0.000 ***** ERROR ***** []    => #3 /var/www/html/projeqtor/model/persistence/SqlElement.php (2630) -> getSqlElementsFromCriteria()
2018-08-02 16:19:50.998 => 0.000 ***** ERROR ***** []    => #4 /var/www/html/projeqtor/model/persistence/Sql.php (349) -> getSingleSqlElementFromCriteria()
2018-08-02 16:19:50.998 => 0.000 ***** ERROR ***** []    => #5 /var/www/html/projeqtor/view/login.php (38) -> getDbVersion()
2018-08-02 16:19:50.998 => 0.000 ***** ERROR ***** []    => #6 /var/www/html/projeqtor/tool/projeqtor.php (212) -> include()
2018-08-02 16:19:50.998 => 0.000 ***** ERROR ***** []    => #7 /var/www/html/projeqtor/view/main.php (37) -> require_once()
2018-08-02 16:42:58.684 => 0.000 ***** ERROR ***** [] EXCEPTION *****
2018-08-02 16:42:58.685 => 0.008 ***** ERROR ***** [] on file '/var/www/html/projeqtor/model/persistence/Sql.php' at line (92)
2018-08-02 16:42:58.685 => 0.000 ***** ERROR ***** [] cause = Call to a member function query() on null
2018-08-02 16:42:58.685 => 0.000 ***** ERROR ***** []    => #0 /var/www/html/projeqtor/model/persistence/SqlElement.php (2336) -> query()
2018-08-02 16:42:58.685 => 0.000 ***** ERROR ***** []    => #1 /var/www/html/projeqtor/model/Parameter.php (951) -> getSqlElementsFromCriteria()
2018-08-02 16:42:58.685 => 0.000 ***** ERROR ***** []    => #2 /var/www/html/projeqtor/tool/projeqtor.php (106) -> getGlobalParameter()
2018-08-02 16:42:58.685 => 0.000 ***** ERROR ***** []    => #3 /var/www/html/projeqtor/index.php (6) -> include_once()
2018-08-02 16:45:25.604 => 0.000 ***** ERROR ***** [] EXCEPTION *****
2018-08-02 16:45:25.604 => 0.000 ***** ERROR ***** [] on file '/var/www/html/projeqtor/model/persistence/Sql.php' at line (92)
2018-08-02 16:45:25.604 => 0.000 ***** ERROR ***** [] cause = Call to a member function query() on null
2018-08-02 16:45:25.604 => 0.000 ***** ERROR ***** []    => #0 /var/www/html/projeqtor/model/persistence/SqlElement.php (3417) -> query()
2018-08-02 16:45:25.604 => 0.000 ***** ERROR ***** []    => #1 /var/www/html/projeqtor/model/persistence/SqlElement.php (2975) -> getFormatList()
2018-08-02 16:45:25.604 => 0.000 ***** ERROR ***** []    => #2 /var/www/html/projeqtor/model/persistence/SqlElement.php (2299) -> getDataType()
2018-08-02 16:45:25.604 => 0.000 ***** ERROR ***** []    => #3 /var/www/html/projeqtor/model/persistence/SqlElement.php (2630) -> getSqlElementsFromCriteria()
2018-08-02 16:45:25.604 => 0.000 ***** ERROR ***** []    => #4 /var/www/html/projeqtor/model/persistence/Sql.php (349) -> getSingleSqlElementFromCriteria()
2018-08-02 16:45:25.604 => 0.000 ***** ERROR ***** []    => #5 /var/www/html/projeqtor/view/login.php (38) -> getDbVersion()
2018-08-02 16:45:25.604 => 0.000 ***** ERROR ***** []    => #6 /var/www/html/projeqtor/tool/projeqtor.php (212) -> include()
2018-08-02 16:45:25.604 => 0.000 ***** ERROR ***** []    => #7 /var/www/html/projeqtor/view/main.php (37) -> require_once()
2018-08-02 17:04:29.823 => 0.000 ***** ERROR ***** [] EXCEPTION *****
2018-08-02 17:04:29.823 => 0.000 ***** ERROR ***** [] on file '/var/www/html/projeqtor/model/persistence/Sql.php' at line (92)
2018-08-02 17:04:29.823 => 0.000 ***** ERROR ***** [] cause = Call to a member function query() on null
2018-08-02 17:04:29.823 => 0.000 ***** ERROR ***** []    => #0 /var/www/html/projeqtor/model/persistence/SqlElement.php (2336) -> query()
2018-08-02 17:04:29.823 => 0.000 ***** ERROR ***** []    => #1 /var/www/html/projeqtor/model/Parameter.php (951) -> getSqlElementsFromCriteria()
2018-08-02 17:04:29.823 => 0.000 ***** ERROR ***** []    => #2 /var/www/html/projeqtor/tool/projeqtor.php (106) -> getGlobalParameter()
2018-08-02 17:04:29.823 => 0.000 ***** ERROR ***** []    => #3 /var/www/html/projeqtor/index.php (6) -> include_once()
2018-08-02 17:04:36.128 => 0.000 ***** ERROR ***** [] EXCEPTION *****
2018-08-02 17:04:36.128 => 0.000 ***** ERROR ***** [] on file '/var/www/html/projeqtor/model/persistence/Sql.php' at line (92)
2018-08-02 17:04:36.128 => 0.000 ***** ERROR ***** [] cause = Call to a member function query() on null
2018-08-02 17:04:36.128 => 0.000 ***** ERROR ***** []    => #0 /var/www/html/projeqtor/model/persistence/SqlElement.php (3417) -> query()
2018-08-02 17:04:36.128 => 0.000 ***** ERROR ***** []    => #1 /var/www/html/projeqtor/model/persistence/SqlElement.php (2975) -> getFormatList()
2018-08-02 17:04:36.128 => 0.000 ***** ERROR ***** []    => #2 /var/www/html/projeqtor/model/persistence/SqlElement.php (2299) -> getDataType()
2018-08-02 17:04:36.128 => 0.000 ***** ERROR ***** []    => #3 /var/www/html/projeqtor/model/persistence/SqlElement.php (2630) -> getSqlElementsFromCriteria()
2018-08-02 17:04:36.128 => 0.000 ***** ERROR ***** []    => #4 /var/www/html/projeqtor/model/persistence/Sql.php (349) -> getSingleSqlElementFromCriteria()
2018-08-02 17:04:36.128 => 0.000 ***** ERROR ***** []    => #5 /var/www/html/projeqtor/view/login.php (38) -> getDbVersion()
2018-08-02 17:04:36.128 => 0.000 ***** ERROR ***** []    => #6 /var/www/html/projeqtor/tool/projeqtor.php (212) -> include()
2018-08-02 17:04:36.128 => 0.000 ***** ERROR ***** []    => #7 /var/www/html/projeqtor/view/main.php (37) -> require_once()

and the last one...
2018-08-02 17:07:56.246 => 0.000 ***** ERROR ***** [] EXCEPTION *****
2018-08-02 17:07:56.246 => 0.000 ***** ERROR ***** [] on file '/var/www/html/projeqtor/model/persistence/Sql.php' at line (92)
2018-08-02 17:07:56.246 => 0.000 ***** ERROR ***** [] cause = Call to a member function query() on null
2018-08-02 17:07:56.246 => 0.000 ***** ERROR ***** []    => #0 /var/www/html/projeqtor/model/persistence/SqlElement.php (2336) -> query()
2018-08-02 17:07:56.246 => 0.000 ***** ERROR ***** []    => #1 /var/www/html/projeqtor/model/Parameter.php (951) -> getSqlElementsFromCriteria()
2018-08-02 17:07:56.246 => 0.000 ***** ERROR ***** []    => #2 /var/www/html/projeqtor/tool/projeqtor.php (106) -> getGlobalParameter()
2018-08-02 17:07:56.246 => 0.000 ***** ERROR ***** []    => #3 /var/www/html/projeqtor/index.php (6) -> include_once()

which is mostly repeated, but a different one near the end.

If I open up FF's dev panel, and reload the page, the only error I really see is on the "Network", or "Console" tab:
Source map error: TypeError: NetworkError when attempting to fetch resource.
Resource URL: moz-extension://f9ca66db-45f4-48fb-b79a-5e52eff81c9f/content/js/purify.min.js
Source Map URL: purify.min.js.map[Learn More]


I notice that entering in "localhost/projeqtor" it directs me to "localhost/projeqtor/view/main.php", but if I type in "localhost/projeqtor/index.php", I still get redirected but a slightly longer error in the developer tool on FF;

Source map error: TypeError: NetworkError when attempting to fetch resource.
Resource URL: moz-extension://f9ca66db-45f4-48fb-b79a-5e52eff81c9f/content/js/purify.min.js
Source Map URL: purify.min.js.map[Learn More]
Source map error: TypeError: NetworkError when attempting to fetch resource.
Resource URL: moz-extension://f9ca66db-45f4-48fb-b79a-5e52eff81c9f/content/js/purify.min.js
Source Map URL: purify.min.js.map[Learn More]


Guess its the same, but I still see the flashing screen that I think is correct...

Thanks all!

Please Log in or Create an account to join the conversation.

More
03 Aug 2018 19:07 #2 by babynus
Replied by babynus on topic after new LAMP install on Debian, "access denied" error (different than earlier
The error you get is incorrect DB access...

SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'


It seems you first ran configuration and get incorrect db access info.
Try and remove file /tool/parametersLocation.php to retry config.
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
03 Aug 2018 19:52 - 03 Aug 2018 20:04 #3 by brett
Replied by brett on topic after new LAMP install on Debian, "access denied" error (different than earlier
I successfully saw the configuration page. Looking through it I didn't see anything (to me) that was wrong, and noticed it validated that the extensions were installed.

"max_input_vars=1000"
Well I grepped for it and found a few files. According to: PHP and
php --ini
, my php.ini file, at
sbh@astra:/var/www/html/projeqtor$ php --ini
Configuration File (php.ini) Path: /etc/php/7.0/cli
Loaded Configuration File:         /etc/php/7.0/cli/php.ini
Scan for additional .ini files in: /etc/php/7.0/cli/conf.d
Additional .ini files parsed:      /etc/php/7.0/cli/conf.d/10-mysqlnd.ini,
/etc/php/7.0/cli/conf.d/10-opcache.ini,
/etc/php/7.0/cli/conf.d/10-pdo.ini,
/etc/php/7.0/cli/conf.d/15-xml.ini,
/etc/php/7.0/cli/conf.d/20-bz2.ini,
/etc/php/7.0/cli/conf.d/20-calendar.ini,
/etc/php/7.0/cli/conf.d/20-ctype.ini,
/etc/php/7.0/cli/conf.d/20-curl.ini,
/etc/php/7.0/cli/conf.d/20-dom.ini,
/etc/php/7.0/cli/conf.d/20-exif.ini,
/etc/php/7.0/cli/conf.d/20-fileinfo.ini,
/etc/php/7.0/cli/conf.d/20-ftp.ini,
/etc/php/7.0/cli/conf.d/20-gd.ini,
/etc/php/7.0/cli/conf.d/20-gettext.ini,
/etc/php/7.0/cli/conf.d/20-iconv.ini,
/etc/php/7.0/cli/conf.d/20-imap.ini,
/etc/php/7.0/cli/conf.d/20-json.ini,
/etc/php/7.0/cli/conf.d/20-mbstring.ini,
/etc/php/7.0/cli/conf.d/20-mysqli.ini,
/etc/php/7.0/cli/conf.d/20-pdo_mysql.ini,
/etc/php/7.0/cli/conf.d/20-phar.ini,
/etc/php/7.0/cli/conf.d/20-posix.ini,
/etc/php/7.0/cli/conf.d/20-readline.ini,
/etc/php/7.0/cli/conf.d/20-shmop.ini,
/etc/php/7.0/cli/conf.d/20-simplexml.ini,
/etc/php/7.0/cli/conf.d/20-sockets.ini,
/etc/php/7.0/cli/conf.d/20-sysvmsg.ini,
/etc/php/7.0/cli/conf.d/20-sysvsem.ini,
/etc/php/7.0/cli/conf.d/20-sysvshm.ini,
/etc/php/7.0/cli/conf.d/20-tokenizer.ini,
/etc/php/7.0/cli/conf.d/20-wddx.ini,
/etc/php/7.0/cli/conf.d/20-xmlreader.ini,
/etc/php/7.0/cli/conf.d/20-xmlwriter.ini,
/etc/php/7.0/cli/conf.d/20-xsl.ini,
/etc/php/7.0/cli/conf.d/20-zip.ini

had a commented line relating to this directive;
; max_input_vars = 1000

I imagine I'll just add a duplicate line below it with 4000, as recommended by the error - ?

---

Apparently the main error I was receiving I am still getting...? Out of curiosity, if I got o that address in my FF browser, 127.0.0.1:3306, it says;
b���
5.5.5-10.1.26-MariaDB-0+deb9u1����Ju25U*pv�ÿ÷-�? ����������!=NQ-.;!2v|0�mysql_native_password�!��ÿ„#08S01Got packets out of order

which I don't know if it is meaningful at all... Sorry, meant to include .png file.
Attachments:
Last edit: 03 Aug 2018 20:04 by brett. Reason: forgot attachment of png file

Please Log in or Create an account to join the conversation.

More
03 Aug 2018 20:36 #4 by babynus
Replied by babynus on topic after new LAMP install on Debian, "access denied" error (different than earlier
On the configuration page, you must take care of connection parameters to the DB.
Check password, as default proposed by projeqtor may not be the default one of your LAMP install
Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
03 Aug 2018 21:39 #5 by brett
Replied by brett on topic after new LAMP install on Debian, "access denied" error (different than earlier
Thank you! I was able to log in on the "home page" using admin/admin, login credentials after using these two links (in case another newb finds this useful):

link1
link2

to find all the users, db names, domains (and grants) that I could then input into the ProjeQtOr config page.

Looking forward to learning ProjeQtOr!

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.064 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form