What is the addy to my MySQL database server?

JawZ · Post by **JawZ** » Mon Jun 28, 2004 9:08 pm

I can't figure this out.

I have my own server (ipaska) and I have created my database on it. Created a user/pw and all that but I don't know what the address is.

I'm trying to install some software on it and it asks me for the address to the MySQL server database.

Would it be something like:

http://www.universeofdiscourse.org/????/????/???

I don't know the correct syntax that it needs.

lance-tek · Post by **lance-tek** » Mon Jun 28, 2004 9:19 pm

yes, I would believe so, however, you may also try to use the IP of it ...

192.168.0.1/root/ ....

-lance

JawZ · Post by **JawZ** » Mon Jun 28, 2004 9:24 pm

lance-tek wrote:yes, I would believe so, however, you may also try to use the IP of it ...

192.168.0.1/root/ ....

-lance

I don't know what that is......

Look, here is the deal, I'm trying to setup F@H stats for everybody here. I have an ipaska webserver. I have FTP access to it as well as their own cpanel but that's it. I can do everything I need to but because I'm going through their own frontend for administering the server....I don't know what the REAL url's are. you know how when you look at phpmyadmin...it's usually like localhost/myadmin.php blah blah blah....well everything here on this cpanel is proceeded by soemthing else. I don't know how to ****ing explain it........this sucks

JawZ · Post by **JawZ** » Mon Jun 28, 2004 9:30 pm

Setup for Coolrunr's F@H Stats System

Admin user:
Admin Password:
Admin Password (confirm):
Team Number (ID):
MySQL Server address:
MySQL User:
MySQL User Password:
MySQL User Password (confirm):
MySQL Database Name:
Prefix for table names:
Team homepage or site
Install

So what do I put in there? I have no idea what the location of the server is....

lance-tek · Post by **lance-tek** » Mon Jun 28, 2004 9:33 pm

start > run > ping www.universeofdiscourse.org = 64.147.162.81

don't you have a remote connection tool you can use? if so just connect that way and go in ...

where are the big networking peeps at that would know all about this stuff ...

-lance

lance-tek · Post by **lance-tek** » Mon Jun 28, 2004 9:35 pm

UOD wrote:Setup for Coolrunr's F@H Stats System

Admin user:
Admin Password:
Admin Password (confirm):
Team Number (ID):
MySQL Server address:
MySQL User:
MySQL User Password:
MySQL User Password (confirm):
MySQL Database Name:
Prefix for table names:
Team homepage or site
Install

So what do I put in there? I have no idea what the location of the server is....

this will all be on the server or on your machine? if it is on the server then it will be just a local directory from there ...

if you are trying to connect to it remotely then, I would suggest using the ip and then the path ... however, I am not sure what directory you have it in or if you are allowing external applications to access it. (apps that aren't on the machine, as in coming from an external IP

)

-lance

JawZ · Post by **JawZ** » Mon Jun 28, 2004 9:40 pm

let's make this real simple...I'll give you my user name and pw and you can go in there and look around all you want. I have no ide where they keep the MySQL databases...they are there...but there is nothing that tells me where. It's like looking at a folder's properties without any info.

JawZ · Post by **JawZ** » Mon Jun 28, 2004 9:49 pm

And what does this mean?

Warning: fopen(dba.php): failed to open stream: Permission denied in /home/esp666/public_html/FAHStats/includes/install.php on line 211

It says in the help file to make that file (dba.php) writeable. When I went in and checked it's properties...it said it was writable. Or am I doing it wrong?

lance-tek · Post by **lance-tek** » Mon Jun 28, 2004 10:33 pm

UOD wrote:And what does this mean?

It says in the help file to make that file (dba.php) writeable. When I went in and checked it's properties...it said it was writable. Or am I doing it wrong?

chmod 767 I think that is right .. read, not write, execute ...

lance-tek · Post by **lance-tek** » Mon Jun 28, 2004 10:37 pm

lance-tek wrote:chmod 767 I think that is right .. read, not write, execute ...

I just took a look in there and I don't see the ability to make the change without going into the edit ... which I did not want to do in case you may have been in there looking around or something ... I didn't want to F anything up for ya

check yer PM's in regards to the path and see if that helps you any ... I am not fond of DB's on machines off in la la land that I can not log into like a workstation ... if you have that kind of rcon access it would be a lot better ... cpanel kinda sux for this, and the knowledge base is terrible ...

I would even suggest since it is just data (prolly like no stream at all) hosting the DB on your local machine and pointing the page to query from it ...

-lance

JawZ · Post by **JawZ** » Mon Jun 28, 2004 11:56 pm

[quote="lance-tek"]I just took a look in there and I don't see the ability to make the change without going into the edit ... which I did not want to do in case you may have been in there looking around or something ... I didn't want to F anything up for ya ]

See, I don't want to host anything on my own machine for obvious reasons. If my machine is off....nobody gets their stats. I just can't believe that this is that difficult. I use Foxserv on a server at work to serve up a forum for work related crap. So I know how to set up everything and the paths are simple....but because this on on a remote host...I have no idea how to do it.

