[General] Webboard: Indexer not working for name-based https site

[bar]

Author: Stan
Email: 
Message:
Just want to add that mnogosearch's attempt at indexing the https version of 
the site produces no apache access logs leading me to believe that the indexer 
doesn't even try to access the site in the first place.

Indexing the non-ssl version generates hits in the access log as expected.

Reply: 

___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general

[General] Webboard: Indexer not working for name-based https site

[bar]

Author: Stan
Email: 
Message:
Hi,

I switched a development site to using https, using name-based host matching in 
apache (same IP, multiple sites) and the mnogosearch indexer no longer works:

[10072]{01} URL: https://test.somesite.com/
[10072]{01} ROBOTS: https://test.somesite.com/robots.txt
[10072]{01} No HTTP response status

If I specify http in indexer.conf, the indexing completes but adding a redirect 
to https in apache (which will be the case in production) breaks it.

The certificate is valid and signed by a CA (the site opens fine in a browser).

Here's the full output with verbose = 5:

https://pastebin.com/qQqWQjxN

Reply: 

___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general

[General] Webboard: indexer not working

[bar]

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: 

___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general

[General] Webboard: indexer not working

[bar]

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: 

___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general

[General] Webboard: indexer not working

[bar]

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: 

___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general

[General] Webboard: indexer not working

[bar]

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: 

___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general

[General] Webboard: indexer not working

[bar]

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: 

___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general

[General] Webboard: indexer not working

[bar]

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

mysql error 1044 

for other possible solutions if needed.

Reply: 

___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general

[General] Webboard: indexer not working

[bar]

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: 

___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general

[General] Webboard: indexer not working

[bar]

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

Reply: 

___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general

[General] Webboard: indexer not working

[bar]

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: 

___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general

[General] Webboard: indexer not working

[bar]

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


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


Reply: 

___
General mailing list
General@mnogosearch.org
http://lists.mnogosearch.org/listinfo/general