Unknown column 'sslcertck' in 'field list' at /var/spool/fetchmail/fetchmail.pl line 97.

[internethering]

Hi, I'm using postfixadmin 2.93. This version need three more SQL-Coloumns: sslcertck, sslcertpath & sslfingerprint

[PF4Public]

Have you tried using the same table (at the same database) for postfixadmin and roundcube fetchmail plugin (that is roundcube) and failed?
Or do you have separate tables for postfixadmin and roundcube fetchmail plugin (that is roundcube)?

[internethering]

I created the table with the sql-script delivered with this plugin and failed. I'm using the table from postfixadmin now and it works.

I use different databases for roundcube & postfixadmin.

[internethering]

Here is the table schema from postfixadmin 2.93:

CREATE TABLE `fetchmail` (
  `id` int(11) UNSIGNED NOT NULL,
  `domain` varchar(255) DEFAULT '',
  `mailbox` varchar(255) NOT NULL,
  `src_server` varchar(255) NOT NULL,
  `src_auth` enum('password','kerberos_v5','kerberos','kerberos_v4','gssapi','cram-md5','otp','ntlm','msn','ssh','any') CHARACTER SET utf8 DEFAULT NULL,
  `src_user` varchar(255) NOT NULL,
  `src_password` varchar(255) NOT NULL,
  `src_folder` varchar(255) NOT NULL,
  `poll_time` int(11) UNSIGNED NOT NULL DEFAULT '10',
  `fetchall` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `keep` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `protocol` enum('POP3','IMAP','POP2','ETRN','AUTO') CHARACTER SET utf8 DEFAULT NULL,
  `usessl` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `sslcertck` tinyint(1) NOT NULL DEFAULT '0',
  `sslcertpath` varchar(255) CHARACTER SET utf8 DEFAULT '',
  `sslfingerprint` varchar(255) DEFAULT '',
  `extra_options` text,
  `returned_text` text,
  `mda` varchar(255) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `active` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

[PF4Public]

I got used to have subjects to have some keywords to identify the body, but never have put specific information to subjects, for this reason I just ignored the subject, which is why I didn't get it right away.
This is definitely a bug