Register auf VPS apache2

[autoprd]

Halo, i habe VPS mit FreeBsd 9 Os , und installiert Apache2.
My ip ist 178.238.46.57
Navicate wird über SSH verbunden, und config auf web wird über mysql verbunden.
Wie stelle ich die config.
Um via ssh verbinden.
Danke

[Mashkin]

So einfach geht das nicht.
PHP verfügt zwar über eine SSH-Bibliothek, aber dennoch benötigt das zusätzlichen Code.
Ich empfehle dir mal einen Blick auf die SS2-Funktionen von PHP zu werfen:


Insbesondere auf die Funktion "ssh2_tunnel", die eine beliebige Verbindung (z.B. MySQL) durch SSH tunneln kann.

[autoprd]

$mysql_host localhost oder ip?
ODER

Gibt es eine Anleitung zur Registrierung auf FreeBSD VPS machen?

********************
*General Information
********************
Server Type: MySQL
Connection Name: localhost_3306
Host Name/IP Address: localhost
Port: 3306
User Name: root
Save Password: True

********************
*SSH Information
********************
Use SSH Tunnel: True
Host Name/IP Address: 178.238.46.57
Port: 22
User Name: root
Authentication Method: Password
Save Password: True

_________________________
Wie richtet man einen Config?

$mysql_host = "???";
$mysql_user = "???";
$mysql_pass = "???";
$mysql_db = "account";

[MegaChilla12]

$mysql_host = "Dein Ip die da oben steht178.....";
$mysql_user = "root";
$mysql_pass = "dein navicat passwort";
$mysql_db = "account";

[Mashkin]

Originally Posted by MegaChilla12

$mysql_host = "Dein Ip die da oben steht178.....";
$mysql_user = "root";
$mysql_pass = "dein navicat passwort";
$mysql_db = "account";

Er will es aber doch über SSH tunneln...

PHP Code:

$ssh = ssh2_connect('178.238.46.57', 22) or die('SSH connection failed');
ssh2_auth_password('root', 'password') or die ('SSH login failed');
ssh2_tunnel($ssh, 'localhost', 3306) or die('cannot establish tunnel');

$mysql_host = "localhost";
$mysql_user = "root";
$mysql_pass = "password";
$mysql_db    = "account"; 


Funktioniert dann etwa so:
PHP--> localhost:3306--> SSH: 178.238.46.57:22--> localhost:3306 (auf dem Root-Server)--> MySQL

[autoprd]

$ssh = ssh2_connect('178.238.46.57', 22) or die('SSH connection failed');
ssh2_auth_password('root', '****') or die ('SSH login failed');
ssh2_tunnel($ssh, 'localhost', 3306) or die('cannot establish tunnel');

$mysql_host = "localhost";
$mysql_user = "root";
$mysql_pass = "****";
$mysql_db = "account";

Nichts (

________
und aus web

$mysql_host = "178.238.46.57";
$mysql_user = "root";
$mysql_pass = "****";
$mysql_db = "account";

->

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/clients/client19/web184/web/index.php on line 4

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /var/www/clients/client19/web184/web/index.php on line 4

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/clients/client19/web184/web/index.php on line 5

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /var/www/clients/client19/web184/web/index.php on line 5

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/clients/client19/web184/web/index.php on line 6

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /var/www/clients/client19/web184/web/index.php on line 6

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/clients/client19/web184/web/index.php on line 7

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /var/www/clients/client19/web184/web/index.php on line 7

Warning: mysql_query() [function.mysql-query]: Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/clients/client19/web184/web/index.php on line 10

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/clients/client19/web184/web/index.php on line 10
NOT

Index ist -

<?php
include('config.php');
if(isset($_POST['submit']) && $_POST['submit'] == 'Register') {
$username = mysql_real_escape_string($_POST['username']);
$password = mysql_real_escape_string($_POST['password']);
$rl_name = mysql_real_escape_string($_POST['rl_name']);
$email = mysql_real_escape_string($_POST['email']);

$sql = "INSERT INTO account SET login = '".$username."', password = PASSWORD('".$password."'), real_name = '".$rl_name."', email = '".$email."'";
$result = mysql_query($sql);
if($result) { echo 'EEE ASTA E FRATE MERGE CONTU go...'; } else { echo 'NOT'; }
}
?>
<!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>
<title>Registration</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<meta name="description" content="Registration" />
<meta name="keywords" content="some, keywords, comes, later" />
<meta name="language" content="en" />
<meta name="robots" content="index,follow" />
<meta name="author" content="S3cr3t" />
<meta name="revisit-After" content="5 days" />
<meta name="distribution" content="local" />
<style type="text/css">
<!--
body { background:#000; color:#FF0; font:bold 8pt Verdana,Arial,Helvetica,sans-serif; }
#container { margin:40px auto; width:750px; overflow:hidden; }
#text { padding:5px; }
#text ul { padding:0px; margin-left:15px; }
#text li { display:block; }
#left { float:left; }
#right { float:right; margin-right:15px; }
!.style1 {color: #00FF00}
.style1 {color: #00FF00}
-->
</style>
<script type="text/javascript">
if (top.frames.length != 0)
top.location=self.location;
</script>
</head>
<body>
<div class="style1" id="container">
<div id="text">
<form action="index.php" method="post">
<ul>
<li>Username:</li>
<li><input type="text" name="username" size="60" /></li>
<li>&nbsp;</li>
<li>Password:</li>
<li><input type="password" name="password" size="60" /></li>
<li>&nbsp;</li>
<li>Password Again:</li>
<li><input type="password" name="password" size="60" /></li>
<li>&nbsp;</li>
<li><input type="submit" name="submit" value="Register" /></li>
</ul>
</form>
</div>
</div>
<span class="style1">Goooooooooooooooooooooooooooooooooo ooooooooooooood</span>
</body>
</html>