Password plugins - Page 3

sumit9451 · #21 09-24-2009, 11:16 PM

YEs i can access it .. i have tried can you send me once again step by step instruction from starting so i can try once again ... please i used simplescript to uplaod roundcube mail script.. this is my mysql server status

* Server: Localhost via UNIX socket
* Server version: 5.0.81-community-log
* Protocol version: 10
* User: comp35_rnd02@localhost
* MySQL charset: UTF-8 Unicode (utf

Web server

* Apache/2.2.13 (Unix) mod_ssl/2.2.13 OpenSSL/0.9.8k DAV/2 mod_auth_passthrough/2.1 FrontPage/5.0.2.2635
* MySQL client version: 5.0.81
* PHP extension: mysqli

fms · #22 09-25-2009, 12:54 PM

Where are your users? on what database?

Lets say:
1) your mysql-user: comp35_rnd02
2) your mysql-password:3aRqSzgezi
3) your mysql-database: postfix

So, user comp35_rnd02 should have rights to access postfix database from localhost (assuming RoundCube is running on same machine where mysql is)

Code:

#mysql
mysql> GRANT ALL ON postfix.* TO comp35_rnd02@localhost IDENTIFIED BY '3aRqSzgezi'; FLUSH PRIVILEGES;
exit

So, your password-plugin config is something like this:
/usr/local/www/roundcube/config/password/config.inc.php

Code:

$rcmail_config['password_db_dsn'] = 'mysql://comp35_rnd02:3aRqSzgezi@unix(/tmp/mysql.sock)/postfix';
$rcmail_config['password_query'] = "UPDATE `mailbox` SET `password` = %c, modified=now() WHERE `username` = %u LIMIT 1";

rosali · #23 09-25-2009, 02:44 PM

@fms: The problem of sumit9451 is, that he is using the imap server of his host. His webspace is controlled by cpanel. I don't think that he has access to postfix database. I'm not familiar with cpanel. I don't know if it is even possible to code a suiteable driver for the current password plugin. MySQL - at least with the credential posted by sumit 9451 - has only access to the RoundCube database.

fms · #24 09-25-2009, 05:36 PM

humm ok Rosali.

In this case, I dont know a solution for him.

sumit9451 · #25 09-26-2009, 07:24 AM

SO tell me the way ... is this not for cpanel .. what you need just tell me so i can find and tell you.. pzzzzzzzzzzzzzz

sumit9451 · #26 09-26-2009, 07:39 AM

i have one idea if you support me ... tell me where should i install roundcube manually and i have full control for cpanel...

sumit9451 · #27 09-26-2009, 08:27 AM

This is the change password from cpanel .. if this helps your for me then i am really happy please

https://host293.hostmonster.com:2083...ertreasure.com

rosali · #28 09-26-2009, 09:27 AM

You don't understand the structure:

RoundCube is a IMAP server client.
The backend is a IMAP server.
The IMAP server or a backend of the IMAP server administers users and passwords.
Really deep insights to your imap server and the user/password administration are necessary to code a php script to jump into it.
At the moment no skilled php programmer and cpanel user has coded a password change driver ...

yinzhen · #29 03-03-2010, 03:39 PM

hello,

i use roundcube 0.3.2.30 and have a problem with the Password Plugin. If try to change a Password, there is always the 'internalerror' Message. But if i try out the wrong 'curpasswd' , roundcube detect that it is the wrong psw. and put out the 'passwordincorrect' message.

Seems like Roundcube cant write to the DB.
I use mysql, postfix

There is a error in the log:

Code:

apache2: MDB2 Error: not found (-4): _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT update_passwd('qtr$hjhtdjrtdjrdjrtz345z54rt', 'xxxxxxx@xxxxxx.com')] [Native code: 1305] [Native message: FUNCTION roundcubemail.update_passwd does not exist]

yinzhen · #30 03-05-2010, 01:06 PM

Quote:

Originally Posted by yinzhen

hello,

i use roundcube 0.3.2.30 and have a problem with the Password Plugin. If .......

uff. a solution.....
first i discovered that the old changepswd plugin (0.2.1) work. so i copied some lines. but in the end (like first page in this thread) it works with:

PHP Code:


			
$rcmail_config['password_db_dsn'] = 'mysqli://username:gfd534PASSgdfGGERR53@localhost/vmail';

PHP Code:


			
$rcmail_config['password_query'] = "UPDATE `mailbox` SET `password` = %c, modified=now() WHERE `username` = %u LIMIT 1";

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)