Recover ListMail Admin Password

[DW]

Your password is stored in your ListMail MySQL database in the "admpw" field of the "lm_config" table.  The value can be viewed with PhpMyAdmin, commonly available from your hosting control panel, or by using a custom PHP script, below:

Copy the following code into a new file, such as "recover_pw.php".  Upload the file to your main ListMail directory and browse to it.

Code: [Select]

<php>0){
list($pw)=mysql_fetch_row($row);
echo "  your password is <b>$pw</b><br>";
} else {
echo "<b>  could not read config!</b><br>";
}


?>

[lewis.wolk]

Thanks Dean.
Your a lifesaver
Lewis

oops I get the following error.
retrieving password.. your password is

However if I try and login with no password it tells me the password is wrong.

[DW]

Sorry, this is undocumented... A blank password means the password will be "install".

Regards

[drostlelistmail]

I though I knew my password, but I have either forgotten or something else is going on. When I try to login I either get a blank page or the bad password page. I tried uploading the recover_pw.php but got the following message when browsed...

<?php
// show admin password from ListMail
$listmail_dir = ".";
include($listmail_dir."/config.php");
include($listmail_dir."/admin.php");

$link = mysql_connect($sqlhost, $sqluser, $sqlpass) or die("Can't connect to MySQL");
mysql_selectdb($sqldb) or die("Can't select database, does it exist?");

echo "retrieving password.. ";

$row = mysql_query("select admpw from $ctable where 1");
if(mysql_num_rows($row)>0){
list($pw)=mysql_fetch_row($row);
echo " your password is <b>$pw</b><br>";
} else {
echo "<b> could not read config!</b><br>";
}


?>

[DW]

The PHP code itself should definitely not be displayed when you browse to the php file.  (Could there be a space or something at the end of the filename?)  I suspect this is a temporary we hosting problem.  If it persists please contact your web host to have them look into it.

Regards