Setup textpattern for a godaddy user

jephlife · 2008-09-26 17:11:15

I’m far from a computer genius, and this is the first MySQL database I ever created. I tried following the textbook formats for my userID, etc.. on the initial textpattern setup screen where you enter your information, but it keep telling me it can’t connect to the server. I figure most likely I’m not entering the info in the right format, so I was wondering if anyone who has used textpattern with godaddy knows the correct format. I think I’m using the right host name because I followed this:

http://help.godaddy.com/topic/67/article/39

But I don’t know if I’m using the right format for my userID and password and database name…

Any suggestions?

jephlife · 2008-09-26 20:17:52

I feel like I’ve tried every format I could possibly enter it under. I tried just my username and database name. I tried adding my hosting userid before it in the format yourhostID_databaseUserID, like in the detailed installation instructions, but it still won’t connect.

If no one knows what format godaddy users need to use, does anyone know if there’s anything else that might be preventign me from connecting? Does it have to do with whether I install DNS on the database or not? I tried it both ways, but any tips would help.

jm · 2008-09-26 21:00:55

~~Make sure your MySQL host is correct. With GoDaddy, it’s usually something like xxxx.secureserver.net (it should say in your hosting panel).~~ Edit: Oops, I can’t read today.

Your GoDaddy db user should just be dbUserID without the hosting account prefix.

Last edited by jm (2008-09-26 21:03:48)

jephlife · 2008-11-12 06:59:13

Oddly, I still can’t log in. I dunno. Maybe I’ll just have to give up on textpattern. Sad.

Si · 2008-11-12 09:04:46

If you can’t login, it’s not the CMS you have to blame… You will have to configure the database connection for any other platform anyway

jephlife · 2008-11-12 18:15:45

You are certainly correct, Si. I didn’t mean to blame textpattern, so much as express that this situation is so annoying (entirely because of my host!). I am just midway through a contract, so switching hosts is not much of an option. Though, I would much prefer to keep using textpattern if possible.

Actually, I finally just got a response from godaddy, and they said that the problem is that a user can’t log on to their databases externally to their site! I imagine there must be a workaround, as I’ve seen people claim to use textpattern with godaddy. But I can’t imagine what… unless godaddy’s technical support was just wrong.

Anyone know if there is some easy manual way I can set up the database? Or some sneaky workaround solution?

Last edited by jephlife (2008-11-12 19:55:10)

THE BLUE DRAGON · 2008-11-14 09:55:51

Setup textpattern on Godaddy is not a problem at all!

1. login to Godaddy
2. click on ‘my hosting account’ under ‘hosting’ in the main menu
3. click on ‘Manage Account’ right to your hosting account
4. click on ‘Databases’ and then on ‘MySql’
5. click on ‘Create Database’
6. change ‘MySQL Version’ to 5.0

7. and fill it like this:
Description: blabla
MySQL Database/User Name: blabla
Enter New Password: qj1D9JFxjgRe30
(some crazy password with lowercase, uppercase & numbers)
Confirm New Password: qj1D9JFxjgRe30

8. click OK and wait like 20 minutes for the database will done setup and ready to use
9. after 20 minutes go again to ‘MySql’ under ‘Databases’ in ‘Manage Account’

10. you will now see your database with the status of ‘Setup’
click on the pen icon image under ‘Action’ (left to the X icon)
now you will see your ‘MySQL Database Information’

11. copy the ‘Host Name:’ (something like: p48p0mysql9.secureserver.net)
12. close all godaddy windows (you will not need it anymore from here.)
13. upload all the textpattern’s files to your server and launch the setup

14. enter your database info like this:
MySQL login: blabla
MySQL server: p48p0mysql9.secureserver.net
MySQL password: qj1D9JFxjgRe30
MySQL database: blabla
leave Table prefix empty
click on Next

15. copy the code into some txt file and rename it to config.php
16. upload the config.php file to your textpattern folder (not to the root folder!)
17. click on ‘I did it’
18. now create your admin login info and then login to textpattern, that’s it.

hope that’s help you

amora · 2009-03-23 20:27:56

jephlife, did you ever resolve your GoDaddy install problem? I’m helping a friend setup TXP with his GoDaddy hosting account, and I’m experiencing the same situation. I’ve used TXP many times, but always with MediaTemple and never had a problem connecting to a new database. The Blue Dragon’s instructions are thorough and clear, but still no luck for me. Hm…

