Project

General

Profile

Forums » Help »

Help I need a way to get into Redmine when LDAP server is down

Added by Michael Lincoln about 13 years ago

I have become system admin for our redmine install running on a ubunta machine.
It was pretty unstable when I got it. I have figured it out and redmine is running and serving pages just fine. The remaining issue is that users can not log into the projects.

This is becasue all the users are set to LDAP authentification and the LDAP server is not aval anymore. If I could get a user logged in that has privaleges I know how to set back to local from inside redmine, but none of the users can log in.

Is there a way to set a user to local authentification from outside of redmine.


Replies (5)

RE: Help I need a way to get into Redmine when LDAP server is down - Added by Michael Lincoln about 13 years ago

Yes I believe that I do, I have admin on the machine and it is on my desk :-)
I did hunt around and could not seem to "find" the database file. However I am new to this sort of thing and redmine is up and showing webpages.

RE: Help I need a way to get into Redmine when LDAP server is down - Added by Felix Schäfer about 13 years ago

Well, depending on the database there is no file per se. The Redmine configuration file that tells it what DB to use is either in config/database.yml or somewhere in /etc/redmine, depending on whether it's been installed from source or from the ubuntu package. When you've find which DB it uses, connect to the DB, look in the table users, there should be a user with the login admin, change the hashed_password to d033e22ae348aeb5660fc2140aec35850c4da997, that should reset the password of the user admin to admin.

RE: Help I need a way to get into Redmine when LDAP server is down - Added by Michael Lincoln about 13 years ago

OK I am sorry for being dumb.
How do I connect to the database if I can not find the "file"
I have the database.yml file but what it says is

"database: redmine"

How do I turn this into knowing how to connect to the DB with out using redmine?

RE: Help I need a way to get into Redmine when LDAP server is down - Added by Felix Schäfer about 13 years ago

That's the name of the database, but that's not all the information you need.

You should have a whole section under a production: heading in there, that tells you which database adapter is in use, what server it is on, what the DB name is, what user and password Redmine uses to connect to it. With all that, you should be able to connect to the DB and make the change I suggested earlier.

It seems to me that you have little to no knowledge of system administration, thus I'd strongly suggest you invest the time read a little at least about the bits we've discussed so that you understand what you are doing instead of just blindly applying what you are told. The level of detail into which I went in my explanation, for example, is above what I usually do, and I won't give you any more advice on things I consider are basic and essential knowledge when dealing with those topics. If you're blocked at a specific point and have a specific question though, feel free to ask and I'll gladly help.

    (1-5/5)