added2

1 files changed, 51 insertions, 0 deletions

diff --git a/sphinx.conf b/sphinx.conf
new file mode 100644
index 0000000..24d271b
--- /dev/null
+++ b/sphinx.conf
@@ -0,0 +1,51 @@
+source journal
+{
+    type                            = mysql
+    sql_host                        = localhost
+    sql_user                        = journal_user
+    sql_pass                        = journal_password
+    sql_db                          = journal
+#    sql_sock                        =  /var/run/mysqld/mysqld.sock
+    sql_port                        = 3306                  
+
+    # indexer query
+    # document_id MUST be the very first field
+    # document_id MUST be positive (non-zero, non-negative)
+    # document_id MUST fit into 32 bits
+    # document_id MUST be unique
+    sql_query                       = \
+            SELECT \
+                    `id`, `fulltext`, `image_url` \
+            FROM \
+                    journals;
+#
+#    sql_group_column                = assembly
+#    sql_group_column                = model
+
+    # document info query
+    # ONLY used by search utility to display document information
+    # MUST be able to fetch document info by its id, therefore
+    # MUST contain '$id' macro 
+    #
+
+    sql_query_info          = SELECT * FROM journals WHERE id=$id
+}
+
+index journal
+{
+    source                  = journal
+    path                    = /home/pepper/sphinx/journal
+    morphology              = stem_en
+
+    min_word_len            = 3
+    min_prefix_len          = 0
+    min_infix_len           = 3
+}
+
+searchd
+{
+  port        = 3312
+  log         = /var/log/searchd/searchd.log
+  query_log     = /var/log/searchd/query.log
+  pid_file      = /var/log/searchd/searchd.pid
+}