sphinx mysql socket location path change

  • hi

    i have installed wordpress in my localhost (Linux Pc) and i have install sphinx search plugin in my wordpress but wile clicking run indexing and continue buttion i get

    Indexer: reindexing error, try to run it manually.
    Command: /opt/lampp/htdocs/workspace/sph/wp-content/uploads/sphinx/bin/indexer –config /opt/lampp/htdocs/workspace/sph/wp-content/uploads/sphinx/sphinx.conf wp_delta wp_main wp_stats

    error and i have tried this Command: /opt/lampp/htdocs/workspace/sph/wp-content/uploads/sphinx/bin/indexer –config /opt/lampp/htdocs/workspace/sph/wp-content/uploads/sphinx/sphinx.conf wp_delta wp_main wp_stats

    manualy in linux terminal and i got
    Sphinx 0.9.9-release (r2117)
    Copyright (c) 2001-2009, Andrew Aksyonoff

    using config file ‘/opt/lampp/htdocs/workspace/sph/wp-content/uploads/sphinx/sphinx.conf’…
    indexing index ‘wp_delta’…
    ERROR: index ‘wp_delta’: sql_connect: Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) (DSN=mysql://root:***@localhost:3306/sphinxs).
    total 0 docs, 0 bytes
    total 0.000 sec, 0 bytes/sec, 0.00 docs/sec
    indexing index ‘wp_main’…
    ERROR: index ‘wp_main’: sql_connect: Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) (DSN=mysql://root:***@localhost:3306/sphinxs).
    total 0 docs, 0 bytes
    total 0.000 sec, 0 bytes/sec, 0.00 docs/sec
    indexing index ‘wp_stats’…
    ERROR: index ‘wp_stats’: sql_connect: Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) (DSN=mysql://root:***@localhost:3306/sphinxs).
    total 0 docs, 0 bytes
    total 0.000 sec, 0 bytes/sec, 0.00 docs/sec
    total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
    total 0 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg

    this error. and i found that i need to change the mysql socket location

    how can i change and where can i change

  • The topic ‘sphinx mysql socket location path change’ is closed to new replies.