myDBR Forums » Installation

Not able to login after initial setup

(25 posts) (4 voices)

  1. aescripts, Member

    Followed all the setup instruction up to the 'Welcome to the myDBR'-screen, entered all my database information but when I get to the login screen and try the default dba/dba it says: Login error Check the username/password

    Any ideas?

    Thanks

  2. myDBR Team, Key Master

    Are you upgrading from a previous version or are you doing a fresh install?

    The upgrade procedure will add the dba / dba account only if no previous admin account exists. Purpose of this is to preserve user's setup (database initialization can be always repeated).

    You can check the existing logins directly from the database by issuing following SQL command in your reporting database (mydbr by default):

    select user, password from mydbr_userlogin

    The password field contains an md5 hash of the password. If you lose the admin password, you can simply reset it from here by updating the password field with md5('password').

    Hope this helps,
    --
    myDBR Team

  3. aescripts, Member

    Hi,

    Thanks for the quick reply. This is a fresh install not an upgrade.

    Thanks,

    Lloyd

  4. aescripts, Member

    Figured it out. It was a permissions problem on the myDBR folder. Working now. Thanks.

  5. aescripts, Member

    Actually, it seems it is only half working. Is there a guide to what exactly the permissions should be within the myDBR folder?

  6. aescripts, Member

    Ok, got things working by setting everything to 775. Is that too risky?

    Thanks

  7. myDBR Team, Key Master

    775 allows local users to read your setup, including the login credentials. You will be safer if you just limit the access to your web server. Change the ownership of the application files to web server username and deny access from others.

    Following example uses 'apache' as web server username:

    $ cd /var/www/html/mydbr $ sudo chown -R apache:apache * . $ sudo chmod -R go-r * $ sudo chmod -R u+w *

  8. aescripts, Member

    Unfortunately due to my hosting setup I am not able to change ownership but i control all the local users so limiting to local users is ok.

  9. epeschard, Member

    I am also getting the error: : Login error Check the username/password.
    After checkin at PHPmyAdmin for mydbr_userlogin I tried the name and password values there without success. I edited both, tried again and nothing... I tried chmoding the myDBR folder but only 755 works, all other values return error 400 in the browser.

    Could you please help?
    Thanks

  10. myDBR Team, Key Master

    Couple of questions would help to solve the problem.

    - Are you upgrading from a previous version or are you doing a fresh install?
    - What is the exact content you have in the mydbr_userlogin-table after the editing?
    - What is the environment you are using myDBR in?

    --
    myDBR Team

  11. epeschard, Member

    My apologies for not replying earlier. The problem is solved now.
    - It was a fresh install
    - I was attempting to replace the mashed passwords without success, so I relogged with dba/dba user, deleted the user in question and created it again.
    - I am using myDBR on a server with Linux OS, MySQL v5.0.85-community server & PHP v5.2.9

  12. kin6slay3r, Member

    I seem to be having this issue also. This is a fresh install of 1.4.3, running under Windows 2003 Server Enterprise, MySQL 5.1.33, Apache 2.2.11, and PHP 5.2.9. All of which were installed useing XAMPP. I have given 755 to the dir /mydbr for 'local service' (apache username) and have attempted to recreate the dbr password as suggested above. What I am currently seeing is when I attempt to login, I get redirected back to the login screen no matter the creds. I have also attempted to create a new user without login success.

    Any help would be greatly appreciated.

    thanks,

    -Ryan

  13. myDBR Team, Key Master

    Ryan,
    could you re-check the file permissions. Not only for the /mydbr -directory, but also the all subdirectories. Sounds like the web-server is not able to read necessary files. You could also check the Apache error log for any errors.

    --
    myDBR Team

  14. kin6slay3r, Member

    It looks like I am missing a folder.

    Mon Dec 07 11:06:45 2009] [error] [client xxx.xxx.xxx.xxx] File does not exist: /mydbr/user/userstyle, referer: /mydbr/redirector.php

    Any suggestings? I have already attempted to create this folder with full needed permissions. Still no luck.

    Just FYI there are no Calls to outside folders that would look to cause an issue.

  15. myDBR Team, Key Master

    It should actually be a reference to a userstyle.css. It is mistakenly referred without the css-extension in login-screen. This will not however cause the login to fail, the style is simply not used.

    If your problem still remains, please check the file permissions and that your installation can create a sessions. Those are the most likely reasons for your login to fail.

    myDBR will notify you if you have entered false username/password. If you do not get any notification and the application simply returns to login screen, you are most likely having a permission problem in any of the subdirectories.

    --
    myDBR Team

  16. kin6slay3r, Member

    Is there a log somewhere that could suggest what file/folder this issue is related to? I have gone through each directory and made sure the correct permissions exist. I have even went as far as running apache under a full access admin account and then gave folder permissions to that user. Still getting the same return to login (redirector.php) page.

    Apache logs show nothing..

  17. myDBR Team, Key Master

    We've seen similar behavior in cases where web-server is not able to create sessions. Please make sure that your web server can create sessions (myDBR does check this, but there might be a configuration error it is not able to catch).

    You could check your PHP error handling and logging. To see all errors set the error level to E_ALL and restart the web-server:

    error_reporting = E_ALL

    --
    myDBR Team

  18. kin6slay3r, Member

    Yea I had already attempted E_ALL to check for a more comprehensive idea on whats causing my issue. Any other ideas?

  19. kin6slay3r, Member

    Also I dont have any issue with creating a session. I have many other login apps running that GET and POST data without issue.

    - - [07/Dec/2009:16:32:57 -0500] "GET /it%20material/mydbr/redirector.php HTTP/1.1" 200 4083
    - - [07/Dec/2009:16:32:57 -0500] "GET /it%20material/mydbr/user/userstyle HTTP/1.1" 301 388
    - - [07/Dec/2009:16:33:06 -0500] "POST /it%20material/mydbr/index.php HTTP/1.1" 302 -
    - - [07/Dec/2009:16:33:06 -0500] "GET /it%20material/mydbr/redirector.php HTTP/1.1" 200 4083
    - - [07/Dec/2009:16:33:06 -0500] "GET /it%20material/mydbr/user/userstyle HTTP/1.1" 301 388
    - - [07/Dec/2009:16:33:09 -0500] "POST /it%20material/mydbr/index.php HTTP/1.1" 302 -
    - - [07/Dec/2009:16:33:09 -0500] "GET /it%20material/mydbr/redirector.php HTTP/1.1" 200 4083
    - - [07/Dec/2009:16:33:09 -0500] "GET /it%20material/mydbr/user/userstyle HTTP/1.1" 301 388

  20. myDBR Team, Key Master

    Do you have any special Apache configurations in place that might cause the issue? Any redirects?

    As an example here is an Apache log when loading the login-screen directly from the web-root:

    [08/Dec/2009:13:06:20 +0200] "GET /mydbr HTTP/1.1" 301 231
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/ HTTP/1.1" 302 -
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/redirector.php HTTP/1.1" 200 4210
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/interface/style.css HTTP/1.1" 200 16146
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/interface/pager.css HTTP/1.1" 200 823
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/user/userstyle HTTP/1.1" 404 218
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/lib/external/prototype/prototype.js HTTP/1.1" 200 139854
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/lib/javascript/login.js HTTP/1.1" 200 482
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/lib/javascript/flash.js HTTP/1.1" 200 539
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/interface/normal.css HTTP/1.1" 200 803
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/interface/themes/blue.css HTTP/1.1" 200 1934
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/lib/external/scriptaculous/js/scriptaculous.js HTTP/1.1" 200 2698
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/lib/javascript/common.js HTTP/1.1" 200 361
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/lib/external/md5/md5.js HTTP/1.1" 200 8570
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/lib/external/scriptaculous/js/sound.js HTTP/1.1" 200 1906
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/lib/external/scriptaculous/js/effects.js HTTP/1.1" 200 38745
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/lib/external/scriptaculous/js/slider.js HTTP/1.1" 200 10194
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/lib/external/scriptaculous/js/dragdrop.js HTTP/1.1" 200 31174
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/lib/external/scriptaculous/js/builder.js HTTP/1.1" 200 4744
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/lib/external/scriptaculous/js/controls.js HTTP/1.1" 200 34787
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/interface/themes/blue/bluebg.jpg HTTP/1.1" 200 360
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/interface/images/grayBackground.gif HTTP/1.1" 200 1044
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/images/apppic_small.jpg HTTP/1.1" 200 3046
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/interface/images/graySliding.gif HTTP/1.1" 200 1987
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/images/logo_txt.png HTTP/1.1" 200 908
    [08/Dec/2009:13:06:20 +0200] "GET /mydbr/images/mydbr_fav.png HTTP/1.1" 200 1131

    --
    myDBR Team

  21. kin6slay3r, Member

    Here is what I have for a complete log of attempting to login. My Apache setup is pretty generic. Typically what settings that come fixed within the XAMPP build is what I have, outside of the usual directory root settings. Still looking though, but definately no redirecting.

    ____________________________________________________________________________________

    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/redirector.php HTTP/1.1" 200 4083
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/interface/style.css HTTP/1.1" 304 -
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/interface/themes/blue.css HTTP/1.1" 304 -
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/lib/javascript/common.js HTTP/1.1" 304 -
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/interface/pager.css HTTP/1.1" 304 -
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/user/userstyle HTTP/1.1" 301 388
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/interface/normal.css HTTP/1.1" 304 -
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/user/userstyle/ HTTP/1.1" 200 678
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/lib/external/prototype/prototype.js HTTP/1.1" 304 -
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/lib/external/scriptaculous/js/scriptaculous.js HTTP/1.1" 304 -
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/lib/javascript/login.js HTTP/1.1" 304 -
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/lib/javascript/flash.js HTTP/1.1" 304 -
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/lib/external/md5/md5.js HTTP/1.1" 304 -
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/interface/ie.css HTTP/1.1" 304 -
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/lib/external/scriptaculous/js/builder.js HTTP/1.1" 304 -
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/lib/external/scriptaculous/js/effects.js HTTP/1.1" 304 -
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/lib/external/scriptaculous/js/dragdrop.js HTTP/1.1" 304 -
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/lib/external/scriptaculous/js/controls.js HTTP/1.1" 304 -
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/lib/external/scriptaculous/js/slider.js HTTP/1.1" 304 -
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/lib/external/scriptaculous/js/sound.js HTTP/1.1" 304 -
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/interface/ie7orless.css HTTP/1.1" 304 -
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/images/logo_txt.png HTTP/1.1" 304 -
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/interface/themes/blue/bluebg.jpg HTTP/1.1" 304 -
    - - [08/Dec/2009:08:27:46 -0500] "GET /it%20material/mydbr/images/apppic_small.jpg HTTP/1.1" 304 -
    - - [08/Dec/2009:08:27:50 -0500] "POST /it%20material/mydbr/index.php HTTP/1.1" 302 -
    - - [08/Dec/2009:08:27:50 -0500] "GET /it%20material/mydbr/redirector.php HTTP/1.1" 200 4083
    - - [08/Dec/2009:08:27:50 -0500] "GET /it%20material/mydbr/user/userstyle HTTP/1.1" 301 388
    - - [08/Dec/2009:08:27:53 -0500] "POST /it%20material/mydbr/index.php HTTP/1.1" 302 -
    - - [08/Dec/2009:08:27:53 -0500] "GET /it%20material/mydbr/redirector.php HTTP/1.1" 200 4083
    - - [08/Dec/2009:08:27:53 -0500] "GET /it%20material/mydbr/user/userstyle HTTP/1.1" 301 388

  22. myDBR Team, Key Master

    OK.
    Few questions while trying to find out the reason:

    • What version are you using? Point your cursor to the upper left myDBR logo to see the version.
    • How did you do the installation? Did you use the included wizard?
    • Any problems during the install process?
    • What database username are you using in mydbr_config.php?
    • When you enter the username/password and press login, is any error messages show?
    • What is the content of mydbr_userlogin-table?

    --
    myDBR Team

  23. kin6slay3r, Member

    ◦What version are you using? Point your cursor to the upper left myDBR logo to see the version.
    -1.4.3 (Build 414)

    ◦How did you do the installation? Did you use the included wizard?
    -Uploaded 'mydbr' folder to server via Filezilla -Binary mode. Ran wizard via weburl ../mydbr

    ◦Any problems during the install process?
    -No problems, install was seamless.

    ◦What database username are you using in mydbr_config.php?
    -<?php
    // myDBR configuration file. Created: 2009-12-07 11:00:21
    define( "DB_VENDOR", 'mysql' );
    define( "DB_HOST", 'localhost' );
    define( "DB_PORT", 3306 );
    define( "DB_NAME", 'mydbr' );
    define( "DB_USER", 'mydbr' );
    define( "DB_PASSWORD", 'xxxxxxx' );
    define( "SETUP_DONE", true );

    ◦When you enter the username/password and press login, is any error messages show?
    -No errors, it simply flashes and returns back to the original redirector.php
    ◦What is the content of mydbr_userlogin-table?
    INSERT INTO mydbr_userlogin (user, password, name, admin, passworddate, email)VALUES
    ('admin', 'xxxxxxxxxxxxxxx', 'administrator', 1, '2009-12-07 11:02:19', 'xxxxxxxx'),
    ('dbr', 'xxxxxxxxxxxxxxx', 'admin', 1, NULL, NULL);

  24. myDBR Team, Key Master

    Everything seems to be ok there. We'll contact you directly for more info.

    --
    myDBR Team

  25. myDBR Team, Key Master

    FYI,
    problem was caused by the space in the URL. The URL is stored in the cookie causing certain browsers (IE, Firefox) to not able to handle the situation. Fix will be included in the upcoming 1.4.5 release.

    --
    myDBR Team


Reply

You must log in to post.