Frag Infinity Tournament, Inc. - FITES LAN Party - www.fites.net
LAN Party Forums => Support Group => Started by: .:F3ar0n:. on July 04, 2008, 01:38:51 PM
-
If anyone would happen to have a nice bookmark page regarding IIS webservers...could you please help me out. I am currently attempting to get a web server configured. I installed PHP and Mysql (which I'm also having issues getting php to recognize mysql...yes I uncommented the php_mysql in php.ini and I also moved the php_mysql to sys32 dir (even though I set the ext to C:\php\ext in my ini file as well). I read about setting system variables to the php dir but am not sure how to do so
Anywho...Everytime I attempt to access the web server though localhost I get a auth required. Now I know this should be Iuser_mycomopname but I have read permisions enabled. I also have the anonymous login allowed and set the login to the iuser account like in default. I just dont understand where I'm going wrong. I've uninstalled and reinstalled IIS services 3 times. I dont get why I'm having issues but It something to do with permissions. I ran the diagnostic amoung other things and now am working towards my 2nd day of troubleshooting this biatch
So any links you may come across regarding IIS permissions and or mysql and php in server 03...please let me know. Dont bother telling me to google it because I've been through the first 10 pages of hits and everything leads me to the same location.
-
Been a while since I did this but I did setup a server with IIS, PHP and MySQL. The only hard part I found was getting the PHP to load in the IIS. One thing that I found that worked really well is to have a script with
<?
Phpinfo();
?>
Going through that will tell you a lot about your configuration and where things are pointing.
How about this page for the IIS user accounts http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/3648346f-e4f5-474b-86c7-5a86e85fa1ff.mspx?mfr=true (http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/3648346f-e4f5-474b-86c7-5a86e85fa1ff.mspx?mfr=true)
and it is IUSR not IUSER. Hope that isn't your error.
-
OH no its Iusr...i just did that unconsciously...
Here is the very very interesting thing about this though. If I run a normal html (i just slapped a page together 2 sec ago) i dont have any issues with accessing it. Like you said, it's only when I run my phpinfo test (aka a page that has PHP in it) that I get the access denied. Now my original thought would be that it's attempting to access my isapi.dll (for thats what's executing my php right??) which doesnt have the iusr permission and thats why I was having issues. However I changed the dir temporary to grant those permissions yet I'm still having issues.
IIS just doesnt seem to like PHP but I dont know any other way of doing it unless I guess I would run apachi and scrap IIS alltogether
-
Does the IUSR account have full permission to the php directory??
-
for the time being it has read/write...I'm just throwing anything I can think of to why I can't access php files
Me = MASSIVE FRUSTRATION ATM
-
Ok..i'm at my whits ends..I gotta take a break before I punch something. Just does not make any sense whatsoever
-
Ok..i'm at my whits ends..I gotta take a break before I punch something. Just does not make any sense whatsoever
Hey, you sound almost exactly like I do when I get mad at my code! WOOT
-
Well do u storm off...down 3 shots and come back to try to make more sense of things buzzed. I often feel "hey! if it doesn't make sense sober...it def will when I cant feel my fingers and toes!" LOL J/K
-
been there too
-
I've never put PHP on IIS, but I think you may have to be granting execute permissions to your IUSR account so the PHP pages can be interpreted and rendered. Just reading the file will not let the PHP interpreter actually do anything to the outputted page.
Also, for more specific PHP/IIS info, this might be a good place to check: http://us3.php.net/manual/en/install.windows.iis.php
-
I am just wondering why IIS? Any specific reason?
XAMPP FTW http://portableapps.com/apps/development/xampp
-
for a possible side job, I put together a test server of Linux, Apache, MySQL, and PHP. Using Ubuntu and an old clunker PC it took me literally 3 hours to have a fully functional server up and running. And I wasn't working on it non-stop.
-
And as the Doctor mentioned above, XAMPP let's you have a fully functioning Apache/MySQL/PHP/FileZilla setup in just minutes. I keep a copy of the above on my USB stick just in case I need a server in a jiffy (and, yes, I have used it before for just that occasion).
-
I haven't had any direct experience with setting up php in iis, but recently, i did setup some authentication and reverse proxy ISAPI filters in a bunch of iis-based webservers. Are you seeing anything juicy in the iis logs or the Windows event log viewer?
Also, just googling around:
http://www.peterguy.com/php/install_IIS6.html
http://www.themssforum.com/IIS/Help-with-341209/
http://www.usenet-forums.com/php-general/55280-re-php-shell_exec-batch-files-iis-windows.html
-
IIS, over-complicates something that in reality is fairly simple.
-
IIS, over-complicates something that in reality is fairly simple.
I agree..I believe scrapping IIS altogether and going Apache will be a lot simpler. I'm not planning on using ASP anyways, just php and sql so
-
I just dealt with a sucky IIS issue today, granted it was ASP, but I think I can help you if you haven't switched.
Do you get a 401.x (1,3, or 5)? Saying a script is unauthorized?
-
I just dealt with a sucky IIS issue today, granted it was ASP, but I think I can help you if you haven't switched.
Do you get a 401.x (1,3, or 5)? Saying a script is unauthorized?
Yep..thats exactly what I'm getting (401.3 authorization required..even though I have anonymous login checked) I know it's a permission issue with iusr_comp but I granted read acess to all www root dir and subdir along with access to my php (C:\php)
No worries though because after 2 days of messing with it...I just spent 2 hours and got apache, php and mysql running. Currently am in the process of throwing phpnuke up and i'll be set. Just was really annoying to deal with microsoft permissions. Apache has its downfalls but it's quick simple and does what I want.
Thanks anywho though
-
Yeah, the simple solution... Go to the security tab of your wwwroot... Go to your security tab. Add iusr_**** whatever... Go to advanced and check the replace on child objects box. And then things will work.. I found that crap wasn't getting handed down.. At least on the server I was working on.
-
Well I got PHP and Mysql to install but now am having massive issues with getting PHP-Nuke to install correctly. I actually got the original phpnuke to install fine but I'm trying to load Nuke Evo.
http://www.nuke-evolution.com/
When I go through the install I get a boatload of errors like this...
There has been a MySQL error. MySQL Error Details:
1101: BLOB/TEXT column 'field_desc' can't have a default value
CREATE TABLE `nuke_bbxdata_fields` ( field_id smallint(5) UNSIGNED NOT NULL, field_name varchar(255) NOT NULL default '', field_desc text NOT NULL default '', field_type varchar(255) NOT NULL default '', field_order smallint(5) UNSIGNED NOT NULL default '0', code_name varchar(255) NOT NULL default '', field_length mediumint(Cool UNSIGNED NOT NULL default '0', field_values text NOT NULL default '', field_regexp text NOT NULL default '', manditory TINYINT( 1 ) NOT NULL DEFAULT '0', default_auth tinyint(1) NOT NULL default '1', display_register tinyint(1) NOT NULL default '1', display_viewprofile tinyint(1) NOT NULL default '0', display_posting tinyint(1) NOT NULL default '0', handle_input tinyint(1) NOT NULL default '0', allow_html tinyint(1) NOT NULL default '0', allow_bbcode tinyint(1) NOT NULL default '0', allow_smilies tinyint(1) NOT NULL default '0', viewtopic TINYINT( 1 ) DEFAULT '0' NOT NULL, signup TINYINT( 1 ) DEFAULT '0' NOT NULL, PRIMARY KEY (field_id), UNIQUE KEY code_name (code_name) );
There has been a MySQL error. MySQL Error Details:
1146: Table 'evonuke.nuke_bbxdata_fields' doesn't exist
INSERT INTO `nuke_bbxdata_fields` (field_id, field_name, field_type, field_order, code_name, display_register) VALUES (1, 'ICQ Number', 'special', '1', 'icq', 2);
There has been a MySQL error. MySQL Error Details:
1146: Table 'evonuke.nuke_bbxdata_fields' doesn't exist
INSERT INTO `nuke_bbxdata_fields` (field_id, field_name, field_type, field_order, code_name, display_register) VALUES (2, 'AIM Address', 'special', '2', 'aim', 2);
There has been a MySQL error. MySQL Error Details:
1146: Table 'evonuke.nuke_bbxdata_fields' doesn't exist
INSERT INTO `nuke_bbxdata_fields` (field_id, field_name, field_type, field_order, code_name, display_register) VALUES (3, 'MSN Messenger', 'special', '3', 'msn', 2);
There has been a MySQL error. MySQL Error Details:
1146: Table 'evonuke.nuke_bbxdata_fields' doesn't exist
INSERT INTO `nuke_bbxdata_fields` (field_id, field_name, field_type, field_order, code_name, display_register) VALUES (4, 'Yahoo Messenger', 'special', '4', 'yim', 2);
There has been a MySQL error. MySQL Error Details:
1146: Table 'evonuke.nuke_bbxdata_fields' doesn't exist
INSERT INTO `nuke_bbxdata_fields` (field_id, field_name, field_type, field_order, code_name, display_register) VALUES (5, 'Website', 'special', '5', 'website', 2);
There has been a MySQL error. MySQL Error Details:
1146: Table 'evonuke.nuke_bbxdata_fields' doesn't exist
INSERT INTO `nuke_bbxdata_fields` (field_id, field_name, field_type, field_order, code_name, display_register) VALUES (6, 'Location', 'special', '6', 'location', 2);
Even after the install is done however I can go to my localhost and it'll load the page. It looks great and I dont see any errors really except when I try to hit up the phpbb forums.
phpBB : Critical Error
Error creating new session
DEBUG MODE
SQL Error : 1364 Field 'session_url_qs' doesn't have a default value
INSERT INTO nuke_bbsessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('1b4cd8f0134ff34b62d26658deebb3e5', '1', '1215476755', '1215476755', '7f000001', '0', '0', '0')
Line : 429
File : sessions.php
Any ideas on any of this Shado? I posted on there boards hoping someone would take the time to help me out but no one's paid any attention. I think i'll reinstall MySql later on today too see if that does anything
-
I doubt it is a MySQL install problem. If the other tables loaded correctly it is the PHPbb tables that have errors in the import.
You could just create the nuke_bbxdata_fields table by hand. All of the fields and types are listed there. The errors just below that are the system trying to add records to the table. If you have multiple errors like this I would look around for another SQL file for the install. This one might not be made to be used in a MySQL database.
-
Yeah. 'evonuke.nuke_bbxdata_fields' doesn't exist. I would double check the sql files that come with nuke.
-
I figured it out...Basically had to go into phpmyadmin and change the values manually. Got the forum up as well after I set default values for bbsessons_qw and bbsessions_pw
Just a pain in the arse I guess...Nuke Evo seems to be glitchy though. Any other nuke mod that you know of thats solid?
-
My takes on Nuke:
-
My takes on Nuke:
LOL...in your professional opinion..what would u suggest to is in place of nuke
-
I don't know what you are trying to do.
-
I used PHP-Nuke as an intranet website along with a photo gallery module, calendar module, and a couple of custom modules that I created at my last job. It worked fine. Although we didn't have any hackers or bots running around our net. I know the old FithLAN site kept getting hacked as well which is why it has been reduced to a phpbb.
-
I used PHP-Nuke as an intranet website along with a photo gallery module, calendar module, and a couple of custom modules that I created at my last job. It worked fine. Although we didn't have any hackers or bots running around our net. I know the old FithLAN site kept getting hacked as well which is why it has been reduced to a phpbb.
As did FITES on a few occasions. If you're looking for a good CMS (Content Management System), I've heard good things about Drupal (http://drupal.org/), but have not used it personally.
-
Cool...Thanks Sully...I'll check it out tonight. Looks nice though