Advertisement
Guest User

Untitled

a guest
Feb 5th, 2016
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.80 KB | None | 0 0
  1. db = QSqlDatabase::addDatabase("QMYSQL", "Sphinx");
  2. db.setHostName("192.168.0.14");
  3. db.setPort(9306);
  4. db.open();
  5.  
  6. QByteArray ba("select id from lettersIndex where match('коллеги')");
  7. // Пробовал и без кодека, а так же со всевозможными кодировками
  8. QTextCodec* codec = QTextCodec::codecForName("Windows-1251");
  9. QString query = codec->toUnicode(ba);
  10. q.exec(query);
  11.  
  12. source lettersSource
  13. {
  14. type = firebird
  15. sql_host = 192.168.0.14
  16. sql_port = 3050
  17. sql_user = user
  18. sql_pass = password
  19. sql_db = 192.168.0.14/3050:rc
  20. sql_query = SELECT l.ID, l.USERNAME, l.CAPTION, l.BODY,
  21. DATEDIFF(second, timestamp '1/1/1970 00:00:00', l.logdate) as posttime
  22. from LETTERS l
  23. sql_attr_timestamp = posttime
  24. }
  25. index lettersIndex
  26. {
  27. source = lettersSource
  28. path = /usr/local/sphinx/data/lettersIndexes
  29. docinfo = extern
  30. min_word_len = 3
  31. min_prefix_len = 6
  32. html_strip = 1
  33. }
  34. searchd
  35. {
  36. listen = 192.168.0.14:3312
  37. listen = 192.168.0.14:9306:mysql41
  38.  
  39. log = /usr/local/sphinx/data/searchd.log
  40. query_log = /usr/local/sphinx/data/query.log
  41. max_children = 20
  42. pid_file = /usr/local/sphinx/data/searchd.pid
  43. }
  44.  
  45. [Wed Feb 3 15:04:47.913 2016] 0.000 sec 0.000 sec [ext2/0/ext 0 (0,20)] [lettersIndex]
  46. ???????
  47. [Fri Feb 5 10:25:22.623 2016] 0.000 sec 0.000 sec [ext2/0/ext 0 (0,20)] [lettersIndex]
  48. ?????»?»?µ????
  49. [Wed Feb 3 15:05:22.284 2016] 0.000 sec 0.000 sec [ext2/0/ext 4 (0,20)] [lettersIndex]
  50. коллеги
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement