Login Problem

[mcarr]

Hello,

Per the instructions, the initial login to LetoDMS is username admin password admin. It does not work.

In phpmyadmin, the username was admin. I believe that the password was masked with md5. I reset the password to admin. It did not fix the problem. I created a new user in phpmyadmin but that did not work. I cannot enter the program. Hopefully, someone can come up with a solution for me.

[administrator]

hi

which version do you have?

and which version of php and mysql do you have ?

and please post your setting file

thanks

LD

[mcarr]

hi

which version do you have?

and which version of php and mysql do you have ?

and please post your setting file

thanks

LD

I have version 2.0
PHP and mysql are the latest. PHP is v5 and mysql is 5.1.

Settings file is:

class Settings

{

// Name of site -- used in the page titles. Default: MyDMS

var $_siteName = "letoDMS";



// Message to display at the bottom of every page.

var $_footNote = "letoDMS free document management system - www.letodms.com";



// if true the disclaimer message the lang.inc files will be print on the bottom of the page

var $_printDisclaimer = true;



// Default page on login. Defaults to out/out.ViewFolder.php

var $_siteDefaultPage = "";



// IDs of admin-user, guest-user and root-folder (no need to change)

var $_adminID = 1;

var $_guestID = 2;

var $_rootFolderID = 1;



// If you want anybody to login as guest, set the following line to true

// note: guest login should be used only in a trusted environment

var $_enableGuestLogin = false;



// Restricted access: only allow users to log in if they have an entry in

// the local database (irrespective of successful authentication with LDAP).

var $_restricted = true;



// Strict form checking. If set to true, then all fields in the form will

// be checked for a value. If set to false, then (most) comments and

// keyword fields become optional. Comments are always required when

// submitting a review or overriding document status.

var $_strictFormCheck = false;



// path to where mydms is located

var $_rootDir = "/var/www/letoDMS-2.0/";



// The relative path in the URL, after the domain part. Do not include the

// http:// prefix or the web host name. e.g. If the full URL is

// http://www.example.com/mydms/, set $_httpRoot = "/mydms/".

// If the URL is http://www.example.com/, set $_httpRoot = "/".

var $_httpRoot = "/letoDMS-2.0/";



// Where the uploaded files are stored (best to choose a directory that

// is not accessible through your web-server)

var $_contentDir = "/var/www/letoDMS-2.0/data/";



// To work around limitations in the underlying file system, a new

// directory structure has been devised that exists within the content

// directory ($_contentDir). This requires a base directory from which

// to begin. Usually leave this to the default setting, 1048576, but can

// be any number or string that does not already exist within $_contentDir.

var $_contentOffsetDir = "1048576";



// Maximum number of sub-directories per parent directory. Default: 32700.

var $_maxDirID = 32700;



// default language (name of a subfolder in folder "languages")

var $_language = "English";



// users are notified about document-changes that took place within the last $_updateNotifyTime seconds

var $_updateNotifyTime = 86400; //means 24 hours



// files with one of the following endings can be viewed online (USE ONLY LOWER CASE CHARACTERS)

// to disable: var $_viewOnlineFileTypes = array();

var $_viewOnlineFileTypes = array(".txt", ".text", ".html", ".htm", ".pdf", ".gif", ".png", ".jpg", ".jpeg");



// enable/disable converting of files

var $_enableConverting = true;



// default style (name of a subfolder in folder "styles")

var $_theme = "clean";



// Workaround for page titles that go over more than 2 lines.

var $_titleDisplayHack = true;



// enable/disable automatic email notification

var $_enableEmail = true;



// enable/disable group and user view for all users

var $_enableUsersView = true;



// false to don't list administrator as reviewer/approver

var $_enableAdminRevApp = false;



// the name of the versioning info file created by the backup tool

var $_versioningFileName = "versioning_info.txt";



// set false to disable log system

var $_logFileEnable = true;



// the log file rotation (h=hourly, d=daily, m=monthly)

var $_logFileRotation = "d";



// enable users images

var $_enableUserImage = false;



// enable calendar

var $_enableCalendar = true;



// first day of the week (0=sunday, 6=saturday)

var $_firstDayOfWeek = 0;



// false to don't show the folder tree

var $_enableFolderTree = true;



// -------------------------------- Database-Setup --------------------------------------------



//Path to adodb

var $_ADOdbPath = "/var/www/letoDMS-2.0/adodb/";



//DB-Driver used by adodb (see adodb-readme)

var $_dbDriver = "mysql";



//DB-Server

var $_dbHostname = "localhost";



//database where the tables for mydms are stored (optional - see adodb-readme)

var $_dbDatabase = "letodms";



//username for database-access

var $_dbUser = "letodms";



//password for database-access

var $_dbPass = "letodms";



// -------------------------------- LDAP Authentication Setup --------------------------------------------



// var $_ldapHost = ""; // URIs are supported, e.g.: ldaps://ldap.host.com

// var $_ldapPort = 389; // Optional.

// var $_ldapBaseDN = "";



function Settings()

{

//files with one of the following endings will be converted with the given commands

//for windows users

$this->_convertFileTypes = array(".doc" => "cscript \"" . $this->_rootDir."op/convert_word.js\" {SOURCE} {TARGET}",

".xls" => "cscript \"".$this->_rootDir."op/convert_excel.js\" {SOURCE} {TARGET}",

".ppt" => "cscript \"".$this->_rootDir."op/convert_pp.js\" {SOURCE} {TARGET}");

// For linux users

// $this->_convertFileTypes = array(".doc" => "mswordview -o {TARGET} {SOURCE}");

}

}



