[dokuwiki] [dokuwiki] Pb with Mysql and PHPBB
- From: "Antoine FIXARY" <antoine.fixary@xxxxxxxxxxx>
- To: "dokuwiki" <dokuwiki@xxxxxxxxxxxxx>
- Date: Tue, 10 Jan 2006 18:33:40 +0100
Hello,
I want try the 20060110 CVS to try the news Mysql backend
with PHPBB v2.
I change the file local.php but I have a error :
"MySQL: Query was empty
L'utilisateur ou le mot de passe est incorrect."
I don't see my error, could you tell me if I make a error or
if the problem is in CVS ??
Here the file local.php (the parameter to connect at the
database are hide).
$conf['lang'] = 'fr'; //your language
$conf['start'] = 'Sommaire'; //name of start
page
$conf['title'] = 'Base de connaissance de
ChaleurTerre'; //what to show in the title
$conf['useacl'] = 1; //Use Access
Control Lists to restrict access?
$conf['openregister']= 0; //Should users to
be allowed to register?
$conf['authtype'] = 'mysql'; //which
authentication backend should be used
$conf['auth']['mysql']['encryptPass'] = 0;
$conf['auth']['mysql']['server'] = 'xxx'; //
mySQL host, usually localhost
$conf['auth']['mysql']['user'] = 'xxx'; // mySQL
database user for the database that is used by phpBB
$conf['auth']['mysql']['password'] = 'xxx'; // mySQL
database password for the database that is used by phpBB
$conf['auth']['mysql']['database'] = 'xxx'; //
mySQL database that is used by phpBB
$conf['auth']['mysql']['getUserID'] = "SELECT user_id AS id
FROM phpbb_users
WHERE username='%u'";
$conf['auth']['mysql']['getGroupID'] = "SELECT group_id AS id
FROM phpbb_groups
WHERE group_name='%g'";
$conf['auth']['mysql']['checkpass']= "SELECT user_password
FROM phpbb_users
WHERE username = '%u'
AND user_password =
MD5('%p')";
$conf['auth']['mysql']['getGroups'] = "SELECT group_name
as `group`
FROM phpbb_groups
g, phpbb_users u, phpbb_user_group ug
WHERE u.user_id =
ug.user_id
AND g.group_id =
ug.group_id
AND u.username='%u'";
$conf['auth']['mysql']['getUserInfo'] = "SELECT
user_password, username AS name, user_email AS mail
FROM phpbb_users
WHERE username='%u'";
$conf['superuser'] = 'antoine';
$conf['notify'] = ''; //send change info
to this email (leave blank for nobody)
$conf['mailfrom'] = ''; //use this email
when sending mails
-------------- ALICE HAUT DEBIT : TRIPLE PLAY A 29,95 EUR/MOIS --------------
Découvrez vite ALICEBOX : avec le modem WIFI, profitez de l'ADSL, de la
TELEPHONIE et en exclusivité de la TELEVISION !
Bénéficiez aussi de la hotline gratuite 24h/24 ! Soumis à conditions. Pour en
profiter cliquez ici http://abonnement.aliceadsl.fr
--
DokuWiki mailing list - more info at
http://wiki.splitbrain.org/wiki:mailinglist
Other related posts:
- » [dokuwiki] [dokuwiki] Pb with Mysql and PHPBB
