Admin area- when clicking a link, redirected to login
Posted: Mon Aug 06, 2007 10:41 pm
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
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
