Re: [Quexf-discuss] Configuration

[David T. <pen...@ya...>]

Hi Adam,

Thanks for all of the help. Sorry it has taken me so long to reply. I had to go out of town and am back working on this.
I have things working in Mac OS!

I came across this in the FAQ section of entropy php (http://www.entropy.ch/software/macosx/php/#install)


"My PHP code is not executed and its source code is visible in the browser instead. Why?
The package installs PHP with the configuration option short_open_tags disabled. This means that you need to open your PHP code blocks with <?php and not just <?.
If you use the short form, you should go through all your PHP files and change it."
I went into the php.ini file enabled short_open_tags and the configuration test passed! I then imported a test form.
Again, thanks for all of the help.

Thanks for the Ubuntu/Debian tip. It can be helpful to know what you are developing on.

Dave


----- Original Message ----
From: Adam Zammit <ada...@ac...>
To: David Tisdell <pen...@ya...>
Cc: que...@li...
Sent: Sunday, August 2, 2009 7:17:05 PM
Subject: Re: [Quexf-discuss] Configuration

Dear David,

It appears that PHP is not executing the script if you see all that
text in your browser.

Regards,
Adam Zammit

2009/8/1 David Tisdell <pen...@ya...>:
>
> Hi Adam,
>
> I have been struggling along. Needed some support from entropy-PHP before writing back here. The only way for me to get the PHP GD functions was to replace Apple's built in PHP with Entropy-PHP. However, when I run the config test I get the following error whereas the config test ran fine with Apple's PHP;just wouldn't import forms.
> Anyway here is what I get when I run the config test. I know the database information is configured properly so I am thinking I need some edits in the php.ini file.
>
> Execute($sql))) { $fail = true; print "
>
> Could not connect to database. Make sure the database: " . DB_NAME . " exists on " . DB_HOST . " and that " . DB_USER . " 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
> "; }else { print "
>
> Database connection succeeded
> "; } if (is_file(GS_BIN)) { $ver = exec(GS_BIN . " --version"); if ($ver) { print "
>
> Found GhostScript version $ver
> "; } else { print "
>
> " . GS_BIN . " exists but can not execute it. Please make sure you are pointing to the executable file, not just the directory of Ghostscript
> "; $fail = true; } } else { echo "
>
> Could not find GhostScript in path: " . GS_BIN . "
>
> Please modify config.inc.php, GS_BIN to point to the gs executable. Also please make sure you are pointing to the executable file, not just the directory of Ghostscript
> "; $fail = true; } if (OCR_ENABLED) { if (is_file(TESSERACT_BIN)) { print "
>
> Found Tesseract
> "; } else { echo "
>
> Could not find Tesseract in path: " . TESSERACT_BIN . "
>
> Please modify config.inc.php, TESSERACT_BIN to point to the tesseract executable or disable OCR by changing OCR_ENABLED to false
> "; $fail = true; } if (is_file(CONVERT_BIN)) { print "
>
> Found ImageMagick
> "; } else { echo "
>
> Could not find ImageMagick in path: " . CONVERT_BIN . "
>
> Please modify config.inc.php, CONVERT_BIN to point to the convert executable or disable OCR by changing OCR_ENABLED to false
> "; $fail = true; } } if ($fail) { print "
> FAILED
> "; } else { print "
> Passed Configuration Test
> "; } ?>
>
> Thanks for all your help
>
> Dave
>
>
>
> ----- Original Message ----
> From: Adam Zammit <ada...@ac...>
> To: David Tisdell <pen...@ya...>
> Cc: que...@li...
> Sent: Thursday, July 9, 2009 7:30:14 PM
> Subject: Re: [Quexf-discuss] Configuration
>
> Hello David,
>
> It sounds like you don't have the PHP GD functions installed. (I'm not
> sure how this is done on a Mac)
>
> Regards,
> Adam Zammit
>
> 2009/7/10 David Tisdell <pen...@ya...>:
>>
>> Hi Adam,
>>
>> I am planning to run this on a Mac server. Rather than debugging my
>> install, I installed everything on the server. The versions of quexf
>> and adodb are the same.
>> The OS is Mac OS X 10.5.7 Server.
>> Apache is 2.2
>> MySQL is 5.0.67
>> PHP is 5.2.8
>> When I try and import the test form, I get this error:
>>
>> Fatal error:  Call to undefined function imagecreatefromstring() in /sync/web/quexf-1.8.1/admin/new.php on line 78
>>
>>
>>
>> What should I do next? I really appreciate all of the help.
>>
>> Dave
>>
>> ----- Original Message ----
>> From: Adam Zammit <ada...@ac...>
>> To: David Tisdell <pen...@ya...>
>> Cc: que...@li...
>> Sent: Thursday, July 9, 2009 1:32:22 AM
>> Subject: Re: [Quexf-discuss] Configuration
>>
>> Hi David,
>>
>> That seems to be working successfully. The problem must be elsewhere.
>>
>> Make sure that the process that is running the webserver has
>> permission to read from your temporary directory. Also have a look
>> through your PHP error logs to see if any messages will help.
>>
>> Regards,
>> Adam Zammit
>>
>> 2009/7/8 David Tisdell <pen...@ya...>:
>>>
>>> Hi Adam,
>>>
>>> That seemed to help. Here is the output of the cliL
>>>
>>> /usr/local/bin/gs -sDEVICE=pngmono -r300 -sOutputFile=/private/tmp/FORM2Im825%d.png-dNOPAUSE -dBATCH /Applications/mamp/htdocs/quexf-1.8.1/doc/test_blank.pdf
>>> GPL Ghostscript 8.64 (2009-02-03)
>>> Copyright (C) 2009 Artifex Software, Inc.  All rights reserved.
>>> This software comes with NO WARRANTY: see the file PUBLIC for details.
>>>   **** Warning:  Generation number out of 0..65535 range, assuming 0.
>>>   **** Warning:  Generation number out of 0..65535 range, assuming 0.
>>>   **** Warning:  Generation number out of 0..65535 range, assuming 0.
>>>   **** Warning:  File has an invalid xref entry:  2.  Rebuilding xref table.
>>> Processing pages 1 through 3.
>>> Page 1
>>> Loading NimbusSanL-Regu font from %rom%Resource/Font/NimbusSanL-Regu... 2861272 1120950 5953756 4651623 3 done.
>>>>>showpage, press <return> to continue<<
>>>
>>> Page 2
>>>>>showpage, press <return> to continue<<
>>>
>>> Page 3
>>>>>showpage, press <return> to continue<<
>>>
>>>
>>>   **** This file had errors that were repaired or ignored.
>>>   **** The file was produced by:
>>>   **** >>>> itext-paulo-155 (itextpdf.sf.net-lowagie.com) <<<<
>>>   **** Please notify the author of the software that produced this
>>>   **** file that it does not conform to Adobe's published PDF
>>>   **** specification.
>>>
>>> What is my next step? Thanks.
>>>
>>> Dave
>>>
>>>
>>>
>>> ----- Original Message ----
>>> From: Adam Zammit <ada...@ac...>
>>> To: David Tisdell <pen...@ya...>
>>> Cc: que...@li...
>>> Sent: Tuesday, July 7, 2009 7:20:49 PM
>>> Subject: Re: [Quexf-discuss] Configuration
>>>
>>> Hi David,
>>>
>>> Replace the final line with the filename, so it will go from this:
>>>
>>> /usr/local/bin/gs -sDEVICE=pngmono -r300
>>> -sOutputFile=/private/tmp/FORM2Im825%d.png-dNOPAUSE -dBATCH
>>> /Applications/MAMP/tmp/php/php1Ley5t
>>>
>>> to:
>>>
>>> /usr/local/bin/gs -sDEVICE=pngmono -r300
>>> -sOutputFile=/private/tmp/FORM2Im825%d.png-dNOPAUSE -dBATCH
>>> yourfile.pdf
>>>
>>>
>>> Regards,
>>> Adam Zammit
>>> 2009/7/8 David Tisdell <pen...@ya...>:
>>>>
>>>> Hi Adam,
>>>>
>>>> Here is the output in the browser when I try that:
>>>>
>>>> /usr/local/bin/gs -sDEVICE=pngmono -r300
>>>> -sOutputFile=/private/tmp/FORM2Im825%d.png-dNOPAUSE -dBATCH
>>>> /Applications/MAMP/tmp/php/php1Ley5t
>>>>
>>>> and this is the output from running the command in terminal:
>>>>
>>>> Error: /undefinedfilename in (/Applications/MAMP/tmp/php/php1Ley5t)
>>>> Operand stack:
>>>>
>>>> Execution stack:
>>>>   %interp_exit   .runexec2   --nostringval--   --nostringval--   --nostringval--   2   %stopped_push   --nostringval--   --nostringval--   --nostringval--   false   1   %stopped_push
>>>> Dictionary stack:
>>>>   --dict:1147/1684(ro)(G)--   --dict:0/20(G)--   --dict:69/200(L)--
>>>> Current allocation mode is local
>>>> Last OS error: 2
>>>> GPL Ghostscript 8.64: Unrecoverable error, exit code 1
>>>>
>>>> Where would I define the file name? You mentioned I may need to do that? Thanks.
>>>>
>>>>
>>>> Dave
>>>>
>>>>
>>>>
>>>> ----- Original Message ----
>>>> From: Adam Zammit <ada...@ac...>
>>>> To: David Tisdell <pen...@ya...>; que...@li...
>>>> Sent: Monday, July 6, 2009 11:29:46 PM
>>>> Subject: Re: [Quexf-discuss] Configuration
>>>>
>>>> Hi David,
>>>>
>>>> It is possible the problem is with the way we are executing ghostscript.
>>>>
>>>> Try the following:
>>>>
>>>> Edit the file: admin/new.php
>>>>
>>>> Add the following line (approx line 51) that prints out the exec statement:
>>>>
>>>> i.e after:
>>>> //print("gs -sDEVICE=pngmono -r300 -sOutputFile=$tmp%d.png -dNOPAUSE
>>>> -dBATCH $filename");
>>>>
>>>> add:
>>>>
>>>> print(GS_BIN . " -sDEVICE=pngmono -r300 -sOutputFile=$tmp%d.png
>>>> -dNOPAUSE -dBATCH $filename");
>>>>
>>>> Then try importing the form again. The command line argument should
>>>> appear on the screen.
>>>>
>>>> Try running the command exactly in a command window, and see if it is
>>>> successful (you may have to change the last filename reference at the
>>>> end of the line to refer directly to the test PDF file).
>>>>
>>>> Let us know what that produces.
>>>>
>>>> Regards,
>>>> Adam Zammit
>>>>
>>>> 2009/7/7 David Tisdell <pen...@ya...>:
>>>>>
>>>>> Hi Adam,
>>>>>
>>>>> Thanks. The OS is Mac OS X 10.4.11. I am using mamp to run apache, mysql, and php
>>>>> PHP version is 5.2.6
>>>>> MySQL version 5.0.41
>>>>> GhostScript version 8.64
>>>>> adodb version 5.09a
>>>>> Apache version 2.0.59
>>>>> quexf version 1.8.1
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Dave
>>>>>
>>>>>
>>>>> ----- Original Message ----
>>>>> From: Adam Zammit <ada...@ac...>
>>>>> To: David Tisdell <pen...@ya...>
>>>>> Cc: que...@li...
>>>>> Sent: Monday, July 6, 2009 10:12:18 PM
>>>>> Subject: Re: [Quexf-discuss] Configuration
>>>>>
>>>>> Hi David,
>>>>>
>>>>> Can you please let me know the versions you are using of the following systems:
>>>>> Operating system
>>>>> mySQL
>>>>> PHP
>>>>> Your web server (what it is as well)
>>>>> Ghostscript
>>>>> AdoDB
>>>>> queXF
>>>>>
>>>>> This will help in debugging the problem.
>>>>>
>>>>> Regards,
>>>>> Adam Zammit
>>>>>
>>>>> 2009/7/7 David Tisdell <pen...@ya...>:
>>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> I downloaded and installed quexf today. Following the directions, I have tried testing the import form function. After selecting the supplied test PDF and clicking the "upload form" button, I don't get any messages; just a blank page.
>>>>>> The directions say I should get:
>>>>>> BARCODE: 00000100
>>>>>> BARCODE: 00000102
>>>>>> BARCODE: 00000103
>>>>>> SUCCESSFULLY INSERTED NEW QUESTIONNAIRE
>>>>>>
>>>>>> I downloaded and copied the adodb the the web server root just as I did with quexf. The quexf test config says things are ok.
>>>>>> The adodb documentation is pretty sketchy on what file to edit. It talks about changes to make but never specifies the file.
>>>>>> Any suggestions on what I am missing?
>>>>>> Thanks.
>>>>>>
>>>>>> Dave
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------------------------
>>>>>> _______________________________________________
>>>>>> Quexf-discuss mailing list
>>>>>> Que...@li...
>>>>>> https://lists.sourceforge.net/lists/listinfo/quexf-discuss
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>
>
>
>
>