====== Forums ======
Users-list sur ma boite email
* mnoGoSearch Announcements : announce-subscribe@mnogosearch.org
* general-subscribe@mnogosearch.org
* [[http://lists.mnogosearch.org/listinfo/general|Subscribe and archives]]
* [[http://blog.gmane.org/gmane.comp.web.mnogosearch.general|blog.gmane]]
* [[http://www.mail-archive.com/general%40mnogosearch.org/|general mail archives]] (Trés bien fait)
* windows-subscribe@mnogosearch.org
* [[http://blog.gmane.org/gmane.comp.web.mnogosearch.windows|blog.gmane]]
* mnoGoSearch PHP frontend discussion : php-frontend-subscribe@mnogosearch.org
* [[http://lists.mnogosearch.org/listinfo/php-frontend|php-frontend Subscribe and archives]]
* [[http://blog.gmane.org/gmane.comp.web.mnogosearch.php-frontend|blog.gmane]]
* [[http://www.mail-archive.com/udmsearch%40web.izhcom.ru/|udm mail archives]]
**Autres**
[[http://www.mnogosearch.org/board/board.php?board=1&Offset=680|mnoGoSearch web board]]
[[http://www.developpez.net/forums/d460521/webmasters-developpement-web/general-conception-web/services/mnogosearch-php-session/|developper.com]]
[[http://forum.slackware-fr.org/viewtopic.php?id=3229|slackware-fr.org]]
====== FAQ ======
===== url et bicti corrompus =====
L'indexation plante : en fait dans phpmyadmin les tables bdicti et url sont marqués 'utilisées'.
Si on tape la commande
mysqlcheck -o -u root -pDolimysql! --all-databases
on s'aperçoit que le process boucle sur la table url de la base mnogosearch :
mnogosearch.bdict OK
mnogosearch.bdict_tmp OK
mnogosearch.bdicti
Error : Table './mnogosearch/bdicti' is marked as crashed and last (automatic?) repair failed
Error : Table 'bdicti' is marked as crashed and last (automatic?) repair failed
error : Corrupt
mnogosearch.categories Table is already up to date
mnogosearch.crossdict Table is already up to date
mnogosearch.dict Table is already up to date
mnogosearch.links Table is already up to date
mnogosearch.qcache Table is already up to date
mnogosearch.qinfo Table is already up to date
mnogosearch.qtrack Table is already up to date
mnogosearch.server OK
mnogosearch.srvinfo Table is already up to date
mnogosearch.url
Error : Table './mnogosearch/url' is marked as crashed and last (automatic?) repair failed
Error : Table 'url' is marked as crashed and last (automatic?) repair failed
error : Corrupt
^C
Il faut réparer les tables ISAM url et bdicti.
Toy d'abord stopper apache et mysql
/etc/init.d/apache2 stop
/etc/init.d/mysql stop
Vérifier que le fichier que nous souhaitons réparer contient bien des erreurs
myisamchk /var/lib/mysql/mnogosearch/url.MYI
puis lancer la procédure de réparation
myisamchk -r /var/lib/mysql/mnogosearch/url.MYI
===== la recherche avec accent n'est pas prise en charge =====
hodei@devhodei:/$mysql -u root -pDolimysql!
mysql> connect mnogosearch
mysql> ALTER TABLE bdict CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
mysql> ALTER TABLE bdicti CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
mysql> ALTER TABLE urlinfo CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
Cela ne suffit pas car une recherche ecrit dans la table bdict et la repasse en latin_sweden;
il faut initialiser les variables **$localcharset** et **$browsercharset** avec **utf-8** dans le fichier ./search.php
dans l'indexer.conf j'ai décommenté
#Localcharset utf-8
===== Inverted word index not found. Probably you forgot to run 'indexer -Eblob =====
Le message ci-dessus s'affiche aprés le lancement d'une recherche.
Pour résoudre le problème, j'ai lancé la commande suivante en 'live':
./indexer -Eblob -d /usr/local/mnogosearch/etc/indexer.conf
La commande retourne ceci :
indexer[[19179]]: Indexing
indexer[[19179]]: Loading URL list
indexer[[19179]]: Converting url.
indexer[[19179]]: Switching to new blob table.
indexer[[19179]]: Indexing finished 0.01
===== Indexer stop for indexing =====
2014-08-08 dev@hodei.net
Hi,
When i indexing my database, the indexer program stop : perhaps my mysql database is too big ? 17 GO
Here the message :
---------------------------------------------------------------------------------------------------------------------------------------------------
root 17549 0.0 0.0 7832 880 pts/1 S+ 11:25 0:00 grep indexer
root@bot:/usr/local/mnogosearch/sbin# ./indexer -Eblob /usr/local/mnogosearch/etc/indexer.conf
indexer[17550]: Indexing
indexer[17550]: Loading URL list
indexer[17550]: Converting intag00
indexer[17550]: Converting intag01
indexer[17550]: Converting intag02
indexer[17550]: Converting intag03
indexer[17550]: Converting intag04
indexer[17550]: Converting intag05
indexer[17550]: Converting intag06
indexer[17550]: Converting intag07
indexer[17550]: Converting intag08
indexer[17550]: Converting intag09
indexer[17550]: Converting intag0A
indexer[17550]: Converting intag0B
indexer[17550]: Converting intag0C
indexer[17550]: Converting intag0D
indexer[17550]: Converting intag0E
indexer[17550]: Converting intag0F
indexer[17550]: Converting intag10
indexer[17550]: Converting intag11
indexer[17550]: Converting intag12
indexer[17550]: Converting intag13
indexer[17550]: Converting intag14
indexer[17550]: Converting intag15
indexer[17550]: Converting intag16
indexer[17550]: Converting intag17
{dbmode-blob.c:4169} Query: UNLOCK TABLES
indexer[17550]: MySQL driver: #2006: MySQL server has gone away
root@bot:/usr/local/mnogosearch/sbin#
---------------------------------------------------------------------------------------------------------------------------------------------------
I send too the database information :
+--------------+------------+
| Tables | Size in MB |
+--------------+------------+
| bdict | 649.07 |
| bdict_tmp | 2112.98 |
| bdicti | 4144.23 |
| categories | 0.00 |
| crossdict | 0.00 |
| dict | 0.00 |
| links | 0.00 |
| qcache | 0.00 |
| qinfo | 0.00 |
| qtrack | 0.00 |
| server | 0.15 |
| srvinfo | 0.00 |
| url | 1493.58 |
| urlinfo | 10231.24 |
| wrdstat | 0.00 |
+--------------+------------+
17 rows in set (0.12 sec)
Thanks for your help
Je n'ai pas envoyé ce message car j'ai trouvé une solution [[http://bogdan.org.ua/2008/12/25/how-to-fix-mysql-server-has-gone-away-error-2006.html|ici]] :
Dans **/etc/mysql/my.cnf** il faut modifié le paramètre **max_allowed_packet** et mettre **64M** à la place de **16M** par exemple
ATTENTION l'indexation est tres longue 5h ...
le résutat à ce jour 08/08/2014 Total converted: 370963997 records, 1903913799 bytes