Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

What login and password should I enter after installation? #13

Open
it19862 opened this Issue Apr 11, 2018 · 24 comments

Comments

Projects
None yet
5 participants
@it19862
Copy link

commented Apr 11, 2018

Somewhere it was written that "admin" "passwd".
But it does not work
3147

What login and password should I enter after installation?

@teodorg

This comment has been minimized.

Copy link
Contributor

commented Apr 17, 2018

Hello, the default admin username and password are these, mentioned by you.
Do you have write access to the SQL database? If so, try to overwrite the password field and try again.

The relevant table is "users" (could be dotp_users), the field is "user_password" and it should be MD5 hashed.

something like this:

UPDATE users SET user_password=MD5("passwd");

@it19862

This comment has been minimized.

Copy link
Author

commented Apr 27, 2018

@teodorg
I have already tried several options.

In MySql, in the table "dotp_users" I put my data.
Does not work...

I do not remember which login and password I entered when I installed "dotproject".

In MySQL, the original login and password was
login = "admin"
pass = "76a2173be6393254e72ffa4d6df1030a"
But I do not remember exactly.

How can I recover my login and password?
I have full access.
3170

@teodorg

This comment has been minimized.

Copy link
Contributor

commented Apr 27, 2018

@it19862

This comment has been minimized.

Copy link
Author

commented Apr 28, 2018

@teodorg
I did so.
Correctly?

Does not work
3179

@teodorg

This comment has been minimized.

Copy link
Contributor

commented Apr 28, 2018

Ouf, contact me on private, if you want. I will login and solve it for you.

@it19862

This comment has been minimized.

Copy link
Author

commented Apr 28, 2018

@teodorg
How to do it?
I need to contact you by email?

@teodorg

This comment has been minimized.

Copy link
Contributor

commented Apr 28, 2018

tgeorgiev at stonard dot eu

@it19862

This comment has been minimized.

Copy link
Author

commented Apr 29, 2018

@teodorg
Sorry, but I did not understand what your message means.

Could you write more in detail what is required of me to get help from you.

Thank you.

@xSmorpheusSx

This comment has been minimized.

Copy link

commented Sep 5, 2018

I have a similar problem but I am definitely sure that username and password are correct. After complete install of dotproject, I reach the login view, type in the default username "admin" and "passwd" but login seems to fail. After clicking on "Login" the application shows the login page again without any information if anything went wrong. I looked at the user table and checked the md5 encoded default password "passwd". The password matches the encoded String "passwd" so it seems to be correct. Does anybody know why login fails despite valid login information?

@teodorg

This comment has been minimized.

Copy link
Contributor

commented Sep 5, 2018

@xSmorpheusSx

This comment has been minimized.

Copy link

commented Sep 5, 2018

What do you mean with provide me with access? You mean some remote sesssion? I can provide you my system information. Trying to install "dotproject" on XAMPP 3.3.2 with MySql, Apache 2.4.29, Tomcat 7.0.56 and PHP Version 7.1.12. There are no dotproject mods installed.

@renatorroliveira

This comment has been minimized.

Copy link

commented Oct 19, 2018

Any luck from anyone? Same problem here

@teodorg

This comment has been minimized.

Copy link
Contributor

commented Oct 20, 2018

Guys, I played several times with 2.1.9. The install procedure goes smoothly and I login in without any troubles.
Platform: Linux, Centos 6 and 7 , Apache 2.2, MySQL 5.1, PHP 5.3. If someone needs a helping hand in installing - just do let me know. I would gladly do it in 10min for you.

@renatorroliveira

This comment has been minimized.

Copy link

commented Oct 22, 2018

I see, my system is running PHP 5.6 and MySQL 5.5, this can be an issue?

@ajdonnison

This comment has been minimized.

Copy link
Contributor

commented Nov 5, 2018

It should also work with PHP 5.6 and MySQL 5.5. It will work with Apache and also with Nginx using php-fpm. If you get into trouble with the login look for any errors in your system log files, and report them here. Also read above for how to check the database.

@ghost

This comment has been minimized.

Copy link

commented Nov 5, 2018

There's something wrong when updating an existing installation. I was coming from 2.1.6 and no user could get in. I could see that the user roles were gone, so all users were set Inactive. In order to make them active you need to assign them a role. Apart from that, I also lost some other information like cost code. I can't be sure if there's something else, too. I had to revert back to 2.1.6 and restore user roles. I wanted to try 2.1.9 to see which improvements it has, but I can't. That's a shame.

@teodorg

This comment has been minimized.

Copy link
Contributor

commented Nov 5, 2018

I would suggest that you suppress the anger inside you and see how we can dig into that problem and solve it together?

@ghost

This comment has been minimized.

Copy link

commented Nov 5, 2018

I would suggest that you suppress the anger inside you and see how we can dig into that problem and solve it together?

Dear @teodorg, I was trying to give some insight. I'm no programmer, so I'm sorry for giving limited information. But there was no anger in my words, only the aim to provide some info. I'm so grateful to the developers.

@ajdonnison

This comment has been minimized.

Copy link
Contributor

commented Nov 5, 2018

@lgarmendia76 can you give us a bit more information? Things like:

  • What operating system
  • What version of PHP
  • What version of MySQL
  • Nginx or Apache and version
  • Any errors or messages that showed up during the upgrade
  • How did you perform the upgrade?
    That would make it a lot easier to provide assistance.
@ghost

This comment has been minimized.

Copy link

commented Nov 6, 2018

  • Windows Server 2008 R2
  • Based on Bitnami Wamp stack 5.4.17.0:
    • PHP 5.4.0
    • MySQL 5.0.10
    • Apache 2.4.0
  • I tried several installations. First from my remote computer:
    • A clean install creating a new DB. Had some problems creating the DB.
    • Then I tried and upgrade by duplicating the current installation folder and updating the files over it. Again, had problems managing the DB, it wouldn't connect to it.
      Then, from the server itsefl (remote connection):
    • I could manage to upgrade the duplicated folder and I got in with admin user. That's the moment when user roles were gone.
@ajdonnison

This comment has been minimized.

Copy link
Contributor

commented Nov 6, 2018

@lgarmendia76 I've moved this to a new issue as it is not the same as the original and is therefore likely to confuse - let's follow this up on the new issue (#31 )

@ghost

This comment has been minimized.

Copy link

commented Nov 6, 2018

I'm not that sure about it. Can you try to get into mySQL and check the admin's status? If it's "inactive", then it can be all related.

@ajdonnison

This comment has been minimized.

Copy link
Contributor

commented Nov 6, 2018

@lgarmendia76 it is not the same issue - the oiriginal issue was about login and password for a new installation - your issue is about updating an existing installation - and has nothing to do with login and password - please don't hijack other threads.

@ajdonnison

This comment has been minimized.

Copy link
Contributor

commented Nov 27, 2018

By default the admin user is admin with a password of passwd . If you didn't see any errors on the database build page then it should work. If it doesn't, and doesn't show an error on the login page then check your web server error log for clues.

There was a known issue with 2.1.9 and certain versions of MariaDB (which is often installed as MySQL on Linux distros). It may also be a problem with other databases. However, that would usually result in error messages in the install phase when it builds the database. Either way it is probably a good idea to try with the devel branch and see if that works:

https://github.com/dotproject/dotProject/archive/devel.zip

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.