username and password not working can't log in as admin

[4css]

For some odd reason I can't seem to log into my directory. I have checked in phpmyadmin and the pw and un I am using are correct. I just can't get logged into the account.

Any help would be greatly appreciated, I have not changed anything since the install as I have been too busy to get into it. I figured last night I would go in and add links and do a few things to it, but am not able to get into it.

Thanks in advance

[4css]

I figured it out, for some reason even though I thought my un was cssaddict, it is admin. The pw I have set works. I'm not sure why I can't seem to get the un changed to a different one. If anyone can explain to me how to change it from admin i woud appreciate it. Thanks in advance

[Dave Baker]

Hello 4css,
Try via phpMyAdmin Insert new row in the table yourPrefix_admins.
With the following values of fields:
username: admin00
password: a5a30bc4c47888cd59c4e9df68d80242

After that try to use:
Admin username: admin00
Admin password: admin00

[Dave Baker]

Maybe it can help you too in creation of the new admin
http://www.esyndicat.com/forum/showthread.php?t=6066&highlight=change+password

[4css]

Hi Dave,
Actually, my web host went in and changed it for me :yahoo: I love my host, they are terrific and are always there to help me out with stuff!

Once again, thank you for your help and your reply!

[Dave Baker]

You're welcome!

[Miles Kushin]

We're having this same issue with our esyndicat directory. The admin username and password does not work anymore. Nothing was changed in the admin area, and I have tried the above suggestions.

What else could cause this? We are using the free version.

Thanks!

[Sergey Ten]

Welcome to our support forum Miles Kushin,

You could use this script for reset or set up new admin username and password.


<?

include_once "classes/DirDb.php";
include_once "includes/config.inc.php";

$myDb = new Database();
$myDb->mDbhost = $gDirConfig["dbhost"];
$myDb->mDbuser = $gDirConfig["dbuser"];
$myDb->mDbpwd = $gDirConfig["dbpwd"];
$myDb->mDbname = $gDirConfig["dbname"];
$myDb->mPrefix = $gDirConfig["prefix"];

$myDb->connect();

$admin_name = "admin";
$admin_pass = md5("admin");

$query = "UPDATE `{$gDirConfig['prefix']}admins` SET `username` ='{$admin_name}' WHERE `id`='1'";

if(!$myDb->query($query))
{
echo "Error!!";
}

$query = "UPDATE `{$gDirConfig['prefix']}admins` SET `password` ='{$admin_pass}' WHERE `id`='1'";

if(!$myDb->query($query))
{
echo "Error!!";
}

?>


You could change this code:


$admin_name = "admin";
$admin_pass = md5("admin");


Create php file and run it on your server.

[Miles Kushin]

Thanks for the suggestion Sergey... That didn't work unfortunately.

[Miles Kushin]

I get this error:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'leetimag'@'localhost' (using password: NO) in /home/leetimag/public_html/motorme/yellowpages/classes/DirDb.php on line 40
Could not connect: Access denied for user 'leetimag'@'localhost' (using password: NO)Could not connect: Access denied for user 'leetimag'@'localhost' (using password: NO)

I know for a fact that I'm using the correct username and pw, etc.

[Sergey Ten]

Miles Kushin,

Please send me your FTP credentials and I will try fix your problem.

sten@esyndicat.com

[Miles Kushin]

Ok, I just emailed you with the info. Thank you!

[hollis3]

Hello Sergey,

If it helps we (Miles and I) just bought the full version. It will be installed on a different server. So if it will be fixed with moving, you can save some time.

Thanks.

[nemesis]

I did try this fix and this is what I get:
------------------------------------
Warning: main(classes/DirDb.php) [function.main]: failed to open stream: No such file or directory in /home/avenidac/public_html/passRECOVER.php on line 3

Warning: main() [function.include]: Failed opening 'classes/DirDb.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/avenidac/public_html/passRECOVER.php on line 3

on the Pro version latest release
still does not work to recover the login/password

[Sergey Ten]

Hello all,

First of all check up which version use you. I posted a scripts for adding new admin to database.

[ FOR PRO 2.0 ]


<?php

include_once "classes/DirDb.php";
include_once "includes/config.inc.php";

$myDb = new Database();
$myDb->mDbhost = $gDirConfig["dbhost"];
$myDb->mDbuser = $gDirConfig["dbuser"];
$myDb->mDbpwd = $gDirConfig["dbpwd"];
$myDb->mDbname = $gDirConfig["dbname"];
$myDb->mPrefix = $gDirConfig["prefix"];

$myDb->connect();

$admin_name = "escadmin";
$admin_pass = md5("escadmin");

$sql = "INSERT INTO `{$gDirConfig['prefix']}admins` ";
$sql .= "(`username`, `password`) VALUES ";
$sql .= "('{$admin_name}', '{$admin_pass}')";

if(!$myDb->query($sql))
{
echo "Error!!";
}
?>



[ FOR PRO 2.1 ]


<?php

include('includes'.DIRECTORY_SEPARATOR.'config.inc .php');

loadClass('DirDb');
loadClass('Dir');

$gDirDb = &new eSyndicat(DBHOST,DBUSER,DBPASS,DBNAME,PREFIX,DBPOR T);

$insert['username'] = "escadmin";
$insert['password'] = md5("escadmin");

$gDirDb->setTable("admins");
$gDirDb->insert($insert);
$gDirDb->resetTable();

?>