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 29th January 2010, 06:01
gr33d gr33d is offline
Junior Member
 
Join Date: Nov 2009
Posts: 23
Thanks: 1
Thanked 0 Times in 0 Posts
Question Trouble logging into SquirrelMail for the first time

Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail (Ubuntu 9.04) - Page 5

I'm stuck at the section where I login to SquirrelMail with mail_admin@domain.tld and password--no luck. I tried using phpMyAdmin to reset the password of mail_admin@domain.tld using the ENCRYPT function to no avail. I was logged in as mail_admin--I think I named the database user/owner the same.

tail /var/log/mail.log shows this each time I fail the login:
Jan 28 22:53:33 mail imapd: Connection, ip=[::1]
Jan 28 22:53:33 mail imapd: LOGIN FAILED, user=mail_admin@domain.tld, ip
=[::1]
Jan 28 22:53:38 mail imapd: LOGOUT, ip=[::1], rcvd=80, sent=323

I can see my first mailx message in /home/vmail/domain.tld/mail_admin/new/

in the 6 postfix config files created, should the password be that of the database user mail_admin
or the postfix user mail_admin@domain.tld?

Any ideas what I may have missed?

Thanks in advance!

Last edited by gr33d; 29th January 2010 at 06:31.
Reply With Quote
Sponsored Links
  #2  
Old 30th January 2010, 15:52
gr33d gr33d is offline
Junior Member
 
Join Date: Nov 2009
Posts: 23
Thanks: 1
Thanked 0 Times in 0 Posts
Default blank screen after login to squirrelmail (webmail.php)

I found a slight inaccuracy in /usr/share/squirrelmail/plugins/change_sqlpass/config.php on the line

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

I didn't have the ); at the end of the line. the line looked like

$password_update_queries = array('UPDATE users SET password = %4 WHERE email = "%1"', maybe I didn't copy and paste correctly.

Now, I simply see a blank screen when I login to webmail.php. I think squirrelmail was sending my browser to redirect.php or maybe it was still login.php before when it was denying my login.

Any ideas? Thanks!


here is my iptables -L output. I tried with all 3 chains -P ACCEPT and that didn't work either.

Chain INPUT (policy DROP)
target prot opt source destination
ACCEPT all -- anywhere anywhere state RELATED,ESTABLISHED
ACCEPT all -- anywhere anywhere
ACCEPT tcp -- anywhere anywhere tcp dpt:ssh
ACCEPT tcp -- anywhere anywhere tcp dpt:www

Chain FORWARD (policy DROP)
target prot opt source destination

Chain OUTPUT (policy ACCEPT)
target prot opt source destination
Reply With Quote
  #3  
Old 30th January 2010, 17:06
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

Can you post your /usr/share/squirrelmail/plugins/change_sqlpass/config.php? I guess you have a PHP syntax error in there.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #4  
Old 30th January 2010, 17:48
gr33d gr33d is offline
Junior Member
 
Join Date: Nov 2009
Posts: 23
Thanks: 1
Thanked 0 Times in 0 Posts
Default

i only replaced my password with "mail_admin_password" in the $csp_dsn variable below:

Code:
<?php

   // 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_pa
ssword,
          $include_nonalphanumeric_in_password;

   $csp_dsn = 'mysql://mail_admin:mail_admin_password@localhost/mail';

   $lookup_password_query = 'SELECT count(*) FROM users WHERE username = "%1" AN
D 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 = 8080;
   $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_delimiter = '@';
   $csp_debug = 0;
?>
i installed the squirrelmail debugger plugin and when i login now, i receive:

Code:
Notice: A session had already been started - ignoring session_start() in /usr/share/squirrelmail/functions/global.php on line 429

Stack Trace:

session_start()
/usr/share/squirrelmail/functions/global.php
line 429

    sqsession_start()
    /usr/share/squirrelmail/functions/global.php
    line 409

        sqsession_is_active()
        /usr/share/squirrelmail/functions/global.php
        line 250

            sqsession_register("http://1.1.1.1", "sq_base_url")
            /usr/share/squirrelmail/functions/strings.php
            line 350

                get_location()
                /usr/share/squirrelmail/src/redirect.php
                line 35

My browser information:
  Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.7) Gecko/20091221 Firefox/3.5.7 (.NET CLR 3.5.30729)

