:angry:

After getting online this morning, I get an ICQ Message from one of my customers saying


Hey Nick,

The new phpmysql version is messed up..... and I think mysql is messed up in general...

I'm trying to run a SQL query in telnet - as well as phpmysql and I'm getting errors...

The db/user are correct and the user is added to the db... and I'm still getting denies...


So I log into the customers phpMyAdmin and I can see all the databases.

I then go to create a table in one of the customers databases which has had a username and password created for it and get the message:


SQL-query:

CREATE TABLE nick (id TINYINT (3) not null , text1 MEDIUMTEXT not null , text2 MEDIUMTEXT not null , PRIMARY KEY (id), UNIQUE (id))
MySQL said: Access denied for user: 'CUSTOMER@localhost' to database 'CUSTOMER_db'


So it now seems that since the cpanel updates, if you create a user and password for a certain database, you cant access that database by going to

CPanel >> SQL >> phpMyAdmin

Anyone else noticed this?

:rolleyes: :mad:

Correction...

It now seems to be working in phpMyAdmin but not in the mysql comand prompt via ssh :(

I can't install vbulletin, getting 1044 access denied errors after completion of about 2/3 of the third part of the script (inserting and manipulating vbulletin tables). See below, caps substituted for actual values:

............

Altering word table

The script reported errors in the installation of the tables. Only continue if you are sure that they are not serious.

The errors were:

Error number: 1044

Error description: Access denied for user: 'USERNAME@localhost' to database 'DATABASENAME'

Originally posted by slinky
I can't install vbulletin, getting 1044 access denied errors after completion of about 2/3 of the third part of the script (inserting and manipulating vbulletin tables). See below, caps substituted for actual values:

Yeah - what cpanel are you running? Dark orb or VDI?

Im running dark orb - everything was fine until the new phpMyAdmin was introduced into cpanel :bawling: :mad:

Originally posted by Nicholas Brown


Yeah - what cpanel are you running? Dark orb or VDI? I have no idea -- I'm on a virtual host and don't know how to tell the difference. Just says CPanel 3 on the top right, logo on top left, dark blue outside, medium blue main page with white text. Either way... I'm stuck!!!:bawling:

Yeah, I have the Darkorb version and have the same problems :(

I had this problem yesterday then Nick tracked down this bug yesterday afternoon and built a release with the fix. Just run /scripts/upcp to update your Cpanel to the latest version. Also - if you still experience this issue after
updating, try adding/deleting a mysql username - this will reset the mysql perms for that user.

Regards

Craig

Thanks Craig. That did the trick :)

Originally posted by Craig
I had this problem yesterday then Nick tracked down this bug yesterday afternoon and built a release with the fix. Just run /scripts/upcp to update your Cpanel to the latest version. Also - if you still experience this issue after
updating, try adding/deleting a mysql username - this will reset the mysql perms for that user.Craig
THanks but I tried all that. My provider updated cpanel to the latest version, reset it, I deleted the database, creating a new one, created a new user, tried it all, same problem. Very odd...

slinky,

This might sound stupid, but are you entering the correct database user on the config.php file for vbulletin?

I mean, remember that with cpanel, your database user is a combination of your account user and the database user like this:
accoutusername_databaseusername

You might off course know this, but I just thought it was worth mentioning. ;)

Originally posted by bert
slinky,

This might sound stupid, but are you entering the correct database user on the config.php file for vbulletin?

I mean, remember that with cpanel, your database user is a combination of your account user and the database user like this:
accoutusername_databaseusername

You might off course know this, but I just thought it was worth mentioning. ;) Definitely worth mentioning and it solved problems for other people. Unfortunately, the answer is absolutely. I also edited the same config file settings that works for vb that I'm currently using at the same domain!!! (Yes, I also used a fresh copy of vbulletin 2.0.3 and edited that config too!) I'm trying a fresh install into a different directory, new database, different user. You name the combination and it just doesn't work. The fact that I'm on the same domain shouldn't matter and I've done this before. I'm entering the following:

database: accountusername_database2name
user: accountusername_newdbaseusername
password: newdbaseusernamepassword

Thanks so much for this. Nobody can figure this strange one out. :eek:

This is very strange. :eek:

Have you asked your host if anyone else is having these problems on their server(s) ?

Originally posted by bert
This is very strange. :eek:

Have you asked your host if anyone else is having these problems on their server(s) ? Yeah. They said they received a lot of calls after they updated the new cpanel. However, I'm not sure if I'm the only one with this particular problem.

You need to let them know again. By the looks of it, it has to do with the server and its configuration and not with you. They need to look into this for you.

Good luck :)

Last couple of days have been just awful with the cpanel issues. Lets hope that tonites fix's will sort out any problems that are left. Im sure the team is working hard to solve all of them.

Time is the greatest healer, aparrently.

Regards

Craig

Originally posted by Craig
Time is the greatest healer, aparrently.

Regards

Craig

I hope so :(

Originally posted by Nicholas Brown


I hope so :( Already fixed at Ventures Online. Those guys are unbelieveable, really. Apparently the bug from the new cpanel strikes....

Hey,
To fix the problem, just re-grant your table permisions for each user.. a pain i agree.. but the only fix :)

Originally posted by kunal
Hey,
To fix the problem, just re-grant your table permisions for each user.. a pain i agree.. but the only fix :)

Yes, but this is cpanels fault and I personally dont fancy doing this for every single user :(

Do the math... 200-250 users on a box, most having plans that include at least 5 databases ... erm ... frightening :(

Nicholas, did you run the update script and didn't get fixed?

Originally posted by bert
Nicholas, did you run the update script and didn't get fixed?

Im in the middle of running it now. If this doesnt fix it, Im gonna cry :bawling:

That fixed it for me. A little scary though. :(

Originally posted by bert
That fixed it for me. A little scary though.

:D :D :D :D :D :D :D
YAY! It works. Your safe cpanel team, for now BWAHAHA j/k :)

See, I told you :D

Glad it worked out for you.

Is there a command I can type to see which build is on my box?

edit: found it..just cat /usr/local/cpanel/version

If you see 3.8.0-STABLE_31, you got the latest.

Spoke to soon.

My user just tried it via SSH and it is returning a MySQL 1044.

I told you I was going to cry.....:bawling:

Nicholas, why don't you contact your upstream ?

Originally posted by bert
Nicholas, why don't you contact your upstream ?

Our NOC doesnt supply us with cpanel :)

My customer deleted the username and database and added them again and it seems to be working ok now.

If I get any more problems, I'll have to contact our supplier <sigh>

Originally posted by Nicholas Brown


Our NOC doesnt supply us with cpanel :)

My customer deleted the username and database and added them again and it seems to be working ok now.

If I get any more problems, I'll have to contact our supplier <sigh> I did this 5 times. It does not work for most. The update needs to be applied and, in certain cases, only the host can modify this so that it works properly. Very uncool situation.

Originally posted by slinky
I did this 5 times. It does not work for most. The update needs to be applied and, in certain cases, only the host can modify this so that it works properly. Very uncool situation.

I am the host ;)
Your right, it is a very uncool situation :(

Please send problem reports to nick@darkorb.net AFAIK everything is working ok. If not then I'll help you out ASAP.


If you want to get access to the beta builds, just PM, AIM:bdraco, ICQ:605408, or email me and I will send you access information.

You could also post a message to http://support.cpanel.net

Originally posted by bdraco
Please send problem reports to nick@darkorb.net AFAIK everything is working ok. If not then I'll help you out ASAP.


If you want to get access to the beta builds, just PM, AIM:bdraco, ICQ:605408, or email me and I will send you access information.

You could also post a message to http://support.cpanel.net

Thanks Nick.

It appears to be all ok now :)

Cheers :)