[IMail Forum] External Database with mySQL

[Richard Bewley]

Hi,

I'm trying to get IMail working off an external mySQL database.  It has the 
following structure:

CREATE TABLE imail (
  USERID varchar(31) NOT NULL default '',
  PASSWORD varchar(31) NOT NULL default '',
  FULLNAME varchar(63) default NULL,
  USERDIR varchar(255) default NULL,
  MAILADDR varchar(255) default NULL,
  MAXSIZE int(11) default NULL,
  MAXMSGS int(11) default NULL,
  FLAGS int(11) default NULL,
  TYPE int(11) default NULL,
  NUMTRIES int(11) default NULL,
  ATTEMPTTIME int(11) default NULL,
  NUMTIMESSUSP int(11) default NULL,
  LASTLOGIN int(11) default NULL,
  SPNDUSRACCT int(11) default NULL,
  ICALENBL int(11) default NULL,
  SPELLENBL int(11) default NULL,
  NUMSGSTNS int(11) default NULL,
  IWDEPTH int(11) default NULL,
  IWOPTIONS int(11) default NULL,
  SPELLCHKG int(11) default NULL,
  PRVWSIZE int(11) default NULL,
  DEFVIEW varchar(40) default NULL,
  TIMEZONE varchar(255) default NULL,
  STRTDAY int(11) default NULL,
  DEFCALNM varchar(40) default NULL,
  ENTRYGRNL int(11) default NULL,
  STARTTIME int(11) default NULL,
  ENDTIME int(11) default NULL,
  MAXEVNTDISP int(11) default NULL,
  MAXTSKDISP int(11) default NULL,
  MAXNOTEDISP int(11) default NULL,
  MAXDLYRCURCNT int(11) default NULL,
  MAXWKLYRCURCNT int(11) default NULL,
  MAXMONRCURCNT int(11) default NULL,
  MAXYRLYRCURCNT int(11) default NULL,
  DISPCMPLTDTSKS int(11) default NULL,
  HOURSCLOCK int(11) default NULL,
  MAXSRCHRESPPG int(11) default NULL,
  MAXEVENTTITLELEN int(11) default NULL,
  MAXTASKTITLELEN int(11) default NULL,
  CONFIRMONDELETE int(11) default NULL,
  NUMNOTIFY int(11) default '0',
  LASTNOTIFY int(11) default '0',
  FTPMAXSPACE int(11) default NULL,
  FTPMAXFILES int(11) default NULL,
  FTPFLAGS int(11) default '11',
  PRIMARY KEY  (USERID)
) TYPE=MyISAM;
Also, I have gotten the DP-M710-odbcuser.dll file, but I am unsure where to 
put the hostname of the mySQL server.  Is it supposed to go somewhere in 
this line?

mysql; UID=username; PWD=password

Also, what should I have where I had "mysql"?  I believe this is supposed 
to be the DSN name, if I were using SQL Server.

Any direction you could give me would be greatly appreciated.

Thanks,
Richard
---
[This E-mail scanned for viruses by friend.ly.net.]
To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html
List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/