[General] Webboard: indexer not working
Author: roebert Email: stu...@gmail.com Message: mysql seems not to be the problem: dsec023:/opt/src/mnogosearch-3.3.15 # mysql -u mnogo -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12070 Server version: 5.5.31-log Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql use mnogosearch; Database changed mysql show grants for CURRENT_USER; +- -- -- + | Grants for mnogo@localhost | +- -- -- + | GRANT USAGE ON *.* TO 'mnogo'@'localhost' IDENTIFIED BY PASSWORD '*21C1C788CC7B570384F0377F1ED167D3568F07EA' | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `mnogosearch`.* TO 'mnogo'@'localhost' | +- -- -- + 2 rows in set (0.00 sec) i also tried 3.3.14 after reinstalling 3.3.15 as i mentioned before: the mnogosearch i installed on the previous machine worked without problems... search.cgi gives me An error occurred! Inverted word index not found. Probably you forgot to run 'indexer - Eblob'. - this looks like it has the ability to connect to the database and read from it ... but the indexer wont fill the database : ( Reply: http://www.mnogosearch.org/board/message.php?id=21628 ___ General mailing list General@mnogosearch.org http://lists.mnogosearch.org/listinfo/general
[General] Webboard: indexer not working
Author: roebert Email: stu...@gmail.com Message: i am starting to think this mnogo hates me :( i made a script with this inside: /usr/local/mnogosearch/sbin/indexer -Edrop indexer.log 2 error.log /usr/local/mnogosearch/sbin/indexer -Ecreate indexer.log 2 error.log /usr/local/mnogosearch/sbin/indexer indexer.log 2 error.log /usr/local/mnogosearch/sbin/indexer -Eblob indexer.log 2 error.log the first 2 commands are working! indexer can drop the tables, indexer can create the tables ... but when it comes to indexing and -Eblob indexer won't connect .. still the same message: Log has not been opened DB err: MySQL driver: #1044: Access denied for user 'mnogo'@'localhost' to database 'mnogosearch' - /usr/local/mnogosearch/etc/indexer.conf:997: Indexing Loading URL list {dbmode-blob.c:4062} Query: LOCK TABLES bdicti READ, bdict_tmp WRITE MySQL driver: #1044: Access denied for user 'mnogo'@'localhost' to database 'mnogosearch' Reply: http://www.mnogosearch.org/board/message.php?id=21629 ___ General mailing list General@mnogosearch.org http://lists.mnogosearch.org/listinfo/general
[General] Webboard: indexer not working
Author: roebert Email: stu...@gmail.com Message: finally solved my problem with logging on the mysql-database ... after mnogo tried to lock a table it quit ... so the lock-table-right was missing for the mnogo-user (also missing in your documentary) Reply: http://www.mnogosearch.org/board/message.php?id=21630 ___ General mailing list General@mnogosearch.org http://lists.mnogosearch.org/listinfo/general
[General] Webboard: indexer not working
Author: Alexander Barkov Email: b...@mnogosearch.org Message: Hello, Hello, i had to move a website from an older server to a new one. on the old server in installed mnogosearch and it worked great. on the new server the indexer wont work. i created a mysql-user for the mnogo-database and edited search.htm and indexer.conf ... search.htm is working (it doesnt show me mysql 1045 can not connect but it shows 'An error occurred! Inverted word index not found. Probably you forgot to run 'indexer - Eblob'.) - meaning the indexer did not run properly ... but the indexer just gives me the same error everytime: Log has not been opened DB err: MySQL driver: #1044: Access denied for user 'mnogo'@'localhost' to database 'mnogosearch' - /usr/local/mnogosearch/etc/indexer.conf:997: Indexing Loading URL list {dbmode-blob.c:4062} Query: LOCK TABLES bdicti READ, bdict_tmp WRITE MySQL driver: #1044: Access denied for user 'mnogo'@'localhost' to database 'mnogosearch' the DBAddr in both files is: DBAddr mysql://mnogo:password@localhost/mnogosearch/? socket=/var/lib/mysql/mysql.sock what is the difference between indexer and search.cgi while connecting to the mysql? indexer needs more privileges, e.g. to do LOCK TABLES. Try GRANT LOCK TABLES for the user running indexer: https://dev.mysql.com/doc/refman/5.6/en/grant.html Reply: http://www.mnogosearch.org/board/message.php?id=21631 ___ General mailing list General@mnogosearch.org http://lists.mnogosearch.org/listinfo/general
[General] Webboard: Created a bug report
Author: Alexander Barkov Email: b...@mnogosearch.org Message: just an fyi: created a bug report for this since it is a reproducible crash on 2 different operating systems. Thanks for reporting the problem. Please find a fix at: http://www.mnogosearch.org/bugs/index.php?id=4835 Greetings! Reply: http://www.mnogosearch.org/board/message.php?id=21632 ___ General mailing list General@mnogosearch.org http://lists.mnogosearch.org/listinfo/general
[General] Webboard: indexer not working
Author: Alexander Barkov Email: b...@mnogosearch.org Message: finally solved my problem with logging on the mysql-database ... after mnogo tried to lock a table it quit ... so the lock-table-right was missing for the mnogo-user (also missing in your documentary) I put this on my TODO to add GRANT related things into the installation instructions. Thanks. Reply: http://www.mnogosearch.org/board/message.php?id=21633 ___ General mailing list General@mnogosearch.org http://lists.mnogosearch.org/listinfo/general
[General] Webboard: Thank you
Author: momma Email: Message: Thank you for resolving the issue. :) Reply: http://www.mnogosearch.org/board/message.php?id=21634 ___ General mailing list General@mnogosearch.org http://lists.mnogosearch.org/listinfo/general