I have also deleted the database using phpmyadmin and then recreated the database. Same result. I cannot login with admin admin.

Mike
$settings = new Settings();



?>

[mcarr]

Hello,

I have two installations of LetoDMS. At home is my test bed. So yesterday, I could not login with admin admin. Here at work, I installed LetoDMS and was able to login with admin admin. I got it setup so that the outside world could connect to the website. As soon as I got that configured, admin admin no longer worked. So now, I have the same problem at home and at work on two installations using the same application versions.

I would really like to get some assistance. How can I lose the ability to login with admin admin. I did not get a chance to change that.

Here are my settings:

class Settings

{

// Name of site -- used in the page titles. Default: MyDMS

var $_siteName = "letoDMS";



// Message to display at the bottom of every page.

var $_footNote = "letoDMS free document management system - www.letodms.com";



// if true the disclaimer message the lang.inc files will be print on the bottom of the page

var $_printDisclaimer = true;



// Default page on login. Defaults to out/out.ViewFolder.php

var $_siteDefaultPage = "";



// IDs of admin-user, guest-user and root-folder (no need to change)

var $_adminID = 1;

var $_guestID = 2;

var $_rootFolderID = 1;



// If you want anybody to login as guest, set the following line to true

// note: guest login should be used only in a trusted environment

var $_enableGuestLogin = false;



// Restricted access: only allow users to log in if they have an entry in

// the local database (irrespective of successful authentication with LDAP).

var $_restricted = true;



// Strict form checking. If set to true, then all fields in the form will

// be checked for a value. If set to false, then (most) comments and

// keyword fields become optional. Comments are always required when

// submitting a review or overriding document status.

var $_strictFormCheck = false;



// path to where mydms is located

var $_rootDir = "/var/www/letoDMS-2.0/";



// The relative path in the URL, after the domain part. Do not include the

// http:// prefix or the web host name. e.g. If the full URL is

// http://www.example.com/mydms/, set $_httpRoot = "/mydms/".

// If the URL is http://www.example.com/, set $_httpRoot = "/".

var $_httpRoot = "/letoDMS-2.0/";



// Where the uploaded files are stored (best to choose a directory that

// is not accessible through your web-server)

var $_contentDir = "/var/www/letoDMS-2.0/data/";



// To work around limitations in the underlying file system, a new

// directory structure has been devised that exists within the content

// directory ($_contentDir). This requires a base directory from which

// to begin. Usually leave this to the default setting, 1048576, but can

// be any number or string that does not already exist within $_contentDir.

var $_contentOffsetDir = "1048576";



// Maximum number of sub-directories per parent directory. Default: 32700.

var $_maxDirID = 32700;



// default language (name of a subfolder in folder "languages")

var $_language = "English";



// users are notified about document-changes that took place within the last $_updateNotifyTime seconds

var $_updateNotifyTime = 86400; //means 24 hours



// files with one of the following endings can be viewed online (USE ONLY LOWER CASE CHARACTERS)

// to disable: var $_viewOnlineFileTypes = array();

var $_viewOnlineFileTypes = array(".txt", ".text", ".html", ".htm", ".pdf", ".gif", ".png", ".jpg", ".jpeg");



// enable/disable converting of files

var $_enableConverting = true;



// default style (name of a subfolder in folder "styles")

var $_theme = "clean";



// Workaround for page titles that go over more than 2 lines.

var $_titleDisplayHack = true;



// enable/disable automatic email notification

var $_enableEmail = true;



// enable/disable group and user view for all users

var $_enableUsersView = true;



// false to don't list administrator as reviewer/approver

var $_enableAdminRevApp = false;



// the name of the versioning info file created by the backup tool

var $_versioningFileName = "versioning_info.txt";



// set false to disable log system

var $_logFileEnable = true;



// the log file rotation (h=hourly, d=daily, m=monthly)

var $_logFileRotation = "d";



// enable users images

var $_enableUserImage = false;



// enable calendar

var $_enableCalendar = true;



// first day of the week (0=sunday, 6=saturday)

var $_firstDayOfWeek = 0;



// false to don't show the folder tree

var $_enableFolderTree = true;



// -------------------------------- Database-Setup --------------------------------------------



//Path to adodb

var $_ADOdbPath = "/var/www/letoDMS-2.0/adodb/";



//DB-Driver used by adodb (see adodb-readme)

var $_dbDriver = "mysql";



//DB-Server

var $_dbHostname = "10.32.57.101";



//database where the tables for mydms are stored (optional - see adodb-readme)

var $_dbDatabase = "letodms";



//username for database-access

var $_dbUser = "letodms";



//password for database-access

var $_dbPass = "letodms";



// -------------------------------- LDAP Authentication Setup --------------------------------------------



// var $_ldapHost = ""; // URIs are supported, e.g.: ldaps://ldap.host.com

// var $_ldapPort = 389; // Optional.

// var $_ldapBaseDN = "";



function Settings()

{

//files with one of the following endings will be converted with the given commands

//for windows users

$this->_convertFileTypes = array(".doc" => "cscript \"" . $this->_rootDir."op/convert_word.js\" {SOURCE} {TARGET}",

".xls" => "cscript \"".$this->_rootDir."op/convert_excel.js\" {SOURCE} {TARGET}",

".ppt" => "cscript \"".$this->_rootDir."op/convert_pp.js\" {SOURCE} {TARGET}");

// For linux users

// $this->_convertFileTypes = array(".doc" => "mswordview -o {TARGET} {SOURCE}");

}

}



