Webboard: indexer not working

[b***@mnogosearch.org]

Author: roebert
Email: ***@gmail.com
Message:
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:***@localhost/mnogosearch/?
socket=/var/lib/mysql/mysql.sock


what is the difference between indexer and search.cgi while connecting
to the mysql?


Reply: <http://www.mnogosearch.org/board/message.php?id=21622>

[b***@mnogosearch.org]

Author: momma
Email:
Message:
Those errors mean that the app can not connect to mysql using the username and password you provided.

try just running mysql from the command line to make sure you can login using those parameters:

mysql -uusername -ppassword databasename

example:

mysql -umnogo -ppassword mnogosearch

Reply: <http://www.mnogosearch.org/board/message.php?id=21623>

[b***@mnogosearch.org]

Author: roebert
Email: ***@gmail.com
Message:
connecting from commandline is working with the mnogo-user ...

Reply: <http://www.mnogosearch.org/board/message.php?id=21624>

[b***@mnogosearch.org]

Author: momma
Email:
Message:
Perhaps the user has not been granted the proper privs to the database.

I believe the mysql command is:

show grants for username

where username -s the username you are using in the config file.

But, I would Google it first to be sure.

mnogosearch probably needs full privs since it needs to drop and create
tables among other things.

Reply: <http://www.mnogosearch.org/board/message.php?id=21625>

[b***@mnogosearch.org]

Author: momma
Email:
Message:
p.s. you can also google:

mysql error 1044

for other possible solutions if needed.

Reply: <http://www.mnogosearch.org/board/message.php?id=21626>

[b***@mnogosearch.org]

Author: roebert
Email: ***@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 ***@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>

[b***@mnogosearch.org]

Author: roebert
Email: ***@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>

[b***@mnogosearch.org]

Author: roebert
Email: ***@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>

[b***@mnogosearch.org]

Author: Alexander Barkov
Email: ***@mnogosearch.org
Message:
Hello,

Post by b***@mnogosearch.org
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
Indexing
Loading URL list
{dbmode-blob.c:4062} Query: LOCK TABLES bdicti READ, bdict_tmp WRITE
database '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>

[b***@mnogosearch.org]

Author: Alexander Barkov

Post by b***@mnogosearch.org
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>