Hi
When using the MKDoc 1.8 site install script on FC4
(mysql-4.1.12-2.FC4.1) with SELinux is non-enforcing mode I get this
error:
DBD::mysql::db do failed: Access denied for user 'mkd'@'localhost' to database 'mkd' at /usr/lib/perl5/site_perl/5.8.6/MKDoc/SQL/MySQL.pm line 28, <STDIN> line 34.
DBD::mysql::db do failed: Access denied for user 'mkd'@'localhost' to database 'mkd' at /usr/lib/perl5/site_perl/5.8.6/MKDoc/SQL/MySQL.pm line 28, <STDIN> line 34.
This is after creating the database like this:
INSERT INTO user (Host, User, Password) VALUES ('localhost', 'mkd', password ('mkd'));
CREATE database mkd;
INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv,Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv) VALUES ('localhost', 'mkd', 'mkd', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');
flush privileges;
I do have old_passwords=1 in /etc/my.cnf and connecting to the database
works fine on the command line:
mysql -umkd -pmkd mkd
The line that is causing the problem is this:
$dbh->do ("LOCK TABLES $name LOW_PRIORITY WRITE");
I *think* the problem might be with the commands used to create the mkd
database, although this works with MySQL 4.0.x on FC2 perhaps it needs
to change for 4.1.x?
I have these DBD packages installed:
perl-DBD-MySQL-2.9007-1
perl-DBI-1.48-4
libdbi-0.7.2-2
libdbi-devel-0.7.2-2
libdbi-dbd-mysql-0.7.1-3
libdbi-drivers-0.7.1-3
Anyone have any ideas?
Chris
--
Chris Croome <
chris@...>
web design
http://www.webarchitects.co.uk/
web content management
http://mkdoc.com/
_______________________________________________
MKDoc-dev mailing list
MKDoc-dev@...
https://lists.webarch.co.uk/mailman/listinfo/mkdoc-dev