$settings = new Settings();



?>

Mike

[turkeburgr]

Verify that your MySQL user for LetoDMS is still valid and has the correct permissions on the database. And that you can query with that user. That's the first thing that comes to mind when you can't login. I'm not sure if anything would show up in the webserver logs regarding database connectivity issues.

[mcarr]

Verify that your MySQL user for LetoDMS is still valid and has the correct permissions on the database. And that you can query with that user. That's the first thing that comes to mind when you can't login. I'm not sure if anything would show up in the webserver logs regarding database connectivity issues.

I checked the error logs in Apache. This comes up repeatedly:

[Tue Sep 14 02:27:39 2010] [error] [client 127.0.0.1] PHP Warning: mysql_connect(): Access denied for user 'letodms'@'localhost' (using password: YES) in /var/www/letoDMS-2.0/adodb/drivers/adodb-mysql.inc.php on line 365, referer: http://localhost/letoDMS-2.0/op/op.Login.php

In several hours, I will check the logs on my other server at work to see if I have the error. I am sure I do.

Mike

[mcarr]

At work, the problem was that I was looping in the server (instead of using localhost, I had instead used the IP address of the server in inc.Settings.php.)

I can login with the no problem but still have an issue at home on my test box.

Mike

[turkeburgr]

That's what i suspected, I would assume the issue with your home instance is that the correct permissions are not set for the letodms user in MySQL or that the password is just wrong.

Try connecting to MySQL with that user and see if it works.

Code:

#> mysql -u letodms -p

If that works connect to MySQL as the root user and redo the grant privileges statements.

Code:

# mysql -u root -p
Enter Password:

mysql> grant all privileges on letodms.* to letodms@localhost

[mcarr]

That's what i suspected, I would assume the issue with your home instance is that the correct permissions are not set for the letodms user in MySQL or that the password is just wrong.

Try connecting to MySQL with that user and see if it works.

Code:

#> mysql -u letodms -p

If that works connect to MySQL as the root user and redo the grant privileges statements.

Code:

# mysql -u root -p
Enter Password:

mysql> grant all privileges on letodms.* to letodms@localhost

I was able to successfully connect with letodms. I connected as the root user and redid the grant privileges statement but I could not login as admin admin.

I get this error in the apache error log:
[error] [client 127.0.0.1] PHP Warning: mysql_connect(): Access denied for user 'letodms'@'localhost' (using password: YES) in /var/www/letoDMS-2.0/adodb/drivers/adodb-mysql.inc.php on line 365, referer: http://localhost/letoDMS-2.0/out/out.Login.php

------------------------

Just realized that I had to change the $_dbPass = "user password for database";

Once I did that, I was able to login as admin admin. It took me long enough to realize that!
Thanks for your help.

[turkeburgr]

No problem, its always the little things we overlook.