HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=4)
-   -   Virtual Users + Mysql + Squirrelmail + ChangePass Plugins Problem (http://www.howtoforge.com/forums/showthread.php?t=18923)

JEU 2nd January 2008 14:28

Virtual Users + Mysql + Squirrelmail + ChangePass Plugins Problem
 
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.

falko 3rd January 2008 14:46

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

JEU 3rd January 2008 15:42

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:

falko 4th January 2008 18:51

Did you install the php-mysql package?

JEU 4th January 2008 21:32

: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?

falko 5th January 2008 14:24

Quote:

Originally Posted by JEU
can i uninstall all those php5 related packages?

If you're using PHP4, then yes.

spirre 5th November 2008 14:56

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

JEU 5th November 2008 16:03

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.

falko 6th November 2008 13:33

Quote:

Originally Posted by spirre (Post 153715)
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

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

Rashef 26th November 2008 11:25

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, user=user@mydomain.com, ip=[::ffff:127.0.0.1], port=[52975], protocol=IMAP
Nov 26 11:19:28 server1 imapd: LOGOUT, user=user@mydomain.com, 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...


All times are GMT +2. The time now is 22:36.

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