Just getting started...

Connection denied error in file upload process.
Unsure how to get basic functionality off the ground.

Connection denied error in file upload process. (Error message shown at bottom of post)
Unsure how to get basic functionality off the ground.
Here is the error message I get when uploading my php files to the remote server.
I'm hosted by GoDaddy.
I have a simple form, comments and email.
This is what I do...

Insert -> WebAssist -> Create Email Message...
... From there I just put a to and from email basically..
... Trigger : any form post
... Go to Page : home page or index.php
... Subject : test

And I create a file and select default file.

I've tried using no file and using default file.
I've tried using my smtp server information as well.

No idea what to do from here.
I'd like to fix the Connection error message and see where that gets me.

But I'd also like to have this up and running, so if it would be easier to troubleshoot it va the $49 one time ticket, I'd happily do that.


HERE'S THE ERROR MESSAGE I GET
=================================================================
Started: 3/24/2011 12:06 PM

testmailer.php - Put operation successful
webassist\email\mail_php.php - same - not transferred
webassist\email\mailformatting_php.php - same - not transferred
Connections - error occurred - Access denied. The file may not exist locally, may be open in another program, or there could be a local permission problem.
webassist\email\waue_testmailer_2.php - Put operation successful
images\125MHM.jpg - same - not transferred

File activity incomplete. 1 file(s) or folder(s) were not completed.
Files updated: 2
Files skipped: 3

Files with errors: 1
Connections

close all of the files that are open in Dreamweaver,

Then in the files panel select the Connection folder and the click the Up arrow to upload it.


Make sure that the connection has been modified for the remote GoDaddy mysql server be=fore uploading it. See the "Managing your live database settings" tutorial on the Learning resources page for details:
resources.php

Hi Jason, thanks for the help.
I don't understand that aspect of it.
I don't want to store that data in a SQL database.
I just want to send the form information to an email destination of my choice.
I do use dynamic databases for other purposes, so I know I connect to it no problem.
What am I missing here?
I'd be happy to pay the $49 if you could walk me through this process to get up and running.

My needs here are quite elementary, I assure you I wont be looking for complex solutions.

My confusion relates in you reply relates to: 'for the remote GoDaddy mysql server'. I'm not quite sure what you mean by that.

I'm going to go through the link you suggested again right now, but I tried that with no luck.

==============================================================================================

===============================================
Okay, look 2.
I have mySQL, and SQL Server. Both show up in my Hosting Control Panel under databases. I use mySQL for dynamic data in my site, but I did not have a SQL Server database. I went ahead and set that up, and once it's up and running I believe I know how to set up the connection from there. I'll give that a shot and then report back if I'm still having trouble. Thanks Jason.

I was mentioning the remote godaddy mysql server because the error was happening on the Connections file, this file creates a connection to the MySQL server.

in actual fact, if that file has been uploaded to the server at another time, then the error can be ignored, it should really only ever be uploaded to the server once. Since you mention using a database in your site before, I would think the connection file is already uploaded.

What happens if you test the testmailer.php file in the browser.

It depends on whether or not I include the /gdform.php supplied by Go Daddy. If include that in the form action via post method it will send the email, but it will only send it to the email address I've entered in my hosting control panel form mailer area. I'm under the impression that with Web Assist Universal Email I no longer need the /gdform.php supplied by Go Daddy. In the same form, if I don't incude the /gdform.php in the Action link then I get an error telling me it can't find the gdform. The error reads

Not Found

The requested URL /gdform.php was not found on this server.

If I include the form, it doesn't matter what I put into the Insert -> Web Assist -> Create Email message, it will only send to the email listed in my control panel form mailer area.

Does that make sense?

I guess I'm not clear if I need the /gdform or not. I'm under the impression I don't, I'm under the impression that's what the Extension does for me.

That said, I am really lost when it comes to the relationship between the form and the extension. I'm trying to use the simplest form I can think of, which is just an email address and comments. Do I need to have every field that's contained in the Web Assist Create Email Message in my form? How do they match up?

I think once I have the ability to direct email, and simply get the thing to work I'll be able to work with the form and the structure, but I'm at a loss there.

At the end of the day I need this functionality up and running sooner than later, and I'm afraid this is going to take me a week or two to try to solve in this forum. I'm happy to spend $49 to expedite this set up process.

GD FORM SCRIPT
======================
<?php
$request_method = $_SERVER["REQUEST_METHOD"];
if($request_method == "GET")
{
$query_vars = $_GET;
}
elseif ($request_method == "POST")
{
$query_vars = $_POST;
}

reset($query_vars);
$t = date("U");
$file = $_SERVER['DOCUMENT_ROOT'] . "\ssfm\gdform_" . $t;
$fp = fopen($file,"w");

while (list ($key, $val) = each ($query_vars))
{
fputs($fp,"<GDFORM_VARIABLE NAME=$key START>\r\n");
fputs($fp,"$val\r\n");
fputs($fp,"<GDFORM_VARIABLE NAME=$key END>\r\n");
if ($key == "redirect")
{
$landing_page = $val;
}
}

fclose($fp);

if ($landing_page != "")
{
header("Location: http://".$_SERVER["HTTP_HOST"]."/$landing_page");
}
else
{
header("Location: http://".$_SERVER["HTTP_HOST"]."/");
}
?>
=======================================================


TESTMAILER FORM SCRIPT
=======================================================
<?php require_once("webassist/email/mail_php.php"); ?>
<?php require_once("webassist/email/mailformatting_php.php"); ?>
<?php
if (!isset($_SESSION))session_start();
if (($_SERVER["REQUEST_METHOD"] == "POST")) {
//WA Universal Email object="mail"
set_time_limit(0);
$EmailRef = "waue_testmailer_2";
$BurstSize = 200;
$BurstTime = 1;
$WaitTime = 1;
$GoToPage = "index.php";
$RecipArray = array();
$StartBurst = time();
$LoopCount = 0;
$TotalEmails = 0;
$RecipIndex = 0;
// build up recipients array
$CurIndex = sizeof($RecipArray);
$RecipArray[$CurIndex] = array();
$RecipArray[$CurIndex ][] = "bdgasner9@yahoo.com";
$TotalEmails += sizeof($RecipArray[$CurIndex]);
$RealWait = ($WaitTime<0.25)?0.25:($WaitTime+0.1);
$TimeTracker = Array();
$TotalBursts = floor($TotalEmails/$BurstSize);
$AfterBursts = $TotalEmails % $BurstSize;
$TimeRemaining = ($TotalBursts * $BurstTime) + ($AfterBursts*$RealWait);
if ($TimeRemaining < ($TotalEmails*$RealWait) ) {
$TimeRemaining = $TotalEmails*$RealWait;
}
$_SESSION[$EmailRef."_Total"] = $TotalEmails;
$_SESSION[$EmailRef."_Index"] = 0;
$_SESSION[$EmailRef."_Remaining"] = $TimeRemaining;
while ($RecipIndex < sizeof($RecipArray)) {
$EnteredValue = is_string($RecipArray[$RecipIndex][0]);
$CurIndex = 0;
while (($EnteredValue && $CurIndex < sizeof($RecipArray[$RecipIndex])) || (!$EnteredValue && $RecipArray[$RecipIndex][0])) {
$starttime = microtime_float();
if ($EnteredValue) {
$RecipientEmail = $RecipArray[$RecipIndex][$CurIndex];
} else {
$RecipientEmail = $RecipArray[$RecipIndex][0][$RecipArray[$RecipIndex][2]];
}
$EmailsRemaining = ($TotalEmails- $LoopCount);
$BurstsRemaining = ceil(($EmailsRemaining-$AfterBursts)/$BurstSize);
$IntoBurst = ($EmailsRemaining-$AfterBursts) % $BurstSize;
if ($AfterBursts<$EmailsRemaining) $IntoBurst = 0;
$TimeRemaining = ($BurstsRemaining * $BurstTime * 60) + ((($AfterBursts<$EmailsRemaining)?$AfterBursts:$EmailsRemaining)*$RealWait) - (($AfterBursts>$EmailsRemaining)?0:($IntoBurst*$RealWait));
if ($TimeRemaining < ($EmailsRemaining*$RealWait) ) {
$TimeRemaining = $EmailsRemaining*$RealWait;
}
$CurIndex ++;
$LoopCount ++;
session_commit();
session_start();
$_SESSION[$EmailRef."_Index"] = $LoopCount;
$_SESSION[$EmailRef."_Remaining"] = round($TimeRemaining);
session_commit();
wa_sleep($WaitTime);
include("webassist/email/waue_testmailer_2.php");
$endtime = microtime_float();
$TimeTracker[] =$endtime - $starttime;
$RealWait = array_sum($TimeTracker)/sizeof($TimeTracker);
if ($LoopCount % $BurstSize == 0 && $CurIndex < sizeof($RecipArray[$RecipIndex])) {
$TimePassed = (time() - $StartBurst);
if ($TimePassed < ($BurstTime*60)) {
$WaitBurst = ($BurstTime*60) -$TimePassed;
wa_sleep($WaitBurst);
}
else {
$TimeRemaining = ($TotalEmails- $LoopCount)*$RealWait;
}
$StartBurst = time();
}
if (!$EnteredValue) {
$RecipArray[$RecipIndex][0] = mysql_fetch_assoc($RecipArray[$RecipIndex][1]);
}
}
$RecipIndex ++;
}
$_SESSION[$EmailRef."_Total"] = 0;
$_SESSION[$EmailRef."_Index"] = 0;
$_SESSION[$EmailRef."_Remaining"] = 0;
session_commit();
session_start();
if ($GoToPage!="") {
header("Location: ".$GoToPage);
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>I just want to send a quick email...</title>
</head>

<body>
<p><a href="index.php">Home</a></p>
<form id="form1" name="form1" method="post" action="/gdform.php">
<input type="hidden" name="redirect" value="index.php" />
<p>
<label for="title">Comments: </label>
<textarea name="title" cols="150" rows="6" id="title"></textarea>
</p>
<p>
<label for="email">Email:</label>
<input name="email" type="text" id="email" size="50" />
</p>
<p>
<input type="submit" name="button" id="button" value="Send Email..." />
</p>
</form>
<p><img src="images/125MHM.jpg" width="235" height="125" alt="MHM" /></p>
</body>
</html>
===========================================================

Connection Page information with username and password crossed out
===============================================================
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_First_Ever = "itsjustanemail.db.7592921.hostedresource.com";
$database_First_Ever = "itsjustanemail";
$username_First_Ever = "xxxxxxxxx";
$password_First_Ever = "xxxxxxxx";
$First_Ever = mysql_pconnect($hostname_First_Ever, $username_First_Ever, $password_First_Ever) or trigger_error(mysql_error(),E_USER_ERROR);
?>
===============================================================
I'm not sure what other information to get you.
I really have absolutely no clue where to begin here.
I'm able to manage my web site and use dynamic data, but when it comes to form mailing I"m lost.

the forms action should not be set t post to the gdform.php script.


you would use the gdform.php script in place of Universal Email, not with it.


you should change the forms action:
<form id="form1" name="form1" method="post" action="/gdform.php">

to:
<form id="form1" name="form1" method="post" action="">

so that the form will post to itself.


When using Universal Email, the only time the connection file to the database is an issue is if you have set up the email logging features.


GoDaddy can be meritoriously troublesome with sending emails. Before starting with Universal Email, you should double check the following with GoDaddy:

Is your hosting package Unix or Windows? If it is Windows, you should have them transition you to a Unix Host.

s your PHP running PHP 4 or 5? If it is running PHP 4, you should have them upgrade you to PHP 5.


Once you can verify that you are on a Unix host running PHP 5, here the most basic steps for creating a page that will send an email using Universal Email.

1) Start with a blank PHP page, Add a form to it(Insert -> Form -> Form). In the form add a text box (Insert-> Form -> Text Field), and a submit button (Insert -> Form -> Button). at this stage, the entire page should look like this in code view:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
</head>

<body>
<form id="form1" name="form1" method="post" action="">
  <input type="text" name="email" id="email" />
  <br />
  <input type="submit" name="button" id="button" value="Submit" />
</form>
</body>
</html>

2) Add universal Email to the page. Go to Webassist -> Create Email Message.

Use the following settings on the main page of the wizard:
- Trigger to: Any Form Post
- Go To page: thankyou.php (make sure you create this page also)
- From: use a valid email for your domain, for example if my domain is:
mydomain.com
I would use something like: contact@mydomain.com
-To: Click the lightning bolt and select the email form element from the dynamic data bindings.
- Subject: Your Test Email

In the email Body sect, check the option to create a file for the email and select a template.

3) In the toolbar section, click the envelope icon to configure mail server settings. use the following settings:
-Email object: Mail
-Character Set: Default
-SMTP Server: relay-hosting.secureserver.net
-Port: 25
- Check the Include From Address as an additional parameter option

see the attached screen shots for examples of the settings to use.

Once you have configured the Mail Server settings click the OK button to save them, verify that the settings in the initial screen are correct, then click the finish button.

Now you need to upload your page, and the webassist directory.

none of the settings that where used in this example need a database connection, so any errors about a connection file can be ignored.

Okay, got that in the works, they say it can take up to 24 hours, so it'll be a while before you hear back from me. I didn't read the 2nd part yet, so I'll try that and then follow up. Thanks for the help, have a great weekend!

you're welcome.