Thread: [Quexf-discuss] queXF 1.7.0 : Some tips to install it under Windows & Xampp...
Web based, Open Source alternative to Remark OMR or Teleform
Brought to you by:
azammitdcarf
From: Laurent P. <lau...@ri...> - 2009-02-26 09:13:16
|
Hi, I would like to add some comment on the queXF installation and particularly, how to set parameters inside config.inc.php file for a Windows machine using Xampp, regarding time I've spent to find the right values. Here is my folder arborescence : xampp anonymous apache cgi-bin htdocs adodb gs imagemagick quexf tesseract mysql perl php phpMyAdmin security sendmail tmp First of all, I've found in config.default.php a wrong value (for my configuration...) : if (!defined('DB_TYPE')) define('DB_TYPE', 'mysqlt'); I don't know if the 'mysqlt' DB type is a right value under linux but unfortunately, it's a wrong value under Windows/Xampp. So, I've added this line in my config.inc.php just after the DB_NAME parameter line : define('DB_TYPE', 'mysql'); The next lines concern the folder definition in the config.inc.php file. What I've added for all definition paths is dirname(__FILE__). Prefix function. So, here is my definition path : ... define('ADODB_DIR', dirname(__FILE__).'/../adodb/'); ... ***** On next line, you need to add the right ghostscript EXE and not just the folder ... //REQUIRED: Ghostscript binary define('GS_BIN', dirname(__FILE__).'/../gs/gs8.63/bin/gswin32c.exe'); //Temporary directory define('TEMPORARY_DIRECTORY', dirname(__FILE__)."/../tmp"); //OCR requires CONVERT_BIN (imagemagick convert binary) and TESSERACT_BIN (tessearct binary) to be enabled define('OCR_ENABLED', true); ***** On this part too, you need to specify the right EXE file define('CONVERT_BIN', dirname(__FILE__).'/../imagemagick/convert.exe'); define('TESSERACT_BIN', dirname(__FILE__).'/../tesseract/tesseract.exe'); ... So, I hope this will help you for a quick queXF installation under a Windows/Xampp setup. Best regards, Laurent |
From: Adam Z. <ada...@de...> - 2009-02-26 09:18:17
|
Thank you Laurent, Please be aware though, that you have set your database type as "mysql" this does not support transactions - which are necessary for the safe operation of queXF. The reason it wouldn't have worked for you is because you have not enabled the INNODb database engine type in your mySQL installation. I strongly recommend that you use the innodb engine, and set your database type to 'mysqlt' Regards, Adam Zammit On Thu, 2009-02-26 at 10:12 +0100, Laurent PIERRE wrote: > Hi, > > I would like to add some comment on the queXF installation and particularly, > how to set parameters inside config.inc.php file for a Windows machine using > Xampp, regarding time I've spent to find the right values. > > Here is my folder arborescence : > > xampp > anonymous > apache > cgi-bin > htdocs > adodb > gs > imagemagick > quexf > tesseract > mysql > perl > php > phpMyAdmin > security > sendmail > tmp > > First of all, I've found in config.default.php a wrong value (for my > configuration...) : > > if (!defined('DB_TYPE')) define('DB_TYPE', 'mysqlt'); > > I don't know if the 'mysqlt' DB type is a right value under linux but > unfortunately, it's a wrong value under Windows/Xampp. So, I've added this > line in my config.inc.php just after the DB_NAME parameter line : > > define('DB_TYPE', 'mysql'); > > The next lines concern the folder definition in the config.inc.php file. > What I've added for all definition paths is dirname(__FILE__). Prefix > function. So, here is my definition path : > > ... > define('ADODB_DIR', dirname(__FILE__).'/../adodb/'); > ... > > ***** On next line, you need to add the right ghostscript EXE and not just > the folder > ... > //REQUIRED: Ghostscript binary > define('GS_BIN', dirname(__FILE__).'/../gs/gs8.63/bin/gswin32c.exe'); > > //Temporary directory > define('TEMPORARY_DIRECTORY', dirname(__FILE__)."/../tmp"); > > //OCR requires CONVERT_BIN (imagemagick convert binary) and TESSERACT_BIN > (tessearct binary) to be enabled > define('OCR_ENABLED', true); > > ***** On this part too, you need to specify the right EXE file > > define('CONVERT_BIN', dirname(__FILE__).'/../imagemagick/convert.exe'); > define('TESSERACT_BIN', dirname(__FILE__).'/../tesseract/tesseract.exe'); > ... > > So, I hope this will help you for a quick queXF installation under a > Windows/Xampp setup. > > Best regards, > > Laurent > > > ------------------------------------------------------------------------------ > Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA > -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise > -Strategies to boost innovation and cut costs with open source participation > -Receive a $600 discount off the registration fee with the source code: SFAD > http://p.sf.net/sfu/XcvMzF8H > _______________________________________________ > Quexf-discuss mailing list > Que...@li... > https://lists.sourceforge.net/lists/listinfo/quexf-discuss -- Adam Zammit, Research Fellow in Survey Technology Deakin University 221 Burwood Hwy, Burwood Australia. Phone: 03 9251 7290 International: +61 3 9251 7290 Fax: 03 9251 7632 International: +61 3 9251 7632 Email: ada...@de... Website: http://www.deakin.edu.au/buslaw/dcarf/ Deakin University CRICOS Provider Code 00113B (Vic) Important Notice: The contents of this email are intended solely for the named addressee and are confidential; any unauthorised use, reproduction or storage of the contents is expressly prohibited. If you have received this email in error, please delete it and any attachments immediately and advise the sender by return email or telephone. Deakin University does not warrant that this email and any attachments are error or virus free. |
From: Adam Z. <ada...@de...> - 2009-02-26 22:26:01
|
Dear Laurent, I am not sure what is causing the problem in your particular situation. I recommend you download the queXF "Windows Installation" and use that, and upgrade queXF in place. That has been properly set up for use with InnoDB, etc. Documentation: http://quexf.sourceforge.net/node/15 Install file: http://sourceforge.net/project/showfiles.php?group_id=215100&package_id=306168&release_id=653602 Regards, Adam Zammit On Thu, 2009-02-26 at 12:09 +0100, Laurent PIERRE wrote: > Well, what I've found concerns the my.cnf file. This one has the right > defined lines to enable the use of InnoDB. Normally, InnoDB should be active > on my configuration. Here are the lines from my my.cnf file : > > ... > # Comment the following if you are using InnoDB tables > #skip-innodb > innodb_data_home_dir = "C:/Rivage/Development/Xampp/mysql/data" > innodb_data_file_path = ibdata1:30M:autoextend > innodb_log_group_home_dir = "C:/Rivage/Development/Xampp/mysql/data" > innodb_log_arch_dir = "C:/Rivage/Development/Xampp/mysql/data" > ## You can set .._buffer_pool_size up (16M) to 50 - 80 % > ## of RAM but beware of setting memory usage too high > innodb_buffer_pool_size = 24M > innodb_additional_mem_pool_size = 2M > ## Set .._log_file_size (5M) to 25 % of buffer pool size > innodb_log_file_size = 6M > innodb_log_buffer_size = 8M > innodb_flush_log_at_trx_commit = 1 > innodb_lock_wait_timeout = 50 > ... > > So, I've changed my config.inc.php to obtain this line : > > define('DB_TYPE', 'mysqlt'); > > and after a restart of my Xampp modules, I try the testconfig.php. Here is > the displayed result : > > ========================================================================== > Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL > server on '127.0.0.1' (10061) in > C:\Rivage\Development\Xampp\htdocs\adodb\drivers\adodb-mysql.inc.php on line > 364 > > Could not connect to database. Make sure the database: dbquexf exists on > 127.0.0.1 and that root has privileges to it, otherwise modify > config.inc.php to point to the correct database. Also make sure you have > loaded the database structure from quexf.sql > > Found GhostScript version 8.63 > > Found Tesseract > > Found ImageMagick > FAILED > ========================================================================== > > The surprise for me, is to read the adodb-mysql.inc.php whereas I should > read adodb-mysqlt.inc.php > > Do I need to modify other setting files ? > > Thanks for your patience. > Regards, > > Laurent > -- Adam Zammit, Research Fellow in Survey Technology Deakin University 221 Burwood Hwy, Burwood Australia. Phone: 03 9251 7290 International: +61 3 9251 7290 Fax: 03 9251 7632 International: +61 3 9251 7632 Email: ada...@de... Website: http://www.deakin.edu.au/buslaw/dcarf/ Deakin University CRICOS Provider Code 00113B (Vic) Important Notice: The contents of this email are intended solely for the named addressee and are confidential; any unauthorised use, reproduction or storage of the contents is expressly prohibited. If you have received this email in error, please delete it and any attachments immediately and advise the sender by return email or telephone. Deakin University does not warrant that this email and any attachments are error or virus free. |
From: Adam Z. <ada...@de...> - 2009-03-02 03:32:29
|
Dear Laurent, Thank you for pointing out this issue. To verify, you simply access the base directory of the queXF installation (index.php), then click on "Verify". Please note that you must have directory authentication enabled, and have added operators in the queXF administration system, as is described in the documentation. Regards, Adam Zammit On Fri, 2009-02-27 at 10:47 +0100, Laurent PIERRE wrote: > Hello Adam, > > I've found the problem... > Since my last MySQL update, the line bellow in my.cnf, must be now commented > : > > #innodb_log_arch_dir = "C:/Rivage/Development/Xampp/mysql/data/" > > You should modify your installation regarding this remark. > > Here is comment from the net : > ================================= > Description: > The variable innodb_log_arch_dir has been unsused since 4.0.6 or so, and has > been > deprecated since 5.0.24 according to the version docs > ================================= > > So, I retrieve the "Passed Configuration Test" for the testconfig.php now. > > I've read the documentation (http://quexf.sourceforge.net/node/16) under > "Operator Tasks". > I must say that I cannot find the verifier step under my queXF admin > functions and I think now, it's for this reason that I cannot have output > data. > > How can I do to access to this step ?? Do I need to execute a specific php > script ? > > Once again, thank you for your precious help. > > Best regards, > > Laurent > > > > -----Original Message----- > From: Adam Zammit [mailto:ada...@de...] > Sent: jeudi 26 février 2009 23:26 > To: lau...@ri... > Cc: quexf maillist > Subject: RE: [Quexf-discuss] queXF 1.7.0 : Some tips to install it under > Windows & Xampp... > > Dear Laurent, > > I am not sure what is causing the problem in your particular situation. > > I recommend you download the queXF "Windows Installation" and use that, and > upgrade queXF in place. That has been properly set up for use with InnoDB, > etc. > > Documentation: > http://quexf.sourceforge.net/node/15 > > Install file: > http://sourceforge.net/project/showfiles.php?group_id=215100&package_id=3061 > 68&release_id=653602 > > > Regards, > Adam Zammit > > On Thu, 2009-02-26 at 12:09 +0100, Laurent PIERRE wrote: > > Well, what I've found concerns the my.cnf file. This one has the right > > defined lines to enable the use of InnoDB. Normally, InnoDB should be > > active on my configuration. Here are the lines from my my.cnf file : > > > > ... > > # Comment the following if you are using InnoDB tables #skip-innodb > > innodb_data_home_dir = "C:/Rivage/Development/Xampp/mysql/data" > > innodb_data_file_path = ibdata1:30M:autoextend > > innodb_log_group_home_dir = "C:/Rivage/Development/Xampp/mysql/data" > > innodb_log_arch_dir = "C:/Rivage/Development/Xampp/mysql/data" > > ## You can set .._buffer_pool_size up (16M) to 50 - 80 % ## of RAM but > > beware of setting memory usage too high innodb_buffer_pool_size = 24M > > innodb_additional_mem_pool_size = 2M ## Set .._log_file_size (5M) to > > 25 % of buffer pool size innodb_log_file_size = 6M > > innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 > > innodb_lock_wait_timeout = 50 ... > > > > So, I've changed my config.inc.php to obtain this line : > > > > define('DB_TYPE', 'mysqlt'); > > > > and after a restart of my Xampp modules, I try the testconfig.php. > > Here is the displayed result : > > > > ====================================================================== > > ==== > > Warning: mysql_connect() [function.mysql-connect]: Can't connect to > > MySQL server on '127.0.0.1' (10061) in > > C:\Rivage\Development\Xampp\htdocs\adodb\drivers\adodb-mysql.inc.php > > on line > > 364 > > > > Could not connect to database. Make sure the database: dbquexf exists > > on > > 127.0.0.1 and that root has privileges to it, otherwise modify > > config.inc.php to point to the correct database. Also make sure you > > have loaded the database structure from quexf.sql > > > > Found GhostScript version 8.63 > > > > Found Tesseract > > > > Found ImageMagick > > FAILED > > ====================================================================== > > ==== > > > > The surprise for me, is to read the adodb-mysql.inc.php whereas I > > should read adodb-mysqlt.inc.php > > > > Do I need to modify other setting files ? > > > > Thanks for your patience. > > Regards, > > > > Laurent > > > -- > Adam Zammit, Research Fellow in Survey Technology > > Deakin University 221 Burwood Hwy, Burwood Australia. > Phone: 03 9251 7290 International: +61 3 9251 7290 > Fax: 03 9251 7632 International: +61 3 9251 7632 > Email: ada...@de... > Website: http://www.deakin.edu.au/buslaw/dcarf/ > Deakin University CRICOS Provider Code 00113B (Vic) > > Important Notice: The contents of this email are intended solely for the > named addressee and are confidential; any unauthorised use, reproduction or > storage of the contents is expressly prohibited. If you have received this > email in error, please delete it and any attachments immediately and advise > the sender by return email or telephone. > > Deakin University does not warrant that this email and any attachments are > error or virus free. > > -- Adam Zammit, Research Fellow in Survey Technology Deakin University 221 Burwood Hwy, Burwood Australia. Phone: 03 9251 7290 International: +61 3 9251 7290 Fax: 03 9251 7632 International: +61 3 9251 7632 Email: ada...@de... Website: http://www.deakin.edu.au/buslaw/dcarf/ Deakin University CRICOS Provider Code 00113B (Vic) Important Notice: The contents of this email are intended solely for the named addressee and are confidential; any unauthorised use, reproduction or storage of the contents is expressly prohibited. If you have received this email in error, please delete it and any attachments immediately and advise the sender by return email or telephone. Deakin University does not warrant that this email and any attachments are error or virus free. |