[Tutorial] Read this for people who are having trouble with website!

[Raman]

There are many people who are having trouble with port forwarding and apache and their websites! I believe i have found a solution!

You will need a website host (not freewebs) that has php enabled. I recommend Freehostia (http://freehostia.com/). Then open your mysql manager program (heidi sql, navicat, sqlog) and make a new user. Give the new user all privileges and make his host %. The user and pass can be whatever. Then in the config file for the website put the hostname as your external ip (http://whatismyip.com/). User is the username you made and pass is the pass you made. Database name is logon.

Now just upload the files to freehostia or your php host and voila! I have tested this and it works like a charm! You dont even need apache running no more! This should fix some of your website-related problems! Hope this helps you somehow!

VIDEO (http://abcdefghijklmnop.freehostia.com/TUT/TUT.html)

[deadprezz]

i dont get this part

Then in the config file for the website put the hostname as your external ip. User is the username you made and pass is the pass you made. Database name is logon.


explain more im using freehostia and navicat

[Raman]

k paste the config file for your website here.

[deadprezz]

Database: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
is what i get now

config file


<?php

#################
# #
# #
# Enjoy! #
# #
# #
#################

$config['mysql_host'] = 'localhost';//http://24.254.28.237
$config['mysql_user'] = 'root';//deadprezz
$config['mysql_pass'] = 'ascent';//********
$config['mysql_dbname'] = 'logon';//logon

?>

[Dark Realms]

Thank you very much for this guide! I have been searching for days and posting numorous forums/topics but know one could answer/help fix my problem.

You sir.. are a genius :D

+rep!!

P.S - know how to make the server info pages work?

[Raman]

thanks, what do you mean by server pages?

[Dark Realms]

Well..

My account creation page now works, BUT my server stats page doesnt..

Account Creation Page (http://www.slayrot.exofire.net/howto.htm)

Server Stats Page (http://www.slayrot.exofire.net/server.htm)

The stats you see on there are not live.. Any idea how to make it so it displays live server stats? (It came with the 7.4 AC-Web Repack)

Thanks mate :)

[Raman]

i think it does work....

I can see people online.

[Dark Realms]

Naa it doesnt work.. its showing people online but thats just because i uploaded "stats.xml" to my website whilst people were on the server lol..

I take it config.php controls both the account creation page & server stats page?

If so then thats weird that the stats doesnt work..

I changed the "ascent.conf" file to dumb the stats from 'C:\AC Web Ultimate Repack\Server\htdocs\stats\stats.xml' to 'my web address /stats.xml' instead.. That the wrong thing to do? lol

[Golepa]

I changed the "ascent.conf" file to dumb the stats from 'C:\AC Web Ultimate Repack\Server\htdocs\stats\stats.xml' to 'my web address /stats.xml' instead.. That the wrong thing to do? lolChange it back.

[Raman]

did you edit the config.php in your /stats/ directory?

[Dark Realms]

Changed it back..

Still not working..

I'll post my configs...

<?php

#################
# #
# #
# Enjoy! #
# #
# #
#################

$config['mysql_host'] = 'slayrot.kicks-ass.net'; //MySQL Host
$config['mysql_user'] = '*****'; //MySQL Username
$config['mysql_pass'] = '*****'; //MySQL Password
$config['mysql_dbname'] = 'logon'; //Database Name

?>

All i uploaded to my website was the files inside:

"C:\AC Web Ultimate Repack\Server\htdocs\stats"

The account Creation page is fine but stats still dont work..

Here's the ascent.conf bit:

#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#
# Status Dumper Config
#
# These directives set up the status dumper plugin. Filename is an
# absolute or relative path to the server binary. Interval is the
# time that the stats will be dumped to xml.
# Default: stats.xml / 120000 (2 minutes)
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<StatDumper FileName = "C:\AC Web Ultimate Repack\Server\htdocs\stats\stats.xml" Interval = "120000">

What's wrong?

I have apache etc running 24/7 so it cant be that :rolleyes:

This is just really frustrating as its something i want soooo bad lol

Thanks for your help again guys!

[jakx]

everything works except my register.php page wont load

link is http://ultimatedoom.freehostia.com/

[Blackboy0]

There are many people who are having trouble with port forwarding and apache and their websites! I believe i have found a solution!

You will need a website host (not freewebs) that has php enabled. I recommend Freehostia (http://freehostia.com/). Then open your mysql manager program (heidi sql, navicat, sqlog) and make a new user. Give the new user all privileges and make his host %. The user and pass can be whatever. Then in the config file for the website put the hostname as your external ip (http://whatismyip.com/). User is the username you made and pass is the pass you made. Database name is logon.

Now just upload the files to freehostia or your php host and voila! I have tested this and it works like a charm! You dont even need apache running no more! This should fix some of your website-related problems! Hope this helps you somehow!

How would you do this with Freeforums?

Site: WoWCraft Site (www.wowcraftonline.freeforums.org)

I REALLY need an Account Creation Page. Doing it manually is SICK :( +Rep if you help me :P

-Blackboy0

[poyan2000]

is there a way to make your website and server work without hamachi?and without a routher?

[Dark Realms]

Tried soo many things and still not working.. Anyone?

[kilijan]

is there a way to make your website and server work without hamachi?and without a routher?

yes there is,go to search button up there :) and u ll find the answer to q HOW ;p

Tried soo many things and still not working.. Anyone?

i have got same problem ,i changed the statt in ascent.conf but wont work :/

and + i dunno how to set up forum on my site : ludisrbi.servegame.org :(

[Raman]

everything works except my register.php page wont load

link is http://ultimatedoom.freehostia.com/

Is your MySQL running? Try going on register.php with MySQL, Ascent and logonserver running. I tried to go on my register page without MySQL running, it didn't work. Then I tried it with MySQL running and it worked perfectly. :D I'm updating the video with screen shots and maybe a video.

Tried soo many things and still not working.. Anyone?

Try changing this in your "ascent.conf":

<StatDumper FileName = "C:/AC Web Ultimate Repack/Server/htdocs/stats/stats.xml" Interval = "120000">

To this:

<StatDumper FileName = "YOUR WEBSITE PATH TO STATS.XML" Interval = "120000">

Start your server, log into WoW, make sure you are logged into WoW, then Alt-Tab, wait 3 minutes then go to the stats.xml page.

[Dark Realms]

Tried. Failed..

[dsssnake]

what files do you need to upload to you freehostia????? everyone in htdocs???

and when i create my domain name it says that it has no dns. why???

[Raman]

it doent have to, config spora, then upload it.

[dsssnake]

how to i make my DNS wrk???

do you need to pay for it?

[Raman]

you don't need a dns

[omppu43]

plz make vid how to do this im not understanding this..

post video to me plz

[Raman]

k ill try to make a video

[xXxburxXx]

Nice and simple guide , thnx :D

[Raman]

yw :)

[aaamrapoc]

Raman,
Exactly what files should be uploaded to the ftp for it to work correctly?

All in the htdocs?

[Raman]

yup, and just edit all the config files!

The values are as followed:

Host: YOUR IP OR DNS
User: THE USER YOU MADE
Pass: THE PASS YOU MADE
Database: logon

[imfamous08]

Now just upload the files to freehostia or your php host and voila! I have tested this and it works like a charm! You dont even need apache running no more! This should fix some of your website-related problems! Hope this helps you somehow!>>>> What??

How do i do that? how about a really good description on how to do it or a video! PLEASE

[aaamrapoc]

yup, and just edit all the config files!

The values are as followed:

Host: YOUR IP OR DNS
User: THE USER YOU MADE
Pass: THE PASS YOU MADE
Database: logon

Raman,
I copied all to the ftp and it came up but said cant connect to mysql on blah blah.... So exactly which configs should I change? I added the host name and all to navicat and change the config in stats on the one I loaded up. Is that all?

also when you said **make his host %**, I'm not sure what ya mean by %. I tried using the web sight ip and that doesn't do it. Changed it to *%* and well anyway so much for that :).

I know its got to be something simple. Just need a little more info from ya on this and I think I can finish it.

[Raman]

added video

[imfamous08]

Dude the video dont work

Add it to youtube or something

[killer911pt]

i have tried this but i have a ingenious soloution for myslef i run the forums and site from a free host but the account creation and stats are on my pc so if its down the forums are not less bandwith is required!

[madatlis]

im just woundering what you mean by this

". Give the new user all privileges and make his host %."

[hhhhj]

what to do to make my site public aswell?

[Legendkilla]

you really need to include more information about how to get your website hosted my the website its not easy.

[wartick]

Just up all the files in htdocs
Took me a day to under stand that "Put the host %"
It means like when The SQL browser (navi,heidi's etc) Asks Username, PW and host for the new user. Put "%" to the Host and it works!

- Stats page still isnt working. $config['mysql_host'] = '**.**.**.**'; //MySQL Host
$config['mysql_user'] = 'The one i got account working too'; //MySQL Username
$config['mysql_pass'] = '******'; //MySQL Password
$config['mysql_dbname'] = 'logon'; //Database Name

[cyberlif]

well this idea is very good, but still i would only use it if you can't make the stuff work which was included in the repack

[wartick]

I dont think that is a good solution for this, better without stats :P

[AddIcT]

Can some1 post a video on youtube plz...I can't open the one that is posted...I am very very new to Navicat, got stuck on "make a new user" plz help meeee

[dagsvik1]

not bad