found these 2 errors in cache erro log
CMS Error includes/poodle/kernels/dragonfly.php line 208: Access denied for user 'root'@'localhost' (using password: NO)
PHP Warning includes/poodle/sql/adapter/mysqli.php line 88: mysqli::real_connect(): (28000/1045): Access denied for user 'root'@'localhost' (using password: NO)
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
xp/2.4.18/5.1.73/5.5.35/9.4
DJ MazeOffline
Joined: Apr 19, 2004
Posts: 6434
Location: http://tinyurl.com/5z8dmv
If you have shared hosting (Plesk, cPanel, DirectAdmin, etc. etc.) then you configure a database and user there.
Say your control panel loginname is "johndoe", then:
a MySQL database like "johndoe_db" must be created
a MySQL user like "johndoe_dbuser" must be created
the MySQL user must be added to the MySQL database with all privileges
then use that database and user at Dragonfly install
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Fedora 25 / Apache 2.4.27 / MariaDB 10.1.26 / PHP 7.1.10 / Mercurial
I know how to do the above .I just installed 2 different cms as a test , one on public_html and 1 in folder both by installers . they worked perfectly on the same dbs I was trying to use on Dragonfly install.
one cms was platinum nuke , the other was extreme evo
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
xp/2.4.18/5.1.73/5.5.35/9.4
Last edited by Critical on Wed Aug 24, 2016 9:36 pm; edited 1 time in total
DJ MazeOffline
Joined: Apr 19, 2004
Posts: 6434
Location: http://tinyurl.com/5z8dmv
Thanks for your information! That explains a lot about your good experience.
Something must be wrong on the server itself then.
"SHOW VARIABLES" not allowed is very strange
"Access denied for user 'root'@'localhost' (using password: NO)" is very strange
Is there an "includes/config.php" ?
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Fedora 25 / Apache 2.4.27 / MariaDB 10.1.26 / PHP 7.1.10 / Mercurial
No their is no includes/configure.php , this is very strange , the first time i have ever had trouble with an installer. All my server stats are green. I run the test/test.php , it showed all fine
.I get all green lights on 2nd page of installer for dragonfly , then fill out the next page with db , dbu , pw, prefix etc next page i get error , very strange indeed
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
xp/2.4.18/5.1.73/5.5.35/9.4
I did find the includes/config.php file you mentioned . I edited it with db , dbu , pw. Message I got was
We're glad you made the decision to use Dragonfly
We're sorry, but only MySQL 4 or higher is supported
Ask your server administrator about upgrading to MySQL 4 or higher
Your current version is: 10.0.20-MariaDB-cll-lve
So now I know I can't use it n my sql version I put up was wrong.
Thought I would pop in and let you know , much thanks
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
xp/2.4.18/5.1.73/5.5.35/9.4
Last edited by Critical on Mon Aug 29, 2016 8:33 pm; edited 1 time in total
DJ MazeOffline
Joined: Apr 19, 2004
Posts: 6434
Location: http://tinyurl.com/5z8dmv
MariaDB is also supported, the bug is a wrong check in /install/step3.php
It does a wrong version compare.
Delete on line 18 if ($server['version'][0] < 4) {
echo sprintf($instlang['s1_mysql'], $server['version']);
return;
}
Thanks for reporting
Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Fedora 25 / Apache 2.4.27 / MariaDB 10.1.26 / PHP 7.1.10 / Mercurial
Last edited by DJ Maze on Tue Aug 30, 2016 7:48 am; edited 2 times in total