PHP - Lost Connection To Mysql Server At 'reading Initial Communication Packet', Syste

This topic has been moved to Installation in Windows.

http://www.phpfreaks.com/forums/index.php?topic=312024.0

Hey guys I m developing a download system for my server that reads files from a third party server and enables MY USER to download it via my URL. What mechanisms should i use to manage this efficiently ???


file_get_contents();
fopen();


Or should I use some kind of buffer mechanism ??? Please do provide a code sample as I'm stuck here very badly.

Note: The file sizes may be >500MB

This isn't exactly an application design question, but rather a system design one.   I am about to install an Inventory Control System inside this store I work in.   The store itself also owns a Linode VPS running Centos 6.4 which hosts our website.   This new Inventory System will come built in with a Microsoft SQL Server, and supposedly it is a SQL Anywhere database, but I'm not too sure what that means.     I need to make this database publicly accessible, but only via the Linode VPS.  Surely, setting restrictions is easy enough to address that issue.  That isn't my question.   My first idea is to put this server into the DMZ, easy.  But it doesn't exactly sound safe.  So my next idea was to put a middleman server in the DMZ, this way the Linode can send queries to that middleman server and it will send that data to the SQL Server and back.  This is very vaguely described I know, but I don't want to get too much into details, but rather, understand how I can create that middleman server, and what could Install onto it that would allow me to securely process queries?   My first thought was to install a webservice, that accepts an XML/JSON request and returns an XML/JSON response. Then, I realized directly afterwards that I don't have any experience setting up a webservice like that. What kind of options are there out there?
  Ultimately, my question is, should I just put the Server in the DMZ or should I create the middleman, and if so, can someone point me in the right direction as to getting a webservice set up?
Edited by Zane, 15 July 2014 - 11:28 PM.

hi everyone I have a question... does creating a connection to mysql takes time depeding on the database size?
Lets say that in my entire project I will be connection to 4 databases so I created a config.php which looks like this:

Code: [Select]
$hostname = "localhost";
$username = "root";
$pword = "";

$con1 = @mysql_connect($hostname,$username,$pword,true);
@mysql_selectdb("databasename1",$con1);

$con2 = @mysql_connect($hostname,$username,$pword,true);
@mysql_selectdb("databasename2",$con2);

$con3 = @mysql_connect($hostname,$username,$pword,true);
@mysql_selectdb("databasename3",$con3);

$con4 = @mysql_connect($hostname,$username,$pword,true);
@mysql_selectdb("databasename4",$con4);

so, this file is included in every pages, I put this on the top. Basically every page request it will open 4 connection and the script will only use 2 connection and another page will only 1 and so on.....

this style is very convenient as for I am not creating a connection in every page.. But my concern is will it effect the performance of my system?

Tnx in advance.....

Hi Friends,

               i am new one to this.i have a big problem i think i will get the correct solution...
              when i am connecting to the MySql Database i am getting this.

Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 110 in /home/txtimg0/public_html/cherple/Scheduled_Campaigns.php  on line 24 unable to select database

define("prod_dbuser","xxxx");  //gtmdev1

define("prod_dbpass","xxxxx");  //gtmdev1

define("prod_database_cm2","cm2");

define("prod_database_glue","glue");

define("prod_hostname","xxxxxxxx");

i am defined these constants in gtm
_constants.php i am includeing this file when ever i need to connect with database.

this working fine in past.now we installed the new Database from then i am getting this error.

can any one Please me Help to Resolve this Issue.?
and why php is not connecting to the database???


Thanks,
Ramky




       

The below scenario works fine but why shouldnt you do this?

Why can I not just run the mysql_connect and mysql_select_db at the top of each page and then run my queries under all of this.

What I have read is that the mysql_connection will die after the script finishes (at the end of the page) any way so why do people create mysql_connection objects as php is stateless so it doesnt save this any way.

Code: [Select]
<?php

mysql_connect('localhost', 'user', 'pass');
mysql_select_db('test');

?>
<html>
<body>

<?php

$query = mysql_query("Select * from data");
while($row = mysql_fetch_array($query))
{
echo $row['name']."<br />";
}

?>

-------------- OTHER HTML HERE ---------------

<?php

$query = mysql_query("Select * from addresses");
while($row = mysql_fetch_array($query))
{
echo $row['postcode']."<br />";
}

?>


</body>
</html>

I have a class and a lot of the function in the class require a connection to a MySQL database.  At the moment I am using the "__construct()" to connect to the database each time a new instance of the classes is created.  Is this the best way to do it or should I have a separate class for connection to the database?  Just wanted to get an idea of what other people do.   

