GoDaddy and WoWRoster

Installation issues with WoWRoster

GoDaddy and WoWRoster

Postby yamahammer » Tue Feb 20, 2007 4:37 pm

I have seen many threads about mysql issues. My issue is the same as a lot of the others, i have mysql 4.0.x and needless to say, i get:
settings.php: line[132]
Could not connect to database "roster"
MySQL said:
1044: Access denied for user: 'wowchar@%' to database 'roster'
i sent a help request to godaddy and got-
"Unfortunately, we are currently running MySQL - 4.0.27 on our shared hosting accounts. At this time we do not have a estimated time on when we will be upgrading the MySQL version. If you would like to upgrade it yourself, you will need a Virtual Dedicated or Dedicated server."
Which means- "spend a lot more money and you can do whatever you want"
I am pretty sure i already know the answer to this... but for the sake of other people who are locked into godaddys hosting for whatever reason, i'll ask it anyway...
is there any work around? is there any possibility or hope to making wowroster work using gogdaddy?

*edit*
forgot to mention that you guys rock! You are a real asset to the WoW community:)
Last edited by yamahammer on Tue Feb 20, 2007 4:51 pm, edited 1 time in total.
yamahammer
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Tue Feb 20, 2007 4:29 pm

GoDaddy and WoWRoster

Postby zanix » Tue Feb 20, 2007 6:36 pm

There are a few places in Roster that use mysql 4.1 commands
I don't know where they are or if changing them would break anything because I do not develop on mysql 4.0 (I use 5.x)
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

GoDaddy and WoWRoster

Postby ScratchMonkey » Tue Feb 20, 2007 9:53 pm

What are you paying for that grade of hosting?

I just installed roster on my account at http://page-zone.com and it went pretty smooth. A basic account is $5/month. (Not sure if that will do what you want. I upgraded to the reseller account to get more domains and more storage.)

You can see my roster here:

http://sewingwitch.com/imajia/roster/

I need to upgrade roster from 1.7.2 to 1.7.3.

From the roster diag I can see that I'm running:

Apache/1.3.37 (Unix)
mod_auth_passthrough/1.8
mod_log_bytes/1.2
mod_bwlimited/1.4
FrontPage/5.0.2.2635.SR1.2
mod_ssl/2.8.28
OpenSSL/0.9.7a
PHP-CGI/0.1b
MySQL 4.1.21-standard
PHP 5.0.5
GD 2.0.28 compatible (bundled)

I had to tweak the upload_max_filesize setting to 8M using a .htaccess file.
Last edited by ScratchMonkey on Tue Feb 20, 2007 9:57 pm, edited 1 time in total.
User avatar
ScratchMonkey
WR.net Expert
WR.net Expert
 
Posts: 212
Joined: Wed Jul 05, 2006 4:32 pm
Location: San Pablo, CA

Re: GoDaddy and WoWRoster

Postby Vanterax » Tue Feb 20, 2007 10:27 pm

The weird thing is that i'm on GoDaddy as well and WoWRoster has always been working fine. And yes, I'm on 1.7.3...
Vanterax
WR.net Apprentice
WR.net Apprentice
 
Posts: 66
Joined: Wed Dec 13, 2006 6:58 am

GoDaddy and WoWRoster

Postby ScratchMonkey » Tue Feb 20, 2007 11:50 pm

What versions does your diagnostic report? Perhaps you're on a different physical host that has a different version loaded.
User avatar
ScratchMonkey
WR.net Expert
WR.net Expert
 
Posts: 212
Joined: Wed Jul 05, 2006 4:32 pm
Location: San Pablo, CA

GoDaddy and WoWRoster

Postby yamahammer » Wed Feb 21, 2007 5:35 pm

Thanks for the repsponse:)

PHP Version: Using: 4.3.11 Required: 4.3.0+
MySQL Module: Available: Yes Required: Yes
GD Module: Available: Yes Required: Optional

server version - 4.0.27-max-log
client version - 3.23.49

Is this my problem? Any suggestions on how to fix it?
yamahammer
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Tue Feb 20, 2007 4:29 pm

GoDaddy and WoWRoster

Postby ScratchMonkey » Wed Feb 21, 2007 9:09 pm

People tout that SQL is a standard, but I remain skeptical when it's so easy to get incompatible with different servers. (And SQL is only the language. It doesn't say anything about how the statements get in and out of the server, another big opportunity for vendors to break compatibility.)

Is there any move to create a well-supported subset of SQL that every server supports, so that any usage outside that subset can be easily identified and documented?

Ok, rant over. Back to your regularly scheduled programming. :P
User avatar
ScratchMonkey
WR.net Expert
WR.net Expert
 
Posts: 212
Joined: Wed Jul 05, 2006 4:32 pm
Location: San Pablo, CA

GoDaddy and WoWRoster

Postby Vanterax » Wed Feb 21, 2007 11:11 pm

I'm with GoDaddy as well. Diagnostic says:

OS Linux
Server Software Apache
MySQL Version 4.0.27-max-log
PHP Version 4.3.11
PHP API Type cgi-fcgi
safe_mode Off
open_basedir Off
allow_url_fopen On
file_uploads On
upload_max_filesize 20M

I have no problems at all with WowRoster 1.7.3.

Access denied for user: 'wowchar@%' to database 'roster'


Sounds like a permission issue... Or maybe the characters at the end are invalid.
Last edited by Vanterax on Wed Feb 21, 2007 11:14 pm, edited 2 times in total.
Vanterax
WR.net Apprentice
WR.net Apprentice
 
Posts: 66
Joined: Wed Dec 13, 2006 6:58 am

GoDaddy and WoWRoster

Postby jkibbles » Fri Feb 23, 2007 6:11 am

Also, check your mysql host in the install. I left it on localhost the first time and got a similar error. Godaddy uses a remote server for sql, wil show the info on the mysql manager window for the database you are using.
User avatar
jkibbles
WR.net Apprentice
WR.net Apprentice
 
Posts: 20
Joined: Wed Feb 21, 2007 7:05 am

GoDaddy and WoWRoster

Postby yamahammer » Fri Feb 23, 2007 6:06 pm

i checked the db login credentials and even created a new db just to triple check it. when i ran the diagnostics,i could not get the roasterdiag_sql to run at all.
rorsterdiag_sql-
Fatal error: Call to a member function on a non-object in /home/content/y/a/m/*username*/html/forum/roster/rosterdiag_sql.php on line 56
rosterdiag-
settings.php: line[132]
Could not connect to database "wowRoster"
MySQL said:
1044: Access denied for user: 'Roster@%' to database 'wowRoster'

I started from scratch again paying attention to permissions, but didn't see anything that didn't look right. im a little lost and possibly over my head here:(
yamahammer
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Tue Feb 20, 2007 4:29 pm

GoDaddy and WoWRoster

Postby zanix » Fri Feb 23, 2007 6:17 pm

rosterdiag_sql.php is not used in Roster anymore
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: GoDaddy and WoWRoster

Postby jkibbles » Fri Feb 23, 2007 10:03 pm

yamahammer wrote:i checked the db login credentials and even created a new db just to triple check it. when i ran the diagnostics,i could not get the roasterdiag_sql to run at all.
rorsterdiag_sql-
Fatal error: Call to a member function on a non-object in /home/content/y/a/m/*username*/html/forum/roster/rosterdiag_sql.php on line 56
rosterdiag-
settings.php: line[132]
Could not connect to database "wowRoster"
MySQL said:
1044: Access denied for user: 'Roster@%' to database 'wowRoster'

I started from scratch again paying attention to permissions, but didn't see anything that didn't look right. im a little lost and possibly over my head here:(


I'm assuming that the username is actually Roster@% as printed above. Try this. Instead of making a username with funky characters at the end to distinguish it from the dozen other roster type usernames, put the distinguishing marks at the beginning. For example, if your login for webhosting was jkibbles (don't bother trying it, people, that ain't the login for my db :D) make the username jkibbles_roster. Try running it that way, and see if it works. If not, contact me thru the board and I'll try giving you a hand. What I do know is that we are running the exact same version of mysql, and wowroster is giving me no problems on my server.
User avatar
jkibbles
WR.net Apprentice
WR.net Apprentice
 
Posts: 20
Joined: Wed Feb 21, 2007 7:05 am

GoDaddy and WoWRoster

Postby PleegWat » Fri Feb 23, 2007 10:44 pm

The @% is not part of the username. What is actually given is user@host. % is a wildcard meaning 'any character, any number of times', like * in DOS/Windows.
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm

Re: GoDaddy and WoWRoster

Postby Karavirs » Sat Mar 03, 2007 7:36 am

I'm on GoDaddy shared hosting and after a nice talk with the techs, (you catch more flies with sugar), I have access to 4.0, 4.1 and 5.0 MySQL db's.

If you are with GoDaddy and need to create a 4.1 or 5.0 db (you can mix and match them).
1. Logon to Hosting Manger
2. Goto MySQL Admin
3. Click on the Create Database Button
Here comes the trick
4. Modify that URL by adding the following ?mysql4150=TRUE
your url should look something like this
https://somehost.someserverfarm.net/MyS ... l4150=TRUE
5. You will now have a create database screen with the option for 4.1 or 5.0

Enjoy!!!
Image

Image
User avatar
Karavirs
WR.net Apprentice
WR.net Apprentice
 
Posts: 49
Joined: Mon Feb 26, 2007 6:33 pm
Location: Chicago

GoDaddy and WoWRoster

Postby Vanterax » Sun Mar 04, 2007 3:49 am

Oh that's some sweet trick. Thanks for sharing!
Vanterax
WR.net Apprentice
WR.net Apprentice
 
Posts: 66
Joined: Wed Dec 13, 2006 6:58 am

Next

Return to Installation

Who is online

Users browsing this forum: No registered users and 0 guests

cron