amora · 2009-03-23 20:50:40

Here is my problem, in more detail:

I’ve used TextPattern many times and never had a problem setting up databases (with Media Temple) and installing TXP. But now I’m trying to help a friend and his domain/hosting is on GoDaddy. I’m getting the same errors as this thread.

Quoted from that thread:

“
Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server during query in […]/textpattern/setup/index.php on line 178
Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server during query in […]/textpattern/setup/index.php on line 180
Can’t connect to database

the “[function.mysql-connect]” is a link to a page that says this:
“config.php is missing or corrupt. To install Textpattern, visit textpattern/setup/”
“

Unfortunately, that question was resolved by the person who posted it (and it had to do with MT, not GD). I’m using TXP 4.0.8 and the database is MySQL 5.0; hosting OS is Linux.

Maybe I’m missing something obvious, any help is greatly appreciated. Thanks.

jephlife · 2009-03-23 22:43:09

I never ended up successfully installing on godaddy. I now use Dreamhost and everything works fine.

When I was having the trouble, I contacted godaddy and they told me that they set their mysql databases up so that they can not be accessed externally to their own mysql interface. They said that for this reason , I would not be able to login through textpattern.

I am no expert on databases, so I do not know if this is correct, but it is straight out of the horse’s mouth. On the other hand, others have claimed to have set up textpattern fine on their godaddy sites. This leads me to believe that some godaddy accounts might be compatible with txp and others not so much.

Below is the exact message that I got from godaddy:

“Thank you for your response. For us to provide any support on this issue we will need to see the full text of any error messages that you are receiving when setting this up. I am unfamiliar with textpattern, but if this is something that requires remote connection to the database you will not be able to use this on our shared hosting accounts. Unfortunately, we do not allow external connections to our database servers. When connecting to a database in your Shared Hosting account, you must access it through the Database section of the Hosting Control Center.

In case we need to reveal account specific information please also provide the 4 digit shopper PIN or the last 4 digits of a credit card on file.

Please let us know if we can assist you in any other way.”

THE BLUE DRAGON · 2009-03-24 14:17:43

1. try upload all textpattern’s files + the config.php with a FTP client program,
and not from the godaddy file manager.

2. check your config.php file see if all the info there is right
and check for case-sensitive.

3. check if you upload the config.php file to the right directory:
if your site is in the root folder (index.php,inages-directory and all the stuff is in the root)
so upload your config.php file to the ‘textpattern’ folder.
if your site is in an subdirectory name like “blabla-site” so upload the config.php file to: ‘blabla-site/textpattern/’

4. if you still have problems
you can email me your godaddy & ftp login info (change them later)
and I will try do it for you
(also email me the name of the database you want me to name it)

amora · 2009-03-24 17:04:20

Thanks, Blue Dragon. For this install, all the TXP files were loaded with an FTP.

But you are suggesting to create a config.php file on my own, and upload that with the setup? Basically, to cut the textpattern setup page out of the process? (I just want to be sure, since your previous, detailed post said to fill out the setup as usual.)

Thanks.

Textpattern CMS

Textpattern CMS support forum

#1 2008-09-26 17:11:15

Setup textpattern for a godaddy user

#2 2008-09-26 20:17:52

Re: Setup textpattern for a godaddy user

#3 2008-09-26 21:00:55

Re: Setup textpattern for a godaddy user

#4 2008-11-12 06:59:13

Re: Setup textpattern for a godaddy user

#5 2008-11-12 09:04:46

Re: Setup textpattern for a godaddy user

#6 2008-11-12 18:15:45

Re: Setup textpattern for a godaddy user

#7 2008-11-14 09:55:51

Re: Setup textpattern for a godaddy user

#8 2009-03-23 20:27:56

Re: Setup textpattern for a godaddy user

#9 2009-03-23 20:50:40

Re: Setup textpattern for a godaddy user

#10 2009-03-23 22:43:09

Re: Setup textpattern for a godaddy user

#11 2009-03-24 14:17:43

Re: Setup textpattern for a godaddy user

#12 2009-03-24 17:04:20

Re: Setup textpattern for a godaddy user

Board footer