Posts by sport80

Quote from TheCry

This should be a problem from an older version.
With the current versions this double entries will not appear

I have installed this server on 16 june, so the spamassassin plugin used before was the 0.0.8 version...

So, no problem for me, but the upgrade process does not work in this case

Ok, i've tried and theses are the results:

- In main.inc.php the 'markasjunk2', 'sauserprefs' are not present in plugin array
- Uninstalling and Reinstalling the plugin, some values in user_prefs are double and the plugin installation fails. When removed from table, it works

Thanks

Quote from TheCry

Check your config.php of the plugin.

Code

1. /*
2. * Roundcube Plugins
3. */
6. // Adds a new button to the mailbox toolbar to mark the selected messages as Junk/Not Junk,
7. // optionally detaching original messages from spam reports if the message is not junk and
8. // learning the bayesian database with junk/not junk.
9. 'markasjunk2' => 'yes', // YES (default), NO
12. // Adds a 'Spam' tab to the 'Settings' in Roundcube to allow the users to change
13. // their SpamAssassin preferences which are stored in the imscp_spamassassin database.
14. 'sauserprefs' => 'yes', // YES (default), NO

Display More

On my installation it works

It's the same as mine..

Hi

I've upgraded to the last 0.0.9 version but don't appears the SPAM options in roundcube as before...

Thanks

Quote from TheCry

So.. It seems that it works.
Log in to phpmyadmin and select the database of spamassasin. There you run this 2 queries

Code

1. ALTER TABLE `userpref` DROP INDEX `user_pref`;
2. ALTER TABLE `userpref` ADD UNIQUE `user_pref` ( `username`, `preference`, `value`);

After this it is possible to add more than an entry

It works also for me

Thanks

Quote from pdias

Hi all,
Not shure if it go ther or if I must open another thread but the bug I'm going to talk produces the same error.

Bug: can't add more than one address in SA whitelis/blacklist. If you try you get a database connection error from roundcube plugin (at least in my install).

Steps to reproduce :

Install IMSCP, install SA & Roundcube Plugins, create a domain in imscp, create new email address.
Connect to roundcube and add a new e-mail address to the whitelist, then save changes.
Now add another one and click save ...

The problem is in user-prefs table structure. There is a unique index based on username and pref name (where IMHO it should be username + pref name + pref value) and when you add more than one whitelist/blacklis address you have a constraint violation.

I've just modified the user-prefs table structure and now, I can add more than one adress but maybe I'm in the wrong way ?

Apologize for bad english.

Regard's
Paul

Display More

Yes, i confirm this error, also for me the same results

Thanks

Quote from Dylan

Thanks sport80, it's works!

Good!

Ok, nuxwin have solved this problem.

This is a bug in the upstart init script in ubuntu package

To solve easy you must to modify the /etc/init/php5-fpm.conf and edit

#reload signal USR2

to

reload signal USR2

Thank you very much

Ok, only one moment, please

Ok, i've tried as you have described

same results.. same i-MSCP version... same problems..

the system is apt-get updated and upgraded

before i have used a i-mscp script to update to the last version that use

git clone -b stable git://github.com/i-MSCP/imscp.git /usr/local/src/stable/imscp