help with ABVFP and ssl... I think?

[provocr]

Hello,

I've previously had a form created using ABVFP but due to a mistake when viewing the sql database I was forced to delete the old ABVFP folder from my directory. I'd previously created the form before I had an ssl certificate.

I'm now trying to re-install the Advanced Form Builder but everytime I try and install I get the following message:

Could not connect to the database. Please check Database details !

Now, I;ve done this over 10 times, verifying name fields, trying CPusername_xxxx and CP_username_xxxx.

I've tried different passwords and tow different users; I've tried my siwth with http:// and https:// but it continues to throw me the error. Is there an issue with ssl based pages?

The first time I set this up it was a breeze! I;m now tearing what hair I have left, out!

Cheers,

[provocr]

Re: help with ABVFP and ssl... I think?

Okay; I realised I was being an idiot and hadn't set my ABVFP to 777 but once I'd done that and attempted to submit details again; I now get this error:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@nogymrequired.co.uk and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.




Not only that, but everytime I type the install address it now goes straight to this error!

Help!

[Karen Mac]

Re: help with ABVFP and ssl... I think?

You cant set it to 777... you need to set it to 775 or you will get this error.

Karen

[navaldesign]

Re: help with ABVFP and ssl... I think?

755 is the correct as Karen mentioned.

The database connection has nothing to do with ssl.

Recreate the user in the CP, and ADD the user to the alloed users list for the ABVFP database, then try again.

[provocr]

Re: help with ABVFP and ssl... I think?

Hello,

Its set to 755 but when I attempt a login I get the following:

Connection Error. Please check parameters in the file config.php

I've checked the config file and the info is correct but the mail address and the site address were missing. I've fixed this and saved the file but its still throwing up this error.

Here is an edited version of the config file:

<?
$dbts_username="*******";
$dbts_password="********";
$dbts_site="https://www.nogymrequired.co.uk";
$dbts_contactemail="mail@nogymrequired.co.uk";
$db_host="localhost";
$db_name="********_ABVFP";
$db_user="********_***";
$db_password="************";
?>

Cheers,

[provocr]

Re: help with ABVFP and ssl... I think?

Hello again,

I've edited the example form in the SQL database but when I enter a mail address and password into the form I get the following error via the AVBFP window:

No direct access is allowed!

Help!

Thanks,

[navaldesign]

Re: help with ABVFP and ssl... I think?

This last error has to do with the ssl.
You have used some httpaccess file or some other script that redirects non https links to the https.

Solution: change the action of the form to https://www.nogymrequired.co.uk/ABVFP/dbts_abvfp.php Note the https

However, you still have the DB connection issue.

[provocr]

Re: help with ABVFP and ssl... I think?

Thanks Naval. I am running a redirect scripot; but what am I supposed to be editing in the dbts_abvfp.php file? Its got quite a few scripts in there...

It also references the config script as a required script. If I am having a problem with getting past this check, should I edit this too?

Thanks,

[provocr]

Re: help with ABVFP and ssl... I think?

Good news and a further glitch

I deleted and rebuilt the folders and database content again and I was third time lucky. I've been able to go through the install and form setup process without a glitch - HOORAY!

However, everytime I test the form with various mail addresses, some I've used before, others, I hadn't; I am always redirected to my error page. Any chance you can decipher this?

Thanks for your patience on this; at least I'm not stuck in server error loops. I'd rather see my own page than a generic error page!

Thanks,

[provocr]

Re: help with ABVFP and ssl... I think?

I should add... the issue is with the form on the left (newsletter) found on the news page: www.nogymrequired.co.uk (full url - add index.php).

I've added the poll form via the AB with 100% success so its a little weird the newsletter is only throwing up errors.

Thanks,

[provocr]

Re: help with ABVFP and ssl... I think?

This is beginning to remind me of my QA Engineering days!

So, to try and get more info I decided to use your errorpage.php template and unlike my own error page I get this warning inside the editbox:

Illegal Form Submission

I'm not sure where to look next to resolve the issue? I checked the forums and there was a post about hidden fields but my only hidden field references the form number and this syncs up...

Cheers,

[navaldesign]

Re: help with ABVFP and ssl... I think?

Illegal form submission: this means that in the ABVFP control panel you have set as form URL something different than the actual one. Maybe you have forgotten the "s" in http ?? A Mistake in the URL is the ONLY reason for this error message (which, by the way, is for your own protection by anauthorized spammers trying to use your script to send spam).

[provocr]

Re: help with ABVFP and ssl... I think?

Thanks Naval.

I've checked the form fields via the admin page and they are all https://. I.ve also checked the form properties and it was https://.

Forgive me, but am I looking in the right area? Control Panel, Admin Area, Confg etc all seem so interchangeable.

Anyway, I thought I'd modify the form property itself (to http://) and it threw up this error. I don't want to confuse, I'm only trying to resolve the bug.

No direct access is allowed!

Thanks,

[navaldesign]

Re: help with ABVFP and ssl... I think?

I mean the ABVFP control panel, in other words the page where you set the form properties. Please note that the same error may display if in the menus you have the form URL with https://www. ...... whilst in the ABVFP cp you have missed the www or viceversa.

As i expalined, you can't change the form action to http:// because your script will redirect to the https:// but in the redirect the POST array (the form info) is lost, and that's why you get the "No direct access allowed" message.

[provocr]

Re: help with ABVFP and ssl... I think?

Thanks for a further reply, naval. The error continues to occur and I've copy/paste the addresses so I know they are in sync; I've created a new form but it continues to fail. Its not really making any sense; I quadruple checked everything specific to the error.

I'll keep trying and let you know how it goes

Best,