corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » My SQL-Nearly there!


New Topic

New Poll
  <<  1    2  >> Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author My SQL-Nearly there!
Tom J
Organiser: South Wales
Premium Member


Registered: 8th Sep 03
Location: Bridgend
User status: Offline
24th Dec 06 at 16:42   View User's Profile U2U Member Reply With Quote

Im trying to install MySQl, and keep getting this error message




[Edited on 25-12-2006 by Tom J]
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
24th Dec 06 at 16:54   View Garage View User's Profile U2U Member Reply With Quote

are you a local admin?
Tom J
Organiser: South Wales
Premium Member


Registered: 8th Sep 03
Location: Bridgend
User status: Offline
24th Dec 06 at 16:57   View User's Profile U2U Member Reply With Quote

do you mean am i computer administrator?
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
24th Dec 06 at 16:58   View Garage View User's Profile U2U Member Reply With Quote

no i meant are you a local admin, but yes are you a computer administrator?
Tom J
Organiser: South Wales
Premium Member


Registered: 8th Sep 03
Location: Bridgend
User status: Offline
24th Dec 06 at 17:00   View User's Profile U2U Member Reply With Quote

yes i am a computer administrator, don't know what you mean when you say am i a local admin
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
24th Dec 06 at 17:04   View Garage View User's Profile U2U Member Reply With Quote

Local admin, admin on that computer, same thing.

Try installing somewhere that doesn't have spaces in the file name as Program Files does.

MySQL / PHP / most unix stuff is funny like that. I had to move my installs around to get some of the extensions working, wouldn't work with the paths with spaces.
Tom J
Organiser: South Wales
Premium Member


Registered: 8th Sep 03
Location: Bridgend
User status: Offline
24th Dec 06 at 17:12   View User's Profile U2U Member Reply With Quote

worked cheers, i will probably be back soon with more problems
Tom J
Organiser: South Wales
Premium Member


Registered: 8th Sep 03
Location: Bridgend
User status: Offline
24th Dec 06 at 17:28   View User's Profile U2U Member Reply With Quote

right i've installed phbb2 and apache webserver and mysql. im wanting to create a forum, been following this http://www.devside.net/guides/windows/phpbb

but when i try to visit http://localhost/forums/install/install.php like it says but no joy
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
24th Dec 06 at 17:29   View Garage View User's Profile U2U Member Reply With Quote

You seeing any page at all?
Tom J
Organiser: South Wales
Premium Member


Registered: 8th Sep 03
Location: Bridgend
User status: Offline
24th Dec 06 at 17:32   View User's Profile U2U Member Reply With Quote

im presuming im meant to be doing this in IE, i get HTTP 404 not found. In windows explorer it just doesnt do anything
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
24th Dec 06 at 17:35   View Garage View User's Profile U2U Member Reply With Quote

Yeah, IE.

Anything at http://localhost/ ?
Tom J
Organiser: South Wales
Premium Member


Registered: 8th Sep 03
Location: Bridgend
User status: Offline
24th Dec 06 at 17:37   View User's Profile U2U Member Reply With Quote

yes,
Index of /
Name Last modified Size Description

--------------------------------------------------------------------------------

apache_pb.gif 20-Nov-2004 16:16 2.3K
apache_pb.png 20-Nov-2004 16:16 1.4K
apache_pb22.gif 14-Dec-2005 12:25 2.4K
apache_pb22.png 14-Dec-2005 12:25 1.5K
apache_pb22_ani.gif 14-Dec-2005 12:25 2.2K
aspsample/ 13-Dec-2006 21:26 -
phpinfo.php 05-Jul-2003 21:23 21
stats/ 13-Dec-2006 21:26 -
webdeveloper/ 12-Dec-2006 18:20 -

--------------------------------------------------------------------------------


Apache/2.2.3 (Win32) mod_ssl/2.2.3 OpenSSL/0.9.8d PHP/5.2.0 mod_perl/2.0.3-dev Perl/v5.8.8 Server at localhost Port 80
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
24th Dec 06 at 17:41   View Garage View User's Profile U2U Member Reply With Quote

But no /forums/install/install.php, hence the file not found.

I'm assuming that is default apache htdocs location?

You need to either move your forum stuff in to there or change the DocumentRoot variable in the httpd.conf to where the forum files are.
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
24th Dec 06 at 17:48   View Garage View User's Profile U2U Member Reply With Quote

you need to find out where the default lcoation for htdocs is set and put it in there
Tom J
Organiser: South Wales
Premium Member


Registered: 8th Sep 03
Location: Bridgend
User status: Offline
24th Dec 06 at 17:55   View User's Profile U2U Member Reply With Quote

my document root is set to "/www/webroot"

ht docs is in C:\www\Apache22\htdocs

so do i need to put ht docs into webroot?

here is a screen print of c:\www http://www.corsasport.co.uk/carimages/923/apache.jpg

[Edited on 24-12-2006 by Tom J]
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
24th Dec 06 at 18:02   View Garage View User's Profile U2U Member Reply With Quote

try putting them in webroot, but to be 100% sure without experimenting just look in your apache conf file as to where your default root is
Tom J
Organiser: South Wales
Premium Member


Registered: 8th Sep 03
Location: Bridgend
User status: Offline
24th Dec 06 at 18:20   View User's Profile U2U Member Reply With Quote

quote:
Originally posted by Ian
But no /forums/install/install.php, hence the file not found.
where is this file from? from phbb2?

I'm assuming that is default apache htdocs location?
htdocs is in www:\apache22

You need to either move your forum stuff in to there or change the DocumentRoot variable in the httpd.conf to where the forum files are.
where would the forum files be?

Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
24th Dec 06 at 18:27   View Garage View User's Profile U2U Member Reply With Quote

the forum files are what you downloaded mate
Tom J
Organiser: South Wales
Premium Member


Registered: 8th Sep 03
Location: Bridgend
User status: Offline
24th Dec 06 at 18:36   View User's Profile U2U Member Reply With Quote

well i just downloaded phpbb2 again to c:\www and still no luck
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
24th Dec 06 at 18:45   View Garage View User's Profile U2U Member Reply With Quote

where does your conf file say the htdocs default location is?
Tom J
Organiser: South Wales
Premium Member


Registered: 8th Sep 03
Location: Bridgend
User status: Offline
24th Dec 06 at 18:54   View User's Profile U2U Member Reply With Quote

###*********************************************************
###* DeveloperSide.NET *
###* http://www.devside.net *
###* admin@devside.net *
###* v1.90-httpd22-ssl *
###*********************************************************


ThreadsPerChild 250
MaxRequestsPerChild 0

Listen 80

ServerRoot "/www/Apache22"
DocumentRoot "/www/webroot"

ServerName localhost:80
ServerAdmin admin@localhost

ErrorLog logs/error.log
LogLevel error

###
# Note that the following LoadModule lines only represent the minimum 'Web-Developer' Suite configuration.
#
# Also note that some of the following LoadModule lines, which are commented out, are still loaded under...
# conf\Suite-extra\*.conf
# conf\extra\*.conf
# ...configuration files -- for modular reasons.
#
# For example:
# mod_deflate is loaded under conf\Suite-extra\mod_deflate_logio.conf and NOT under httpd.conf
# status_module is loaded under conf\extra\httpd-info.conf and NOT under httpd.conf
#
# Check last part of httpd.conf for the Apache base and 'Web-Developer' *.conf files that are included.
###

#LoadModule actions_module modules/mod_actions.so
LoadModule alias_module modules/mod_alias.so
#LoadModule asis_module modules/mod_asis.so
#LoadModule auth_basic_module modules/mod_auth_basic.so
#LoadModule auth_digest_module modules/mod_auth_digest.so
#LoadModule authn_anon_module modules/mod_authn_anon.so
#LoadModule authn_dbm_module modules/mod_authn_dbm.so
#LoadModule authn_default_module modules/mod_authn_default.so
#LoadModule authn_file_module modules/mod_authn_file.so
#LoadModule authz_dbm_module modules/mod_authz_dbm.so
#LoadModule authz_default_module modules/mod_authz_default.so
#LoadModule authz_groupfile_module modules/mod_authz_groupfile.so
LoadModule authz_host_module modules/mod_authz_host.so
#LoadModule authz_user_module modules/mod_authz_user.so
LoadModule autoindex_module modules/mod_autoindex.so
#LoadModule cern_meta_module modules/mod_cern_meta.so
#LoadModule cgi_module modules/mod_cgi.so
#LoadModule dav_module modules/mod_dav.so
#LoadModule dav_fs_module modules/mod_dav_fs.so
#LoadModule deflate_module modules/mod_deflate.so
LoadModule dir_module modules/mod_dir.so
#LoadModule env_module modules/mod_env.so
#LoadModule expires_module modules/mod_expires.so
#LoadModule file_cache_module modules/mod_file_cache.so
#LoadModule headers_module modules/mod_headers.so
#LoadModule imagemap_module modules/mod_imagemap.so
#LoadModule include_module modules/mod_include.so
#LoadModule info_module modules/mod_info.so
#LoadModule isapi_module modules/mod_isapi.so
LoadModule log_config_module modules/mod_log_config.so
LoadModule mime_module modules/mod_mime.so
#LoadModule mime_magic_module modules/mod_mime_magic.so
#LoadModule proxy_module modules/mod_proxy.so
#LoadModule proxy_ajp_module modules/mod_proxy_ajp.so
#LoadModule proxy_balancer_module modules/mod_proxy_balancer.so
#LoadModule proxy_connect_module modules/mod_proxy_connect.so
#LoadModule proxy_http_module modules/mod_proxy_http.so
#LoadModule proxy_ftp_module modules/mod_proxy_ftp.so
#LoadModule negotiation_module modules/mod_negotiation.so
#LoadModule rewrite_module modules/mod_rewrite.so
LoadModule setenvif_module modules/mod_setenvif.so
#LoadModule speling_module modules/mod_speling.so
#LoadModule status_module modules/mod_status.so
#LoadModule unique_id_module modules/mod_unique_id.so
#LoadModule userdir_module modules/mod_userdir.so
#LoadModule usertrack_module modules/mod_usertrack.so
#LoadModule vhost_alias_module modules/mod_vhost_alias.so
<IfDefine SSL>
LoadModule ssl_module modules/mod_ssl.so
</IfDefine>


DefaultType text/plain

<IfModule dir_module>
DirectoryIndex index.html index.php index.aspx
</IfModule>

<FilesMatch "^\.ht">
Order allow,deny
Deny from all
</FilesMatch>

<Directory />
Options FollowSymLinks
AllowOverride None
Order deny,allow
Deny from all
Satisfy all
</Directory>

<Directory "/www/webroot">
Options Indexes FollowSymLinks
AllowOverride None
Order allow,deny
Allow from all
</Directory>


<IfModule log_config_module>
LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined
LogFormat "%h %l %u %t \"%r\" %>s %b" common

<IfModule logio_module>
LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %I %O" combinedio
</IfModule>

CustomLog logs/access.log combined
</IfModule>


<IfModule mime_module>
TypesConfig conf/mime.types
AddType application/x-compress .Z
AddType application/x-gzip .gz .tgz
</IfModule>


# Apache base configuration
#
# The configuration files in the conf/extra/ directory can be
# included to add extra features or to modify the default configuration of
# the server.

# Server-pool management (MPM specific)
#Include conf/extra/httpd-mpm.conf

# Multi-language error messages
#Include conf/extra/httpd-multilang-errordoc.conf

# Fancy directory listings
Include conf/extra/httpd-autoindex.conf

# Language settings
Include conf/extra/httpd-languages.conf

# User home directories
#Include conf/extra/httpd-userdir.conf

# Real-time info on requests and configuration
Include conf/extra/httpd-info.conf

# Virtual hosts
#Include conf/extra/httpd-vhosts.conf

# Local access to the Apache HTTP Server Manual
Include conf/extra/httpd-manual.conf

# Distributed authoring and versioning (WebDAV)
#Include conf/extra/httpd-dav.conf

# Various default settings
Include conf/extra/httpd-default.conf


# DeveloperSide.NET Server-Suite Configuration
#
# The configuration files in the conf/Suite-extra/ directory can be
# included to add extra features or to modify the default configuration of
# the server.
#
# The specifics are loaded under components.conf...

Include conf/Suite-extra/components.conf


# Security check -- if no php module is loaded, Apache should return 'permissions denied' on php(4,5) all URL requests
<IfModule !php5_module>
<IfModule !php4_module>
<Location />
<FilesMatch "\.php[45]?$">
Order allow,deny
Deny from all
</FilesMatch>
</Location>
</IfModule>
</IfModule>


<IfModule ssl_module>
Include conf/extra/httpd-ssl.conf
SSLRandomSeed startup builtin
SSLRandomSeed connect builtin
</IfModule>
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
24th Dec 06 at 19:02   View Garage View User's Profile U2U Member Reply With Quote

DocumentRoot "/www/webroot"

and youve tried sticking the phpbb files in there?

try just creating a simple html file with the word hello in it and see if that appears
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
24th Dec 06 at 19:09   View Garage View User's Profile U2U Member Reply With Quote

I agree - try that.
Tom J
Organiser: South Wales
Premium Member


Registered: 8th Sep 03
Location: Bridgend
User status: Offline
24th Dec 06 at 19:31   View User's Profile U2U Member Reply With Quote

right, i copied the bb files in there then it came up with the phpBB 2 Installation, where you input database name, password and the rest, then i click on start install and it says:

phpBB : Critical Error

Could not connect to the database
Steve
Premium Member

Avatar

Registered: 30th Mar 02
Location: Worcestershire Drives: Defender
User status: Offline
24th Dec 06 at 19:32   View Garage View User's Profile U2U Member Reply With Quote

do you have mysql running? you need to create the instace in mysql, then use that as the db name, download the GUI mysql admin tool, or use phpmyadmin if you have that installed

[Edited on 24-12-2006 by Steve]

  <<  1    2  >>
New Topic

New Poll

  Related Threads Author Forum Replies Views Last Post
Anyone use/know anything about Oracle database?? Bram Geek Day 18 1195
16th Mar 04 at 09:09
by Tim
 
forum hacking - SQL's Drew Geek Day 15 1711
9th Sep 04 at 23:50
by Ian
 
website help :( Drew Geek Day 18 1090
30th Nov 04 at 21:26
by Drew
 
Need a good MySQL host Matt H Geek Day 3 1036
14th Feb 05 at 22:08
by John
 
Webspace A1EX Geek Day 7 1031
25th Mar 06 at 16:03
by MikeLamb
 

Corsa Sport » Message Board » Off Day » Geek Day » My SQL-Nearly there! 28 database queries in 0.0163460 seconds