[SM-USERS] Preference file *.tmp could not be opened
-BEGIN PGP SIGNED MESSAGE- Hash: SHA512 Hi List, i can't login to my squirrelmail installation due to this error: > Preference file, > /var/local/squirrelmail/data/m...@maildomain.pref.tmp, could not be > opened. Contact your system administrator to resolve this issue. this file extension *.tmp doesn't exist, i show you the squirrelmail/data content and permissions: > ~ # ls -la /var/local/squirrelmail/data/ total 20K drwxr-sr-x 3 > www-data www-data 4.0K Nov 21 01:52 . drwxr-sr-x 4 www-data > www-data 4.0K Nov 19 13:13 .. -rw--- 1 www-data www-data0 > Nov 21 01:02 my@maildomain.abook drwx--S--T 2 www-data www-data > 4.0K Nov 21 01:46 my@maildomain.gnupg -rw-rw-rw- 1 www-data > www-data 604 Nov 21 01:52 m...@maildomain.pref -rw--- 1 www-data > www-data 36 Nov 21 00:41 .pref Do you have any suggestions ? Lots of regards Gab - -- Key fingerprint = EB67 3CA1 6C61 EACE B705 4EC3 A28D E2DD 4C47 A4D9 -BEGIN PGP SIGNATURE- Version: GnuPG v1 iQIcBAEBCgAGBQJUtoIaAAoJEKKN4t1MR6TZKZ0P/21R69Y/OxmSdRQA04+w+X0q A0wqJXDvNqkoH7vo/8hjKX5B7NqB/rCfzuJ0Akz8pC2zREQlR/s9Wy4NmLYmM4Je zMqVKJeb/IlBLx6/6VdgPCIzypO+SVBCy2/huMQ1F/aSc1En6WGyKzLBSS3Vyl82 ZTZZ+IyowXZN28P2zB4LmCvOb0+PHRmnPDn32qj0OAVKV2Y29j2Rqbcsb4/sKVWj mvPpnp16MgrVa3FcvTY9QNA+jbR1BZmj7mcwTTnCMqyrrpAD/IBVxI0pItLLRTqg HO0avfOsvHBr31SznBY2E12ybCH3q+aI7INFaZvcrk782FktNmKLZyH64ZkeG4e4 53l3nkghGanvVlFJvS7bW4ZUXz2fgvwEToyQIdA5mM7SysmfXYREuDe4pB0hPYWE hMoVcosySyyYS4t+CrHgWkMS5OoX/Gu1HAp2VhLg/Dj1JyafolfDPHa4/5ba0WY5 SBGO7r/gEn58Wcyrh9iaIXcAnb1tJ2w+GhVIt3S2MoTN33xW30mbLb8wkMRHNuXk wFV9cb/3duwp2d2En+lSk8VD/YOAnUgiZbCklzytzWEPJHhKXynWPLA550HzV6LW /UDqlNFVLD9/oukmlnGlQgNEg1r7pWdbvdC+mk7umSCgsFWPHK7iv6BsQpN+YrcA 3y4fGvL3GvpUVu7L2Jyz =PT8T -END PGP SIGNATURE- -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet - squirrelmail-users mailing list Posting guidelines: http://squirrelmail.org/postingguidelines List address: squirrelmail-users@lists.sourceforge.net List archives: http://news.gmane.org/gmane.mail.squirrelmail.user List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
[SM-USERS] Preference file *.tmp could not be opened
Hi List, i can't login to my squirrelmail installation due to this error: > Preference file, > /var/local/squirrelmail/data/m...@maildomain.pref.tmp, could not be > opened. Contact your system administrator to resolve this issue. this file extension *.tmp doesn't exist, i show you the squirrelmail/data content and permissions: > ~ # ls -la /var/local/squirrelmail/data/ total 20K drwxr-sr-x 3 > www-data www-data 4.0K Nov 21 01:52 . drwxr-sr-x 4 www-data > www-data 4.0K Nov 19 13:13 .. -rw--- 1 www-data www-data0 > Nov 21 01:02 my@maildomain.abook drwx--S--T 2 www-data www-data > 4.0K Nov 21 01:46 my@maildomain.gnupg -rw-rw-rw- 1 www-data > www-data 604 Nov 21 01:52 m...@maildomain.pref -rw--- 1 www-data > www-data 36 Nov 21 00:41 .pref Do you have any suggestions ? Lots of regards Gab -- -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet - squirrelmail-users mailing list Posting guidelines: http://squirrelmail.org/postingguidelines List address: squirrelmail-users@lists.sourceforge.net List archives: http://news.gmane.org/gmane.mail.squirrelmail.user List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
[SM-USERS] change_sqlpass for qmailtoaster
hi
i was able to adapt the change_sqlpass plugin to suit vpopmail mysql database
of qmailtoaster wherein the domains are created as domain_com.
however i got stuck at one specific point
as per the details in the config file the variable : %3 returns the domain name
as : domainname.com
how do i get domainname.com within a variable so that i can replace dot with
underscore ie domainname.com with domainname_com
for example i tried to use : $domainname = %3; but php throws a blank page.
if i use %3 within sql select query the domain name (domainname.com) is
returned correctly.
i am not a php programmer but have a very basic knowledge only.
my change_sqlpass config file is quoted below
any help would be greatly appreciated. i am trying to figure this for so many
weeks now and i am stuck at the very last step.
rajesh
* 2002-2005 Paul Lesneiwski
* This program is licensed under GPL. See COPYING for details
*
* @package plugins
* @subpackage Change SQL Password
*
*/
// Global Variables, don't touch these unless you want to break the plugin
//
global $csp_dsn, $password_update_queries, $lookup_password_query,
$force_change_password_check_query, $password_encryption,
$csp_salt_query, $csp_salt_static, $csp_secure_port,
$csp_non_standard_http_port, $csp_delimiter, $csp_debug,
$min_password_length, $max_password_length,
$include_digit_in_password,
$include_uppercase_letter_in_password,
$include_lowercase_letter_in_password,
$include_nonalphanumeric_in_password;
// csp_dsn
//
// Theoretically, any SQL database supported by Pear should be supported
// here. The DSN (data source name) must contain the information needed
// to connect to your database backend. A MySQL example is included below.
// For more details about DSN syntax and list of supported database types,
// please see:
// http://pear.php.net/manual/en/package.database.db.intro-dsn.php
//
//$csp_dsn = 'mysql://user:password@localhost/email_users';
$csp_dsn = 'mysql://vpopmail:xx@localhost/vpopmail';
// lookup_password_query
//
// This plugin will always verify the user's old password
// against their login password, but an extra check can also
// be done against the database for more security if you
// desire. If you do not need the extra password check,
// make sure this setting is empty.
//
// This is a query that returns a positive value if a user
// and password pair are found in the database.
//
// This query should return one value (one row, one column), the
// value being ideally a one or a zero, simply indicating that
// the user/password pair does in fact exist in the database.
//
// %1 in this query will be replaced with the full username
// (including domain), such as "j...@example.com"
// %2 in this query will be replaced with the username (without
// any domain portion), such as "jose"
// %3 in this query will be replaced with the domain name,
// such as "example.com"
// %4 in this query will be replaced with the current (old)
// password in whatever encryption format is needed per other
// plugin configuration settings (Note that the syntax of
// the password will be provided depending on your encryption
// choices, so you NEVER need to provide quotes around this
// value in the query here.)
// %5 in this query will be replaced with the current (old)
// password in unencrypted plain text. If you do not use any
// password encryption, %4 and %5 will be the same values,
// except %4 will have double quotes around it and %5 will not.
//
//$domainname = %3;
//$tablename = str_replace(".","_",$domainname);
//$lookup_password_query = '';
// TERRIBLE SECURITY: $lookup_password_query = 'SELECT count(*) FROM users
WHERE username = "%1" AND plain_password = "%5"';
// $lookup_password_query = 'SELECT count(*) FROM users WHERE username = "%1"
AND crypt_password = %4';
// $lookup_password_query = 'SELECT count(*) FROM $tablename WHERE pw_name =
"%2" AND pw_domain = "%3" AND pw_passwd = %4';
$lookup_password_query = 'SELECT count(*) FROM mydomain_com WHERE pw_name =
"%2" AND pw_passwd = %4';
// password_update_queries
//
// An array of SQL queries that will all be executed
// whenever a password change attempt is made.
//
// Any number of queries may be included here.
// The queries will be executed in the order given here.
//
// %1 in all queries will be replaced with the full username
// (including domain), such as "j...@example.com"
// %2 in all queries will be replaced with the username (without
// any domain portion), such as "jose"
// %3 in all queries will be replaced with the domain name,
// such as "example.com"
// %4 in all queries will be replaced with the new password
// in whatever encryption format is ne
Re: [SM-USERS] squirrelmail error message issue.
paul squirrelmail version : Version: 1.4.22 dovecot version : 2.2.7 i followed your advice and here is the response from the server A LOGIN u...@xx.com 111 A NO [AUTHENTICATIONFAILED] Authentication failed. B LOGOUT Connection closed by foreign host. dovecot log file shows as follows Jan 15 07:21:35 imap-login: Info: Aborted login (auth failed, 1 attempts in 14 secs): user=, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured, session= the error squirrelmail shows is : connection dropped by imap server. query logout. rajesh - Original Message - From: Paul Lesniewski [mailto:p...@squirrelmail.org] To: squirrelmail-users@lists.sourceforge.net Sent: Mon, 8 Dec 2014 14:19:57 -0800 Subject: Re: [SM-USERS] squirrelmail error message issue. >> hi >> >> i am using dovecot for pop3 and imap along with qmail toaster >> >> i had recently changed over from a 32 bit system to a 64 bit system. >> >> i use squirrelmail. >> >> the issue i face is that when the user inserts an invalid password then >> the >> message he gets is connection dropped by imap server (instead of invalid >> userid or password) >> >> such a message confuses the user. >> >> my earlier 32 bit version used to give the correct message >> >> i am posting this issue here because i am not sure if this is >> squirrelmail >> issue or a dovecot issue. > > Probably a Dovecot issue. The answer is in your logs. > > paul > > thanks for your reply > > i intentionaly put the wrong password and checked the dovecot log and the > message i got was > > # tail -f /var/log/dovecot.log | grep "x...@yyy.com" > Nov 25 08:47:46 imap-login: Info: Aborted login (auth failed, 1 attempts in > 2 secs): user=, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, > secured, session= > > but in the squirrelmail login page instead of the message "unknown user or > password incorrect" i get the message > > ERROR: Connection dropped by IMAP server. > Query: LOGOUT > > > in my old server where it is working correctly dovecot logs shows the error > > Nov 25 14:46:12 imap-login: Info: Aborted login (auth failed, 1 attempts): > user=<"x...@yyy.com">, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured >> and squirrelmail gives the error : "unknown user or password incorrect" > which is correct. > > is there any other place i need to check or some other config file (either > squirrelmail or dovecot) that i need to modify > > could you kindly guide me At the command line: telnet localhost 143 (or whatever port your Dovecot server is listening on) A LOGIN x...@yyy.zzz w B LOGOUT See what the IMAP response is to line A. It is probably not giving a valid response such as "NO login failed." If it's giving a "BAD" response, you need to fix your Dovecot settings. -- Paul Lesniewski SquirrelMail Team Please support Open Source Software by donating to SquirrelMail! http://squirrelmail.org/donate_paul_lesniewski.php -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk - squirrelmail-users mailing list Posting guidelines: http://squirrelmail.org/postingguidelines List address: squirrelmail-users@lists.sourceforge.net List archives: http://news.gmane.org/gmane.mail.squirrelmail.user List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users -- New Year. New Location. New Benefits. New Data Center in Ashburn, VA. GigeNET is offering a free month of service with a new server in Ashburn. Choose from 2 high performing configs, both with 100TB of bandwidth. Higher redundancy.Lower latency.Increased capacity.Completely compliant. http://p.sf.net/sfu/gigenet- squirrelmail-users mailing list Posting guidelines: http://squirrelmail.org/postingguidelines List address: squirrelmail-users@lists.sourceforge.net List archives: http://news.gmane.org/gmane.mail.squirrelmail.user List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
