piler.documents table is missing after green field installation

[Former user]

Hi J. Suto,

After installation and configuration when running 'su piler;indexer --all' I get : ERROR: index 'test1': sql_query: Table 'piler.documents' doesn't exist (DSN=mysql://piler:***@localhost:3306/piler) All other tables seems present (32 tables are created).

Can you please help me out? Thanks! RTop

[Janos SUTO]

Hello, where does this "test1" index come from? I think you use some other sphinx.conf, not what's shipped with piler. Possible solutions:

#1: overwrite the OS version of sphinx.conf

#2: specify the used config file for both indexer and searchd to use the piler's version

[Ronald Top]

Hi J. Suto,

Can you tell me which sphinx.conf I need? I just installed the version sphinx-2.1.3-1.rhel6.x86_64.rpm from the sphinx web site. Do you have an example conf file?

Thanks! RTop

[Janos SUTO]

look at etc/sphinx.conf in the piler source directory for an example. You should fix the mysql password in the config file.

[Ronald Top]

I ran through this cookbook : https://extremeshok.com/2013/08/28/rhel-centos-redhat-mailpiler-sphinx-mariadb-mysql/ In this cookbook sphinx is dl'ed from http://sphinxsearch.com/files/sphinx-2.0.9-1.rhel6.x86_64.rpm I used http://sphinxsearch.com/files/sphinx-2.1.3-1.rhel6.x86_64.rpm coz my first install didn't work. But I don't see any piler specific sphinx.conf, just the one that comes default with sphinx. This is the /etc/sphinx.conf file:

Minimal Sphinx configuration sample (clean, simple, functional)

source src1 { type = mysql

    sql_host                = localhost
    sql_user                = test
    sql_pass                =
    sql_db                  = test
    sql_port                = 3306  # optional, default is 3306

    sql_query               = \
            SELECT id, group_id, UNIX_TIMESTAMP(date_added) AS date_added, title, content \
            FROM documents

    sql_attr_uint           = group_id
    sql_attr_timestamp      = date_added

    sql_query_info          = SELECT * FROM documents WHERE id=$id

} and I have this corrected in:

Minimal Sphinx configuration sample (clean, simple, functional)

source src1 { type = mysql

    sql_host                = localhost
    sql_user                = piler
    sql_pass                = securepass
    sql_db                  = piler
    sql_port                = 3306  # optional, default is 3306

    sql_query               = \
            SELECT id, group_id, UNIX_TIMESTAMP(date_added) AS date_added, title, content \
            FROM documents

    sql_attr_uint           = group_id
    sql_attr_timestamp      = date_added

    sql_query_info          = SELECT * FROM documents WHERE id=$id

} But I guess the query is not OK, what do I need to put there?

Thanks! RTop

[Janos SUTO]

Go to the piler source directory, I guess it's piler-0.1.24. Then go to etc directory inside. There you find a sphinx.conf file.

[Ronald Top]

Thanks! Looks like I got it running now. I just copied the one from the mailpiler sources /etc/sphinx.in in the /etc/sphinx dir (after editing the connection details of course). You can close this issue, thank you very much! Cheerz!

[Janos SUTO]

OK