Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
database creation problem
Okay, so last time (using cpanel) setting up textpattern was a snap, with help from the manual. This time, I have spent hours trying to create the mysql database and its still a no go. I called my (budget) host and they don’t really know how to help. I have been getting a number of errors when trying to set up TXP, but mostly something like: Warning: mysql_connect(): Host ‘ci-uxangunq4jky’ is not allowed to connect to this MySQL server in c:\web\69.13.230.113\LocalUser\courtena\htdocs\textpattern\setup\index.php on line 181 Can’t connect to database.
When setting up the MySQL database, I have only three options:
DSN name: ( I have tried “textpattern”, but not really sure if that is right)
Server IP address or Hostname: (I have tried various, but from advice from the host, I have tried puting the IP address of the server the site is on)
*Database name:*( (I usually put “textpattern”)
When setting up TXP I have tried various, but mostly:
MySQL login: (since there is no place to set up password in MySQL setup, I have put the hosting account username, which the host seemed to think was right.)
MySQL password: (since there is no place to set up password in MySQL setup, I have put the hosting account username)
MySQL server: (the IP address of the server, “69.13.230.113”)
MySQL database: “textpattern”
Table prefix: blank
Full server path to Textpattern: (it usually gives me an address like c:\web\69.13.230.113\LocalUser\courtena\htdocs\textpattern, which seems like it cant be right. I have also tried, the address to the textpattern files: http://courtenaywebber.com/textpattern, to no avail).
Site URL: site url with path to textpattern
Any assistance would be much appreciated. I am a newbie at setting up databases, and this has taken way way longer then it should. This makes me remember the valiue of helpful hosts and intuitive hosting control panels.
Jeff.
Last edited by Jeff_K (2005-09-06 18:23:56)
Offline
Re: database creation problem
> Warning: mysql_connect(): Host ‘ci-uxangunq4jky’ is not allowed to connect to this MySQL
> server in
is mysql on the same server as the webserver?
If not, then you have to configure mysql such that you can connet to it from external servers. This is explained in the mysql manual.
Offline
Re: database creation problem
I believe it is on the same server. At least that is the impression that I got when I called tech support.
Offline
Re: database creation problem
In that case:
> MySQL server: (the IP address of the server, “69.13.230.113”)
try localhost instead of any IP.
Offline
Re: database creation problem
Sencer.
hmmfp:
Warning: mysql_connect(): Access denied for user: ‘courtena@localhost’ (Using password: YES) in c:\web\69.13.230.113\LocalUser\courtena\htdocs\textpattern\setup\index.php on line 181
Can’t connect to database
Same happens when I change c:\web\69.13.230.113\LocalUser\courtena\htdocs\textpattern\setup\index.php to http://courtenaywebber.com/htdocs/textpattern
I am wishing we would have gone with a better host right now..
Offline
#6 2005-09-06 19:26:24
- rene
- Member
- From: Switzerland
- Registered: 2004-03-27
- Posts: 67
Re: database creation problem
Did you create an user for the mysql database in cPanel? Just creating a database without assigning an user to it doesn’t work.
Last edited by rene (2005-09-06 19:26:46)
Offline
Re: database creation problem
>Warning: mysql_connect(): Access denied for user: ‘courtena@localhost’
That’s an improvement. You can now connect and talk with the server. However your db-password is wrong, or the db-username is wrong, or the privileges for that user are not set correctly.
Offline
Re: database creation problem
The control panel does not allow for the creation of a username, so I have been using the username for the hosting account (which the guy at tech support seemed to think would work). The control panel (unfortunately not cpanel but some arcaic copy) says:
“***For security reasons on a shared hosting server, passwords are not stored as part of the DSN and should be specified in your scripting code.***”
Offline
Re: database creation problem
> “For security reasons on a shared hosting server, passwords are not stored as part of the
DSN
That has nothing to do with this. You have to add a user to mysql or you have to grant the existing user rights to the table. Do you have any other way to access mysql for checking whether the user had the necessary credentials?
Offline
Re: database creation problem
There is certianly no way of setting up a username and password for databases within the host software’s control panel. If there is a way to sety up SLQ usernames with other software, I wouldn’t know. Maybe I should try tech support (again).. arrg. Thanks for the help sencer and rene.
Offline
Re: database creation problem
okay, well problem (sort of) solved. I just talked to the host, and we had to upgrade for MySql, as we were only getting SQL. Hopefully with the new account the set up will be easy. thanks again, and I will let you know how it goes…
Offline
Re: database creation problem
The upgrade worked like a charm.. The server doesn’t seem to accept an .htaccess file (uploading one seems to shut off the site), but I can live with messy urls for the time being.. Thanks for all the help RE: my questions.
Offline