Virtual Users + Mysql + Squirrelmail + ChangePass Plugins Problem

Discussion in 'Installation/Configuration' started by JEU, Jan 2, 2008.

  1. JEU

    JEU New Member

    Hi everyone, i have an installed and currently working email server (did it on falko's way :) ). I have the need of allow password changing to my users, so i was searching and the easiest way of doing this i have found is the squirrelmail + changepass plugin (If someone has some advice or any idea of another way of letting users change their passwords it will be welcome ;)), well anyway my problem is that i cant make it work. Im stuck on "cant connect to database" error, it seems to me that the query to connect to the database isnt well but i cant fix it, the query on the config.php of the plugin that i guess is wrong is:

    $csp_dsn = 'mysql://user: password@localhost/email_users';

    i replace the username and the password and the final part "email_users" that i suppose is the name of the database i will work with, with my own database called "mail", the rest of the configuration file it seems to be ok (not sure either).

    i've already tested the user and password and privileges on the command line (with mysql -u user -p pass -d mail) and seems to work fine (select + update privileges over mail database).

    If anyone has any idea to fix this or workaround... i will be waiting to probe it.

    Thks in advance.
     
  2. falko

    falko Super Moderator Howtoforge Staff

    Are there any errors in your logs, especially Apache's error log?
     
  3. JEU

    JEU New Member

    No errors. I tried using an older version with another database connection method but the result is another error of another kind, so i put back the newer one. The newer one uses Pear DB to make the connection, and i guess i have all those packages installed, but i dont know how to check if those package actually works or how to make the same connection from the command line or some other utility that let me check for more detailed errors or so :S. I used some script (that i find on the net) maded on php to "check" pear DB and guess what, it gives me an error :p (that i guess is the key), some error relative to "cant find DB package or so". I will copy & paste if needed, so i suppose it could be some missing path on php.ini or so.

    The other chance is to change all to that project called RoundCube, any advice on that? at least is more beatifull than squirrel :D, too bad is still an alfa or so. I just need some nice webmail frontend, and allowing users to change pass i guess thats all for now. :cool:
     
  4. falko

    falko Super Moderator Howtoforge Staff

    Did you install the php-mysql package?
     
  5. JEU

    JEU New Member

    :D good one! i have installed php5-mysql package but not the php4-mysql package :) now i did it and im obtaining some error but is mysql query relative :) so it works!!!. Btw... why i have php5 support and php4 if apache2 is actually using just php4 :confused: can i uninstall all those php5 related packages?
     
  6. falko

    falko Super Moderator Howtoforge Staff

    If you're using PHP4, then yes.
     
  7. spirre

    spirre New Member

    Problem - SQL Change pass

    Hi,
    Ihave a problem with the Change pass plugin. when i enables it and tries to login i just get a white page. no errors.

    Any ideas?

    *Edit running Ubuntu 8.10 and Php5
     
  8. JEU

    JEU New Member

    No, but...

    Currently i'm using roundcube for the webmail installations. It works like an imap client, it's easy to setup and has plugins to do the change pass also (depending on your backend). If you can, take a look at it, an take a look at the postfixadmin too, because they work fine together and that is an advantage for mailservers administration.
     
  9. falko

    falko Super Moderator Howtoforge Staff

    If you have edited any Squirrelmail files, please make sure that there's no syntax error in these files.
     
  10. Rashef

    Rashef New Member

    I have the same problem: I get a white page either with Squirrelmail or Roundcube...

    Using Squirrelmail I get the login page but when I try to login I get the white page. This is the mail.log:

    Code:
    Nov 26 11:19:28 server1 imapd: LOGIN, [email protected], ip=[::ffff:127.0.0.1], port=[52975], protocol=IMAP
    Nov 26 11:19:28 server1 imapd: LOGOUT, [email protected], ip=[::ffff:127.0.0.1], headers=0, body=0, rcvd=30, sent=238, time=0
    I found no errors in mysql.log, mysql.err, auth.log...

    P.S.: I can successfully access to mailbox through IMAP using the same account...
     
  11. falko

    falko Super Moderator Howtoforge Staff

    This probably means that you have a syntax error in the config.php file of the change_sqlpass plugin. Please check that file again.
     

Share This Page