Mysql Character Set / Collation Problem (Cpanel)

Jun 7, 2008

We just had a new dedicated server with FreeBSD + Cpanel.

After the installation, one problem is that Mysql doesn't have some international character sets /collation included such as Big5, gbk, ujis which are mostly for Asian language. Is this normal for Cpanel installation? I got a response from Cpanel stating this is a default setting for Mysql. Because we have lots Asian customers, it there any way can include new international character set /collation without reinstalling Cpanel?

View 0 Replies


ADVERTISEMENT

Mysql Character Set / Collation (Cpanel)

Jun 7, 2008

dedicated server with FreeBSD + Cpanel.

After the installation, one problem is that Mysql doesn't have some international character sets /collation included such as Big5, gbk, ujis which are mostly for Asian language.Is this normal for Cpanel installation? I got a response from Cpanel stating this is a default setting for Mysql. Because we have lots Asian customers, it there any way can include new international character set /collation without reinstalling Cpanel?

View 1 Replies View Related

Mysql Collation

Jun 20, 2007

I have problem with my mysql server. If i install a web application ( IPB, VBB ... ) set mysql collation in utf8_general_ci so have problem with font of my board.

Now is the question : how can i set the mysql collation from utf8_general_ci to latin1_swedish_ci ? So, after, if i start to install a web application, was the collation in latin1_swedish_ci by default.

Dedicated Server, full root access
Mysql 4.1.13
Suse 10

View 3 Replies View Related

Unexpected Character In Input: (ASCII=26) State=1 In /usr/local/cpanel/cgi-sys/ph

Apr 3, 2008

i add the php5 and set php4 as cgi from whm,

after finisging,

it takes errors

Warning: Unexpected character in input: (ASCII=26) state=1 in /usr/local/cpanel/cgi-sys/php4 on line 864

Warning: Unexpected character in input: (ASCII=8) state=1 in /usr/local/cpanel/cgi-sys/php4 on line 864

Parse error: syntax error, unexpected '?' in /usr/local/cpanel/cgi-sys/php4 on line 864

View 2 Replies View Related

Database Collation

Sep 15, 2007

For some reason i cant read anything written in Russian language in my database thru Phpmyadmin.

I guess it has something to do with connection/database collation char sets but which one exactly ?

My current Phpmyadmin char sets are

character set client utf8
(Global value) latin1
character set connection utf8
(Global value) latin1
character set database latin1
character set filesystem binary
character set results utf8
(Global value) latin1
character set server latin1
character set system utf8
character sets dir /usr/local/mysql-5.0.x-freebsd6.x-i386/share/mysql/charsets/
collation connection utf8_unicode_ci
(Global value) latin1_swedish_ci
collation database latin1_swedish_ci
collation server latin1_swedish_ci

View 3 Replies View Related

Plesk 11.x / Windows :: Regional Settings And MSSQL Collation

Apr 28, 2014

We received the following request from customer in order for his website to function properly:

Go to the control panel of your Windows Server change Regional Settings so that the default language iS Greek.

Also, change the collation of Microsoft SQL Server to Greek-Accent Insensitive-Case Insensitive.

Will these create any problems to the rest of the websites that are hosted on the server? And if no, how to change the collation of the Microsoft SQL Server?

View 3 Replies View Related

Weird Character Spam. Any Way To Stop It

May 15, 2008

I have been receiving a LOT more "unusual character" spam, where the entire email consists of something like this: .....

View 5 Replies View Related

Apache :: Latin Character Support In UI

Mar 25, 2013

There is a requirement by the customer In order to display latin characters correctly in the UI, we need to add charset information in httpd.conf file.

We have added the AddDefaultCharset UTF-8 in httpd.conf.

Even after adding the above charset in httpd.conf the changes was not reflecting.

And there was a reply by the customer that : Even after adding those lines to httpd.conf file, I am not getting characters (like ö, ä, ü) properly sent to my application.

This works perfectly fine in my local system where I am not using apache web server. But fails when I deploy the same code to QA, where the Apache webserver is used.

View 4 Replies View Related

Japanese Character Encoding In Auto Emails

Jan 30, 2009

We been working on building a Japanese site for some time now. We finally finished off and are in the testing stage. Through out the development of the site we've been having trouble with way that Japanese characters display in our auto emails. The problem is, neither us nor programming we team work with are Japanese. And there is very little to no information about this in English.

We've had issues where.

garbled text show up in one or two fields of an email (title/subject/body) but displays fine in others.

garbled text show up in one email account type (yahoo) and not in another (gmail).

Recently one point which really puzzled us, is that we have some auto emails (specific emails from our system to our users relating to topic) that show up fine in all email account types. Yet some emails generated for the same system with basically the same mix of character types have errors. Could this be and error on our part in the incorrect implementation of a coding method that has worked before?

We are using UTF-8 character set now.

View 1 Replies View Related

Unexpected Character Input Error When Running Php4 And Php5 Together

Jul 21, 2008

CentOS - I had php4 running and php5 as cgi but then decided I wanted to have it the other way around i.e. run php5 standard and php4 as cgi.

php5 is now running fine but php4 bombed with this error:

Code:
Unexpected character in input: '?' (ASCII=15) state=1 in /usr/local/cpanel/cgi-sys/php4
I fixed it by doing the following:

EDIT php.ini file:
Normally in /usr/local/php4/lib/php.ini

Under
;;;;;;;;;;;;;;;;;;;;;;;;;
; Paths and Directories ;
;;;;;;;;;;;;;;;;;;;;;;;;;

UNCOMMENT this line

Code:
;cgi.fix_pathinfo=0
(i.e. remove the ";" infront)

and
CHANGE 0 to 1:

Code:
cgi.fix_pathinfo=1
This is for Linux and must be done with root via SSH

Not sure if this will help anyone, but I thought I'd post it anyway.

View 0 Replies View Related

I Moved Mysql From /var To /backup/mysql, Mysql Is No Longer Working

May 8, 2009

Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.

Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..

View 4 Replies View Related

How To Use External CPanel Mysql In Another CPanel Server

Mar 14, 2007

I have 2 servers both have cpanel. I want to use 2nd server's mysql in my site which is on 1st server. I think thats not that hard. I don't wanna do clustering as this is temproary.

View 2 Replies View Related

Installed MySQL In /usr/local/mysql But Error In /var/lib/mysql

Jan 21, 2007

I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:

Code:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2
However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?

View 1 Replies View Related

Mysql/cpanel

Aug 13, 2007

I accidentally clicked upgrade to 5.0 from 4.1 in Cpanel.
Then I ran the update to latest version.

EVERYTHING BROKE!

Sites can't connect to mysql anymore, and also during the update, I'm getting:

Code:
md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e)
Download Failed... trying again...in....60....59....58....57....56....55....54....53....52....51....50....49....48....47....46....45....44....43....42....41....40....39....38....37....36....35....34....33....32....31....30....29....28....27....26....25....24....23....22....21....20....19....18....17....16....15....14....13....12....11....10....9....8....7....6....5....4....3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cgi-sys/formmail.cgi (0)....@74.200.65.162......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e)
...skipping 74.200.65.162...Download Failed... trying again...in....60....59....58....57....56....55....54....53....52....51....50....49....48....47....46....45....44....43....42....41....40....39....38....37....36....35....34....33....32....31....30....29....28....27....26....25....24....23....22....21....20....19....18....17....16....15....14....13....12....11....10....9....8....7....6....5....4....3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cgi-sys/formmail.cgi (0)....@75.126.236.226......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e)
Download Failed... trying again...in....60....59....58....57....56....55....54....53....52....51....50....49....48....47....46....45....44....43....42....41....40....39....38....37....36....35....34....33....32....31....30....29....28....27....26....25....24....23....22....21....20....19....18....17....16....15....14....13....12....11....10....9....8....7....6....5....4....3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cgi-sys/formmail.cgi (0)....@75.126.236.226......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e)
Download Failed... trying again...in....60....59....58....57....56....55....54....53....52....51....50....49....48....47....46....45....44....43....42....41....40....39....38....37....36....35....34....33....32....31....30....29....28....27....26....25....24....23....22....21....20....19....18....17....16....15....14....13....12....11....10....9....8....7....6....5....4....3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cgi-sys/formmail.cgi (0)....@75.126.236.226......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e)
...skipping 75.126.236.226...Download Failed... trying again...in....60....59....58....57....56....55....54....53....52....51....50....49....48....47....46....45....44....43....42....41....40....39....38....37....36....35....34....33....32....31....30....29....28....27....26....25....24....23....22....21....20....19....18....17....16....15....14....13....12....11....10....9....8....7....6....5....4....3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cgi-sys/formmail.cgi (0)....@69.90.250.34......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e)
Download Failed... trying again...in....60....59....58....57....56....55....54....53....52....51....50....49....48....47....46....45....44....43....42....41....40....39....38....37....36....35....34....33....32....31....30....29....28....27....26....25....24....23....22....21....20....19....18....17....16....15....14....13....12....11....10....9....8....7....6....5....4....3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cgi-sys/formmail.cgi (0)....@69.90.250.34......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e)
Download Failed... trying again...in....60....59....58....57....56....55....54....53....52....51....50....49....48....47....46....45....44....43....42....41....40....39....38....37....36....35....34....33....32....31....30....29....28....27....26....25....24....23....22....21....20....19....18....17....16....15....14....13....12....11....10....9....8....7....6....5....4....3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cgi-sys/formmail.cgi (0)....@69.90.250.34......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e)

View 6 Replies View Related

CPanel DNS Only, Now Cant Install PHP, MySQL Etc

Jul 18, 2009

i am running a VPS and recently installed cPanel DNS Only so it can operate as a standalone DNS server.

I would also like to serve standard webpages on it via apache and php, i therefore tired to install php, mysql etc via 'yum install php' but it says there is no package to be installed.

Has the cPanel DNS only install done someting to the yum config? I have installed Yum Priorities plugin, and my repos files are as follows:


Code:
root@stripe [~]# yum list installed | grep httpd
httpd.i386 2.2.3-22.el5.centos.1 installed
root@stripe [~]# yum list installed | grep php*

root@stripe [~]# cat /etc/yum.repos.d/CentOS-Base.repo
# CentOS-Base.repo
#
# This file uses a new mirrorlist system developed by Lance Davis for CentOS.
# The mirror system uses the connecting IP address of the client and the
# update status of each mirror to pick mirrors that are updated to and
# geographically close to the client. You should use this for CentOS updates
# unless you are manually picking other mirrors.
#
# If the mirrorlist= does not work for you, as a fall back you can try the
# remarked out baseurl= line instead.
#
#

[base]
name=CentOS-$releasever - Base
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os
#baseurl=http://mirror.centos.org/centos/$releasever/os/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5
priority=1

#released updates
[updates]
name=CentOS-$releasever - Updates
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=updates
#baseurl=http://mirror.centos.org/centos/$releasever/updates/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5
priority=1

#packages used/produced in the build but not released
[addons]
name=CentOS-$releasever - Addons
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=addons
#baseurl=http://mirror.centos.org/centos/$releasever/addons/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5
priority=1

View 3 Replies View Related

Backup In CPanel/WHM Without Mysql

Apr 14, 2009

The automatic backups you can setup in cpanel/whm bundle the entire user account. Is it possible for it to save everything except the mysql databases?

I have an account that has databases over 5GB+ and would like to handle backing those up separately.

View 6 Replies View Related

Copying Mysql Db In Cpanel

Oct 18, 2009

is there a way to copy mysql from an existing db, and then renaming it to another name?

I would like to copy my current db from a live forum site, and because I got a test forum but I need that test forum to use my current live db...but i want it to use a copy of the live db. The db has to be a different name for the test site. Sorry hard for me to explain.

Is there an easy way to do that? I would do it via cpanel backup and upload but the db is 2gb's gzip....

I can do it via ssh or whm as well.

View 2 Replies View Related

CPanel MySQL/Clamav

Dec 11, 2008

A few weeks ago I installed clamav using the cPanel "Manage Plug-Ins". It all seemed fine but my server load kept going ridiculously high. I couldn't work out what was wrong until I managed to get a ps aux when it was very high and found that clamd was using ridiculous amounts of memory/cpu. It's not such a big deal having it on my server, so I decide to uninstall it. After uninstalling it, MySQL started to randomly turn off regularly (around every 30 minutes). I tried forcing a cPanel update, updating the MySQL files, reinstalling MySQL, etc. but nothing has seemed to fix it. So as a last resort, I've reinstalled Clamav and now my MySQL is fine but my server load keeps going ridiculously high again; causing problems still.

Has anyone/cPanel ever experienced this problem? I need to find a solution as almost every account on my server uses MySQL as a basis for their website, so I can't have it going down even for less than a minute.

View 2 Replies View Related

How To Reinstall Mysql Using Cpanel

Oct 27, 2008

or reinstall mysql in SSH,

View 6 Replies View Related

Upgrading CPanel's MySQL

Feb 3, 2008

I'm trying to upgrade to MySQL 5 from MySQL 4.1, did the change on WHM Tweak Settings and then run /scripts/mysqlup but i get this error:

the installer version: cPPkgs::MySQL 5.0.45 installer for Linux

Fetching http://httpupdate.cpanel.net/mysqlinstall/5.0.45-0/centos/5/MySQL-server-5.0.45-0.glibc23.i386.rpm (0)....@69.72.164.152......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
Preparing... ########################################### [100%]
error: install: %pre scriptlet failed (2), skipping MySQL-server-5.0.45-0.glibc23
running:

rpm -ivh MySQL-server-5.0.45-0.glibc23.i386.rpm
give error:

error: Failed dependencies:
perl(DBI) is needed by MySQL-server-5.0.45-0.glibc23.i386
i did run /scripts/perlinstaller --force Bundle::DBD::mysql too, but it doesn't fix it

View 14 Replies View Related

CPanel Remote MySQL

Aug 1, 2008

just want to know if you use 2 servers ( A & B ) both with cPanel, suppose that you do use the remote MySQL on server B serving website on server A.

How do we access phpmyadmin? Do you guys experience this?

View 8 Replies View Related

Upgrading To MySQL 5 On CPanel

May 7, 2008

I would like to start offering MySQL 5 on all my shared hosting accounts, seeing how it's an increasingly requested feature. However, by my understanding most applications still require MySQL 4 to operate (am particularly concerned with those bundled with Fantastico). I would like my current clients to be able to continue working with these older apps using MySQL 4 while allowing new clients to make use of the latest features available with MySQL 5.

I would like to get people's opinions as to what the best approach would be here. Should I upgrade directly to MySQL 5, offer both versions 4 and 5 simultaneously, or just stick to version 4 until version 5 is better supported? If I choose to install both versions in parallel, is this an easily supported option with CPanel/WHM? Will the configuration change break anything for clients already using applications with MySQL 4?

View 3 Replies View Related

MySQL Keeps Down (Cpanel Server)

May 30, 2007

I have a Cpanel server with a problem: SQL keeps failing

Everytime I try to restart MySQL via WHM, it gives me:

/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't
connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock'
exists! mysql has failed, please contact the sysadmin (result was "mysql
has failed").

I can only restart it successfully after 2nd attempt. Server load is always low. Memory usage is also low.

It happens in very short interval (in less than every 1-10 minutes)

It never happens until recently when my server management company tweak something I didn't know. They said fixed it and then it happens again every minutes.

I have 9 servers and it never happens to the rest 8 servers. Just this server always happening.

View 14 Replies View Related

Fixing Mysql Associations In Cpanel

May 29, 2009

I had a issue, and pretty much everything is fixed, execpt mysql databases are no longer associated with there cpanel accounts,

View 7 Replies View Related

[Cpanel::Mysql]: Not Updating Privileges

Apr 11, 2008

On a cPanel server, running RHEL 4 I got the following error (from cpanel logs) while associating an user with a DB from the cPanel admin:

Fri Apr 11 17:02:47 2008 info [Cpanel::Mysql]: Not updating privileges for user (reseller login and no password specified in ~/.my.cnf) at /usr/local/cpanel/Cpanel/Mysql.pm line 268
Cpanel::Mysql::updateprivs('Cpanel::Mysql=HASH(0xa4a8768)') called at /usr/local/cpanel/bin/mysqladmin line 88
Fri Apr 11 17:02:47 2008 info [Cpanel::Mysql]: Not updating privileges for user (reseller login and no password specified in ~/.my.cnf) at /usr/local/cpanel/Cpanel/Mysql.pm line 268

In fact, from cPanel interface all privileges are added OK, but the MySQL itself is not connecting at all due to this error.

I already tried:

/scripts/mysqlup --force
/scripts/upcp --force
/usr/bin/mysql_fix_privilege_tables -u root --password=PASSWORD

View 2 Replies View Related

Corrupted MySQL Backups CPanel

Mar 18, 2008

Just a warning to all other hosts out there using cPanel it currently generates corrupted mysql backups due to a bug in their pkgacct script which has been like this for over 6 days now.

[url]

So for anyone out there it's an easy fix.

Of course not every host is doing it so the fun of helping a customer migrate data and explain to them that their hosts backups being made are all corrupted is lots of fun.

Sort of sad but I've been told this isn't a critical enough issue to even push it out to all versions. Right now it makes a great lock in so customers cannot switch providers without a lot more work.

View 8 Replies View Related

Mysql Database Locations In Cpanel

Dec 14, 2007

Does anyone know the default location for databases created through cpanel?

View 2 Replies View Related

How To Upgrade Mysql 4.0 To 4.1 On Cpanel Server

Mar 22, 2007

how to upgrade mysql 4.0 to 4.1 on cpanel server? Is there any script there?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved