Server Help Forum Index Server Help
Community forums for Subgame, ASSS, and bots
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   StatisticsStatistics   RegisterRegister 
 ProfileProfile   Login to check your private messagesLogin to check your private messages   LoginLogin (SSL) 

Server Help | ASSS Wiki (0) | Shanky.com
MySQL
Goto page Previous  1, 2
 
Post new topic   Reply to topic Printable version
 View previous topic  New SS graphic site launched Post :: Post   View next topic  
Author Message
D1st0rt
Miss Directed Wannabe


Age:37
Gender:Gender:Male
Joined: Aug 31 2003
Posts: 2247
Location: Blacksburg, VA
Offline

PostPosted: Sat Oct 09, 2004 4:29 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote

I rest my case
_________________

Back to top
View users profile Send private message Add User to Ignore List Visit posters website
Donkano
Server Help Squatter


Gender:Gender:Male
Joined: Jul 02 2003
Posts: 763
Offline

PostPosted: Mon Oct 25, 2004 10:53 pm   Post maybe stupid    Post subject: Donkano. Reply to topic Reply with quote

Don't worry guys, I got it all figured out now. I spent a little bit of exporing time inside and out of my server (even some pats that i never knew that existed) and found it all out
Back to top
View users profile Send private message Add User to Ignore List
CypherJF
I gargle nitroglycerin


Gender:Gender:Male
Joined: Aug 14 2003
Posts: 2582
Location: USA
Offline

PostPosted: Tue Oct 26, 2004 12:07 am   Post maybe stupid    Post subject: Reply to topic Reply with quote

MySQL.com has everything u need to know about how to setup MySQL etc etc.

Thats all you need to do is spend time with it; get to become familiar with the programs you use.
_________________
Performance is often the art of cheating carefully. - James Gosling
Back to top
View users profile Send private message Add User to Ignore List
Donkano.
Guest


Offline

PostPosted: Fri Apr 08, 2005 10:07 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote

Okay, I have looked into it and I have decided to install the following programs:

Apache 2.0.53
PHP 5.0.4
MySQL 4.1.11
MySQL CC 0.9.4

