FreeLists / dokuwiki / [dokuwiki] Re: SMF integration

[Lunatic <lunatic@xxxxxxxx>]

Le Vendredi 6 Janvier 2006 13:27, Matthias Grimm a écrit :
> On Fri, 6 Jan 2006 11:58:49 +0100
>
> Lunatic <lunatic@xxxxxxxx> wrote:
> > Hello,
> >
> > I try for several days to integrate SMF with dokuwiki, without success. I
> > always get a bad password / unknown username error.
>
> This error message appear after checkPass has failed. Your SQL below
> looks good for me so lets do some basic checks:
>
> 1. Do you run the development tree of Dokuwiki? The SQL statements you
>    defined will only work with the development tree. see
>    http://wiki.splitbrain.org/wiki:auth_mysql to configure the current
>    stable release.

Yes I run the development tree which dates from 2005-12-27 

> 2. Is your local.php formally correct? PHP will deny the whole file if
>    it contains syntax errors. Please check your webserver's log file
>    for error messages.

I've checked and re-checked this file, all seem to be ok. No syntax errors, no 
errors messages in log file.

> 3. If the answers to the first two questions will be 'yes', please post
>    the definition of the smf_members table and it's contents for further
>    investigation. Please filter the information and _don't_ send any
>    secret passwords to the list.
>

Ok, here is the complete definition of the table :

CREATE TABLE `smf_members` (
  `ID_MEMBER` mediumint(8) unsigned NOT NULL auto_increment,
  `memberName` varchar(80) NOT NULL default '',
  `dateRegistered` int(10) unsigned NOT NULL default '0',
  `posts` mediumint(8) unsigned NOT NULL default '0',
  `ID_GROUP` smallint(5) unsigned NOT NULL default '0',
  `lngfile` tinytext NOT NULL,
  `lastLogin` int(10) unsigned NOT NULL default '0',
  `realName` tinytext NOT NULL,
  `instantMessages` smallint(5) NOT NULL default '0',
  `unreadMessages` smallint(5) NOT NULL default '0',
  `pm_ignore_list` text NOT NULL,
  `passwd` varchar(64) NOT NULL default '',
  `emailAddress` tinytext NOT NULL,
  `personalText` tinytext NOT NULL,
  `gender` tinyint(4) unsigned NOT NULL default '0',
  `birthdate` date NOT NULL default '0001-01-01',
  `websiteTitle` tinytext NOT NULL,
  `websiteUrl` tinytext NOT NULL,
  `location` tinytext NOT NULL,
  `ICQ` tinytext NOT NULL,
  `AIM` varchar(16) NOT NULL default '',
  `YIM` varchar(32) NOT NULL default '',
  `MSN` tinytext NOT NULL,
  `hideEmail` tinyint(4) NOT NULL default '0',
  `showOnline` tinyint(4) NOT NULL default '1',
  `timeFormat` varchar(80) NOT NULL default '',
  `signature` text NOT NULL,
  `timeOffset` float NOT NULL default '0',
  `avatar` tinytext NOT NULL,
  `pm_email_notify` tinyint(4) NOT NULL default '0',
  `karmaBad` smallint(5) unsigned NOT NULL default '0',
  `karmaGood` smallint(5) unsigned NOT NULL default '0',
  `usertitle` tinytext NOT NULL,
  `notifyAnnouncements` tinyint(4) NOT NULL default '1',
  `notifyOnce` tinyint(4) NOT NULL default '1',
  `memberIP` tinytext NOT NULL,
  `secretQuestion` tinytext NOT NULL,
  `secretAnswer` varchar(64) NOT NULL default '',
  `ID_THEME` tinyint(4) unsigned NOT NULL default '0',
  `is_activated` tinyint(3) unsigned NOT NULL default '1',
  `validation_code` varchar(10) NOT NULL default '',
  `ID_MSG_LAST_VISIT` int(10) unsigned NOT NULL default '0',
  `additionalGroups` tinytext NOT NULL,
  `smileySet` varchar(48) NOT NULL default '',
  `ID_POST_GROUP` smallint(5) unsigned NOT NULL default '0',
  `totalTimeLoggedIn` int(10) unsigned NOT NULL default '0',
  `passwordSalt` varchar(5) NOT NULL default '',
  `t_bookmarks` tinytext NOT NULL,
  `messageLabels` text NOT NULL,
  `buddy_list` tinytext NOT NULL,
  `notifySendBody` tinyint(4) NOT NULL default '0',
  `notifyTypes` tinyint(4) NOT NULL default '2',
  PRIMARY KEY  (`ID_MEMBER`),
  KEY `memberName` (`memberName`(30)),
  KEY `dateRegistered` (`dateRegistered`),
  KEY `ID_GROUP` (`ID_GROUP`),
  KEY `birthdate` (`birthdate`),
  KEY `posts` (`posts`),
  KEY `lastLogin` (`lastLogin`),
  KEY `ID_POST_GROUP` (`ID_POST_GROUP`),
  KEY `lngfile` (`lngfile`(24))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

It's an InnoDB table, but it was a "MyISAM" table few hours ago, when I 
already had my problem. Here is the record corresponding to my account (not 
in the whole) :

INSERT INTO `smf_members` VALUES 
('2','Lunatic','1021746519','8321','1','french','1136564813','Lunatic','159','0','','***password***','lunatic@xxxxxxxx'
 (etc.));

I hope it's you're asking for :-/

Thanls for your help :-)

Lunatic.





___________________________________________________________________________
Nouveau : téléphonez moins cher avec Yahoo! Messenger ! Découvez les tarifs 
exceptionnels pour appeler la France et l'international.
Téléchargez sur http://fr.messenger.yahoo.com
--
DokuWiki mailing list - more info at
http://wiki.splitbrain.org/wiki:mailinglist