Hi there,
I had the spam update settings correctly set and it did work.
Nothing changed. However, today users can no longer update the spam settigs:
The error is:
Jan 28 17:23:45 srv1 roundcube: DB Error: MDB2 Error: insufficient
permissions Query: _doQuery: [Error message: Could not execute
statement] [Last executed query: UPDATE userpref SET value = '6'
WHERE username = 'babuser(a)klunky.co.uk' AND preference =
'required_score';] [Native code: 1142] [Native message: UPDATE command
denied to user 'spam'@'localhost' for table 'userpref'] in
/www/roundcube/program/include/rcube_mdb2.php on line 646 (POST
/?_task=settings&_action=plugin.sauserprefs.save)
The sauserprefgs config file states this, and I can login as the user:
$rcmail_config['sauserprefs_db_dsnw'] =
'mysql://spam:xxxxxxxxxxxxxxxxxx-1@localhost/spamassassin';
The grants are these ( a flush priv has been run).
mysql> show grants for 'spam'@'localhost';
+--------------------------------------------------------------------------------------------------------------------+
| Grants for
spam@localhost
|
+--------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'spam'@'localhost' IDENTIFIED BY PASSWORD
'*xxxxxxxxxxxxxxxxxx' |
| GRANT SELECT, INSERT, DELETE ON `spamassassin`.`bayes_expire` TO
'spam'@'localhost' |
| GRANT SELECT, INSERT, DELETE ON `spamassassin`.`userpref` TO
'spam'@'localhost' |
| GRANT SELECT, INSERT, DELETE ON `spamassassin`.`bayes_global_vars` TO
'spam'@'localhost' |
| GRANT SELECT, INSERT, DELETE ON `spamassassin`.`bayes_token` TO
'spam'@'localhost' |
| GRANT SELECT, INSERT, DELETE ON `spamassassin`.`bayes_seen` TO
'spam'@'localhost' |
| GRANT SELECT, INSERT, DELETE ON `spamassassin`.`bayes_vars` TO
'spam'@'localhost' |
| GRANT SELECT, INSERT, UPDATE, DELETE ON `spamassassin`.`awl` TO
'spam'@'localhost' |
+--------------------------------------------------------------------------------------------------------------------+
Here is the specific sql :
mysql> UPDATE userpref SET value = '6' WHERE username =
'baduser(a)klunky.co.uk' AND preference = 'required_score';
ERROR 1142 (42000): UPDATE command denied to user 'spam'@'localhost' for
table 'userpref'
I tried the same update as the admin user, and it worked.
Has anyone seen this afore, or know what could have changed for this to
suddenly stop working?
* Another weird oddity is that all mail is shown in Roundcube, yet some
is missed from Thunderbird. Very strange.
Best regards, S.
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hi there,
I'm searching for the Button to activate 'Threaded Message Listing'
(TML)!
I'm using the Dec-2010-Xmas-Version with an gmx.net-mail-account.
Does TML depend on gmx or on my roundcube-config?
Best regards from Germany
Ulli Heist
--
http://heist.hobby-site.org/witze
--
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hi there,
Small question. I would like to have a link on the login page of
Roundcube to another site. (Posfixadmin in this case). It can be located
anywhere on the page. Where could I add this into the Roundcube config?
Best wishes, s.
_______________________________________________
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Settings/folders no longer shows the total # of messages for
each folder in this screen.
Is this expected? I sure miss the tot-count!
_______________________________________________
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hello All!
A have upgraded to version 0.5 stable at last weekend, but I have a
strange error.
The deafult language is hungarian, but the user can select language via
lang_sel plugin at login.
With default lang the login is successful, but if I change the lang and
try to login, I get back to the login screen without any error.
In IMAP log a see a successful login and logout.
After that unsuccessful login, if I change the lang, than I get
immediately logged in (without username and pass), with the first
selected lang.
Thanks for any help.
Attila Gyurman
_______________________________________________
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hi, all.
I achieved mailbox sharing with Dovecot & Roundcube webmail in iRedMail[1]
today, just want to share you my experience, hope it helps. Although it's for
iRedMail, but it doesn't depend on it.
http://www.iredmail.org/wiki/index.php?title=IRedMail/FAQ/Share.IMAP.Folder
It describes:
- How to enable mailbox sharing in Dovecot
- How to enable mailbox sharing in Roundcube webmail.
- How to test mailbox sharing with telnet
Requirements:
- Dovecot >= 1.2
- Roundcube webmail >= 0.5 -stable release
[1] iRedMail - Free, Open Source Email Server Solution: http://www.iredmail.org/
_______________________________________________
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hi
I have a roundcube email account and am trying to setup to access it from
Outlook 2000. Need incoming and outgoing server names.
Can anybody help????
TIA
John
_______________________________________________
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hello Roundcube users and lovers
The next major release has now reached stable state and is available for
download. The important new features since 0.4 are: full support for shared
folders and namespaces, Internationalized Domain Names (IDNA) as well as
SMTP Delivery Status Notifications. The user interface for managing IMAP
folders has changed a bit and provides new space for further extensions and
plugins. This was already part of the release candidate published some
weeks ago and the new stable version fixed the last few bugs, namely some
issues with namespaces.
We recommend to update all existing Roundcube installations with this
release. Get it now from http://roundcube.net/download and have a lot of fun!
~Thomas
_______________________________________________
List info: http://lists.roundcube.net/users/
BT/9b404e9e