Server Help

Trash Talk - MySQL

Donkano - Fri Oct 01, 2004 11:32 pm
Post subject: MySQL

I know that this has nothing to do with Continuum, but but how do I set up a MySQL database? (Honestly, I have never done it before so bear with me)

Donkano - Fri Oct 01, 2004 11:33 pm
Post subject:

Crap! Meant to post in General Questions!

Night_Fox - Sat Oct 02, 2004 12:13 am
Post subject:

You have a web server to run it?
Info:
http://forums.devshed.com/t44152/s.html
http://www.blue105.com/internet/support/mysql_offline.html
http://www.vbulletin.com/forum/showthread.php?t=96200
http://www.uniqhost.com/howto-mysql.php

Solo Ace - Sat Oct 02, 2004 7:19 am
Post subject:

What would you need a "web server" for? Just run it on your own computer.

Go to MySQL's official website, download the installer for Windows and install it.

Get a graphical administration client (you can use SQL to change settings but that's harder than using a graphical client which does it for you) like MySQL CC.

Notice: your MySQL server's account with the highest access level: "root", is not protected with a password yet.

Log in using MySQL CC, use "root" as username and no password.

Change the root password, then create other accounts for your other work.

Anonymous - Sat Oct 02, 2004 11:15 am
Post subject:

I got a web server for it and the software I use for it is in a big package that supports PHP, MySQL, Apache and CGI

Anonymous - Sat Oct 02, 2004 11:23 am
Post subject:

BTW, the package i got is called EasyPHP1-7

Anonymous - Sat Oct 02, 2004 11:44 am
Post subject:

Well, I installed that MySQLCC and I am trying to add it with the server (which the server is at my house) and it won't work.

Here is my Info:

Name: Digital Vortech
Host Name: website-host.ath.cx
Username: root
Password: ******
Port: 3306

and it still fails.

Anonymous - Sat Oct 02, 2004 11:46 am
Post subject:

Actually, if anyone could, netmeeting (comes with all versions of Windows) this address: website-host.ath.cx

It would be so much easier for both sides if someone just did it remotely

Night_Fox - Sat Oct 02, 2004 3:47 pm
Post subject:

You need a webserver to run it doh! Like apache or something....

Solo Ace - Sat Oct 02, 2004 3:58 pm
Post subject:

No you don't, haha.

DOH!`1¬

Dustpuppy - Sat Oct 02, 2004 4:06 pm
Post subject:

Night_Fox wrote:

You need a webserver to run it doh! Like apache or something....

OK she doesn't know what she's talking about so ignore her.

When you say it doesn't work, what do you mean? That really doesn't help at all. Describe what you're doing and where you think it's going wrong.

Solo Ace - Sat Oct 02, 2004 7:53 pm
Post subject:

Why are you giving that account info? A MySQL server isn't used as some public webserver, mostly, so it's not like anyone of us is going to check your MySQL server out.

What error are you getting?
For some errors the MySQL manual has some tips on solving your problems.

Did you specify a password which shouldn't be used?

I see in the account information you posted that you are using a password, as I said in a previous post:

Solo Ace wrote:

Notice: your MySQL server's account with the highest access level: "root", is not protected with a password yet.

So first you have to login without any password for the root user, because a password is not set yet.
Change the password in the user administration of the root account (you can only do this after logging in, of course), then change it in your account login information too.

If that wasn't the problem, maybe there's a networking problem?

Did you try connecting to "localhost" instead of to that other address?

Are you sure the server is up?
Check it in the service list of your computer or your task manager (ctrl + alt + del).

See which IPs it's using by running netstat in a command prompt.
Go to Start -> Run, type "cmd" on Windows XP or "command" on 9X, type netstat -an | find ":3306" in the command prompt and hit the Enter key.
This will run netstat and output all active IP's with port 3306.

It should be listening on your local loopback and it should run on your local LAN IP (or on "0.0.0.0" which stands for all available).

When trying to connect from outside your local LAN make sure port 3306 (TCP) is routed to the system which is running the MySQL server.

Anonymous - Sun Oct 03, 2004 12:33 pm
Post subject:

Okay, I got rid of MySQLCC cause I found the segment in my package with MySQL in and I don't know how to connect things up to it.

There is a guide at http://www.canowhoopass.com/guides/easyphp/setupmysql.php but it doesn't really help me. I have no idea where to put the stuff and what not.

Another issue, I cann't access my MySQL directory through IE. It says the page is forbidden for me to enter.

Solo Ace - Sun Oct 03, 2004 12:35 pm
Post subject:

Wtf?!

Do you have any idea what you're trying to do?

k0zy - Sun Oct 03, 2004 12:58 pm
Post subject:

Solo Ace wrote:

Wtf?!

Do you have any idea what you're trying to do?

Exactly what I was thinking...

CypherJF - Sun Oct 03, 2004 1:53 pm
Post subject:

Rotfl EasyPHP.. just take the time to learn how to install each component separately...

Versetti - Sun Oct 03, 2004 3:15 pm
Post subject:

Well MySQL has it's own user database and it has a CUI Client. Default is the root of the MySQL does not have a pw but is binded to 127.0.0.1. Also what it could be is your configurations. Also MySQL is not related to anyother web server it can run standalone.

Dustpuppy - Sun Oct 03, 2004 4:27 pm
Post subject:

Solo Ace wrote:

Wtf?!

Do you have any idea what you're trying to do?

D1st0rt - Sun Oct 03, 2004 7:27 pm
Post subject:

http://www.freesql.org

Solo Ace - Sun Oct 03, 2004 7:28 pm
Post subject:

Gtfo, stop giving him MySQL help, he probably doesn't even know what it is.

Smong - Tue Oct 05, 2004 11:17 am
Post subject:

I'd like to point out that there are two root accounts, local and external, you need to change the passwords on both (or delete the external one, it depends on what you want to use mysql for).

Solo Ace - Tue Oct 05, 2004 2:31 pm
Post subject:

That's not even the point here, he doesn't know what it is.

Guess he just wants to look cool by asking about it, like he did here.

And I guess Night_Fox wanted to look coolar than me by correcting me, and saying MySQL needs a webserver to run on!
"Oh watch me trying to act intelligent and say things I don't know shit about".

D1st0rt - Tue Oct 05, 2004 8:41 pm
Post subject:

^ angry penguin

Solo Ace - Wed Oct 06, 2004 10:16 am
Post subject:

^- Annoying "Miss Directed Wannabe".

CypherJF - Wed Oct 06, 2004 12:18 pm
Post subject:

LOL...

D1st0rt - Sat Oct 09, 2004 4:29 pm
Post subject:

I rest my case

Donkano - Mon Oct 25, 2004 10:53 pm
Post subject: Donkano.

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

CypherJF - Tue Oct 26, 2004 12:07 am
Post subject:

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.

Anonymous - Fri Apr 08, 2005 10:07 pm
Post subject:

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?

Mine GO BOOM - Fri Apr 08, 2005 10:27 pm
Post subject:

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.

Dr Brain - Fri Apr 08, 2005 11:17 pm
Post subject:

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

D1st0rt - Fri Apr 08, 2005 11:24 pm
Post subject:

MySQL admin stuff is a piece of cake when running Webmin

Anonymous - Fri Apr 08, 2005 11:41 pm
Post subject:

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?

Cyan~Fire - Sat Apr 09, 2005 9:45 am
Post subject:

Lol, say "MySQL CC connects...", it's much clearer. I misread you too.

Solo Ace - Sat Apr 09, 2005 10:36 am
Post subject:

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

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".

Anonymous - Mon Apr 11, 2005 6:21 pm
Post subject:

Bump.

Anyone know any other possible solutions?

Solo Ace - Wed Apr 13, 2005 6:17 pm
Post subject:

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.

Solo Ace - Wed Apr 13, 2005 6:26 pm
Post subject:

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.

Anonymous - Sun Apr 17, 2005 6:59 pm
Post subject:

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?

Solo Ace - Sun Apr 17, 2005 7:53 pm
Post subject:

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.

Anonymous - Thu Apr 28, 2005 8:17 am
Post subject:

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?

Solo Ace - Thu Apr 28, 2005 8:35 am
Post subject:

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.

Anonymous - Thu Apr 28, 2005 2:35 pm
Post subject:

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.

Solo Ace - Thu Apr 28, 2005 2:48 pm
Post subject:

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.

Coming back to the ISPs blocking ports, I think that's what happened to you, then.