Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
1 registered (Ruben), 24 Guests and 8 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/12/06
Posts: 666
Top Posters (30 Days)
Ruben 47
Bert 26
Gizmo 18
Rob Provencher 10
Rimex 9
SD 6
sw55 5
Eugene 5
Matthias1976 4
Dunny 3
Latest Photos
Uhm...
Mayan End of World
Gas Station Disco Video Shoot
Test Pictures
Audrey Kate
Page 1 of 2 1 2 >
Topic Options
#200994 - 11/09/07 09:05 PM Server Name issues
toonarrow Offline
journeyman
Registered: 11/08/07
Posts: 99
Loc: New England
Hello all. I am attempting to install my brand new, licensed copy of UBB.threads. I've successfully uploaded all files, set permissions properly, successfully connected to install.php but am hung up on the "enter database information" step.

I've gotta believe that my problem here is server name. I've checked and double-checked my database name, database user, database password. All are definitely right.

For server name I tried "local_host" and failed right away. I tried the "host name" that GoDaddy provided me - a long string that looks like this: p41mysql103.secureserver.net - and it too failed right away. Called godaddy, they said "try mysql.secureserver.net" and at least the step seems to think awhile - maybe 30 or 40 seconds as it tries to connect - then it comes back with "failed." Any suggestions?

PS - I was having so much fun too! Like a kid on xmas morning....


Edited by toonarrow (11/09/07 09:07 PM)
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#200996 - 11/09/07 09:18 PM Re: Server Name issues [Re: toonarrow]
SD Offline
Registered: 04/19/07
Posts: 4205
Loc: SoCal, USA
try 'localhost' \:\)

unless for some reason, they have the mysql on it's own (separate) box... that should work ;\)
_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
#200997 - 11/09/07 09:18 PM Re: Server Name issues [Re: toonarrow]
Gizmo Offline

Registered: 06/05/06
Posts: 15455
Loc: Portland, OR; USA
try localhost, I highly doubt it'd be local_host.

BTW, most domain registries overload their hosting servers, the info could be right and the server just b0ged
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime Supporter, Beta Tester & Resident Post-A-Holic.
Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Top
#200998 - 11/09/07 09:18 PM Re: Server Name issues [Re: Gizmo]
Gizmo Offline

Registered: 06/05/06
Posts: 15455
Loc: Portland, OR; USA
posted AT THE SAME TIME!
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime Supporter, Beta Tester & Resident Post-A-Holic.
Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Top
#200999 - 11/09/07 09:19 PM Re: Server Name issues [Re: Gizmo]
SD Offline
Registered: 04/19/07
Posts: 4205
Loc: SoCal, USA
1 second diff isn't same time \:D
_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
#201000 - 11/09/07 09:22 PM Re: Server Name issues [Re: Gizmo]
toonarrow Offline
journeyman
Registered: 11/08/07
Posts: 99
Loc: New England
no luck on "localhost" and it fails immediately on that, whereas it does seem like it tries - but fails - to connect on the mysql.secureserver.net. perhaps you are right and it is a server issue with the host....bummer
Top
#201001 - 11/09/07 09:45 PM Re: Server Name issues [Re: toonarrow]
toonarrow Offline
journeyman
Registered: 11/08/07
Posts: 99
Loc: New England
So, called back to GoDaddy and this is what they sent me. Given my ignorance - does this or does this not help me at all in terms of succeeding in the connection that is currently failing?

This is called: MySQL connection string with PHP

<?php
//Sample Database Connection Syntax for PHP and MySQL.

//Connect To Database

$hostname="your_mysqlserver.secureserver.net";
$username="your_dbusername";
$password="your_dbpassword";
$dbname="your_dbusername";
$usertable="your_tablename";
$yourfield = "your_field";

mysql_connect($hostname,$username, $password) OR DIE ("<html><script language='JavaScript'<alert('Unable to connect to database! Please try again later.'),history.go(-1)</script></html>");
mysql_select_db($dbname);

# Check If Record Exists

$query = "SELECT * FROM $usertable";

$result = mysql_query($query);

if($result)
{
while($row = mysql_fetch_array($result))
{
$name = $row["$yourfield"];
echo "Name: ".$name."<br>";
}
}
?>


Edited by toonarrow (11/09/07 09:46 PM)
Top
#201002 - 11/09/07 09:52 PM Re: Server Name issues [Re: toonarrow]
SD Offline
Registered: 04/19/07
Posts: 4205
Loc: SoCal, USA
well it's interesting that your username and dbname are the same..

i pinged p41mysql103.secureserver.net and it's good and quick.

so i'd just make sure that the FULL dbname and username is used..

sometimes if you create a dbname like 'ubbthreads', the host will give you an actuall db name of username_ubbthreads... same goes for usernames in the db...

i can't tell for sure without seeing the actual info.. which you shouldn't paste here \:D
_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
#201003 - 11/09/07 09:53 PM Re: Server Name issues [Re: toonarrow]
toonarrow Offline
journeyman
Registered: 11/08/07
Posts: 99
Loc: New England
wow! I figured it out. I entered my hostname followed by the secureserver.net listed in the string and passed. Yay. I'm off and running. Hopefully free of further speedbumps.
Top
#201004 - 11/09/07 09:55 PM Re: Server Name issues [Re: toonarrow]
toonarrow Offline
journeyman
Registered: 11/08/07
Posts: 99
Loc: New England
Thank you, Sirdude, for the responses - as always. And Gizmo too. Thanks.