My web server information:
  PHP Version 5.2.6-3ubuntu4.5
  PHP Extensions (List)
    * 0 = zip
    * 1 = xmlwriter
    * 2 = libxml
    * 3 = xml
    * 4 = wddx
    * 5 = tokenizer
    * 6 = sysvshm
    * 7 = sysvsem
    * 8 = sysvmsg
    * 9 = session
    * 10 = SimpleXML
    * 11 = sockets
    * 12 = soap
    * 13 = SPL
    * 14 = shmop
    * 15 = standard
    * 16 = Reflection
    * 17 = posix
    * 18 = mime_magic
    * 19 = mbstring
    * 20 = json
    * 21 = iconv
    * 22 = hash
    * 23 = gettext
    * 24 = ftp
    * 25 = filter
    * 26 = exif
    * 27 = dom
    * 28 = dba
    * 29 = date
    * 30 = ctype
    * 31 = calendar
    * 32 = bz2
    * 33 = bcmath
    * 34 = zlib
    * 35 = pcre
    * 36 = openssl
    * 37 = xmlreader
    * 38 = apache2handler
    * 39 = gd
    * 40 = mcrypt
    * 41 = mysql
    * 42 = mysqli
    * 43 = PDO
    * 44 = pdo_mysql

SquirrelMail-specific information:
  Version:  1.4.15
  Plugins (List)
    * 0 = compatibility
    * 1 = change_sqlpass
    * 2 = debugger

My IMAP server information:
  Server type:  courier
  Server info:  * OK [HIDDEN] IMAP4rev1 UIDPLUS CHILDREN NAMESPACE THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA IDLE ACL ACL2=UNION STARTTLS] Courier-IMAP ready. Copyright 1998-2008 Double Precision, Inc.  See COPYING for distribution information.
  Capabilities:  IMAP4rev1 UIDPLUS CHILDREN NAMESPACE THREAD=ORDEREDSUBJECT THREAD=REFERENCES SORT QUOTA IDLE ACL ACL2=UNION STARTTLS
i dont know much php, but i thought maybe the session was still active from one of the "blank" logins and waited 25 minutes to login again. same results.
Reply With Quote
  #5  
Old 5th February 2010, 02:11
gr33d gr33d is offline
Junior Member
 
Join Date: Nov 2009
Posts: 23
Thanks: 1
Thanked 0 Times in 0 Posts
Default

bump? any PHP assistance?

Thanks!
Reply With Quote
  #6  
Old 5th February 2010, 16:50
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

Quote:
Originally Posted by gr33d View Post
i only replaced my password with "mail_admin_password" in the $csp_dsn variable below:
Does the password contain any special characters that need to be escaped? Apart from that, the file looks ok, there don't seem to be any syntax errors.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #7  
Old 5th February 2010, 17:03
gr33d gr33d is offline
Junior Member
 
Join Date: Nov 2009
Posts: 23
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Nope--alphanumeric. I think I'm going to become a subscriber at this point. I don't have any 64-bit hardware available, but I spotted a debian lenny image for a virtual user/domain setup I think ill give a whirl on i386. These aren't vmware images only right? I can drop them on a fresh hard drive?

Thanks for the help. Please let me know if you ever find a solution to my problem!
Reply With Quote
  #8  
Old 6th February 2010, 20:17
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

Quote:
Originally Posted by gr33d View Post
Nope--alphanumeric. I think I'm going to become a subscriber at this point. I don't have any 64-bit hardware available, but I spotted a debian lenny image for a virtual user/domain setup I think ill give a whirl on i386. These aren't vmware images only right? I can drop them on a fresh hard drive?
These images run under VMware only. It might be possible to convert them so that they can be used on a physical system, but I can't tell if this really works.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #9  
Old 19th March 2010, 23:54
woodbot woodbot is offline
Junior Member
 
Join Date: Mar 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default I have the exact same symptoms

Hi -

I configured my Fedora Core 12 installation by following the excellent howto at

http://www.howtoforge.com/virtual-us...dora-12-x86_64

So I am using postfix with mysql as the authentication.

I have tried the following:

* switching the compatibility plugin. The howto suggests using version 2.0.15-1.0. There is a newer version, 2.0.16, which can be found at:

http://squirrelmail.org/plugin_view.php?id=152

This did not seem to make a difference.

On the plus side, I am so much better at debugging php that I was this morning.

Speaking of which, can anyone tell me why I can't seem to produce a php log file? I have tried everything...I am a good debugger but it's kinda hard feeling around in the dark!
Reply With Quote
Reply

Bookmarks

Tags
mysql, squirrelmail, ubuntu 9.04, virtual domains

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
Postfix problem and few questions Gimly Installation/Configuration 12 7th July 2009 17:27
Dovecot and SquirrelMail Install/Config Trouble adobe Installation/Configuration 4 16th September 2008 12:36
Squirrelmail time issue rick78 Server Operation 0 12th March 2008 00:40
Just installed squirrelmail package, but can't logging? jnolla Installation/Configuration 11 13th September 2007 02:26
Time logging xp users Aaron Morris Server Operation 4 4th September 2006 00:45


All times are GMT +2. The time now is 04:10.


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