Thanks for the help though. Please erase pw from memory lol.

lance-tek · Post by **lance-tek** » Tue Jun 29, 2004 12:32 am

UOD wrote:...

Thanks for the help though. Please erase pw from memory lol.

already happened

it would probably be easy to contact the host company via email and they can tell you exactly what path you need to use ...

JCOS or someone may be familiar enough with doing this to tell you exactly what you need .... mine is a little different ... so I can't tell you exactly

-lance

JawZ · Post by **JawZ** » Tue Jun 29, 2004 12:33 am

lance-tek · Post by **lance-tek** » Tue Jun 29, 2004 12:44 am

what was that for?

I think in about a month ... I will have time to start putting up a web server at home ... I am gonna start out with a desktop rig set up for it then maybe after I see how it all goes I may upgrade the bandwidth and the rig ... if and when I start I will help you with the DB and even though my IP will change I already have a fix for that ...

I am really diggin my heels into .NET programming (I have to ... it is my job now) and I am a web developer in .NET now so .... all in good time my friends ... all in good time ...

if anyone can find out how to pull from the stanford database that would be a huge help ....

-lance

JawZ · Post by **JawZ** » Tue Jun 29, 2004 1:38 am

Well...it was a way to put your stats in your sig without using a img file. It was all PHP code which would work in a forum like this where the rules say you can't have an img sig.

sito · Post by **sito** » Tue Jun 29, 2004 1:43 am

UOD wrote:Well...it was a way to put your stats in your sig without using a img file. It was all PHP code which would work in a forum like this where the rules say you can't have an img sig.

If that works in a sig I want one damnit!

lance-tek · Post by **lance-tek** » Tue Jun 29, 2004 8:56 am

UOD wrote:Well...it was a way to put your stats in your sig without using a img file. It was all PHP code which would work in a forum like this where the rules say you can't have an img sig.

Gotcha

RicRogue · Post by **RicRogue** » Tue Jun 29, 2004 9:40 am

[quote="lance-tek"]what was that for?

I think in about a month ... I will have time to start putting up a web server at home ... I am gonna start out with a desktop rig set up for it then maybe after I see how it all goes I may upgrade the bandwidth and the rig ... if and when I start I will help you with the DB and even though my IP will change I already have a fix for that ... ]
Lance,

You would problably have to tie your database into the txt file located at:

http://vspx27.stanford.edu/teamstats/team15.txt

It is in tab seperated format.

If you already new this, I appoligize.

I hope it helps,

RicRogue

lance-tek · Post by **lance-tek** » Tue Jun 29, 2004 10:36 am

RicRogue wrote:Lance,

You would problably have to tie your database into the txt file located at:

http://vspx27.stanford.edu/teamstats/team15.txt

It is in tab seperated format.

If you already new this, I appoligize.

I hope it helps,

RicRogue

No Ric, I was not already aware of that. I appreciate the insight

-lance

JawZ · Post by **JawZ** » Tue Jun 29, 2004 11:50 am

JawZ · Post by **JawZ** » Tue Jun 29, 2004 11:54 am

SeedOfChaos · Post by **SeedOfChaos** » Tue Jun 29, 2004 12:04 pm

UOD wrote:

But you're still using the img tag, which isn't allowed in sigs... I think that's how they enforce the no-sig-pic rule, isn't it?

JawZ · Post by **JawZ** » Tue Jun 29, 2004 12:08 pm

SeedOfChaos wrote:But you're still using the img tag, which isn't allowed in sigs... I think that's how they enforce the no-sig-pic rule, isn't it?

This is a different one from http://www.statgfx.com/index.html

The one I can't seem to get working on my webserver is all php code.

Ken · Post by **Ken** » Tue Jun 29, 2004 12:10 pm

Uoody, I believe that P sent you a PM... (Wanted to be sure that you knew...

)

Jeremy · Post by **Jeremy** » Tue Jun 29, 2004 12:39 pm

no idea if you've solved your database problem, but i'm running apache/mysql at home on a windows 2000 server with a number of databases, and you should probably be using LOCALHOST or 127.0.0.1 for yoru server address.

here's a snippet from one of my php files (i work almost exclusively with php)

$link = mysql_connect("localhost","myuser","myuserpassword") or die ("Could not connect");

and you should probably creater a user with limited access to that one database so as to secure any others you have (eg never use a root user)

-Jeremy

JawZ · Post by **JawZ** » Tue Jun 29, 2004 1:36 pm

[quote="Jeremy"]no idea if you've solved your database problem, but i'm running apache/mysql at home on a windows 2000 server with a number of databases, and you should probably be using LOCALHOST or 127.0.0.1 for yoru server address.

here's a snippet from one of my php files (i work almost exclusively with php)

$link = mysql_connect("localhost","myuser","myuserpassword") or die ("Could not connect")]

LOL

The server is here:

http://www.ipaska.com/

My website is this:

