Admin area- when clicking a link, redirected to login

All about webserver configurations, PHP and databases.

Moderator: Thorsten

Post Reply
pchaney
Posts: 4
Joined: Mon Aug 06, 2007 10:23 pm

Admin area- when clicking a link, redirected to login

Post by pchaney »

Hi,

I am new to PHP and this program. I am troubleshooting an issue for a new installation of phpmayFAQ 2.0.2

The symptoms:
I can view the user area and click links with no problem. In the admin backend, I log in and can see the admin menu. When I click a link, it redirects to the login screen. I suspect either a problem authenticating in MS SQL 2005 or my PHP.ini configuration. This is the only php app I have running. Well, sort of running...
Thanks in advance for any help you can provide.

Information:

System Information
phpMyFAQ Version phpMyFAQ 2.0.2
Server Software Microsoft-IIS/6.0
PHP Version PHP 5.2.3
Register Globals off
Safe Mode off
Open Basedir off
Database Server Mssql
Database Client Version Database Server Version Microsoft SQL Server 2005 - 9.00.2047.00 (X64) Apr 14 2006 01:11:53 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
Webserver Interface ISAPI
PHP Extensions bcmath, calendar, com_dotnet, ctype, session, filter, ftp, hash, iconv, json, odbc, pcre, Reflection, date, libxml, standard, tokenizer, zlib, SimpleXML, dom, SPL, wddx, xml, xmlreader, xmlwriter, ISAPI, gd, mbstring, mssql, exif, fdf, bcompiler, mailparse, smtp, PDO, pdo_mssql
NOTE: Art is resistance. Thank you very much for inspiration and everything else, L.


DEBUG INFORMATION:
PMF_Configuration->getAll() in line 87:
SELECT
config_name, config_value
FROM
faqconfig
PMF_AuthDb->checkLogin() in line 135:
SELECT
login
FROM
faquserlogin
WHERE
login = 'admin'

db_mssql->error() in line 323:
SELECT @@ERROR AS ErrorCode
PMF_AuthDb->checkPassword() in line 140:
SELECT
login,
pass
FROM
faquserlogin
WHERE
login = 'admin'

db_mssql->error() in line 248:
SELECT @@ERROR AS ErrorCode
PMF_User->getUserByLogin() in line 146:
SELECT
user_id,
login,
account_status
FROM
faquser
WHERE
login = 'admin'

PMF_UserData->load() in line 373:
SELECT
last_modified, display_name, email
FROM
faquserdata
WHERE
user_id = 1
PMF_CurrentUser->updateSessionId() in line 150:
UPDATE
faquser
SET
session_id = 'mtc0m7erehfojg3kgva1ck9nk3',
session_timestamp = 1186435619,
last_login = '20070806162659',
ip = '172.16.10.19'
WHERE
user_id = 1
PMF_CurrentUser->login() in line 89:
UPDATE
faquser
SET
auth_source = 'local'
WHERE
user_id = 1
PMF_PermBasic->getAllRightsData() in line 122:
SELECT
right_id,
name,
description,
for_users,
for_groups
FROM
faqright
ORDER BY
right_id ASC
PMF_PermBasic->getUserRights() in line 309:
SELECT
faqright.right_id AS right_id
FROM
faqright,
faquser_right,
faquser
WHERE
faqright.right_id = faquser_right.right_id AND
faquser.user_id = 1 AND
faquser.user_id = faquser_right.user_id

db_mssql->getTableStatus() in line 269:
SELECT
obj.name AS table_name,
idx.rows AS table_rows
FROM
sysobjects obj, sysindexes idx
WHERE
idx.id = OBJECT_ID(obj.name)
AND idx.indid < 2
AND obj.xtype = 'u'
ORDER BY obj.name
db_mssql->server_version() in line 350:
SELECT @@version AS SERVER_VERSION

COOKIES:
pmf_lang: en
pmf_sid: 3
ASP_NET_SessionId: wyvvuz450yptiwucyqwv5cie



TABLES & RECORDS:
faqadminlog: 0
faqcaptcha: 2
faqcategories: 0
faqcategory_group: 0
faqcategory_user: 0
faqcategoryrelations: 0
faqchanges: 0
faqcomments: 0
faqconfig: 33
faqdata: 0
faqdata_group: 0
faqdata_revisions: 0
faqdata_tags: 0
faqdata_user: 0
faqglossary: 0
faqgroup: 0
faqgroup_right: 0
faqlinkverifyrules: 0
faqnews: 0
faqquestions: 0
faqright: 29
faqsessions: 3
faqtags: 0
faquser: 2
faquser_group: 0
faquser_right: 29
faquserdata: 2
faquserlogin: 2
faqvisits: 0
faqvoting: 0
sysdiagrams: 0
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

do you see the errors above? Can you try to execute these queries by hand?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
pchaney
Posts: 4
Joined: Mon Aug 06, 2007 10:23 pm

Admin area- when clicking a link, redirected to login

Post by pchaney »

Hi Thorsten,
I executed the queries with errors in MS SQL 2005 Management Studio and the queries seemed to parse and execute okay.
thanks,
paul
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

okay, we'll check this issue.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
pchaney
Posts: 4
Joined: Mon Aug 06, 2007 10:23 pm

Admin area- when clicking a link, redirected to login

Post by pchaney »

Hi Thorsten,
One more thing, do you have a php.ini(v5.2.3) file for a MS Server 2003/IIS6 available that has worked with MS SQL 2005 ? The PHP pages are displaying, but I may have misconfigured something, and it may help for me to go through each line with a good php.ini to compare.
thanks,
paul
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

sorry, I don't have one.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
pchaney
Posts: 4
Joined: Mon Aug 06, 2007 10:23 pm

Admin area- when clicking a link, redirected to login

Post by pchaney »

After more testing, I notice I get different "pmf_auth_" numbers after clicking a link on the admin page. Is this the cause of my return to the log in screen?

Admin Login Page loaded:
COOKIES:
pmf_lang: en

Admin Page 1st load::
COOKIES:
pmf_lang: en
pmf_auth_: 1ttb1piddifqams7631jb1npo4

Admin Login page after clicking an admin link:
COOKIES:
pmf_lang: en
pmf_auth_: tvqj1j6a4hf3v5er90cvpndto2
greatmind
Posts: 1
Joined: Tue Mar 04, 2008 11:08 pm

Facing exactly the same problem

Post by greatmind »

I just installed 2.0.6 on windows 2003 with php 5.2.5 and mysql 5.1 and the problem is exactly the same as explained above by pchaney. please help.
rasta1
Posts: 2
Joined: Wed Mar 12, 2008 11:00 pm

Check your browser

Post by rasta1 »

Hi there,

... i had the same problems like many other users, when clicking on a link in the admin area -> redirecting to the login page.

Some time ago i´ve had session-problems with another application when using IExplorer ...
Mozilla-based browsers can login and act like admins ;)

I hope this could help someone!
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

Mozilla works for you, IE not?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
rasta1
Posts: 2
Joined: Wed Mar 12, 2008 11:00 pm

Mozilla does it

Post by rasta1 »

Hi Thorsten,

yo, ohne den Explorer ist alles fein.

>> yes, when using Mozilla the problem disappears.


Mir hat es jedenfalls geholfen (Kunden hinter Firewall ebenfalls).

Gruß
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

okay... dann habe ich eine Idee... Danke!

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Post Reply