Simple Invoices logo
    • CommentAuthormarkb81
    • CommentTimeMar 26th 2008 edited
     permalink
    Hi,

    Yesterday I installed simpleinvoices. Great program!
    I installed it on an IIS6/MySQL webserver (newest version of PHP) under a virtual directory secured with SSL.
    PDF creation isn't working.

    Can this be fixed? The error I get is below.

    Cannot connect to secure.xs-the.net:443. SSL Extension missing
    Connection error
    Could not open URL https://secure.xs-the.net/facturatie/index.php?module=invoices&view=templates/template&invoice=9&action=view&location=pdf you've specified.

    No response from server

    With kind regards,

    Mark
    • CommentAuthorjustin
    • CommentTimeMar 26th 2008 edited
     permalink
    Hey Mark,

    looks like your using .htaccsss (or whatever the IIS version of that is)

    PDF is not happy when using .htaccess

    but.. in config/config.php there are setting for username etc.. for .htacess protected systems
    - not sure if it'll work for IIS but you can give it a go

    let us know how you go

    Cheers

    Justin
    • CommentAuthormarkb81
    • CommentTimeMar 26th 2008 edited
     permalink
    Hi Justin,

    My system isn't .htaccess protected. It's protected with basic windows authentication.
    I searched for htaccess files and found one in library/pdf. I removed it, but it doesn't resolve the problem.
    Then I turned the whole authentication off (so no password is required anymore) but I still have the same problems.

    Can it be something else?

    Kind regards Mark
    • CommentAuthorjustin
    • CommentTimeMar 27th 2008 edited
     permalink
    Hi Mark,

    only suggestion i have is try editing config/config.php

    //if you are using a .httaccess file
    $http_auth = ""; //value: "name:password@"


    and set the http_auth section to whatever your basic windows auth user details and give it a go

    Cheers

    Justin
    • CommentAuthormarkb81
    • CommentTimeMar 27th 2008 edited
     permalink
    already tried that one :(
    • CommentAuthormarkb81
    • CommentTimeMar 27th 2008 edited
     permalink
    or maybe wrong.

    I tried this:

    $http_auth = ""; value: "username:password"

    is that correct? or do I have to fill something in between the quotes after http_auth?
    • CommentAuthorjustin
    • CommentTimeMar 27th 2008 edited
     permalink
    hey mark

    i didnt write that section and im no .htaccess guru

    but i assume its something like

    $http_auth = "justin@localhost"
    thats assuming
    - username = justin
    - password = mypassword
    - server = localhost

    please replace with your real values

    give the above and variations on it a go and let us know

    anyone else got some suggestions?

    Cheers

    Justin
    • CommentAuthormarkb81
    • CommentTimeMar 27th 2008 edited
     permalink
    still not working. still getting the SSL extension missing error.
    Is the PDF creation thingy something you used from another programmer? maybe they got a forum also?
    • CommentAuthordcaremani
    • CommentTimeMar 27th 2008 edited
     permalink
    mark

    Do you use $authenticationOn = "true"; ?
    make it "false" and check
    • CommentAuthormarkb81
    • CommentTimeMar 27th 2008 edited
     permalink
    I already use false
    • CommentAuthorjustin
    • CommentTimeMar 27th 2008 edited
     permalink
    hmm.. i've still got no ideas about this one

    any IIS people out there?

    cheers

    justin
    • CommentAuthormarkb81
    • CommentTimeMar 28th 2008 edited
     permalink
    anyone?? c'mon there's gotta be someone out there who got this config to work ;-)
    • CommentAuthorsgrayban
    • CommentTimeMar 30th 2008 edited
     permalink
    Linux my friend -- linux :) Everyone knows how insecure IIS is. However there is a port for apache to windows which is a better solution then IIS anyday.
    • CommentAuthorjustin
    • CommentTimeMar 30th 2008 edited
     permalink
    thanks sgrayban
    - unfortunately some organisations demand use of MS products all through the company (exchange, IIS, sql server, etc..) which makes IIS an unfortunate reality

    one suggestion is to remove the windows auth on the simple invoices directory and just use the Simple Invoices auth to protect it

    or just install a PDF printer on your PC and use that instead of the Simple Invoices PDF printing

    also refer: http://forums.iis.net/t/1146286.aspx />
    let us know how you go

    Cheers

    Justin
    • CommentAuthormarkb81
    • CommentTimeApr 2nd 2008 edited
     permalink
    but it's not windows auth. when I disable all authentication it still isnt working.
    an about apache, isn't that the worlds most hacked webserver ?? ;-)
    • CommentAuthorsgrayban
    • CommentTimeApr 2nd 2008 edited
     permalink
    LOL apache hackable ? ROFL that is funny.
    • CommentAuthortheITD
    • CommentTimeApr 7th 2008 edited
     permalink
    Could it be dns? The server is making the query, not your client - so the server could have it's loopback address associated with 'secure.xs-the.net'

    If it is, then this bug may be the cause: http://support.microsoft.com/?kbid=896861 />
    If not, and your dns points to the external address, (and your internal network uses private addressing), then your router would have to support 'reversible NAT', allowing the traffic to be sent back to the outside-NAT address.
    • CommentAuthormarkb81
    • CommentTimeApr 10th 2008 edited
     permalink
    yeah!!!! I'm finally getting somewhere. The SSL Extension missing error isn't simpleinvoice related, but php related.
    What you (if you're experiencing the same problem) need to do is download open SSL. Just google for the wiki and you'll find all the windows or apache or whatever installation stuff you need.
    After the installation enable php_openssl.dll in your php.ini and copy the dll from the extension folder to the right location, and voila... no SSL extension errors anymore ;-)

    Now I'm getting an HTTP 401 error, but someone named theITD was so friendly to post the possible solution to this problem before I had it ;-) so thanks very much and I'll keep you posted if this problem is solved also :-)
    • CommentAuthormarkb81
    • CommentTimeApr 10th 2008 edited
     permalink
    yeah! I got it working now. I modified the config file of simpleinvoices to enable authentication. Furthermore I used Basic Authentication in stead of NTLM. Last but not least I configured the php.ini to support 25M (memory). And I got my PDF. Thanks all!!
    • CommentAuthorjustin
    • CommentTimeApr 10th 2008 edited
     permalink
    awesome!!

    thanks to everyone involved, im very happy to see this issue sorted out!

    cheers

    justin