Please describe the issue you're having
If you accept the answer, please mark the topic as [SOLVED] by clicking the tick.

Moderators: RussH, cptr13

Forum rules: Just please remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but respect our space and keep your comments directed to the topic at hand.
By tttwb
#2324
Hi,

This really is a great product with lots of features, looking forward to future updates.

I just installed the latest version for the first time on my server which is shared hosting.

The install went fine, no problems. At the end of the installation it says to log in with the username admin and the password admin if it is a fresh install.

However when I try to login with these details it does not work and simply refreshes the page to /?m=login&a=attemptLogin showing the error message "Invalid username or password."

I even went into phpmyadmin and can see that there is indeed a user with username admin and password admin, but for some reason I cannot login.

I also tried to install candidATS and the exact same thing happened there, installation went fine but I couldn't login with the default details.

I then used XAMPP with a local server on my pc and installed in the same way and it worked fine with the default login details given, so I can only assume something has gone wrong during the installation process on my server which is strange because there were no errors and the tables appear to have been created correctly in phpmyadmin.

Any help at all would be much appreciated.

Regards
By tttwb
#2326
manuel wrote:Hello and welcome.

Strange, never read that one before.

Is it an idea to make a user directly into the database?
Thanks for your reply, I have tried inserted a user directly into the database using phpmyadmin but this still gives the error "Invalid username or password."

I have even tried exported the sql database from the working local sever XAMPP site and then imported that into the database on the shared hosting server but it still will not login.

Perhaps it is not communicating properly with the database?
User avatar
By RussH
#2327
HI there,

okay can you tail your access.log and error.log logfiles for apache whilst you get denied (and post the output here?) You should be able to see if there's some permissions error returned by your shared host.
By tttwb
#2334
RussH wrote:HI there,

okay can you tail your access.log and error.log logfiles for apache whilst you get denied (and post the output here?) You should be able to see if there's some permissions error returned by your shared host.
Hi, not sure if this is the correct file, I struggled to find the access and error logs since I am on shared hosting (stablehost). I'll keep looking to see if I can find any other information. Not sure if the below will help at all.
Code: Select all
90.204.110.220 - - [06/Jul/2016:10:42:25 +0000] "POST /cats/index.php?m=login&a=attemptLogin HTTP/1.1" 301 262 "http://example.com/cats/?m=login&a=attemptLogin" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36"
90.204.110.220 - - [06/Jul/2016:10:42:25 +0000] "GET /cats?m=login&a=attemptLogin HTTP/1.1" 301 263 "http://example.com/cats/?m=login&a=attemptLogin" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36"
90.204.110.220 - - [06/Jul/2016:10:42:25 +0000] "GET /cats/?m=login&a=attemptLogin HTTP/1.1" 200 3853 "http://example.com/cats/?m=login&a=attemptLogin" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36"
90.204.110.220 - - [06/Jul/2016:10:42:35 +0000] "POST /cats/index.php?m=login&a=attemptLogin HTTP/1.1" 301 262 "http://example.com/cats/?m=login&a=attemptLogin" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36"
90.204.110.220 - - [06/Jul/2016:10:42:35 +0000] "GET /cats?m=login&a=attemptLogin HTTP/1.1" 301 263 "http://example.com/cats/?m=login&a=attemptLogin" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36"
90.204.110.220 - - [06/Jul/2016:10:42:35 +0000] "GET /cats/?m=login&a=attemptLogin HTTP/1.1" 200 3853 "http://example.com/cats/?m=login&a=attemptLogin" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36"
User avatar
By RussH
#2335
that looks like the access log, there will be a error.log alongside it - don't know where you see it in in a shared control panel though!
By tttwb
#2336
RussH wrote:that looks like the access log, there will be a error.log alongside it - don't know where you see it in in a shared control panel though!
Yes that is the access log, I've just had a look at the error log and it doesn't have any errors in it at all so nothing to go on.

It is strange that it is working on my local server with XAMPP but not in the shared hosting. I am using stablehost if that makes any difference.

I assume it must be the environment causing the issue, do you have any idea why it might not be recognising the user login details?

EDIT: I also have shared hosting with bluehost that is expiring soon and managed to install it there with no issues, it is working correctly, it did say at the start of the installation LDAP and SOAP extensions were not loaded even though they seem to be in php.ini but it still worked.

So it must be a problem with stablehost but I cannot think what it might be.
By tttwb
#2340
SOLUTION:

For anybody who is interested, there was a line in the website root .htaccess file that was causing this issue.

The line was:
Code: Select all
RewriteRule ^.*$ http://website.com%{REQUEST_URI} [R=301,L]
After removing this line opencats worked fine.

Thank you for your responses.
By Ilovecats
#2659
Im having the same issue...Just reinstalled OpenCats on a different computer to test the backup file, but i can't log in.

Where do i find this website root file and how do i open it?

Thanks in advance
By Ilovecats
#2661
Figured it out! For anyone interested...

Because i use the backup installation, i need to use the same user name and password as the backup file.
I kept creating new users and passwords with the new installation but the old user name and password worked.

It's essential to keep these synchronized to ensur[…]

Export part in Job Order order search

Same problem as mine. Maybe you're right, I'll che[…]

The error message you're encountering indicates th[…]

Errors restoring mysqldump backup

doesnot work for me