Hi, Cannot access it right now, but in the same file (config.php) there should be some lines defining the database server, login and password. Set these to the same values as you use in dbmail.conf.
Also, if you are running the database and webserver on separate servers, make sure that the database is listening on an (preferably internal) IP-address that is reachable from the webserver (eg not 127.0.0.1). Stanley. > > Thanks. I have tried that too but I got "couldnot connect to database > error" > message. can u share your dsn? > > On 12/28/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: >> >> >> Hi, >> >> There is also a plugin "change_mysqlpass". >> >> I've been using this with dbmail for quite some time now, you need to >> modify a few lines in config.php: >> >> // The names of the user ID and password columns >> $mysql_userid_field = 'userid'; >> $mysql_password_field ='passwd'; >> >> And of course a few lines below that to match the encryption type you >> use >> in your database (which should be MD5): >> >> //--------------------------------------------------------- >> // Password encryption (or lack thereof) >> //--------------------------------------------------------- >> >> // Set only one of the options below to 1. >> >> // Set to 1 if the password column is encrypted >> // using the MySQL password() function. >> $mysql_saslcrypt = 0; >> >> // Set to 1 if the password column is encrypted >> // using the UNIX crypt() function. >> $mysql_unixcrypt = 0; >> >> // Set to 1 if the password column is to use MD5 encryption >> $mysql_MD5crypt = 1; >> >> // Set both to 0 if the password is stored in the >> // column in plaintext. >> >> Should do the trick. >> >> Stanley. >> >> >> >> > ------=_Part_7402_30647837.1135696405212 >> > Content-Type: text/plain; charset=ISO-8859-1 >> > Content-Transfer-Encoding: quoted-printable >> > Content-Disposition: inline >> > >> > Hi all, >> > >> > Hi all, >> > >> > Is there any (official) plugin to change password for dbmail ? I >> found >> > one written by Matthew O'Connor but apparently it was not listed on >> SM >> > plugin page. >> > >> > >> http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin >> > >> > Furthermore, it is for postgreSQL only. How about MySQL? >> > >> > ------=_Part_7402_30647837.1135696405212 >> > Content-Type: text/html; charset=ISO-8859-1 >> > Content-Transfer-Encoding: quoted-printable >> > Content-Disposition: inline >> > >> > Hi all,<br><br><pre><font color="#ff7733">Hi all,</font><br><br><font >> > color="#ff7733"> Is there any (official) plugin to change password >> for >> > dbmail ? I found</font><br><font color="#ff7733"> one written by >> Matthew >> > O'Connor but apparently it was not listed on SM >> > </font><br><font color="#ff7733"> plugin page.</font><br><br><font >> > color="#ff7733"> <a >> > href=" >> http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin >> " >> > target="_blank"> >> http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin >> > </a></font><br><br>Furthermore, it is for postgreSQL only. How about >> > MySQL? <br><br><br></pre><br> >> > >> > ------=_Part_7402_30647837.1135696405212-- >> > >> > >> >> >> _______________________________________________ >> Dbmail mailing list >> [email protected] >> https://mailman.fastxs.nl/mailman/listinfo/dbmail >> > > ------=_Part_14747_19566404.1135766140689 > Content-Type: text/html; charset=ISO-8859-1 > Content-Transfer-Encoding: quoted-printable > Content-Disposition: inline > > Thanks. I have tried that too but I got "couldnot connect to database > error" message. can u share your dsn?<br><br><div><span > class="gmail_quote">On 12/28/05, <b class="gmail_sendername"><a > href="mailto:[EMAIL PROTECTED]"> > [EMAIL PROTECTED]</a></b> <<a > href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</a>> > wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid > rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> > <br>Hi,<br><br>There is also a plugin > "change_mysqlpass".<br><br>I've been using this with dbmail for > quite some time now, you need to<br>modify a few lines in > config.php:<br><br> // The > names of the user ID and password columns > <br> $mysql_userid_field = > 'userid';<br> $mysql_password_field > ='passwd';<br><br>And of course a few lines below that to match the > encryption type you use<br>in your database (which should be > MD5):<br><br> //--------------------------------------------------------- > <br> // Password encryption > (or lack > thereof)<br> //---------------------------------------------------------<br><br> // > Set only one of the options below to > 1.<br><br> // Set to 1 if > the password column is encrypted > <br> // using the MySQL > password() > function.<br> $mysql_saslcrypt > = 0;<br><br> // Set to 1 if > the password column is > encrypted<br> // using the > UNIX crypt() > function.<br> $mysql_unixcrypt > = 0; > <br><br> // Set to 1 if the > password column is to use MD5 > encryption<br> $mysql_MD5crypt > = 1;<br><br> // Set both to > 0 if the password is stored in > the<br> // column in > plaintext.<br><br>Should do the trick. > <br><br>Stanley.<br><br><br><br>> > ------=_Part_7402_30647837.1135696405212<br>> Content-Type: text/plain; > charset=ISO-8859-1<br>> Content-Transfer-Encoding: > quoted-printable<br>> Content-Disposition: inline<br> > ><br>> Hi all,<br>><br>> Hi all,<br>><br>> > Is there any (official) plugin to change password for dbmail ? I > found<br>> one written by Matthew O'Connor but apparently it > was not listed on SM<br>> plugin page. > <br>><br>> <a > href="http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin";>http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin > </a><br>><br>> Furthermore, it is for postgreSQL only. How about > MySQL?<br>><br>> ------=_Part_7402_30647837.1135696405212<br>> > Content-Type: text/html; charset=ISO-8859-1<br>> > Content-Transfer-Encoding: quoted-printable > <br>> Content-Disposition: inline<br>><br>> Hi > all,<br><br><pre><font > color="#ff7733">Hi > all,</font><br><br><font<br>> > color="#ff7733"> Is there any (official) plugin to > change password for > <br>> dbmail ? I found</font><br><font > color="#ff7733"> one written by Matthew<br>> O'Connor but > apparently it was not listed on SM<br>> </font><br><font > color="#ff7733"> plugin > page.</font><br><br><font > <br>> color="#ff7733"> <a<br>> href="<a > href="http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin";>http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin > </a>"<br>> target="_blank"><a > href="http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin";>http://mailman.fastxs.net/pipermail/dbmail/attachments/20040810/03d47c5f/change_dbmail_pass-0001.bin > </a><br>> </a></font><br><br>Furthermore, it is > for postgreSQL only. How about<br>> MySQL? > <br><br><br></pre><br><br>><br>> > ------=_Part_7402_30647837.1135696405212-- > <br>><br>><br><br><br>_______________________________________________<br>Dbmail > mailing list<br><a > href="mailto:[email protected]";>[email protected]</a><br><a > href="https://mailman.fastxs.nl/mailman/listinfo/dbmail";> > https://mailman.fastxs.nl/mailman/listinfo/dbmail</a><br></blockquote></div><br> > > ------=_Part_14747_19566404.1135766140689-- > >
