Topic: godaddy hosting  (Read 8518 times)

Pages: [1] 2  All   Go Down

#1: 27-Jul-2008, 07:27 AM

kathleenread
Posts: 87

i see this has been talked about, apologies in advance still not getting it. am setting up a test modx site on godaddy, found the thread about needing your database details handy when you get to installing modx. tis my first time at something like this so pls be kind...

database name [ok, i know this one, or do i think what goes in here is for db login name?]
table prefix [do i leave this as 'modx_' ?]
collation [am not gonna touch this one]

database host [this is where i'm putting in 'p41mysqletcetc.secureserver.net']
db login name: [same as db name above?]
db password: [no worries with this]

am getting 'Connection to host: failed!' no matter what permutation of this info i try...
help?

#2: 27-Jul-2008, 07:36 AM

Coding Team

sottwell
Posts: 10,494

WWW
The name of the database may not be the same as your username for logging in to the database. Usually the database name is some permutation of your domain name and your login name; mine for one host was sottwe_sottwe, since I always go by sottwell, and my domain is of course sottwell.com, but they only used the first six letters.

Collation is not a big deal, are you using utf-8 or one of the iso-8859 character sets? Once you can get a connection, you'll be able to select from a list of what's available for your database; the list varies depending on the configuration of MySQL. Collation itself has to do with how things are sorted; in some languages A may not be the first letter of its alphabet, and in others the same letter can be in a different location in a sorted list depending on the region. Alphabets like Hebrew, even in utf-8, can be complicated by the fact that there are no vowels, but vowels can be indicated by dots and various other little markings, or not. This can complicate sorting, and using the correct collation type is important. In English, it doesn't really matter.

The prefix can be anything you want; it will be prepended to all of the MySQL tables, so if you have only the one database and want to run the SMF forums as well, you can have modx_users and smf_users; both users tables, but no confusion because of the prefix.
« Last Edit: 27-Jul-2008, 07:42 AM by sottwell »
sottwell.com has moved to a lovely Solaris 10 server!
Log in username guest, password guestuser.
Templates are now becoming available at http://sottwell.com/templates.html

#3: 27-Jul-2008, 08:07 AM

kathleenread
Posts: 87

thank you so much for your email, today is my first day of hitting a forum and i'm stunned at how helpful people are...
do you think then to find the name of my database that's something i need to ask godaddy for?
relating to 'are you using utf-8 or one of the iso-8859'... i had to google that to try to understand the question... and... i don't know... [i can design static websites only for cms ones i've had the good fortune of a programmer who makes them 'work', am trying to learn to do it myself hence what i'm sure is my remarkable ignorance].
i think i'll ask godaddy for the database name as i'm not seeing any more details other than the ones i mentioned below. would that sound like a plan?

#4: 27-Jul-2008, 08:50 AM

Coding Team

sottwell
Posts: 10,494

WWW
Yes, they should be able to help you with which is what  Grin
sottwell.com has moved to a lovely Solaris 10 server!
Log in username guest, password guestuser.
Templates are now becoming available at http://sottwell.com/templates.html

#5: 27-Jul-2008, 08:55 AM

kathleenread
Posts: 87

yr a gem, thank you again for sharing your time and help, really appreciate it. big teethy smile back atcha.   Grin

#6: 28-Jul-2008, 07:04 AM

kathleenread
Posts: 87

so... i've had no joy, as yet, getting modx working on my godaddy server. would anyone [sottwell, are you there? Wink ] be willing to take a look at my screen grabs of what i'm putting in the fields and the screen of my database set up? i emailed godaddy and they said to put in kathleenread as my db name. have tried unsuccessfully... i have no doubt it's me missing something super simple. might be able to provide you with a chuckle at my naivite...

#7: 28-Jul-2008, 09:53 AM

Coding Team

sottwell
Posts: 10,494

WWW
go ahead... if I'm not around, somebody will be.

From what you've said, it should look like the attached screenshot...


* database-info.jpg (70.5 KB, 661x359 - viewed 411 times.)
« Last Edit: 28-Jul-2008, 10:00 AM by sottwell »
sottwell.com has moved to a lovely Solaris 10 server!
Log in username guest, password guestuser.
Templates are now becoming available at http://sottwell.com/templates.html

#8: 29-Jul-2008, 06:19 AM

kathleenread
Posts: 87

thank so much again, think you folks are far away[?] otherwise i'd buy you a beer for your time. more than 1 beer i think! yep, my login screen looks like that. i think it must be the 'database login name' that i'm messing up then. i'm trying everything i can think of. both my database name and user name for that account are kathleenread, so have tried that again. then tried my godaddy login number. i think maybe time for me to hit godaddy again... lordy knows what questions i'll have when i actually really get into using this if i can't even set up my db properly!! Wink if you think of anything i might be missing, pls sing out, i'll check back in the interim while i wait to hear from godaddy. thanks Smiley

#9: 4-Aug-2008, 07:41 AM

kathleenread
Posts: 87

i've been trying [unsuccessfully] since my last post to get modx working on my godaddy hosting. have reuploaded the files in case i messed that up... created a new database in case i messed that up... reentered passwords for my database in case i messed that up... and still having no joy...
i've emailed godaddy and they replied: 'We will need to know the permissions that the database requires in order to determine why you are unable to connect to the database. As this is not our product, we are not aware of the permission requirements.'
does anybody know what they would need information-wise in response to that? susan ottwell and bob ray, you were both kind enough to help me in the past with starting to get this sorted out, if you or any other nice folk would be inclined, i'd be very grateful if you would have a stickybeak around my files [am happy to email to email my ftp details, could give you my email address so yours wouldnt have to be shown to everyone] and see if i'm missing something? because i am stumped. again, am sure it's me, no doubt at all that i'm missing something, just not sure what...   Undecided

#10: 4-Aug-2008, 09:05 AM

Coding Team

sottwell
Posts: 10,494

WWW
All MODx needs is the basics: server, database name, username, password. It uses standard PHP mysql functions for connecting and selecting a database.
sottwell.com has moved to a lovely Solaris 10 server!
Log in username guest, password guestuser.
Templates are now becoming available at http://sottwell.com/templates.html

#11: 4-Aug-2008, 03:10 PM

ryanlwh
Posts: 19

Is it possible for you to post the godaddy database setup screen (or summary)?

#12: 5-Aug-2008, 03:41 AM

Coding Team

BobRay
Posts: 5,288

WWW
i've been trying [unsuccessfully] since my last post to get modx working on my godaddy hosting. have reuploaded the files in case i messed that up... created a new database in case i messed that up... reentered passwords for my database in case i messed that up... and still having no joy...
i've emailed godaddy and they replied: 'We will need to know the permissions that the database requires in order to determine why you are unable to connect to the database. As this is not our product, we are not aware of the permission requirements.'
does anybody know what they would need information-wise in response to that? susan ottwell and bob ray, you were both kind enough to help me in the past with starting to get this sorted out, if you or any other nice folk would be inclined, i'd be very grateful if you would have a stickybeak around my files [am happy to email to email my ftp details, could give you my email address so yours wouldnt have to be shown to everyone] and see if i'm missing something? because i am stumped. again, am sure it's me, no doubt at all that i'm missing something, just not sure what...   Undecided

Kathleen, if you're getting a message during the MODx install saying it can't connect to the database, it's not a permission issue. It almost always means that the info in modx's config.inc.php (in the /manager/includes dir.)  doesn't match what's in your database.

One problem I had when I first used MODx was that I created the database but hadn't actually created a USER in the database. The screens to do this can be confusing and it's easy to think you've created a user without doing it (or to assume that you are automatically the user).

On the cPanel at my host, you select "MySQL Databases"  Then select the modx db, then scroll down to enter the username and password and click on "add user." It will tell you that the user has been created but it will lie to you about the username. When you go back to the original MySQL Databases page, you'll see the real username, usually prefixed with your username at the host. You'll also see the real name of the DB there.  Those values, and the password you just created, are what go in the config.inc.php file. It will typically look something like this assuming that kread is the name you use to log on to your Cpanel, modx is the name you gave the dbase, JoeBlow is your new user, and his password is BiteMe. Remember that everything is case-sensitive.

Code:
$database_type = 'mysql';
$database_server = 'localhost';
$database_user = 'kread_JoeBlow';
$database_password = 'BiteMe';
$database_connection_charset = '';
$dbase = 'kread_modx';
$table_prefix = 'modx_';
error_reporting(E_ALL & ~E_NOTICE);

Hope this helps.
MODx info for newbies: http://bobsguides.com/MODx.html

#13: 5-Aug-2008, 06:58 AM

kathleenread
Posts: 87

thanks very much to all of you for your help, i really appreciate it. i found a blog just now where someone was having trouble setting up wordpress with godaddy and in the end they found out that godaddy's windows packages don't support php [?] i have a windows one so i've just changed it over to linux to see if that'll help things. can take up to 72 hours though to take effect so will be a while b4 i can say if it worked.

i had a look bob b4 i got the wheels in motion to change to linux, to see if i could add a user as you suggested. i think with godaddy that the database name is the same as the username [or maybe this is where you think i could be confused?]. i've put a screenshot up at http://chillischnapper.com/database_setup.png of the fields i fill in when setting up a db with godaddy. then to get the details of the database i get the screen like http://chillischnapper.com/godaddy.png [so the bold headings on the right have the relevant info one line lower on the left]. so to put that into my modx installation fields i'd do... http://chillischnapper.com/modx.png to no avail.

so i'm crossing my fingers that it is a windows problem although i had read windows was fine for modx, might just be a godaddy thing. i hope!! again, i am very grateful to you all for taking the time to help. will let you know how i fare...  Roll Eyes

#14: 5-Aug-2008, 07:37 AM


Breezer
Posts: 533

The steps you took in images you provided is exactly how you will set it up once the server switch is done to the linux package. Smiley
If you wake up breathing, it's a good day...

#15: 5-Aug-2008, 07:53 AM

kathleenread
Posts: 87

thanks breezer! will get there one day. am seeing how very 'holey' my knowledge about things is. i now have a 'php for dummies' book sitting on my kitchen table ready for me, otherwise i will fill the forums!! Wink

#16: 5-Aug-2008, 12:31 PM

ryanlwh
Posts: 19

I think MySQL is also not supported on most Windows hosting packages.

#17: 6-Aug-2008, 05:24 AM

kathleenread
Posts: 87

houston we have lift off!! it's working with the change to linux from windows. thanks so much to you all again for your help!  Grin

#18: 6-Aug-2008, 06:03 AM

kongondo
Posts: 1,390

Nice one! would love to see the site when its up n running  Wink

#19: 6-Aug-2008, 11:40 AM

Coding Team

BobRay
Posts: 5,288

WWW
Congratulations. It should be a comfort to know that you weren't actually doing anything wrong (except getting Windows hosting).  Grin

Bob
MODx info for newbies: http://bobsguides.com/MODx.html

#20: 7-Aug-2008, 06:47 AM

kathleenread
Posts: 87

yes indeed. i was pulling my hair out, have not got a great deal of confidence in my skills in this area so it was unreal to install it and see it work!! lordy knows how many posts i'll make if i had that much trouble getting it up and running! might need bigger storage area for the forum... Wink
and thanks kongado! for the mo i'm just mucking around with different things to see what does what and how it all fits together. tonight i tackle ditto... have got a site in the pipeline though that i'm keen to use modx on so will show you when [if!] done. cheers all Smiley
Pages: [1] 2  All   Go Up
0 Members and 1 Guest are viewing this topic.