Zum Inhalt springen

Roundcube/Plugin/sauserprefs: Unterschied zwischen den Versionen

Aus Foxwiki
K Textersetzung - „</blockquote>“ durch „“
 
(2 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 1: Zeile 1:
== SpamAssassin-User-Prefs-SQL ==
== SpamAssassin-User-Prefs-SQL ==
<blockquote>Writes the ''spamassassin user preferences'' in the DB. The user will be allowed to create a black/white list, to adjust the ''required_score'' and so on.
Writes the ''[[spamassassin]] user preferences'' in the DB
* The user will be allowed to create a black/white list, to adjust the ''required_score'' and so on


* Installed via <code>github</code>: johndoh / roundcube-sauserprefs
* Installed via <code>github</code>: johndoh / roundcube-sauserprefs
* Plugin name: ''sauserprefs''
* Plugin name: ''sauserprefs''


If you migrated to <code>spamassassin</code> v.4 you have to use the v. 1.20.1 which is not available on <code>composer</code> yet. So you have to download it from <code>github</code> and install by yourself:
If you migrated to <code>spamassassin</code> v.4 you have to use the v. 1.20.1 which is not available on <code>composer</code> yet
 
So you have to download it from <code>github</code> and install by yourself:
  cd /var/www/roundcube/htdocs/plugins
  cd /var/www/roundcube/htdocs/plugins
  wget <nowiki>https://github.com/johndoh/roundcube-sauserprefs/archive/refs/tags/1.20.1.tar.gz</nowiki>
  wget <nowiki>https://github.com/johndoh/roundcube-sauserprefs/archive/refs/tags/1.20.1.tar.gz</nowiki>
Zeile 11: Zeile 14:
  mv roundcube-sauserprefs-1.20.1/ sauserprefs
  mv roundcube-sauserprefs-1.20.1/ sauserprefs
  mv config.inc.php.dist config.inc.php
  mv config.inc.php.dist config.inc.php
Adjust the configuration:
 
; Adjust the configuration
  $config['sauserprefs_db_dsnw'] = 'mysqli://spamassassin:<PASSWORD>@<mysql-IP>/spamassassin';
  $config['sauserprefs_db_dsnw'] = 'mysqli://spamassassin:<PASSWORD>@<mysql-IP>/spamassassin';
  $config['sauserprefs_sav4'] = true;
  $config['sauserprefs_sav4'] = true;
NB: <mysql-IP> is the IP address of your <code>mysql</code> server (localhost if the same of <code>qmail</code>).


If '<code>mysqli</code>' extension is not available in your <code>php</code>, then choose the old '<code>mysql</code>' in the line above.
NB: <mysql-IP> is the IP address of your <code>mysql</code> server (localhost if the same of <code>qmail</code>)
 
If '<code>mysqli</code>' extension is not available in your <code>php</code>, then choose the old '<code>mysql</code>' in the line above
 
If you have just upgraded to spamassassin v.4 you'd have to take a look to the following info


If you have just upgraded to spamassassin v.4 you'd have to take a look to the following info.
Spamassassin <code>userprefs</code>' funcionality has been explained in this page
* Now we have to check just the creation/modification of the record inside the ''userprefs'' table of the ''spamassassin'' DB


Spamassassin <code>userprefs</code>' funcionality has been explained in this page. Now we have to check just the creation/modification of the record inside the ''userprefs'' table of the ''spamassassin'' DB.
[[Kategorie:Roundcube/Plugin]]

Aktuelle Version vom 8. Juli 2026, 01:24 Uhr

SpamAssassin-User-Prefs-SQL

Writes the spamassassin user preferences in the DB

  • The user will be allowed to create a black/white list, to adjust the required_score and so on
  • Installed via github: johndoh / roundcube-sauserprefs
  • Plugin name: sauserprefs

If you migrated to spamassassin v.4 you have to use the v. 1.20.1 which is not available on composer yet

So you have to download it from github and install by yourself:

cd /var/www/roundcube/htdocs/plugins
wget https://github.com/johndoh/roundcube-sauserprefs/archive/refs/tags/1.20.1.tar.gz
tar xzf 1.20.1.tar.gz
mv roundcube-sauserprefs-1.20.1/ sauserprefs
mv config.inc.php.dist config.inc.php
Adjust the configuration
$config['sauserprefs_db_dsnw'] = 'mysqli://spamassassin:<PASSWORD>@<mysql-IP>/spamassassin';
$config['sauserprefs_sav4'] = true;

NB: <mysql-IP> is the IP address of your mysql server (localhost if the same of qmail)

If 'mysqli' extension is not available in your php, then choose the old 'mysql' in the line above

If you have just upgraded to spamassassin v.4 you'd have to take a look to the following info

Spamassassin userprefs' funcionality has been explained in this page

  • Now we have to check just the creation/modification of the record inside the userprefs table of the spamassassin DB