Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 17th October 2008, 06:11
laserdot laserdot is offline
Junior Member
 
Join Date: Oct 2008
Posts: 2
Thanks: 1
Thanked 0 Times in 0 Posts
Default Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail

Re: Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 8.04 LTS)

First Off, I wish to thank falko for some wonderful How-To's, they have really saved me a lot of time.

I recently built a mail server and it is working well (the Virtual mail server for Ubuntu 7.10), but there is no user password change facility (without me coding one). When I recently needed to re-build another mail server, I used this how-to and included squirrelmail for the PW change ability. My issue is that SM gives me a blank page after I login. Using IMAP I see the welcome email, so there should be something to display.

In looking around the SM site, and they have asserted that this is typically a problem with the PHP package. I investigated my setup, and noticed that php -v gives me "PHP 5.2.4-2ubuntu5.3 with Suhosin-Patch 0.9.6.2 (cli) (built: Jul 23 2008 06:44:49)", and the How-To was released on 2008-05-20. I suspect there might be a problem with the updated PHP package, but being only a part time admin, my knowledge is sorely lacking.

Can anyone with a working setup tell me the versions they are running from the how-to? I will try syncing my packages with a working install first, making sure there are not any package version issues before I get any deeper into troubleshooting this issue.

Thanks in advance...
Reply With Quote
Sponsored Links
  #2  
Old 17th October 2008, 20:24
marchost marchost is offline
Junior Member
 
Join Date: Feb 2008
Posts: 27
Thanks: 1
Thanked 4 Times in 4 Posts
Default php version

Hi, I got it working, here is my php -v output

PHP 5.2.4-2ubuntu5.3 with Suhosin-Patch 0.9.6.2 (cli) (built: Jul 23 2008 06:46:18)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
Reply With Quote
  #3  
Old 17th October 2008, 20:34
marchost marchost is offline
Junior Member
 
Join Date: Feb 2008
Posts: 27
Thanks: 1
Thanked 4 Times in 4 Posts
Default

I would recommend you to redo the SM part of the tutorial...

Normally a blank page is because there is a typo somewhere in the PHP files.

The only modification of php in the tutorial is

/usr/share/squirrelmail/plugins/change_sqlpass/config.php

Here is the file without comments :

############################
<?php

/**
* SquirrelMail Change SQL Password Plugin
* Copyright (C) 2001-2002 Tyler Akins
* 2002 Thijs Kinkhorst <kink@users.sourceforge.net>
* 2002-2005 Paul Lesneiwski <paul@openguild.net>
* 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 = 'mysql://mail_admin:mail_admin_password@localhost/mail';

$lookup_password_query = 'SELECT count(*) FROM users WHERE email = "%1" AND password = %4';

$password_update_queries = array('UPDATE users SET password = %4 WHERE email = "%1"');

$force_change_password_check_query = '';

$password_encryption = 'MYSQLENCRYPT';

$csp_salt_static = 'LEFT(password, 2)';

$csp_secure_port = 0;

$csp_non_standard_http_port = 0;

$min_password_length = 6;
$max_password_length = 0;
$include_digit_in_password = 0;
$include_uppercase_letter_in_password = 0;
$include_lowercase_letter_in_password = 0;
$include_nonalphanumeric_in_password = 0;

$csp_delimiter = '@';

$csp_debug = 0;

?>
#####################################
Reply With Quote
The Following User Says Thank You to marchost For This Useful Post:
laserdot (18th October 2008)
  #4  
Old 18th October 2008, 06:14
laserdot laserdot is offline
Junior Member
 
Join Date: Oct 2008
Posts: 2
Thanks: 1
Thanked 0 Times in 0 Posts
 
Smile

Thank you for the response marchost...you nailed the problem!

I decided to review the config.php file for errors first, and I found an extra _'_ in the line
$csp_salt_static = 'LEFT(password, 2)';

After I fixed that, squirrelmail now displays properly...Thanks again!
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail -Ubuntu 8.04 c4rdinal HOWTO-Related Questions 112 23rd August 2011 11:49
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail garther HOWTO-Related Questions 54 5th September 2008 13:38
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail Ubuntu 8.04 paulodani HOWTO-Related Questions 7 4th June 2008 01:46
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 8.04 mtzcesar HOWTO-Related Questions 3 1st June 2008 11:57
Virtual Users And Domains W/ Postfix, Courier and MySql + Squirrelmail prob nsurge HOWTO-Related Questions 10 23rd October 2006 18:43


All times are GMT +2. The time now is 09:27.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.