http://www.universeofdiscourse.org

I live in NJ...no telling what state or country the server is actually in....so localhost is not even on my radar.

I know how to setup a server and all that...if I own and operate the hardware myself. I use Foxserv actually...all in one solution with apache, php, and mysql.

I don't have the bandwidth to run this script from my home machine or else I would. So I thought it would have been easy to put it on my webhost. Guess not.

TonyT · Post by **TonyT** » Tue Jun 29, 2004 6:26 pm

Wanna use a web page to be able to use straing mysql commands in a textarea? This way you can issue ANY sql command statement. Save this code as sql_cmd.php and put it in a passworded directory and use it to do whatever you want with mysql. (SELECT, ALTER, DROP, CREATE, etc etc etc)

Code: Select all

<?php
// FILL THESE IN WITH YOUR SERVER'S DETAILS
$mysqlhost = 'localhost';
$mysqlusr = 'user';
$mysqlpass = 'password';

mysql_connect($mysqlhost,$mysqlusr,$mysqlpass);
?>
<html>
<head><title>MySQL Command Line</title></head>
<body onLoad="document.forms[0].elements['query'].focus()">
<?php
if (isset($_POST['submitquery'])) {
        if (get_magic_quotes_gpc()) $_POST['query'] = stripslashes($_POST['query']);
        echo('<p><b>Query:</b>
'.nl2br($_POST['query']).'</p>');
	mysql_select_db($_POST['db']);
        $result = mysql_query($_POST['query']);
        if ($result) {
                if (@mysql_num_rows($result)) {
                        ?>
                        <p><b>Result Set:</b></p>
                        <table border="1">
                        <thead>
                        <tr>
                        <?php
                        for ($i=0;$i<mysql_num_fields($result);$i++) {
                                echo('<th>'.mysql_field_name($result,$i).'</th>');
                        }
                        ?>
                        </tr>
                        </thead>
                        <tbody>
                        <?php
                        while ($row = mysql_fetch_row($result)) {
                                echo('<tr>');
                                for ($i=0;$i<mysql_num_fields($result);$i++) {
                                        echo('<td>'.$row[$i].'</tr>');
                                }
                                echo('</tr>');
                        }
                        ?>
                        </tbody>
                        </table>
                        <?php
                } else {
                        echo('<p><b>Query OK:</b> '.mysql_affected_rows().' rows affected.</p>');
                }
        } else {
                echo('<p><b>Query Failed:</b> '.mysql_error().'</p>');
        }
        echo('<hr />');
}
?>
<form action="<?=$_SERVER['PHP_SELF']?>" method="POST">
<p>Target Database:
<select name="db">
<?php
$dbs = mysql_list_dbs();
for ($i=0;$i<mysql_num_rows($dbs);$i++) {
        $dbname = mysql_db_name($dbs,$i);
        if ($dbname == $_POST['db'])
                echo("<option selected>$dbname</option>");
        else
                echo("<option>$dbname</option>");
}
?>
</select>
</p>
<p>SQL Query:

<textarea onFocus="this.select()" cols="60" rows="5" name="query">
<?=htmlspecialchars($_POST['query'])?>
</textarea>
</p>
<p><input type="submit" name="submitquery" value="Submit Query (Alt-S)" accesskey="S" /></p>
</form>
</body>
</html>

Jeremy · Post by **Jeremy** » Tue Jun 29, 2004 8:20 pm

UOD wrote:LOL

The server is here:

http://www.ipaska.com/

My website is this:

www.universeofdiscourse.org

I live in NJ...no telling what state or country the server is actually in....so localhost is not even on my radar.

I know how to setup a server and all that...if I own and operate the hardware myself. I use Foxserv actually...all in one solution with apache, php, and mysql.

I don't have the bandwidth to run this script from my home machine or else I would. So I thought it would have been easy to put it on my webhost. Guess not.

ok oops i thought you were running from one box

. forget the localhost stuff then!

depending on how heavy your access is i could potentialy help, however remotely possible. i've serve a few GB of stuff a month from home with few complaints, but the connection is 6M/512K so i dunno if it's fast enough. it seems like you're going for the casual FAH stats for just SG?

ISPs up here don't tend to complain about heavy bandwidth as i hosted a few WMVs for somebody's livejournal and transferred about 4GB in a ten hour span.

JawZ · Post by **JawZ** » Tue Jun 29, 2004 8:55 pm

Jeremy wrote:ok oops i thought you were running from one box . forget the localhost stuff then!

depending on how heavy your access is i could potentialy help, however remotely possible. i've serve a few GB of stuff a month from home with few complaints, but the connection is 6M/512K so i dunno if it's fast enough. it seems like you're going for the casual FAH stats for just SG?

ISPs up here don't tend to complain about heavy bandwidth as i hosted a few WMVs for somebody's livejournal and transferred about 4GB in a ten hour span.

Thanks for the offer but it's either my way or the hiway...in other words, I aint giving up until it works LOL. If I have to break some skulls....just kidding.

thanks for the help though.