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 RepliesWe 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...
Code:
Error: Unable to reconfigure web server. websrvmng failed: Site MailEnable WebMail does not exist at IIS7WebSites::get() In IIS7NativeProvider module Exception type: System.Exception at IIS7WebSites.get(IIS7WebSites* , auto_ptr* , Int64 id, basic_string,std::allocator >* idnName)
Windows Server 2012
Plesk 11.0.9 Update #62
Note: Recently migrated from Plesk 9.2
Trying to set Default Site for a Dedicated IP Address.
I go to Subscription, then to domain > Change Hosting Settings, select dedicated IP address and OK, works fine. Site goes to Default Plesk Page.
Go to Tools & Settings, IP Addresses > Select the dedicated IP address I set above. Change Default Site to site above. Click Ok.
I get the error message above and nothing changes.
I looked on my IIS Server and MailEnable's Webmail is installed under the Default Website.
I have another Dedicated IP on this server and it has a default site on it working properly, but it was set up on the old site and it was configured as part of the Migration using Migration Manager.
I tried deleting the IP address and adding it back in. That didn't change anything. I also tried running: "%plesk_bin%websrvmng.exe" –reconfigure-webmail since that came up under someone else's issue when searching the web and that .exe is what's throwing the error.
Plesk12 has been installed on Windows2012R2. In the Tools and Settings/Database Servers list we have
· Local MySQL server (default for MySQL)
· .MSSQLSERVER2012
· sql-db-1 (default for MS SQL)
We only expect to use the remote sql-db-1 database for user databases.
Can we delete the other 2 databases and is this recommended? Does the Local MySQL server contain the Plesk Management database/schema?
Does anyone know anything about how to set up a mysql database? I installed this script for a gallery for wordpress but it won't create it's own databases. I already set one up myself but Im still getting this error:
Quote:
SELECT * FROM wp_fim_cat ORDER BY date DESC
Is there something Im supposed to add inside each database table? And how do I add it to make it work?
i had a problem with setting up DNS in windows VPS server in plesk.
View 0 Replies View RelatedI am having a problem setting mails on Thunderbird.i did exactly as you said in the documentation but still receive an error for sending an email (incoming email is good).i used full email address as username.domainname.tld as Incoming/Outgoing server address.
port 25 and 143 but still seem that i can't send emails.via web-mail i can , but via Thunderbird on my local PC i can't.I have a dedicated windows server with plesk 11.0.9
I am able to do a VPN connection to the Windows XP VPN server.
But however i cannot access the remote VPN computers.
I have a dedicated server running windows web edition. What is the easiest way to set up a VPN server on this machine so that I can log in to it from my home connection and route all my traffic through my server.
I've found a few guides for setting this up on linux boxes, but not with windows.
Curious to know the maximum number of sql server databases you guys have seen on a single server box?
View 0 Replies View RelatedI changed the DNS parameters of the default domain service plans to slave.
But where can I set the default master server, I didn't find it.
I have a server that I use to host my primary domain, and I have a cople Plesk servers, now I updated the hostnames of all the servers like
Code: s1.de.myserverplace.de
Now when the plesk server sends a mail it goes in spam always,
In the SPF records of the primary domain sits this
Code:
myserverplace.de. IN TXT "v=spf1 a mx a:myserverplace.de a:s1.de.myserverplace.de ip4:148.251.100.157 ip4:144.76.163.46 ip6:2a01:4f8:201:81b8::60 ?all"
But when I actually send the mail in the headers of the received mail I get this.
Code:
Received: from s1.de.myserverplace.de (s1.de.myserverplace.de. [144.76.163.46])
by mx.google.com with ESMTPS id p2si2158952wjy.73.2015.05.14.04.09.17
for <mymailtestacount@gmail.com>
(version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);
[Code] ....
How would I set this up so this doesn't happen?
I'm trying to setting plesk backups to own ftp server.. My ftp server is listening by the port 31..
My conf:
Server: mydomain:31
Directory: vpsbkp
User and password...
Passive mode checked
Here the error display: "Transport error: unable to list directory: Curl error: Couldn't connect to server"
Where are the bkp ftp logs?
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 �0�.
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
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
how to set multiple databases for a single user in plesk.
It only alows 1 db per user.
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: Đà Nẵng(Vietnamese) and when i saved, it displayed something funny like this:"ďà 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 RelatedI 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�][vu�][i1l!]d[[:>:]]'
You can see these: �
I get those also in my webpage. They replace almost every special character.
The sql server I have my users use is on a different server from which plesk is installed. Plesk should include the size of the user's databases from the external server as well otherwise the user can have a database as large as he wants. It's no longer restricted by the plans limits.
View 7 Replies View RelatedI have done many tests and always fails.= Plesk 9.5 to Plesk 12 =
I perform a migration with several domains from Plesk 9.5 and Plesk 12, it runs well. Then I remove all the migrated domains in Plesk 12 server. Then I perform a new migration with the same domains from the same server with Plesk 9.5 to the same server with Plesk 12 and it fails.The reason is that Plesk 12 doesn't remove the databases attached to the subscriptions. The new migration tries to deploy the databases and it can't because the same databases with the same users are deployed already.
I tried to remove the databases with `plesk bin database` and it was not enough. Maybe the same error will show when you migrate from Plesk 11.5/12 to Plesk 12.
today we notice that all subscriptions on Plesk when we access phpmyadmin has access to all databases,it was a Plesk update that can be done this ?
I don't remember to update anything during this days to this happen.
I have 2 Nodes. Both of them are configured like this:
Node1: Roles: MySQL, Apache,. Postfix; Attributes: Apache, Postfix, Webhost; restricted=>Reseller1
Node2: Roles: MySQL, Apache,. Postfix; Attributes: Apache, Postfix, Webhost; restricted=>Reseller2
I log in as Reseller1 (clean login; not by switching from PPA Admin to Reseller1), create a Webspace and a Database. At that point I am able to see and create Databases on every Node, even on Reseller1 (Node1), which is set to restricted. I guess this behaviour is not intended, isn't it?
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.
So I was trying to look up something from the horde Databases just to find that the full server backup that can be triggered in "tools & settings" -> "backup manager" does NOT include the horde and roundcube databases, even with "configuration and content" selected.
Sure, there are 7 days worth of daily backups in /var/lib/dumps but it would be nice to have those files included in the "full backup" Or am I missing something here?
My question is regarding Microsoft Access Databases and ASP.NET. I know that you need SQL server installed so that your website can communicate with any sql databases in use. Do you need Microsoft Access installed on a server where you accessing a MS Access Database?
View 1 Replies View RelatedI would like to build a personal website powered by a content management system and I'm wondering: How many SQL Server databases a site requires? At the Godaddy.com site, the plans for Windows offer one, two or three SQL databases and at least 10 MySQL databases.
The integration with MySQL is easy?
How can i check (using SSH) which databases/users cause server load to mysql ?
I've tried "mysqladmin proc stat" but it shows just the current. How can i get stats of the last 24 hours for example ?
I've also seen slow connections stats. What is the command to check more detailed report of the slow connections; which databases caused it etc', in the last 24 hours for example as well.
I am using Windows XP Pro, and since I updated to Internet Explorer 7 I am having problems getting web sites to work on my PC in Internet Explorer using the local IIS web server. These web sites are using ASP and Access databases.
The two errors I get are:
Operation must use an updateable query.
or
Cannot modify the design of table 'TABLE_NAME'. It is in a read-only database. (they are not read only!)
Does anyone know how I can get this working so I can test my web sites locally before uploading them to the live sites?
Since I have never worked on the server end of things I had a quick question for all you web hosting gurus.
Is it possible to have PHP installed on ONE single server and still have the ability for the server to work with both MS Access AND MySQL at the same time?
I would think YES, but I am being told by our server branch at my current job that this is not the case. They claim there is no way for the server on one machine to be able to handle both types of databases. Are they right?
If they are wrong and it is possible to have one server run both type of databases, what steps would be necessary to set up the server to handle both types? Do we need to tweak the php.ini file or is there another method of allowing the server the ability to work with both MySQL and MS Access.
Sorry if this question seems stupid or odd, as I said, I have minimal experience on the server end but I am confident that a server can handle both.