bcordell Posted January 16, 2007 Posted January 16, 2007 Here is my setup: Windows Server 2003 SP1 MySQL 4.1.22 PHP5 I am remote desktopping to the server. Going the address http://www.lp****.com/catalog/install/install.php I check the two boxes and click continue and nothing happens. The URL changes to catalog/install/install.php?step=2 but the page stays the same, I cant get passed this step. I've given full access to the files to see if it was the permissions, but I still get the same damn problem.
kirikintha Posted January 16, 2007 Posted January 16, 2007 Here is my setup: Windows Server 2003 SP1 MySQL 4.1.22 PHP5 I am remote desktopping to the server. Going the address http://www.lp****.com/catalog/install/install.php I check the two boxes and click continue and nothing happens. The URL changes to catalog/install/install.php?step=2 but the page stays the same, I cant get passed this step. I've given full access to the files to see if it was the permissions, but I still get the same damn problem. I can't actually see the site - that link is all messed up - prolly code checking... Also, IIS on Win2k3 is wierd - you may need to set the permissions in IE to allow the site content making it fully trusted - it may be RDP that is stopping you. Win2k3 IE runs in "protected mode" which is insane to manage for a while. The blnk page is hard to diagnose, can you see any server logs that would indicate a fail? or just not populating the page? Nothing unreal exists
bcordell Posted January 16, 2007 Author Posted January 16, 2007 I can't actually see the site - that link is all messed up - prolly code checking... Also, IIS on Win2k3 is wierd - you may need to set the permissions in IE to allow the site content making it fully trusted - it may be RDP that is stopping you. Win2k3 IE runs in "protected mode" which is insane to manage for a while. The blnk page is hard to diagnose, can you see any server logs that would indicate a fail? or just not populating the page? the real site is www.lpcsfl.com/catalog/install/install.php
worldrom Posted January 16, 2007 Posted January 16, 2007 the real site is www.lpcsfl.com/catalog/install/install.php i'm having the same problem. it won't go to step 2. will also monitor this thread. thanks
kirikintha Posted January 16, 2007 Posted January 16, 2007 i'm having the same problem. it won't go to step 2. will also monitor this thread. thanks I think I got it In your php ini file on your server you need to turn on 'register_globals' and 'register_long_arrays' to "on" restart IIS Admin and mysql try that see if that works! Nothing unreal exists
worldrom Posted January 16, 2007 Posted January 16, 2007 I think I got it In your php ini file on your server you need to turn on 'register_globals' and 'register_long_arrays' to "on" restart IIS Admin and mysql try that see if that works! okay, i'll also see if it will work. i'm not sure though if the server is running on IIS or linux. this is not my thread but i'm experiencing the same problem :-)
bcordell Posted January 16, 2007 Author Posted January 16, 2007 sweet, the register long arrays was off! now its working so far thanks!
bcordell Posted January 16, 2007 Author Posted January 16, 2007 I get a username error now: Access denied for user 'Brandon'@'localhost' (using password: YES). This is the command in mysql i used to try and setup a new user to my database. mysql > CREATE DATABASE catalog; mysql > GRANT USAGE ON * . * TO 'Brandon'@'localhost' IDENTIFIED BY 'Password'; mysql > GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , ALTER ON catalog.* TO 'Brandon'@'localhost'; (none came back with errors)
kirikintha Posted January 16, 2007 Posted January 16, 2007 I get a username error now: Access denied for user 'Brandon'@'localhost' (using password: YES). This is the command in mysql i used to try and setup a new user to my database. mysql > CREATE DATABASE catalog; mysql > GRANT USAGE ON * . * TO 'Brandon'@'localhost' IDENTIFIED BY 'Password'; mysql > GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , ALTER ON catalog.* TO 'Brandon'@'localhost'; (none came back with errors) I think you needs to change the password hasgin for mysql - I seem to remember a problem with passwords and how they are read I got this error on one of my servers - Warning: mysql_pconnect(): Access denied for user 'root'@'localhost' (using password: YES) in G:\PHP\php2.php on line 4 PHP version - 4.2 MySQL - 5.0.2 The solution to the above problem is as follows - 1) Check your hostname, username and password from the MySQL monitor, by using the following query - select host,user, password from user; User is a table in the MySQL database (in case u did'nt know ) 2) Now use the above values while using the mysql_pconnect() function. 3) If the error persists then - go to the MySQL monitor and change the password using the following command - mysql> SET PASSWORD FOR -> root@localhost -> =OLD_PASSWORD(''); ****************** just do a search for: Access denied for user (using password: YES). there are a slew of articles and individual solutions Nothing unreal exists
bcordell Posted January 17, 2007 Author Posted January 17, 2007 I finally got it to accept my username by giving it the grant all privileges command a few times. Now I get the error | SQL file does not exist: /install/oscommerce.sql | This looks like it's configured to find the file in the unix directory structure although I may be wrong. The file is \catalog\install\oscommerce.sql, is there a config file that I need to edit to point it to the right place?
bcordell Posted January 18, 2007 Author Posted January 18, 2007 I finally got it to accept my username by giving it the grant all privileges command a few times. Now I get the error | SQL file does not exist: /install/oscommerce.sql | This looks like it's configured to find the file in the unix directory structure although I may be wrong. The file is \catalog\install\oscommerce.sql, is there a config file that I need to edit to point it to the right place? I tried importing the file right into mysql, but I cant get past step 3 in the install now.
♥Vger Posted January 18, 2007 Posted January 18, 2007 Cannot find install/oscommerce.sql ---------------------------------- You are probably trying to install on a Windows server. If they were people - they wouldn't be able to find their own way home. You need to edit install/templates/pages/install_3.php and where you see: $sql_file = $dir_fs_www_root . 'install/oscommerce.sql'; Edit it to (change /path_to_root/ to real path): $sql_file = '/path_to_root/install/oscommerce.sql'; You will need to know the path to the root of your website. Check with your hosting company if you don't know. Vger
Recommended Posts
Archived
This topic is now archived and is closed to further replies.