mysql issue



  • 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.



  • 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?



  • 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.



  • @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.



  • @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?



  • @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!



  • @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!



  • @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 🙂



  • @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.



  • @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.



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



  • So first step, get onto the box using SSH.



  • Roger that!



  • 🙂 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.



  • 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.



  • There you go, that should do it!


Log in to reply