Notifications
Retirer tout
Ask questions
5
Posts
2
Utilisateurs
0
Reactions
4,492
Vu
Début du sujet
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),
I, of course, also installed all required extensions;
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!
Posté : 02/08/2018 7:44 pm
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.
Posté : 03/08/2018 9:07 pm
Début du sujet
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.
Posté : 03/08/2018 9:52 pm
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
Posté : 03/08/2018 10:36 pm
Début du sujet
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):
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!
Posté : 03/08/2018 11:39 pm