Check your dbmail.conf and look for the user and password used to connect to the database.
Then try: mysql -u<user> -p dbmail (where <user> should be substituted by the username of the database user you connect to the database with) and enter the password at the prompt. You have to give the database user permission to read & write all tables in the dbmail database: type, as mysql root, using the mysql command line utility: GRANT ALL on dbmail.* to [EMAIL PROTECTED] identified by 'password'; Fill in the password in /etc/dbmail.conf The docs should probably give more information on this. Ilja On Tue, 2004-04-27 at 12:26, Jan-Kees Fels wrote: > Ok, what now? > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Feargal Reilly > Sent: Tuesday, April 27, 2004 12:24 PM > To: DBMail mailinglist > Subject: Re: [Dbmail] ERROR 1067 at line 7: Invalid > defaultvaluefor'alias_idnr' > > Ignore last mail.. posted before I read the end of the thread... > > -fr. > > On Tue, 27 Apr 2004 11:13:02 +0100 > Feargal Reilly <[EMAIL PROTECTED]> wrote: > > > > > On Mon, 26 Apr 2004 17:50:53 +0200 > > "Jan-Kees Fels" <[EMAIL PROTECTED]> wrote: > > > > > Hi, > > > > > > You were right. Now however I have a problem at the next step: > > > > > > > I submitted a patch back in January to the dbmail-dev list which fixed > these problems. I don't think it was ever used though. > > > > I've attached it again, see if it fixes things. > > > > You should call the scripts by executing 'bash filename', that'll avoid > hardcoded path issues. > > > > -fr. > > > > > > -- > > Feargal Reilly, > > Codeshifter, > > Chrysalink Systems. > > >