Oh, and Rick of course too, who helped me via email...
Top
#201005 - 11/09/07 10:21 PM Re: Server Name issues [Re: toonarrow]
toonarrow Offline
journeyman
Registered: 11/08/07
Posts: 99
Loc: New England
Okay. So, I'm all installed and I'm administering my board through the control panel. But, if I go to the URL (which is http://www.littlepilgrimsforums.com) it says "coming soon" (which is different now than the parked godaddy page that was there a couple hours ago) but it also says "f you are the owner of this web site you have not uploaded (or incorrectly uploaded) your web site."

The software certainly is uploaded successfully. Is there another step - or is this perhaps a timing issue where I'll got to bed tonight and it will be up in the AM?
Top
#201006 - 11/09/07 10:29 PM Re: Server Name issues [Re: toonarrow]
toonarrow Offline
journeyman
Registered: 11/08/07
Posts: 99
Loc: New England
OHHH. I see what happened. The live site is http://www.littlepilgrimsforums.com/forums. Because I created the directory there as per the instructions. However, I want the site to land on the main domain without the /forums. Should I move all files out of the "forums" directory on my server, or would that screw something up?
Top
#201009 - 11/10/07 12:16 AM Re: Server Name issues [Re: toonarrow]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10177
Loc: Aberdeen, WA
You can move all of the files up a directory, you'd just need to hand edit the includes/config.inc.php file. In there you'll see the BASE_URL and FULL_URL variables. The FULL_URL will need to get set to http://www.littlepilgrimsforums.com and the BASE_URL will probably just need to be set to "/".
Top
#201010 - 11/10/07 12:20 AM Re: Server Name issues [Re: toonarrow]
ntdoc Offline
Registered: 11/08/06
Posts: 3386
No you don't want to do that and keeping it in a sub folder is the right thing to do.

You can create a redirect a couple of ways so that when users hit that name it will go to your forums.

Often it is better to have a main page that does not go directly into the forums. Then you can create pages and stuff outside the forum that may pertain to other things and then have a link to the forums.
Top
#201014 - 11/10/07 12:33 AM Re: Server Name issues [Re: ntdoc]
SD Offline
Registered: 04/19/07
Posts: 4205
Loc: SoCal, USA
lol, you can do it either way nt.. i've seen root based ones as well as sub-dir ones..

most common is sub-dir @ /forums /ubbthreads /community, but nothing wrong with / ;\)
_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
#201015 - 11/10/07 01:30 AM Re: Server Name issues [Re: SD]
ntdoc Offline
Registered: 11/08/06
Posts: 3386
Yes you can do either way, any way, but the reason not to is when you sooner or later go to add other software it will often want to place either folders or files in the root that almost guaranteed will interfere with your forum and you then either need to move the forum or not install this new software.

I'm just trying to help him out with "potential" issues in the future as I've seen it a few times and was a pain to clean it all up.
Top
#201017 - 11/10/07 02:19 AM Re: Server Name issues [Re: ntdoc]
Yarp™ Offline

Registered: 08/30/06
Posts: 1522
Loc: Breda, NL
And you can always leave it in the subdir, and if somebody comes to the main url, redirect them to the UBB.threads install url.
_________________________
Top
#201018 - 11/10/07 03:47 AM Re: Server Name issues [Re: Yarp™]
Gizmo Offline

Registered: 06/05/06
Posts: 15455
Loc: Portland, OR; USA
 Originally Posted By: blaaskaak
And you can always leave it in the subdir, and if somebody comes to the main url, redirect them to the ubb.threads install url.
I do that ;\)
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime Supporter, Beta Tester & Resident Post-A-Holic.
Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Top
#201021 - 11/10/07 08:42 AM Re: Server Name issues [Re: Gizmo]
toonarrow Offline
journeyman
Registered: 11/08/07
Posts: 99
Loc: New England
Sorry for wordiness. I wanted to be as specific as possible.

I actually prefer to do it the way Rick suggest. Mostly because this URL will never have other software. My main website is already created and have hyperlinks imbedded throughout to the root to which I'm trying to install. My host didn't have time to install, set up and configure in time for our Monday launch, which is why I reserved hosting space on GoDaddy (and they couldn't support hosting only a sub-domain, which was my hope, so I created a unique domain for forum). So, the main Web site has been changed so that all references to the forum point to the http://www.littlepilgrimsforums.com. Of course, I could have them change that Monday AM prior to launch to be http://www.littlepilgrimsforums/forums easily enough. I might have to do this, because I tried Rick's suggestion and I'm having issues.

I moved everything up to root. I edited the includes/config.inc.php file as per Rick's suggegstion. Now, when you go to root it would show UBB.threads hyperlinks, but none of the style etc (though I confirmed that all UBB folders had been moved successfully from /forums sub-directory and into the root directory). I've since moved everything back to the forums folder, and all is well on that sub-directory.

If I redirect, then I presume it would not require my developers on main site to update hyperlinks, correct? If the main Web site hyperlinks to the root domain, which is inturn redirect to sub-directory, all would be well, correct?

If so, I could use advice on how to redirect. I notice through the domain manger on godaddy I can forward, but I think redirecting is differnt. I tried to forward the main domain to the subdirectory, but the software called the subdirectory an invalid format for forwarding.
Top
Page 1 of 2 1 2 >



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Time zone setup
by skicomau
05/22/13 12:16 AM
Express hosting.
by Ruben
05/16/13 03:54 PM
Level of detail in new user registration emails
by Mitch P.
05/15/13 10:20 PM
Approving users
by Bert
05/15/13 09:22 PM
Users randomly added to other group
by Bert
05/15/13 09:15 PM
Forum Stats
10969 Members
36 Forums
33959 Topics
183413 Posts

Max Online: 978 @ 06/24/07 10:19 PM
Random Image