PHP - Sqlstate[hy000] [1130] Host 'xxx.xxx.xx.xxx' Is Not Allowed To Connect To This Mysql Server

hi all, i have a test server (newest xampp) and the code works fine, as soon as i upload to 1and1 (they use apachi, php and mysql) i get this message: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
i have double checked username and passwords, had a look on google, contacted there support with no luck yet.
i am wondering if its a mysql or php version problem, so hoping someone knows when the following code with classes etc was added or if someone knows how to fix it i be really greatful.
heres some of the code i am using

class cyberglide {

var $host;

var $username;

var $password;

var $db;

function connect() {

$con = mysql_connect($this->host, $this->username, $this->password) or die (mysql_error());

mysql_select_db($this->db, $con) or die(mysql_error());

}

function get_top() {

        if (isset($_GET['page']))
 {

 

$page = $_GET['page'];

// Display Page.
                $sql = "SELECT title,body FROM content WHERE page = '$page' AND location = 'left' AND disabled = 'no' ORDER BY id";
                $res = mysql_query($sql) or die (mysql_error());
                while($row = mysql_fetch_assoc($res)){

echo '<h1>' . $row['title'] . '</h1>';

                    echo '<p>' . $row['body'] . '</p>';

}

}

        else
        {
                //Show Home Page
                $sql = "SELECT title,body FROM content WHERE page = 'home' AND location = 'left' AND disabled = 'no' ORDER BY id";
                $res = mysql_query($sql) or die (mysql_error());
                while($row = mysql_fetch_assoc($res)){

echo '<h1>' . $row['title'] . '</h1>';
                    echo '<p>' . $row['body'] . '</p>';  
                }

  }

}

function get_left() {

        if (isset($_GET['page']))
 {

 

$page = $_GET['page'];

// Display Page.
                $sql = "SELECT title,body FROM content WHERE page = '$page' AND location = 'left' AND disabled = 'no' ORDER BY id";
                $res = mysql_query($sql) or die (mysql_error());
                while($row = mysql_fetch_assoc($res)){

echo '<h1>' . $row['title'] . '</h1>';

                    echo '<p>' . $row['body'] . '</p>';

}

}

        else
        {
                //Show Home Page
                $sql = "SELECT title,body FROM content WHERE page = 'home' AND location = 'left' AND disabled = 'no' ORDER BY id";
                $res = mysql_query($sql) or die (mysql_error());
                while($row = mysql_fetch_assoc($res)){

echo '<h1>' . $row['title'] . '</h1>';
                    echo '<p>' . $row['body'] . '</p>';  
                }

}

}
}//Ends Our Class

db file

//Setup Our Connection Vars

$obj->host = 'localhost';

$obj->username = 'root';

$obj->password = '';

$obj->db = 'db361371865';
 
 

//Connect To Our Database

$obj->connect();

many thanks all.

I apologize if this isn't the exact right location for this question, but it's the best place I could find.  I work for a small business and the server hosting our website recently disabled FormMail.  We no longer have a webdesigner per se and I've been the one taking care of the website.  Unfortunately the few programming classes I've taken have mostly left me by now and I'm banging my head against the wall trying to find a way to get back our multiple feedback forms.  I'm sure the best thing would be to hire someone, but business hasn't been great and the boss is counting on me, so I'm hoping someone here may have some suggestions.  I've been corresponding with our server trying to get some suggestions on what to do and this is the best they've been able to tell me;

"The reason being that Shared Servers must have
the ability for php/cgi to send mail disabled as a protection against
darkmailer, so any form or scripts that would send mail must be able to
authenticate itself to the server as a valid user."

"If you can find a method to send the
mail without php/cgi, or one that does go through the steps to authenticate as
a valid user (specifically, as you), then we can probably get you all set up."

"The only option at this point would
be to correct your script to authenticate as a valid email user."

"...you would need to change your scripts to
login with a mail user to authenticate and send mail."

Now I'm not completely programming illiterate; I mean, I passed my classes in college, but I can't figure out how to do this.  They say they don't allow any FormMail or FormMail Clones, so I'm fairly lost.  If anyone has any helpful hints or suggestions I would appreciate it greatly.

Thanks,
Zach

hi all

First of all

My client have dot net server on windows OS. They want to display some pages which are created by php. Is there any possibility to display like this.

And

How can i connect sql server using php on remote to retrieve data.

Can any one tell me how can i do this.

Thanks in advance

Hi I am trying to send email through following php code to may gmail account but it givrs me SMTP Error: Could not connect to SMTP host. *******************************************************************************************************************************************************

<?phpif(isset($_POST['submit'])){
$message='Full Name: '.$_POST['fullname'].'<br 
/>Subject: '.$_POST['subject'].'<br 
/>Phone: '.$_POST['phone'].'<br 
/>Email: '.$_POST['emailid'].'<br 
/>Comments: '.$_POST['comments'].'';    
require "phpmailer/class.phpmailer.php"; //include phpmailer 
class         // Instantiate 
Class     $mail = new 
PHPMailer();          // 
Set up SMTP     
$mail->IsSMTP();                
// Sets up a SMTP connection     $mail->SMTPAuth = 
true;         // Connection with the 
SMTP does require authorization       
$mail->SMTPSecure = "ssl";      // Connect using a 
TLS connection     $mail->Host = 
"smtp.gmail.com";  //Gmail SMTP server address    
$mail->Port = 465;  //Gmail SMTP port    
$mail->Encoding = '7bit';       // 
Authentication     $mail->Username   = 
"myemail@gmail.com"; 
// Your full Gmail address    $mail->Password   
= "mypassword"; // Your Gmail 
password         // 
Compose    $mail->SetFrom($_POST['emailid'], 
$_POST['fullname']);    
$mail->AddReplyTo($_POST['emailid'], 
$_POST['fullname']);    $mail->Subject = "New Contact Form 
Enquiry";      // Subject (which isn't 
required)     
$mail->MsgHTML($message);     // Send 
To     $mail->AddAddress("myemail@gmail.com", 
"Recipient Name"); // Where to send it - Recipient    $result 
= $mail->Send();  // Send!  $message = $result ? 
'Successfully Sent!' : 'Sending 
Failed!';      unset($mail);
}?><html><head>  <title>Contact 
Form</title></head><body>       <div 
style="margin: 100px auto 0;width: 
300px;">   <h3>Contact 
Form</h3>   <form name="form1" id="form1" action="" 
method="post">     <fieldset>       
<input type="text" name="fullname" placeholder="Full Name" 
/>       <br 
/>       <input type="text" 
name="subject" placeholder="Subject" 
/>       <br 
/>       <input type="text" name="phone" 
placeholder="Phone" />       <br 
/>       <input type="text" 
name="emailid" placeholder="Email" />       
<br />       <textarea rows="4" 
cols="20" name="comments" 
placeholder="Comments"></textarea>       
<br />       <input type="submit" 
name="submit" value="Send" 
/>     </fieldset>   </form>   <p><?php 
if(!empty($message)) echo $message; 
?></p>  </div>     </body></html>

Is there a way for me to connect to a directory on a NAS server running a windows share from PHP.
I can connect from the command line using mount, but I want the connect within my PHP script.
Can this be done & if so how?

Hi guys   I'll try keep this simple   I have been given access to a betting xml feed which requires my IP to be whitelisted.   I have whitelisted my home IP and it works fine.   I have whitelisted an IP on server 1 (linux, cpanel), this works fine   I have whitelisted an IP on server 2 (linux, cpanel), this doesn't work and I get:     "simplexml_load_file failed to open stream: http request failed!"   The IP is definitely whitelisted but I think it is something to do with the server. What could be blocking this? allow_url_fopen and allow_url_include are both on by the way   Many thanks Sam

I've been working on this for 8 hours and still cannot get sqlsrv_connect to work. Thank you, Microsoft. My connection strings work for Access DBs and MySQL - but I can't get this to work.

For servername, I've tried:
$serverName = "MYSERVER";
$serverName = "(MYSERVER\MYINSTANCE)";
$serverName = "'MYSERVER\MYINSTANCE'";
$serverName = "(MYSERVER)";

Setup:
PHP Compiler = MSVC9 (Visual C++ 2008)
C:\Program Files (x86)\PHP\v5.3\php.ini
extension_dir C:\Program Files (x86)\PHP\v5.3\ext\
php_sqlsrv_53_nts_vc9.dll in the extension library.

And I'm getting an error from sqlsrv_errors, so it looks like the DLL is working. Pulling my hair out here.

Any ideas?

Code: [Select]
$serverName = "MYSERVER\MYINSTANCE";
$connectionInfo = array("UID" => $uid, "PWD" => $pwd, "Database"=>"$dbname");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if($conn) {
echo "Connection established.\n";
} else {
echo "Connection could not be established.\n";
die( print_r( sqlsrv_errors(), true));
}

sqlsrv_close( $conn);


Connection could not be established. Array ( => Array ( => 08001  => 08001 [1] => 53  => 53 [2] => [SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [53].  => [SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [53]. ) [1] => Array ( => HYT00  => HYT00 [1] => 0  => 0 [2] => [SQL Server Native Client 10.0]Login timeout expired  => [SQL Server Native Client 10.0]Login timeout expired ) [2] => Array ( => 08001  => 08001 [1] => 53  => 53 [2] => [SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.  => [SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. ) )

Hi friends...
I am using Wamp with PHP 5.3 and want to connect with SQL Server 2005 but not successful. I also tried it with PHP 5.2.8 but it still not working.
I google it and found some solutions but not successsful yet.
Can anyone give me detailed guide (step by step) that how i can connect PHP with Sql Server 2005???
Thanks in advance...

I am using this:

$tags = @get_meta_tags($http["domain"]);

Is there any way to tell if that function can not connect to the server for reasons such as server being down, or an invalid URL?

My code is: <?php
echo system("openssl s_client -crlf -connect pop3.live.com:995");
?>


This connects fine. However, I don't know how to log in now. If I'm connecting from the terminal I then type "user annie" followed by "pass idontlikesand". I don't know how to pipe this in using php.

Any ideas?

hello sir,

            i  have to connect database to my live server using 

<?php

define('DB_HOST', 'localhost');
define('DB_NAME', 'oop_pdo_crud');
define('DB_USER', 'root');
define('DB_PASS', '');

?>

or 

 

Have actually tried this mailer on localhost and it worked perfectly. Now am trying to use it on online but it's giving this error SMTP-> ERROR: Failed to connect to server: Connection timed out (110) SMTP -> ERROR: Could not connect to SMTP host. Mailer Error: SMTP Error: Could not connect to SMTP Host.   please how do i fix this?     include "classes/class.phpmailer.php"; // include the class name
$mail = new PHPMailer(); // create a new object
$mail->IsSMTP(); // enable SMTP
$mail->SMTPDebug = 1; // debugging: 1 = errors and messages, 2 = messages only
$mail->SMTPAuth = true; // authentication enabled
$mail->SMTPSecure = 'ssl'; // secure transfer enabled REQUIRED for GMail
$mail->Host = "smtp.gmail.com";
$mail->Port = 465; // or 587
$mail->IsHTML(true);
$mail->Username = "hypropsict@gmail.com";
$mail->Password = "hyprops123";
$mail->SetFrom("hypropsict@gmail.com");
$mail->Subject = "Requisition Processed";
$mail->Body = "<b>Hello $firstname, your requisition has been processed and Approved.. <br/><br/>Come to the Account department to recieve your $text . <br/> Thank You </b>";

$mail->AddAddress($email);
 if(!$mail->Send()){
    echo "Mailer Error: " . $mail->ErrorInfo;
}

Okay guys I have finished my db and I want to upload it to a live server but don't know exactly what to change in the code to get the ODBC_connect to open the path at the new server location please help.

my database  is located in a subfolder called Databases

i.e. "www.mydomain.com/Databases/myEvents.mdb"

what do i change in the connection string below to get it to open the file on the live server? Thanks in advance.


$conn = odbc_connect('myEvents','','');

The information on the php.net documentation seems to be out of date.   http://php.net/manua...databases.mssql   as the link to the necessary libraries for Linux is broken.    Can you tell me, or point me to what is needed to connect to MSSQL with PHP 5.3.3/Apache  on Red Hat Linux   If there is more than one option, we would like to know what they are and the installation details.   Thanks

I am not very proficient at MySQL so this came as a shock today.  I have moved an entire set of scripts from one machine to another and after ironing out some of the kinks I was hit this error "The used command is not allowed with this MySQL version" and just when I thought it was all over with.  LOL   This is the command being run...   load data local infile './AM.dat' into table AM fields terminated by '|';