Admin area- when clicking a link, redirected to login
Moderator: Thorsten
Admin area- when clicking a link, redirected to login
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
Hi,
do you see the errors above? Can you try to execute these queries by hand?
bye
Thorsten
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
amazon.de Wishlist
Admin area- when clicking a link, redirected to login
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
I executed the queries with errors in MS SQL 2005 Management Studio and the queries seemed to parse and execute okay.
thanks,
paul
Hi,
okay, we'll check this issue.
bye
Thorsten
okay, we'll check this issue.
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Admin area- when clicking a link, redirected to login
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
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
Admin area- when clicking a link, redirected to login
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
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
Facing exactly the same problem
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.
Check your browser
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!
... 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!
Hi,
Mozilla works for you, IE not?
bye
Thorsten
Mozilla works for you, IE not?
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Mozilla does it
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ß
yo, ohne den Explorer ist alles fein.
>> yes, when using Mozilla the problem disappears.
Mir hat es jedenfalls geholfen (Kunden hinter Firewall ebenfalls).
Gruß
Hi,
okay... dann habe ich eine Idee... Danke!
bye
Thorsten
okay... dann habe ich eine Idee... Danke!
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist