mysql issue

technobabble

I was upgrading my WHMCS billing software and ran into this errror:

SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared (SQL: select distinct setting, value from tblconfiguration)

According to the Billing software support, I need to increase the value of table_definition_cache in the server MySQL configuration.

I use WHM/cPanel and really don't know where to start. My googling hasn't helped much either.

scottalanmiller

Do you not have access to your server at all? No way to issue commands to it? Do you run your own? Why do you have cpanel in front of your database?

technobabble

Scott, it's a standard VPS server with WHM/cPanel that I use to host my client's websites.

I remember having to use Putty to access the mysql years ago for a tweak in vBulletin and to do manual backups.

I reinstalled my backup and will worry about the upgrade after I have moved to an updated WHM/cPanel account at A Small Orange.

scottalanmiller

@technobabble said:

Scott, it's a standard VPS server with WHM/cPanel that I use to host my client's websites.

A standard VPS you would have SSH access to and you can do anything that you want. I've never see a VPS that didn't act like a VPS. In fact, if you don't have that access, I'm not sure it technically even qualifies as a VPS. It's just a non-shared web hosting VM.

scottalanmiller

@technobabble said:

I remember having to use Putty to access the mysql years ago for a tweak in vBulletin and to do manual backups.

Then hopefully you just need to remember your login

Is cPanel handling your OS updates?

technobabble

@scottalanmiller said:

@technobabble said:

Scott, it's a standard VPS server with WHM/cPanel that I use to host my client's websites.

A standard VPS you would have SSH access to and you can do anything that you want. I've never see a VPS that didn't act like a VPS. In fact, if you don't have that access, I'm not sure it technically even qualifies as a VPS. It's just a non-shared web hosting VM.

Of course I have SSH access. Doesn't mean I remember how to access it or use it. However now I have something to work with!

technobabble

@scottalanmiller said:

@technobabble said:

I remember having to use Putty to access the mysql years ago for a tweak in vBulletin and to do manual backups.

Then hopefully you just need to remember your login

Is cPanel handling your OS updates?

The OS updates have to be done outside of WHM...which is why my WHM/cPanel updates are not up to date. Moving versus updates gets me a newer hardware!

scottalanmiller

@technobabble said:

@scottalanmiller said:

@technobabble said:

Scott, it's a standard VPS server with WHM/cPanel that I use to host my client's websites.

A standard VPS you would have SSH access to and you can do anything that you want. I've never see a VPS that didn't act like a VPS. In fact, if you don't have that access, I'm not sure it technically even qualifies as a VPS. It's just a non-shared web hosting VM.

Of course I have SSH access. Doesn't mean I remember how to access it or use it. However now I have something to work with!

I thought that the whole post was about lacking SSH access and needing to do this without it

scottalanmiller

@technobabble said:

@scottalanmiller said:

@technobabble said:

I remember having to use Putty to access the mysql years ago for a tweak in vBulletin and to do manual backups.

Then hopefully you just need to remember your login

Is cPanel handling your OS updates?

The OS updates have to be done outside of WHM...which is why my WHM/cPanel updates are not up to date. Moving versus updates gets me a newer hardware!

Shouldn't you be updating as well? Having an unpatched server is problematic. I would update at least weekly.

technobabble

@scottalanmiller said:

@technobabble said:

@scottalanmiller said:

@technobabble said:

Scott, it's a standard VPS server with WHM/cPanel that I use to host my client's websites.

A standard VPS you would have SSH access to and you can do anything that you want. I've never see a VPS that didn't act like a VPS. In fact, if you don't have that access, I'm not sure it technically even qualifies as a VPS. It's just a non-shared web hosting VM.

Of course I have SSH access. Doesn't mean I remember how to access it or use it. However now I have something to work with!

I thought that the whole post was about lacking SSH access and needing to do this without it

Nope...wanted people to know although it was a linux box, it was used only for webhosting using the WHM/cPanel software. Sorry for the confusion.

scottalanmiller

Gotcha, a bit of a red herring there. Doesn't really play into the issue

scottalanmiller

So first step, get onto the box using SSH.

technobabble

Roger that!

scottalanmiller

Now I'm not 100% sure where that setting is tuned, my guess is that it is done so using SQL direction from the MySQL client.

stacksofplates

looks like you might be able to do this

mysql -u <username> -p <password>

then at the prompt

mysql>show global variables like 'table%';
+-------------------------+--------+
| Variable_name           | Value  |
+-------------------------+--------+
| table_definition_cache  | 256    | 
| table_lock_wait_timeout | 50     | 
| table_open_cache        | 64     | 
| table_type              | MyISAM | 
+-------------------------+--------+

mysql> SET GLOBAL table_definition_cache=128;

you can replace 128 with whatever you need.

scottalanmiller

There you go, that should do it!