Thanks for any help. 

Hi,   If I place the following into a file called db.php and save it into folder called includes using xampp:  

 $dbhost = 'localhost';

Hey there,

total n00b here... Just installed and learned the basic functions of PHP and MySQL (Only have very basic programming background.) Also managed to get an Apache server running.

I'm attaching a screenshot that should explain my problem entirely but in short... I can connect to and send SQL queries to my MySQL server using my terminal. My browser reads php statements over the apache server fine and it 'seems' to connect to my MySQL server fine, but it won't select a database and doesn't seem to accept other SQL queries. If I use a non-existant server name I get an error code but when I change to a non-existant user name I don't get an error code.

So I'm not sure if it actually does connect or not or why the other queries doesn't work. As I said I'm VERY new to this, so I might be making some other mistake as well.

Please see attached document/screenshot.

Thank you
Ardinent

 

Hello guys. Trying to connect php with mysql database and then display results on the screen. This is my code:

Code: [Select]
<?php

$dbhost = "localhost";
$dbuser = "username1";
$dbpass = "password1";
$db = "username1_myDB";

$connection = mysql_connect($dbhost, $dbuser, $dbpass)
or die ("Could not connect");
mysql_select_db($connection, $db);

$show = "SELECT Name, Description FROM people";
$result = mysql_query($show);


while($show = mysql_fetch_array($result)){
$field01 = $show[Name];
$field02 = $show[Description];
echo "id: $field01<br>";
echo "description: $field02<p>";
}


?>
However im getting this:
Warning: mysql_select_db() expects parameter 1 to be string, resource given in /home/pain33/public_html/index.php on line 20

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/pain33/public_html/index.php on line 26

Any ideas how to fix this? Thank you.

Perhaps this is a rather lay question, but, is there a way to gather specific connection details about an open MySQL connection in php?

Example:

<?php
    $connect = mysql_connect('localhost', 'username', 'password');
?>

Using the $connect variable, could I run a command that dumps the host, and username to a log file??

Thanks in advance, I'm still searching.

E

I am slightly puzzled when I attempt to connect to MySQL using variables, if I use this:-

Code: [Select]
// Connect to MySQL and select dbase
mysql_connect("$host", "$user", "$pwd") or die("Computer say NO!");
mysql_select_db("test_site") or die("I've just had a senior moment, and cannot connect to the database...");
I get this error:-

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in C:\wamp\www\php\test site\regproc.php on line 24
Computer say NO!

Whereas if I use this:-

Code: [Select]
// Connect to MySQL and select dbase
mysql_connect("localhost", "root", "my password") or die("Computer say NO!");
mysql_select_db("test_site") or die("I've just had a senior moment, and cannot connect to the database...");
it works perfectly. Most of the tutorials I have read seem to indicate that one can use variables in this case, so I do not understand why it doesn't work...

I am trying to get data out off a mysql database, by using an php file. But i am not getting any output? Examples.html

  <html ng-app="countryApp">
  <head>
    <meta charset="utf-8">
    <title>Angular.js Example</title>
    <script src="http://cdnjs.cloudflare.com/ajax/libs/angular.js/1.2.1/angular.min.js"></script>
    <script>
      var countryApp = angular.module('countryApp', []);
      countryApp.controller('CountryCtrl', function ($scope, $http){
        $http.get('category.php').success(function(data) {
          $scope.countries = data;
        });
      });
    </script>
  </head>
  <body ng-controller="CountryCtrl">
    <table>
      <tr ng-repeat="country in countries">
        <td>{{country}}</td>
      </tr>
    </table>
  </body>
</html>

category.php

<?php
$servername = "localhost:3306";
$username = "root";
$password = "root";
$dbname = "myDB";

$conn = mysqli_connect($servername, $username, $password, $dbname);
if(!$conn){
	die("Connection failed: " .mysqli_connecet_error());
}

$showData = "SELECT id FROM myDB";
$data = array();
$result = mysqli_query($conn, $showData);

if(mysqli_num_rows($result) > 0){
	while($row = mysqli_fetch_assoc($result)){
		$data[] = $row;
	}
} else {
	echo "0 results";
};
print json_encode($data);
mysqli_close($conn);
echo($outp);
?>

I'm suddenly having trouble using my connection to my MySQL database... (yes it was working but now...)

I have the Connection created in an include file and stored in variable $DB, in the main file that includes the file containing the$DB there are other includes for classes. These classes are SUPPOSED to use $DB to connect to and SELECT/UPDATE/INSERT, but for a reason I cant figure out they suddenly stopped seeing $DB. it keeps saying its an undefined variable.

If you need to see code I can post...