Apache 2.0.53 installed successfully and DOES NOT work. I can connect to it but others cannot (http://digital-vortech.ath.cx/).

PHP 5.0.4 will not work with Apache, it says in the install.txt to add 2 specific lines into the Apache's httpd.conf (which I did) and still will not work.

MySQL 4.1.11 is working successfully.

MySQL CC 0.9.4 does connect with the MySQL 4.1.11 database successfully.



Can someone help me with my issues please?
Back to top
Mine GO BOOM
Hunch Hunch
What What
Hunch Hunch<br>What What


Age:42
Gender:Gender:Male
Joined: Aug 01 2002
Posts: 3615
Location: Las Vegas
Offline

PostPosted: Fri Apr 08, 2005 10:27 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote

Sadly, these are the wrong type of forums for your problems. We deal with a game called Subspace, and server problems related to that. But since you did pretty good and searched for a related topic, better than most people ever do, I'll still try to help you out.

It sounds like you have a firewall problem for Apache. Else, if you are behind a router, you might be using NAT, in which case you'll need to look up in your router's manual on how to correctly forward port 80. Another related problem is that some ISPs have been know to block port 80, because technically, your agreement with your host usually states "no servers" and anything on port 80 will almost always be a server.

If that isn't the program, I'd recommend ApacheFreaks.com, as they are more suited towards helping you out with that.

For MySQL CC not connecting, by default, MySQL will not allow non-localhost connections. Go into the configuration files for it, and find the variable to allow remote connections, usually you'll set an IP subnet with it.
Back to top
View users profile Send private message Add User to Ignore List Send email
Dr Brain
Flip-flopping like a wind surfer


Age:39
Gender:Gender:Male
Joined: Dec 01 2002
Posts: 3502
Location: Hyperspace
Offline

PostPosted: Fri Apr 08, 2005 11:17 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote

One would hope he knows what SubSpace is, seeing as he has nearly 300 posts on this forum.
_________________
Hyperspace Owner

Smong> so long as 99% deaths feel lame it will always be hyperspace to me
Back to top
View users profile Send private message Add User to Ignore List AIM Address Yahoo Messenger MSN Messenger
D1st0rt
Miss Directed Wannabe


Age:37
Gender:Gender:Male
Joined: Aug 31 2003
Posts: 2247
Location: Blacksburg, VA
Offline

PostPosted: Fri Apr 08, 2005 11:24 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote

MySQL admin stuff is a piece of cake when running Webmin
Back to top
View users profile Send private message Add User to Ignore List Visit posters website
Donkano.
Guest


Offline

PostPosted: Fri Apr 08, 2005 11:41 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote

I have only 1 firewall which I have set to fully allow ALL of the programs for the server.

I do not own a router.

I don't think my ISP blocks port 80 (I will call them up tomorrow and make sure).

I also stated, "MySQL CC 0.9.4 DOES CONNECT with the MySQL 4.1.11 database SUCCESSFULLY."


Besides the ApacheFreaks.com website, do you have any other ideas?
Back to top
Cyan~Fire
I'll count you!
I'll count you!


Age:37
Gender:Gender:Male
Joined: Jul 14 2003
Posts: 4608
Location: A Dream
Offline

PostPosted: Sat Apr 09, 2005 9:45 am   Post maybe stupid    Post subject: Reply to topic Reply with quote

Lol, say "MySQL CC connects...", it's much clearer. I misread you too.
_________________
This help is informational only. No representation is made or warranty given as to its content. User assumes all risk of use. Cyan~Fire assumes no responsibility for any loss or delay resulting from such use.
Wise men STILL seek Him.
Back to top
View users profile Send private message Add User to Ignore List Visit posters website
Solo Ace
Yeah, I'm in touch with reality...we correspond from time to time.


Age:38
Gender:Gender:Male
Joined: Feb 06 2004
Posts: 2583
Location: The Netherlands
Offline

PostPosted: Sat Apr 09, 2005 10:36 am   Post maybe stupid    Post subject: Reply to topic Reply with quote

I wrote this post a few hours ago, just didn't submit yet because I had to leave. sa_tongue.gif

I have no idea how different Apache is on Windows compared to Linux, but I guess most of it is the same.

I wanted to try to set Apache and MySQL up on a computer downstairs (I don't want apache here), but because I have to leave for a LAN party at my friend's house I'll try to do it there.
If I found out I'll post there under the name that friend always uses: "Jaap".
Back to top
View users profile Send private message Add User to Ignore List
Donkano.
Guest


Offline

PostPosted: Mon Apr 11, 2005 6:21 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote

Bump.

Anyone know any other possible solutions?
Back to top
Solo Ace
Yeah, I'm in touch with reality...we correspond from time to time.


Age:38
Gender:Gender:Male
Joined: Feb 06 2004
Posts: 2583
Location: The Netherlands
Offline

PostPosted: Wed Apr 13, 2005 6:17 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote

Sorry for not replying, I was too busy with other things to try this.

I could easily install Apache2 with PHP5 and get it to work by following the install guide in PHP's install.txt.
Are you sure you tried this?

install.txt wrote:
Installing as an Apache module

You need to insert these two lines to your Apache httpd.conf
configuration file to set up the PHP module for Apache 2.0:

[...]

# For PHP 5 do something like this:
LoadModule php5_module "c:/php/php5apache2.dll"
AddType application/x-httpd-php .php


# configure the path to php.ini
PHPIniDir "C:/php"

Note: Remember to substitute the c:/php/ for your actual path to
PHP in the above examples. Take care to use either php4apache2.dll
or php5apache2.dll in your LoadModule directive and not
php4apache.dll or php5apache.dll as the latter ones are designed to
run with Apache 1.3.x.

[...]


If you really can't get that to work, read my quick setup guide here.
I chose the module installation because that's what I prefer.


Installing PHP5 on Apache 2 - Win32

Configuration lines or directives/parameters which need to be added to configuration files are colored blue.
Comments (lines starting with # don't need to be added, but I made them blue anyway because you may want to add them to have comments on what the directive does in your configuration files.

Step 1. - Getting the module to load

So, what I did was just look for the LoadModule directives in "C:\Program Files\Apache Group\Apache2\conf\httpd.conf", and at the bottom:
httpd.conf wrote:
#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
#LoadModule ssl_module modules/mod_ssl.so
LoadModule php5_module "c:/php/php5apache2.dll"


Step 2. - Adding the .php filetype

I just added the "AddType application/x-httpd-php .php" too:
httpd.conf wrote:
AddType application/x-compress .Z
AddType application/x-gzip .gz .tgz
AddType application/x-httpd-php .php



Step 3. - Setting the path to the php.ini

Then, as last configuration step, add the PHPIniDir directive.
httpd.conf wrote:
# Bring in additional module-specific configurations
#
<IfModule mod_ssl.c>
Include conf/ssl.conf
</IfModule>

#
# This directive should point at the directory php.ini is in
# Note: use '/' in path configurations, not '\'.
#

PHPIniDir "C:/php"


### Section 3: Virtual Hosts


Step 4. - Firing it up!

Now just restart the Apache service.
In the taskbar next to the clock you should see the apache logo with a status symbol on it.
Right-click this symbol, click "Open Apache Monitor", select the server entry, then click restart.

If any error occurs when restarting it, check the system log.


Step 5. - Testing PHP

Create a file named "info.php" in the htdocs directory of your apache website files (C:\Program Files\Apache Group\Apache2\htdocs).
Open the file with a text editor (like notepad) and add this to it:
Code: Show/Hide
<?php
   // Generate a test page with information about my server:
   phpinfo();
?>

This will call the phpinfo function, which will generate a page with information about your Apache and PHP versions.

In your webbrowser, now browse to http://127.0.0.1/info.php and check if you see the test page.
If it works, you shouldn't let people be able to browse to this file, since it can display information which makes your server vulnerable), rename it to info.phps or just delete it.

If it doesn't work, reply and provide information which may lead to the cause of the problem.
Back to top
View users profile Send private message Add User to Ignore List
Solo Ace
Yeah, I'm in touch with reality...we correspond from time to time.


Age:38
Gender:Gender:Male
Joined: Feb 06 2004
Posts: 2583
Location: The Netherlands
Offline

PostPosted: Wed Apr 13, 2005 6:26 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote

I don't know about your NA(P)T/ISP/Firewall problems, you'll need to provide more information to get more help.

Some ports may be blocked by your ISP.
If so, you might want to give up trying to run your own services.
If not, you have some routing problems which are probably easy to fix if you know what's going on in your network and equipment.
Back to top
View users profile Send private message Add User to Ignore List
Donkano.
Guest


Offline

PostPosted: Sun Apr 17, 2005 6:59 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote

First of all the directories I have things installed to:
Apache: D:\Web\Host\Apache 2.0.53\Apache2\
PHP: D:\Web\Host\PHP 5.0.4\
MySQL: D:\Web\Host\MySQL 4.1.11\
MySQL CC: D:\Web\Host\MySQL CC 0.9.4\

Okay, I did all of the steps you told me but here is the issues I have:

In my PHP install directory I have the following files:

sessiondata (folder)
uploadtemp (folder)
IISConfig.exe
install.txt
license.txt
php5ts.dll
php-cgi.exe

You told me to add the following line to the Apache's httpd.conf (which I did):
LoadModule php5_module "D:/Web/Host/PHP 5.0.4/php5apache2.dll"

However there is no such file as "php5apache2.dll" in the PHP directory.

I then ran the Apache Test Configuration and it stated:

Apache Test Configuration wrote:


Syntax error on line 174 of D:/Web/Host/Apache 2.0.53/Apache2/conf/httpd.conf:
LoadModule takes two arguments, a module name and the name of a shared object file to load it from
Note the errors or messages above, and press the <ESC> key to exit.



In the httpd.conf on line 135 it has:
#

I also noticed that when I run the Apache Monitor and hover my mouse over the tray icon in the bottom right hand corner of my screen it says for the description:

Apache Monitor Tray Description wrote:


Running none of 1 Apache services



So I enter that and I hit the "Start" button and it comes up with a pop-up dialogue box that says:

Apache Monitor Alert On Start-Up wrote:


The requested operation has failed!





Can you (Solo Ace) or anyone else help me with this?
Back to top
Solo Ace
Yeah, I'm in touch with reality...we correspond from time to time.


Age:38
Gender:Gender:Male
Joined: Feb 06 2004
Posts: 2583
Location: The Netherlands
Offline

PostPosted: Sun Apr 17, 2005 7:53 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote

I think you have the CGI version of PHP installed (sorry, I guess I should've known that you picked the installer instead of the zip package), which means that the webserver (or whatever wants to use PHP) has to pass the script to a php exe.

Apache is failing to boot because it can't load the requested module, as I said in one of my previous posts: "I chose the module installation because that's what I prefer.".

You could, if you want, get the module version of PHP (php5apache2.dll), or just install it as CGI (apache passes the script to the .exe, not to the .dll).

Installing it as CGI is as easy as installing it as module:

install.txt wrote:
Installing as a CGI binary

You need to insert these three lines to your Apache httpd.conf
configuration file to set up the CGI binary:

Example 2-5. PHP and Apache 2.0 as CGI
ScriptAlias /php/ "c:/php/"
AddType application/x-httpd-php .php

# For PHP 4
Action application/x-httpd-php "/php/php.exe"

# For PHP 5
Action application/x-httpd-php "/php/php-cgi.exe"

Warning

By using the CGI setup, your server is open to several possible
attacks. Please read our CGI security section to learn how to defend
yourself from those attacks.


Read the warning, eh.

Just add these three lines to your httpd.conf:
Quote:
ScriptAlias /php/ "d:/web/host/php 5.0.4/"
AddType application/x-httpd-php .php

Action application/x-httpd-php "/php/php-cgi.exe"


Make sure you're not putting these in another configuration block for a specifiec directory or module, you'd probably get syntax errors.

After adding these lines, continue from step 4 in my "setup guide".
Your php.ini is probably in C:\WINDOWS, you can find in that guide (step 3) how to change the location if you want to.

After this Apache should be able to work with PHP, good luck.
Back to top
View users profile Send private message Add User to Ignore List
Donkano.
Guest


Offline

PostPosted: Thu Apr 28, 2005 8:17 am   Post maybe stupid    Post subject: Reply to topic Reply with quote

Okay, I went back to PHP.net and I downloaded the ZIP file of PHP 5.0.4 and I uninstalled and removed the INSTALL of PHP 5.0.4 and re-installed Apache 2.0.53 and then I followed the initial setup guide.

After that i reseted Apache and it says the server is online and PHP is connected.

So I went to http://digital-vortech.ath.cx/ (the web alias of my server) and it worked fine. I then got 3 people to try to connect to it and all of then got "Could Not Open Page".

So I can view my server locally but nobody from a remote location can. How do I make it so that remote users can connect?
Back to top
Solo Ace
Yeah, I'm in touch with reality...we correspond from time to time.


Age:38
Gender:Gender:Male
Joined: Feb 06 2004
Posts: 2583
Location: The Netherlands
Offline

PostPosted: Thu Apr 28, 2005 8:35 am   Post maybe stupid    Post subject: Reply to topic Reply with quote

In httpd.conf are some settings which only allow localhost (127.0.0.1) to access some parts of the server.

Look for settings which apply to your "document root", you may find something preventing all clients except 127.0.0.1 to browse the directory.

If you can't fix it, attach your httpd.conf so I can have a look, otherwise I'll try to see what's wrong in some default httpd.conf, but that'd be later today.

Good to see that service port 80 isn't being blocked, I hate ISPs that do that, even when people agree on the "no running services" rule in the ISP's network policy.
Back to top
View users profile Send private message Add User to Ignore List
Donkano.
Guest


Offline

PostPosted: Thu Apr 28, 2005 2:35 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote

httpd.conf

That there is my httpd.conf and I saw nothing in there about denying from all except digital-vortech.ath.cx / 127.0.0.1 / localhost.

You try and have a look and see if you can find it.




httpd.conf - 32.98 KB
File downloaded or viewed 12 time(s)
Back to top
Solo Ace
Yeah, I'm in touch with reality...we correspond from time to time.


Age:38
Gender:Gender:Male
Joined: Feb 06 2004
Posts: 2583
Location: The Netherlands
Offline

PostPosted: Thu Apr 28, 2005 2:48 pm   Post maybe stupid    Post subject: Reply to topic Reply with quote

Wait a minute, I'm not sure if I understood your previous post correctly.

Where you say "I then got 3 people to try to connect to it and all of then got "Could Not Open Page".".
I actually doubt that has anything to do with Apache, since that error message is probably generated by their browsers. icon_sad.gif

Coming back to the ISPs blocking ports, I think that's what happened to you, then.
Back to top
View users profile Send private message Add User to Ignore List
Display posts from previous:   
Post new topic   Reply to topic    Server Help Forum Index -> Trash Talk All times are GMT - 5 Hours
Goto page Previous  1, 2
Page 2 of 2

 
Jump to:  
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum
View online users | View Statistics | View Ignored List


Software by php BB © php BB Group
Server Load: 37 page(s) served in previous 5 minutes.

phpBB Created this page in 0.662822 seconds : 45 queries executed (79.7%): GZIP compression disabled