Are you running the latest version of ports? If you do:
cat /usr/ports/mail/dbmail/distinfo it should show dbmail-2.0.7.tar.gz etc.. if it doesn't you'll need to upgrade your ports collection; info on how to update freebsd's ports collection below: http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/ports-using.ht ml http://www.freebsddiary.org/ports.php Tried install the port manually instead of via portupgrade? cd /usr/ports/mail/dbmail && make deinstall && make reinstall HTH S -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan Glait Sent: 15 September 2005 16:29 To: DBMail mailinglist Subject: Re: [Dbmail] dbmail-2.0.7 released Perhaps stupid question ... I try to upgrade the port with portupgrade ... and i get bash-2.05b# portupgrade -b -r -i dbmail-mysql ---> Session started at: Thu, 15 Sep 2005 12:32:27 -0300 ** No need to upgrade 'dbmail-mysql-2.0.4_1' (>= dbmail-mysql-2.0.4_1). (specify -f to force) ---> Listing the results (+:done / -:ignored / *:skipped / !:failed) - mail/dbmail (dbmail-mysql-2.0.4_1) ---> Packages processed: 0 done, 1 ignored, 0 skipped and 0 failed ---> Session ended at: Thu, 15 Sep 2005 12:32:28 -0300 (consumed 00:00:01) its ok ? .. Steven Lynn wrote: >That is what I had figured on. I was just wondering cause I ran the >script and got that error... > >Thank you. > >On Wed, 2005-09-14 at 08:46 +0200, Paul J Stevens wrote: > > >>Steven, >> >>The create script has been running virtually unchanged since 2.0.0 >> >>This is very likely something specific to mysql-5. >> >>Steven Lynn wrote: >> >> >>>Has anybody run the mysql_create_innodb.sql script on MySQL 5? >>> >>>I get an error on: >>> >>>CREATE TABLE dbmail_pbsp ( >>> idnr bigint(21) NOT NULL auto_increment, >>> since datetime default '0' not null, >>> ipnumber varchar(40) NOT NULL, >>> PRIMARY KEY (idnr), >>> UNIQUE INDEX ipnumber_index (ipnumber), >>> INDEX since_index (since) >>>) TYPE=InnoDB; >>> >>>Column 'since' has the wrong default value for datetime... If someone >>>has run on mysql 4.x and has had no problems, let me know and I will >>>stop talking. ;) >>> >>>-- >>>Steven Lynn >>> [EMAIL PROTECTED] >>> >>>Paul J Stevens wrote: >>> >>> >>> >>> >>>>>Dbmail 2.0.7 released >>>>> >>>>>This is a bugfix release only. >>>>> >>>>>* Removed all unsafe code from the signal handlers. This should >>>>>mostly benefit FreeBSD users which may have suffered from unreliable >>>>>behaviour in the process pool code. >>>>>* Added 'ON UPDATE CASCADE' to all foreign key restraints in the >>>>>MySQL (InnoDB) and Postgresql create_table files. >>>>>* POP3 AUTH command no longer returns list of supported >>>>>authentication mechanisms when issued without arguments. >>>>> >>>>> >>>>> >>>>> >>_______________________________________________ >>Dbmail mailing list >>Dbmail@dbmail.org >>https://mailman.fastxs.nl/mailman/listinfo/dbmail >> >> >> >> >>---------------------------------------------------------------------- -- >> >>_______________________________________________ >>Dbmail mailing list >>Dbmail@dbmail.org >>https://mailman.fastxs.nl/mailman/listinfo/dbmail >> >> _______________________________________________ Dbmail mailing list Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail