Знаки вопроса в redmine

После установки свеженького redmine обнаружилась проблема с отображением русских символов. Вместо них были только знаки вопроса. Для решения данной проблемы опишем небольшой скрипт на bash, естественно предварительно забекапив базу:

#!/bin/sh
mysqldump -u root -ppassword --default-character-set=latin1 -c --insert-ignore \
--skip-set-charset redmine > dev.db
for i in dev; do iconv -f ISO-8859-1 -t UTF-8 <$i.db >${i}8.db; done

for i in *8.db; do perl -pi -w -e 's/CHARSET=latin1/CHARSET=utf8/g;' $i; done

for i in redmine; do \
  mysql --user=root -ppassword --execute "DROP DATABASE $i; CREATE DATABASE $i \
  CHARACTER SET utf8 COLLATE utf8_general_ci;"; \
done

mysql --user=root -ppassword --max_allowed_packet=16M --default-character-set=utf8 \
  redmine < dev8.db

Если это не помогло, то необходимо произвести настройку на стороне сервера. Открываем файл /etc/mysql/my.cnf и сравниваем с моим:

[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock
default-character-set = utf8
[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0
[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
init_connect=‘SET collation_connection = utf8_unicode_ci'
character-set-server = utf8
collation-server = utf8_unicode_ci
bind-address            = 127.0.0.1
key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 192K
thread_cache_size       = 8
myisam-recover         = BACKUP
query_cache_limit       = 1M
query_cache_size        = 16M
log_error = /var/log/mysql/error.log
expire_logs_days        = 10
max_binlog_size         = 100M
[mysqldump]
quick
quote-names
max_allowed_packet      = 16M
[mysql]
[isamchk]
key_buffer              = 16M
!includedir /etc/mysql/conf.d/

[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock
default-character-set = utf8
[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0
[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
init_connect=‘SET collation_connection = utf8_unicode_ci'
character-set-server = utf8
collation-server = utf8_unicode_ci
bind-address            = 127.0.0.1
key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 192K
thread_cache_size       = 8
myisam-recover         = BACKUP
query_cache_limit       = 1M
query_cache_size        = 16M
log_error = /var/log/mysql/error.log
expire_logs_days        = 10
max_binlog_size         = 100M
[mysqldump]
quick
quote-names
max_allowed_packet      = 16M
[mysql]
[isamchk]
key_buffer              = 16M
!includedir /etc/mysql/conf.d/

213 комментариев к “Знаки вопроса в redmine

  1. Next time I read a blog, I hope that it doesn’t fail me just as much as this one. I mean, I know it was my choice to read, but I genuinely thought you’d have something useful to say. All I hear is a bunch of whining about something you could fix if you were not too busy searching for attention.

  2. Wonderful message. I learn something much more difficult on different blog sites everyday. It will always be boosting to read content from other authors and also practice a something from their shop. I?d choose to utilize some with the material on my blog whether you don?t mind. Natually I?ll give you a web link on your web blog site. Many thanks for sharing.

  3. Youre so awesome! I do not expect Ive check out anything like this before. So wonderful to find someone with some original ideas on this subject. realy thank you for starting this up. this web site is something that is needed online, someone with a little creativity. beneficial task for bringing something new to the web!

  4. There are certainly a great deal of details like that to take into consideration. That is a terrific indicate bring up. I supply the thoughts over as basic motivation but clearly there are concerns like the one you bring up where the most essential thing will certainly be working in honest good faith. I don?t recognize if finest practices have arised around things like that, however I make certain that your work is plainly determined as a level playing field. Both children and also ladies feel the impact of just a moment?s pleasure, for the rest of their lives.

  5. Sweet blog! I found it while searching on Yahoo News. Do you have any tips on how
    to get listed in Yahoo News? I’ve been trying for a while but I never seem to
    get there! Thank you 31muvXS cheap flights

  6. Hey there! I know this is kinda off topic nevertheless I’d figured I’d ask. Would you be interested in exchanging links or maybe guest authoring a blog article or vice-versa? My website covers a lot of the same topics as yours and I believe we could greatly benefit from each other. If you happen to be interested feel free to shoot me an email. I look forward to hearing from you! Wonderful blog by the way!

  7. May I simply say what a relief to uncover someone that genuinely knows what they are discussing over the internet. You certainly know how to bring an issue to light and make it important. More people ought to look at this and understand this side of the story. I was surprised you are not more popular because you definitely have the gift.

  8. After going over a handful of the blog posts on your site, I really like your way of writing a blog. I book marked it to my bookmark site list and will be checking back soon. Please check out my web site as well and let me know how you feel.

  9. Can I simply state what an alleviation to locate somebody who actually knows what theyre speaking about on the web. You certainly understand how to bring an issue to light and also make it essential. More individuals require to read this and also comprehend this side of the tale. I angle think youre not extra prominent because you certainly have the gift.

  10. You really make it appear really easy with your presentation however I to find this matter
    to be really something that I believe I’d never understand.
    It seems too complex and very vast for me. I am looking ahead
    on your subsequent post, I will attempt to get the cling of it!

  11. There are some intriguing moments in this short article but I don?t recognize if I see every one of them center to heart. There is some validity yet I will certainly take hold point of view until I explore it better. Good write-up, thanks and also we desire a lot more! Added to FeedBurner too

  12. There are certainly a great deal of details like that to take into consideration. That is an excellent point to raise. I supply the thoughts above as basic motivation however plainly there are questions like the one you bring up where one of the most crucial point will be operating in sincere good faith. I don?t know if finest techniques have emerged around points like that, but I make certain that your task is clearly recognized as a level playing field. Both kids and also women feel the effect of simply a moment?s enjoyment, for the remainder of their lives.

  13. Hey there just wanted to give you a quick heads up. The text in your content seem to be running off the screen in Opera. I’m not sure if this is a formatting issue or something to do with internet browser compatibility but I figured I’d post to let you know. The layout look great though! Hope you get the issue solved soon. Kudos

  14. Today, I went to the beachfront with my kids. I found a sea shell and gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She placed the shell to her ear and screamed. There was a hermit crab inside and it pinched her ear. She never wants to go back! LoL I know this is totally off topic but I had to tell someone!

  15. Hello! I could have sworn I’ve been to this website before but after browsing through some of the post I realized it’s new to me. Nonetheless, I’m definitely delighted I found it and I’ll be bookmarking and checking back frequently!

  16. Hey, I think your blog might be having browser compatibility issues. When I look at your blog site in Opera, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, awesome blog!

  17. Hmm it looks like your site ate my first comment (it was super long) so I guess I’ll just sum it up what I submitted and say, I’m thoroughly enjoying your blog. I as well am an aspiring blog blogger but I’m still new to everything. Do you have any recommendations for first-time blog writers? I’d definitely appreciate it.

  18. First of all I would like to say terrific blog! I had a quick question that I’d like to ask if you do not mind. I was interested to find out how you center yourself and clear your thoughts before writing. I have had trouble clearing my mind in getting my thoughts out. I truly do enjoy writing however it just seems like the first 10 to 15 minutes are usually lost just trying to figure out how to begin. Any suggestions or tips? Cheers!

  19. My coder is trying to convince me to move to .net from PHP. I have always disliked the idea because of the costs. But he’s tryiong none the less. I’ve been using WordPress on a number of websites for about a year and am concerned about switching to another platform. I have heard excellent things about blogengine.net. Is there a way I can import all my wordpress content into it? Any help would be greatly appreciated!

  20. How come at this time there zero much more a lot of these websites? Your content are perfect and get to themes or templates, that are unable to always be recognized all over the place. Please continue penning this sort of fantastic materials, it could be absolutely important. The net can be full of incredible waste, seeing that A single will be delighted when you learn anything. Exactly why typically are not there a lot more? Commonly do not abandon me dangling!

  21. Hey there! I realize this is somewhat off-topic however I needed to ask. Does running a well-established blog such as yours require a lot of work? I am completely new to operating a blog but I do write in my journal daily. I’d like to start a blog so I can share my personal experience and feelings online. Please let me know if you have any suggestions or tips for new aspiring blog owners. Thankyou!

  22. My developer is trying to convince me to move to .net from PHP. I have always disliked the idea because of the costs. But he’s tryiong none the less. I’ve been using Movable-type on numerous websites for about a year and am nervous about switching to another platform. I have heard great things about blogengine.net. Is there a way I can transfer all my wordpress posts into it? Any help would be greatly appreciated!

  23. There are some intriguing points in time in this short article but I don?t recognize if I see every one of them center to heart. There is some credibility yet I will certainly take hold opinion till I check out it better. Good short article, thanks as well as we want much more! Included in FeedBurner also

  24. After research a few of the article on your internet site now, and I absolutely like your method of blogging. I bookmarked it to my book mark website list and also will certainly be examining back quickly. Pls have a look at my website as well as well as let me know what you think.

  25. First off I would like to say excellent blog! I had a quick question in which I’d like to ask if you do not mind. I was curious to find out how you center yourself and clear your thoughts before writing. I’ve had a hard time clearing my thoughts in getting my ideas out. I do take pleasure in writing however it just seems like the first 10 to 15 minutes are wasted just trying to figure out how to begin. Any suggestions or hints? Cheers!

  26. Please let me know if you’re looking for a article writer for your blog. You have some really great posts and I feel I would be a good asset. If you ever want to take some of the load off, I’d absolutely love to write some material for your blog in exchange for a link back to mine. Please shoot me an email if interested. Kudos!

  27. Hey there! I understand this is somewhat off-topic however I had to ask. Does managing a well-established website like yours require a lot of work? I’m brand new to blogging but I do write in my journal every day. I’d like to start a blog so I will be able to share my experience and thoughts online. Please let me know if you have any kind of ideas or tips for new aspiring bloggers. Thankyou!

  28. Today, I went to the beach with my children. I found a sea shell and gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She placed the shell to her ear and screamed. There was a hermit crab inside and it pinched her ear. She never wants to go back! LoL I know this is totally off topic but I had to tell someone!

  29. I don’t know whether it’s just me or if everyone else experiencing problems with your site. It appears as though some of the text within your content are running off the screen. Can someone else please comment and let me know if this is happening to them as well? This might be a problem with my internet browser because I’ve had this happen previously. Appreciate it

  30. Howdy! This post could not be written any better! Reading this post reminds me of my previous room mate! He always kept chatting about this. I will forward this post to him. Fairly certain he will have a good read. Thank you for sharing!

  31. Hi there I am so delighted I found your weblog, I really found you by accident, while I was searching on Digg for something else, Anyways I am here now and would just like to say thank you for a tremendous post and a all round exciting blog (I also love the theme/design), I don’t have time to go through it all at the minute but I have bookmarked it and also added your RSS feeds, so when I have time I will be back to read a lot more, Please do keep up the excellent job.

  32. Hello! I understand this is somewhat off-topic but I needed to ask. Does running a well-established website such as yours require a massive amount work? I am completely new to operating a blog but I do write in my diary on a daily basis. I’d like to start a blog so I can easily share my personal experience and feelings online. Please let me know if you have any kind of recommendations or tips for brand new aspiring bloggers. Appreciate it!

  33. Hello would you mind letting me know which webhost you’re using? I’ve loaded your blog in 3 completely different web browsers and I must say this blog loads a lot quicker then most. Can you recommend a good internet hosting provider at a reasonable price? Cheers, I appreciate it!

  34. Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You definitely know what youre talking about, why waste your intelligence on just posting videos to your weblog when you could be giving us something enlightening to read?

  35. Whats up this is kinda of off topic but I was wanting to know if blogs use WYSIWYG editors or if you have to manually code with HTML. I’m starting a blog soon but have no coding expertise so I wanted to get guidance from someone with experience. Any help would be enormously appreciated!

  36. Hello there! I know this is kind of off topic but I was wondering if you knew where I could find a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having difficulty finding one? Thanks a lot!

  37. Does your blog have a contact page? I’m having a tough time locating it but, I’d like to send you an e-mail. I’ve got some ideas for your blog you might be interested in hearing. Either way, great website and I look forward to seeing it develop over time.

  38. Hi I am so happy I found your website, I really found you by error, while I was browsing on Aol for something else, Regardless I am here now and would just like to say thanks a lot for a incredible post and a all round entertaining blog (I also love the theme/design), I don’t have time to read it all at the minute but I have book-marked it and also included your RSS feeds, so when I have time I will be back to read a lot more, Please do keep up the great job.

  39. After study a few of the blog posts on your internet site currently, and also I really like your means of blog writing. I bookmarked it to my book marking web site list and also will certainly be inspecting back soon. Pls have a look at my web site also and let me know what you assume.

  40. My spouse and I stumbled over here coming from a different page and thought I may as well check things out. I like what I see so now i’m following you. Look forward to looking at your web page again.

  41. I simply want to mention I’m all new to blogging and site-building and certainly enjoyed this web site. Almost certainly I’m likely to bookmark your website . You absolutely have fantastic well written articles. Regards for revealing your blog.

  42. I really like your blog.. very nice colors & theme. Did you make this website yourself or did you hire someone to do it for you? Plz reply as I’m looking to construct my own blog and would like to find out where u got this from. kudos

  43. I additionally believe that mesothelioma cancer is a scarce form of cancer that is normally found in these previously exposed to asbestos. Cancerous cellular material form in the mesothelium, which is a shielding lining that covers the majority of the body’s internal organs. These cells usually form inside the lining of the lungs, tummy, or the sac that encircles one’s heart. Thanks for giving your ideas.

  44. Hi there, just became aware of your blog through Google, and found that it is really informative. I am gonna watch out for brussels. I’ll be grateful if you continue this in future. Many people will be benefited from your writing. Cheers!

  45. What i do not realize is actually how you’re no longer really a lot more neatly-favored than you may be now. You’re very intelligent. You know therefore significantly with regards to this topic, made me personally consider it from a lot of varied angles. Its like women and men aren’t fascinated until it’s one thing to do with Girl gaga! Your own stuffs great. At all times care for it up!

  46. I beloved as much as you’ll obtain performed right here. The cartoon is tasteful, your authored material stylish. nevertheless, you command get got an nervousness over that you want be handing over the following. in poor health without a doubt come further in the past again since precisely the same just about very ceaselessly inside of case you defend this hike.

  47. I just want to mention I’m very new to blogging and site-building and absolutely loved you’re page. Almost certainly I’m planning to bookmark your website . You surely come with very good articles and reviews. Regards for sharing with us your blog site.

  48. I just could not depart your web site prior to suggesting that I actually enjoyed the standard information an individual supply to your visitors? Is gonna be back steadily in order to investigate cross-check new posts.

  49. Excellent read, I just passed this onto a colleague who was doing a little research on that. And he just bought me lunch because I found it for him smile Thus let me rephrase that: Thanks for lunch!

  50. Hey there I am so grateful I found your webpage, I really found you by accident, while I was looking on Digg for something else, Anyways I am here now and would just like to say cheers for a incredible post and a all round entertaining blog (I also love the theme/design), I don’t have time to browse it all at the moment but I have book-marked it and also added in your RSS feeds, so when I have time I will be back to read much more, Please do keep up the great job.

  51. I blog quite often and I truly thank you for your information. Your article has really peaked my interest. I’m going to bookmark your blog and keep checking for new details about once per week. I subscribed to your Feed as well.

  52. Hello, i read your blog occasionally and i own a similar one and i was just wondering if you get a lot of spam feedback? If so how do you protect against it, any plugin or anything you can advise? I get so much lately it’s driving me mad so any support is very much appreciated.

  53. I blog quite often and I truly thank you for your content. Your article has really peaked my interest. I will book mark your site and keep checking for new information about once per week. I subscribed to your RSS feed as well.

  54. It is appropriate time to make some plans for the future and it is time to be happy. I’ve read this post and if I could I desire to suggest you some interesting things or suggestions. Perhaps you could write next articles referring to this article. I want to read even more things about it!

  55. I feel this is among the so much vital information for me. And i am glad reading your article. But want to statement on few basic things, The web site style is wonderful, the articles is in point of fact excellent : D. Good job, cheers

  56. Having read this I believed it was extremely informative. I appreciate you spending some time and effort to put this information together. I once again find myself personally spending way too much time both reading and commenting. But so what, it was still worth it.

  57. Good post. I learn something totally new and challenging on blogs I stumbleupon everyday. It will always be exciting to read articles from other writers and practice a little something from other websites.

  58. *An impressive share, I just given this onto a colleague who was doing a little analysis on this. And he in fact bought me breakfast because I found it for him.. smile. So let me reword that: Thnx for the treat! But yeah Thnkx for spending the time to discuss this, I feel strongly about it and love reading more on this topic. If possible, as you become expertise, would you mind updating your blog with more details? It is highly helpful for me. Big thumb up for this blog post!

  59. Your style is very unique in comparison to other people I’ve read stuff from. Thanks for posting when you’ve got the opportunity, Guess I’ll just book mark this page.

  60. I’ve been exploring for a little bit for any high quality articles or weblog posts on this sort of space . Exploring in Yahoo I finally stumbled upon this web site. Reading this information So i am happy to convey that I have an incredibly good uncanny feeling I came upon exactly what I needed. I most no doubt will make sure to don’t overlook this web site and give it a look regularly.

  61. I have been surfing online more than 3 hours today, yet I never found any interesting article like yours. It is pretty worth enough for me. In my opinion, if all web owners and bloggers made good content as you did, the net will be much more useful than ever before.

  62. I would like to thank you for the efforts you have put in writing this blog. I really hope to check out the same high-grade blog posts by you in the future as well. In fact, your creative writing abilities has motivated me to get my own site now 😉

  63. hello there and thank you for your info – I have definitely picked up anything new from right here. I did however expertise some technical points using this web site, since I experienced to reload the website lots of times previous to I could get it to load correctly. I had been wondering if your web host is OK? Not that I’m complaining, but slow loading instances times will often affect your placement in google and can damage your high-quality score if advertising and marketing with Adwords. Anyway I am adding this RSS to my e-mail and could look out for much more of your respective interesting content. Ensure that you update this again soon..

  64. An impressive share! I have just forwarded this onto a friend who had been doing a little homework on this. And he actually bought me breakfast simply because I found it for him… lol. So let me reword this…. Thank YOU for the meal!! But yeah, thanx for spending time to talk about this topic here on your site.

  65. Hi would you mind stating which blog platform you’re using? I’m planning to start my own blog in the near future but I’m having a tough time choosing between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design seems different then most blogs and I’m looking for something unique. P.S My apologies for being off-topic but I had to ask!

  66. I have realized that online degree is getting favorite because attaining your college degree online has become a popular option for many people. Many people have definitely not had a chance to attend a traditional college or university but seek the elevated earning possibilities and career advancement that a Bachelor Degree affords. Still others might have a college degree in one discipline but would like to pursue a thing they now have an interest in.

  67. Greetings, I do believe your web site could possibly be having browser compatibility problems. When I look at your web site in Safari, it looks fine but when opening in I.E., it’s got some overlapping issues. I merely wanted to give you a quick heads up! Apart from that, wonderful site.

  68. Thanks for the marvelous posting! I quite enjoyed reading it, you may be a great author.I will be sure to bookmark your blog and definitely will come back someday. I want to encourage you continue your great posts, have a nice evening!

  69. Heya! I realize this is somewhat off-topic however I needed to ask. Does running a well-established website such as yours take a large amount of work? I am completely new to writing a blog however I do write in my diary everyday. I’d like to start a blog so I will be able to share my experience and views online. Please let me know if you have any kind of recommendations or tips for new aspiring blog owners. Appreciate it!

  70. Great beat ! I would like to apprentice even as you amend your web site, how could i subscribe for a weblog site? The account aided me a appropriate deal. I were a little bit familiar of this your broadcast provided vibrant clear idea

  71. Hi there! I know this is kind of off topic but I was wondering which blog platform are you using for this website? I’m getting tired of WordPress because I’ve had problems with hackers and I’m looking at options for another platform. I would be awesome if you could point me in the direction of a good platform.

  72. I adore your blog post.. pleasant colours & style. Did an individual design this web site your self or maybe did you actually hire someone to make it work available for you? Plz respond as I!|m planning to pattern my own website along with would wish to learn in which oughout became that out of. thanks a lot

  73. Good post. I learn something new and challenging on websites I stumbleupon every day. It will always be interesting to read articles from other authors and use a little something from other sites.

  74. Please let me know if you’re looking for a author for your site. You have some really great articles and I believe I would be a good asset. If you ever want to take some of the load off, I’d love to write some content for your blog in exchange for a link back to mine. Please send me an e-mail if interested. Cheers!

  75. I know this if off topic but I’m looking into starting my own weblog and was wondering what all is needed to get setup? I’m assuming having a blog like yours would cost a pretty penny? I’m not very internet smart so I’m not 100 sure. Any suggestions or advice would be greatly appreciated. Cheers

Оставить ответ

Ваш адрес email не будет опубликован. Обязательные поля помечены *