Plesk 12.x / Windows :: MySQL 5.5 - Unknown OS Charset

Sep 29, 2014

We have a special application that works on 3 servers, 1 of them is main server and others are mysql replicate servers basically used for generating reports or backups...

Server 1 - Centos 6.5/Mysql 5.5/Plesk 12
Server 2 - Centos 6.5/Mysql 5.5/Plesk 11
Server 3 - Server 2008 R2/Mysql 5.5/Plesk 12

Server 1->Server 2 replication works perfectly
Server 1->Server 3 replication sometimes fails with character issues (our database and tables use utf8_turkish_ci), when I tried to investigate this issue by logging in to mysql on Server 3 right after connection i saw "Unknown OS Character Set 'cp857' Switching to default character set latin1" and i am guessing that my replication issues are also related to this issue. I tried adding below settings to my.ini at "C:Program Files (x86)ParallelsPleskDatabasesMySQLdata"

[mysqld]
init_connect='SET collation_connection = utf8_turkish_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_turkish_ci
skip-character-set-client-handshake
[mysql]
default-character-set=utf8
default-collation=utf8_turkish_ci
[client]
default-character-set=utf8
default-collation=utf8_turkish_ci

but didnt change anything, i was wondering if these settings were wrong so i tried them at my local wamp installation which i was having same error, but error was gone after adding them to my.ini so i think settings are alright...

View 3 Replies


ADVERTISEMENT

Plesk 12.x / Windows :: Setting Utf8mb4 Charset For Server And Databases

Mar 5, 2015

I have upgrade my mysql plesk installation from 5.1 to 5.6 and have troubles in setting utf8mb4 charset for server and databases. Special characters still display badly in my websites. I'm running Windows Server 2012 R2 and plsk 12. 

View 1 Replies View Related

Which MySQL Utf8 Charset Should I Use

May 20, 2007

to change a mysql database and all its tables to a utf8 charset and collation, however I'm not sure specifically which one I should use. We are currently using latin1_general_ci.

On a forum I've noticed that in a couple of posts I made, sometimes characters such as the euro sign €, and the German ß get converted to question marks.

Being an English forum we don't often have members use these characters but we'd like them displayed correctly when they are.

I don't really know much about character sets and such, but I understand that they contain different characters and treat them differently in comparisons and sorts etc. So which of the following should I be using?
utf8_bin
utf8_general_ci
utf8_unicode_ci

I was leaning towards unicode, but I don't know what the differences between them are. Can anyone advise us on what to use?

This is for MySQL 4.1.22 btw.

I'm certain the problem is not with my browser, and the characters are typed from the keyboard, not copied and pasted from word docs. A charset is specified by a meta tag in the header too.

View 1 Replies View Related

Plesk 12.x / Windows :: Unknown Column Description In Field List

Sep 10, 2014

While accessing plesk it says "ERROR: PleskMainDBException: DB query failed: Unknown column 'description' in 'field list' (db.php:61)" , Plesk 12 windows server.

View 2 Replies View Related

Warning: Unknown: Failed To Open Stream: Permission Denied In Unknown On Line

May 8, 2009

I have set up my Virtual Private Server and uploaded all my site's files to /var/www folder. Before that, there was an old simple 'index.html' file

Code:
<html>
<head>
<title>INDEX</title>
</head>
<body>
<h1>IT WORKS!!!!</h1>
</body>
</html>
and when I typed the address www.mydomain.com it displayed correctly. Then I deleted this html and uploaded my files through FTP and now the browser says :

Code:
Warning: Unknown: failed to open stream: Permission denied in Unknown on line 0

Fatal error: Unknown: Failed opening required '/var/www/index.php' (include_path='.:/usr/share/php:/usr/share/pear') in Unknown on line 0

View 13 Replies View Related

Plesk 11.x / Windows :: Cannot Add Second Mysql Server

Nov 17, 2014

For one of my dedicated server I have the follwoing scenario:

Microsoft Windows Server 2012 X64
Plesk 11.5.30 Update #48

Plesk Panel - Tools and Settings -> Database Server -> Add Database Server
Type: MySql - host: localhost - Port 3307

Actual Result: error unable to connect to host

Expected result: New instance and service of MySql Server

Port 3307 is no firewalled and I have added a rule to allow connection on 3307

View 2 Replies View Related

Plesk 11.x / Windows :: Upgrade MySQL From 5.1 To 5.5?

May 21, 2014

In order to install moodle, I need to upgrade MySQL from 5.1 to 5.5. I have gone through one of the KB articles [URL], but it's not very clear.

Can I upgrade it through Add/remove Components from Install and update products just like it can be done for PHP?? I see MySQL Server 2005, 2008 and 2012,

View 2 Replies View Related

Plesk 11.x / Windows :: Mysql Could Not Start

Mar 23, 2014

I can't start MYSQL. How can i fix this?

View 3 Replies View Related

Plesk 11.x / Windows :: Adding Second MySQL Server

Sep 12, 2014

I have a dedicated server and I am about to get a few high traffic sites that will be Joomla based and MySQL served. What I am thinking a about is to create another MySQL instance, leave the current websites on the "old" instance and get the new ones onto a separate instance.

I am on PPP 11.0.9 on windows and the current mysql version is 5.1.56 on port 3306 (I can get other ports for other instances).

What I did was the following:

In the Database Servers page, I hit "Add Database Server"

In the next page I add the following:
MySQL (from the dropdown)
localhost
3307
(leave blank the default check box)

I then add the Administrator's username and passwords and hit OK.

The next page, reports an error message (in between asterisks below):
************************
Error: Test connection to the database server has failed because of network problems:

No connection could be made because the target machine actively refused it.
************************
The primary (eg. current) mysql instance is working fine, it's just I cannot add a second server...

View 3 Replies View Related

Plesk 11.x / Windows :: How To Upgrade Mysql 4.x Installation

Jul 29, 2012

Plesk has mysql installed with it to run properly and I need to upgrade that version to the latest. Now I am not talking about the mysql server that it provides for me to create databases on. I am talking about the version it uses to run.

View 3 Replies View Related

Plesk 11.x / Windows :: Unable To Connect To MySQL?

Jul 17, 2012

I've upgraded to 11, but when I try and apply updates, I'm getting

WARNING: Unable to connect to local default MySQL server. Read carefully article [URL] ..... for details.

I've followed the directions in the KB mentioned, but haven't had any luck yet.

View 8 Replies View Related

Plesk 11.x / Windows :: Change Database From MySQL To MSSQL

Apr 22, 2013

I have read about people wanting to change their database from MSSQL to MySQL. I however am wanting to change from MySQL to Microsoft SQL in our Plesk panel.

View 7 Replies View Related

Plesk 11.x / Windows :: List Of Suspend Domains From Mysql

May 27, 2014

I need to get a list of suspend domains from mysql. The domains are suspend because they exceeded quota.So far I have done this query:

#############

select domains.id,
domains.name as domena,
Round(((sum(domains.real_size))/1048576),2) realMB,

(select Round((limits.value/1048576),2) from limits left join (domains, subscriptions, subscriptionproperties) on (domains.id=subscriptions.object_id and subscriptions.id=subscriptionproperties.subscription_id and subscriptionproperties.value=limits.id) where subscriptionproperties.name='limitsId' and limits.limit_name='disk_space' and domains.name=domena) quotaMB
from domains
where domains.status='2' and
(select (sum(domains.real_size)))>0
group by domains.cl_id;

but I didnt managed to get only those that exceed the quota.

View 3 Replies View Related

Plesk 11.x / Windows :: MySQL Stopping With No Apparent Reason

Apr 2, 2014

PRODUCT, Plesk for Windows VERSION 11.5 latest update VERSION OF MICROUPDATE 11.5.30 Actualizar #39, OPERATING SYSTEM Windows 2008 Server Suddently with no apparent reason, MYSQL stops and Ihave to go to the panel and restart it.

Every Morning I have to restart MySQL thru the control panel in remote console of windows..Works all day long, and then stops at night..Should work as always did, for several months I did not even reboot the server, no I have to reboot the server to see if that fixes the problem. Latest windows update, latest Plesk for windows update, but I have the feeling that with the latest microupdate something has broken,

View 3 Replies View Related

Plesk 12.x / Windows :: PHP Connecting Over Localhost To MySQL Very Slow

Jan 27, 2015

I have windows server 2012 and Plesk v12.0.18 #30 - I noticed speed problem.

When I try to connect to mySQL with:

$conn = new mysqli('localhost', 'joomla_***', '*****', 'joomla_test');

Connection takes 1 second!!!When I try to connect with '127.0.0.1' instead of 'localhost' connection takes 0,009 seconds.

1. I tried solution to add line '127.0.0.1 localhost' to c:windowssystem32driversetshosts - but no luck.

2. I tried to edit C:Program Files (x86)ParallelsPleskMySQLDatamy.ini - adding lines
bind-address=127.0.0.1
skip-name-resolve
then restarted mySql but 1 second lag time on connection was still there.

3. I even tried to disable IPv6 but still no luck

I guess all users windows windows server 2012 has the same problem??!?!...

View 3 Replies View Related

Plesk 11.x / Windows :: MySQL Could Not Start After Unexpected Server Shutdown

Aug 29, 2013

After an unexpected server shutdown. We cant start mysql anymore.

Error: Could not complete the operation: defpackagemng failed: The process terminated unexpectedly. (Error code 1067) at Start service MySQL

View 4 Replies View Related

Plesk 11.x / Windows :: Import MySQL - Database Failed After Upgrade

Aug 13, 2013

Since we upgraded to Plesk 11.5 or (I'm not shure) the last Update 12, user can not import MySQL-Databases anymore.

If the user open phpMyAdmin for import and select the database and click on Ok, phpMyAdmin does nothing.

I heard that could be a problem with JQUERY and I checked the files in ParallelsadminhtdocsdomainsdatabasesphpMyAdminjsjquery and all files seems to be there.

Only if I check the source of the phpMyAdmin Import-Website it seems, there is a problem with jquery-1.6.2+fix-9521.js.

But how I can fix this problem for all Windows-Servers.

View 19 Replies View Related

Plesk 12.x / Windows :: WordPress Install - MySQL Extension Was Not Found

Feb 9, 2015

Running Plesk 12.0.18 on Windows 2012

I create a new domain then use Plesk Applications tab to install Wordpress. It shows the message:

Code:
Error: Unable to install the app because its installation requirements are not met. Contact your hosting provider to resolve this problem.
Requirements
PHP extension
The 'mysql' extension was not found.

However, php is installed and phpinfo shows that the mysql extension is installed. I try different versions of php, cgi/fastcgi but ll fail with the same error. I install Wordpress via FTP and it works fine.

There are knowledge-base articles relating to this error but they are for Linux and the solutions don't work in this case:

[URL] ...
[URL] ...

Maybe the Wordpress database has to be created before using Plesk to install Wordpress? If so, what should the database name be? How does Plesk know what the name of the database is that it should use? Why doesn't Plesk just create a database to use?

View 6 Replies View Related

Plesk 12.x / Windows :: After 12.0.18 Update Cannot Login To Panel - MySQL 127.0.0.1 Not Allowed

Apr 21, 2015

After installing Plesk 12.0.18 Update 43 on windows when I try to connect to Plesk Panel (https://myurl.com:8443/) I get error:

ERROR: PleskMainDBException: Host '127.0.0.1' is not allowed to connect to this MySQL server (db.php:435)

I tried to reset mysql admin password as described in article - with no luck : [URL] .....

I even tried to reset password:
%plesk_bin%plesksrvclient -set "newpassword" true

Again I get "Faild to connect to database: Host '127.0.01' is not allowed to connect to this mySQL server

All websites that uses mySql works but Plesk Panel is dead?

View 3 Replies View Related

Plesk 12.x / Linux :: Cannot Login - Unknown Database PSA

Feb 22, 2015

ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [1049] Unknown database 'psa' (Abstract.php:144)

View 3 Replies View Related

Plesk 11.x / Windows :: Importing MySQL Backup - Unable To Restore Database

Mar 20, 2014

I have Plesk Windows version, when I want import my backup mysql, i see below error:

Error: dbbackup failed: Unable to restore database 'admin_IranDnn'

ERROR 2006 (HY000) at line 1: MySQL server has gone awayClick to expand...

View 7 Replies View Related

Plesk 11.x / Linux :: Active Sessions Unknown User / IP?

Aug 28, 2014

i saw very often in the active sessions site following line:

Username Empty IP empty Date Nov 30, -0001 12:00 AM Idle time 00:45:39

What is that and how can is stop this or get it fixed ?

View 1 Replies View Related

Plesk 11.x / Windows :: Mysql Duplicate Entry Error - Enabling Spam Filter

May 7, 2013

when im trying to enable spam filter for a particular email account i get this mysql error:

Error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'xxxx@domain.com' for key 3 (mail id i hid it for security reasons xxxx@domain.com)..

i searchd in the psa database but could not find any duplication...

View 2 Replies View Related

Charset On FC5

Feb 18, 2008

I own and run the server I am having issues with FC5 running. it has been online with no issues. Until this new client.

I have a new client moving his sites to my servers. The issue is the sites have text in it that are not displaying correctly. When you view them through your browser or if I view them on the server with nano and look a the code, some characters are all messed up.

here is an example. on the websitethis is how its supposed to look.

“0” but when you view it with Firefox it looks like this &#65533;0&#65533;.

if I download the source and view it in word pad it is fine, and looks as it should I have change my charsets around even have the same charsets installed on his server installed on mine. I have commented out default charset in apache to let the browser choose but to no avail. My server has no problem showing Chinese text on web pages or anything else so i do not understand why this is happening. If anyone has any ideas please let me know, this is very frustrating as I have never had this issue before.
here is what is in my httpd.conf

AddLanguage da .dk
AddLanguage nl .nl
AddLanguage en .en
AddLanguage et .ee
AddLanguage fr .fr
AddLanguage de .de
AddLanguage el .el
AddLanguage he .he
AddCharset ISO-8859-8 .iso8859-8
AddLanguage it .it
AddLanguage ja .ja
AddCharset ISO-2022-JP .jis
AddLanguage kr .kr
AddCharset ISO-2022-KR .iso-kr
AddLanguage nn .nn
AddLanguage no .no
AddLanguage pl .po
AddCharset ISO-8859-2 .iso-pl
AddLanguage pt .pt
AddLanguage pt-br .pt-br
AddLanguage ltz .lu
AddLanguage ca .ca
AddLanguage es .es
AddLanguage sv .sv
AddLanguage cz .cz
AddLanguage ru .ru
AddLanguage zh-tw .tw
AddLanguage tw .tw
AddCharset Big5 .Big5 .big5
AddCharset WINDOWS-1251 .cp-1251
AddCharset CP866 .cp866
AddCharset ISO-8859-5 .iso-ru
AddCharset KOI8-R .koi8-r
AddCharset UCS-2 .ucs2
AddCharset UCS-4 .ucs4
AddLanguage ltz .lu
AddLanguage ca .ca
AddLanguage es .es
AddLanguage sv .sv
AddLanguage cz .cz
AddLanguage ru .ru
AddLanguage zh-tw .tw
AddLanguage tw .tw
AddCharset Big5 .Big5 .big5
AddCharset WINDOWS-1251 .cp-1251
AddCharset CP866 .cp866
AddCharset ISO-8859-5 .iso-ru
AddCharset KOI8-R .koi8-r
AddCharset UCS-2 .ucs2
AddCharset UCS-4 .ucs4
AddCharset UTF-8 .utf8

AddDefaultCharset UTF-8

View 2 Replies View Related

Charset

Aug 17, 2007

i have problems with charsets in all the php-mysql sites whick i setup..i am from greece and i want all to have as default the greek lang...what exactly i must change from mysql or apache to have all working fine with greek charset ISO-8859-7

Before your answers i must tell you that
2))i have change in php.ini as default language to the greek ISO-8859-7
2)also in phpmyadmin mysql connection collation is set it in UTF_8 bin
BUT THE Problem stills remains

View 3 Replies View Related

Plesk 12.x / Linux :: Configuring Slave DNS Manager - Unknown Option

Aug 1, 2014

I have setup bind in centos 6.5 and then edited /etc/named.conf and added the lines

The extension produced but I am getting the following error when restarting the bind service

Error in named configuration:
/etc/named.conf:2: unknown option '...'
/etc/named.conf:14: unknown option '*'
/etc/named.conf:21: 'options' redefined near 'options'

The following code suggested by plesk slave dns manager extension

Code:

options {
...
allow-new-zones yes;
};
key "rndc-key-mainserver ip" {

[Code] .....

After I removed ... from the options now I get the following error :

/etc/named.conf:51: unknown key 'rndc-key'

View 1 Replies View Related

Plesk 11.x / Linux :: Upgrade From 11.0.9 To 11.5 Database Error - Unknown Columns

Sep 9, 2013

I just upgraded from 11.0.9 and i got the following error

ERROR: Zend_Db_Statement_Exception

Eine Ebene höher
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ipAddress' in 'where clause'

A Google Search shows that under Windows there is dbupgrade.exe

Is there such a tool under Linux too??

View 4 Replies View Related

Charset In PhpMyAdmin

May 20, 2007

I have a auction website using php and mySQL and categories are saved in database. When i tried to add new categories in Admin area such as: &#272;à N&#7861;ng(Vietnamese) and when i saved, it displayed something funny like this:"&#271;à N&#ng". I have modified charset in myPhPadmin for the database and for categories table to uft-8, but it won't help.

View 4 Replies View Related

Charset Errors

Aug 14, 2007

I have a server:

CentOS release 4.5 (Final)
PHP Version 4.3.9
Apache Version: 2.0.52-32.3.ent.centos4
mySQL 4.1.20-2.RHEL4.1

And i keep gettings these errors:

Code:
MySQL Error!
------------------------

The Error returned was:
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (cp1251_general_ci,COERCIBLE) for operation 'regexp'

Error Number:
1267

SELECT name FROM uxwarez_users WHERE LOWER(name) REGEXP '[[:<:]]d[a&#65533;][vu&#65533;][i1l!]d[[:>:]]'

You can see these: &#65533;
I get those also in my webpage. They replace almost every special character.

View 4 Replies View Related

Plesk 12.x / Linux :: Module IonCube Loader Already Loaded In Unknown On Line 0

Sep 2, 2014

After successful upgrade PHP, and not successful with ioncube i get:

Failed loading /usr/lib/php/modules/ioncube_loader_lin_5.4.so: /usr/lib/php/modules/ioncube_loader_lin_5.4.so: cannot open shared object file: No such file or directory
PHP Warning: Module 'ionCube Loader' already loaded in Unknown on line 0
The ionCube PHP Loader is disabled because of startup problems.
PHP Warning: Module 'ionCube Loader' already loaded in Unknown on line 0
The ionCube PHP Loader is disabled because of startup problems.
PHP 5.4.32 (cli) (built: Aug 21 2014 07:33:35)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies
with the ionCube PHP Loader v4.6.1, Copyright (c) 2002-2014, by ionCube Ltd., andClick to expand...

View 4 Replies View Related







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