src
/pic/nyilacska.gif<
/pic/nyilacska.gifmetameta"metameta" http-equiv="Content-type" content="text/html; charset=utf-8">
Netalfa ISP Portal - Adatbázis>href=="titletitle/doc/">
<link href="/res/netalfa.css" type="text/css" rel="stylesheet">
<script type="text/javascript" src="/res/nawa.js"></script>
<script backgroundlanguage="JavaScriptlanguagel" type"="/pic/run_line2.giftext/javascript">"
function menuFireShowElementTooltip (menu)
{
window.status = 'Netalfa - ' + menu;
}
function menuFireHideElementTooltip (menu)
{
window.status = 'Netalfa';
}
</script>
<script src="http://www.google-analytics.com/urchin.js" type="text/javascript">
</script>
<script type="text/javascript">
_uacct = "UA-131142-1";
urchinTracker();
</script>
</head>
<body bgcolor="#eeeee9" leftmargin="0" topmargin="0" marginheight="0" marginwidth="0">
<table width="100%" height="100%" border100%background="/pic/run_line2.gif="0"" cellpadding="0" cellspacing="0" bgcolor="#eeeee9">
<tr>
<td tdbackgroundalign=="/pic/run_line2.gif"center"" valign="middle" bgcolor="#eeeee9">
<table width=""src"src100%"=" height="100%/pic/nyilacska.gif" "border="0" cellpadding="0" cellspacing="0">href=""
</software/tr>"
<td height="29" background="/pic/headline.jpg">
</td>
</tr>
<tr>
<td height="81">
<table width="100%" height==background="/pic/run_line2.gif""81" border="0" cellpadding="0" cellspacing="0">
<tr>
<td background="/pic/header_left.jpg"><table border="0" cellspacing="0" cellpadding="0"><tr><td width="1"></td></tr></table></td>
<td width="764" height="8181background="/pic/run_line2.gif""><img src="/pic/header.jpg"/></td>
<td background=backgroundbackground="/pic/run_line2.gif""/pic/header_right.jpg"><table border="0" cellspacing="0" srcsrccellpadding=="0"><"tr>/pic/nyilacska.gif"<td width="1"></td></tr></table></td>href=
</
"/security/"tr>
</table>
</td>
</tr>
<tr>
<td valign="top" height="10">
<table width="100%" height==background=""100%"/pic/run_line2.gif" border="0" cellpadding="0" cellspacing="0">
<tr>
<td background="/pic/run_line1.gif"> </td>
<!--td width="770" height="40" background="/pic/run_line1.gif">
<table width="770" height="40" border="0" cellpadding="0" cellspacing="0" class="navigator"-->
<td width="100%" height="40" background="/pic/run_line1.gif">
<table width="100%" height="40" border="0" cellpadding="0" cellspacing="0" class="navigator">
<tr>
<td width="20"> </td>
<td class="greenbar">
<a href="/" class="greenbar">Netalfa ISP Portal</a> - Online Ügyfélszolgálat
</td>
<td
src =width="/pic/submenu_item.gif""45%" align="right" class="greenbar">
<a href="/kapcsolat/" class="greenbar">"href==Kapcsolat"</a>/security/crypto/"
</td>
<td width="20"> </td>
</tr>
</table>
</td>
<!--td background="/pic/run_line1.gif"> </td-->
</tr>
</table>
</td>
</tr>
<tr>
<td valign="top">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<!--td valign="top"> </td-->
<!--td width="770" valign="top"-->
<td width="100%" valign="top">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" bgcolor="#e4ded3" width="200">
<table width="100%" border="0" cellspacing="0" cellpadding="0">src="/pic/submenu_item.gif"
<tr>
<
href="td>/security/browser/"
<table width="191" border="0" cellpadding="2" cellspacing="0" class="menuitem">
<tr>
<td height="40">
<table width="100%" height="40" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="20" background="/pic/run_line2.gif"> </td>
<td background="/pic/run_line2.gif" class="greenbar">
<img src="/pic/nyilacska.gif" width="4" height="7">
<a href="/doc/" class="leftmenu" style="color: white; font-weight: bold;">Leírások</a>
</td>
<td width="32" background="/pic/run_line2.gif"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="leftmenu_line">
<table width="100%" border="0" cellpadding="0" srccellspacing=src=""0/pic/submenu_item.gif"">
<tr>
<td width="2020href=">"/security/mua/"/security/mua/ </td>
<td valign="middle">
<img src="/pic/submenu_item.gif" align="absmiddle">
<a href="/doc/mail/" class="leftmenu">Levelezés</a>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="leftmenu_line">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="20"> </td>
<td valign="middle">
<img src="/pic/submenu_item.gif" align="absmiddle">
<a href="/doc/web/" class="leftmenu">Web</a>
</td>background="/pic/netalfa_line_vertical.gif"
</tr>
</table>
</td>
</tr>
<tr>
<td class="leftmenu_line">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="20"> </td>
<td valign="middle">
<img src="/pic/submenu_item.gif" align="absmiddle">href="/security/browser/"
<a href="/doc/database/" class="leftmenu">Adatbázis</a>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="40">
<table width="100%" height="40" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="20" background="/pic/run_line2.gif"> </td>
<td background="/pic/run_line2.gif" class="greenbar">
<img src="/pic/nyilacska.gif" width="4" height="7">
<a href="/software/" class="leftmenu" style="color: white; font-weight: bold;">Szoftvertár</a>
</td>href="http://www.netalfa.net/security/?print"
<td width="32" background="/pic/run_line2.gif"> </td>
</tr>
</table>src="/pic/print.gif""
</td>
</tr>
<tr>
<td height="40">
<table width="100%" height="40" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="20" background="/pic/run_line2.gif"> </td>
<td background="/pic/run_line2.gif" class="greenbar">
<img src="/pic/nyilacska.gif" width="4" height="7">
<a href="/security/" class="leftmenu" style="color: white; font-weight: bold;">Biztonság</a>
</td>
<td width="32" background="/pic/run_line2.gif"> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>background="/pic/run_line3.gif"
<tr>background="/pic/run_line3.gif"
<td valign="top">
</td>
</tr>
</table>
</td>
<td width="9" src="/pic/nyilacska.gif"background="/pic/netalfa_line_vertical.gif">>href="http://www.netalfa.hu" </td>
<td width="100%" valign="top""href="/feltetelek/""class="content">
<h1>src="/pic/pipe.gif"Adatbázis</h1>
<p>href="/adatvedelem/"
Az adatbázis kezelők elszigetelt kiszolgálón futnak, így azokhoz csak TCP/IP
kapcsolaton keresztül lehet kapcsolódni, felhasználói azonosítást követően.
Az adatbázisokhoz csak a webkiszolgálóról lehet kapcsolódni, biztonsági
megfontolásokból kifolyólag interneten keresztüli kapcsolat csak külön kérésre
lehetséges.
</p>
<p>
Távoli adminisztráció alapértelmezés szerint ezáltal két módon lehetséges:
<ul>
<li>background="/pic/run_line3.gif"böngészővel a
<a href="http://webadmin.netalfa.net" target="_blank">http://webadmin.netalfa.net</a>
oldalról,</li>
<li>a webkiszolgálóra történő távoli bejelentkezéssel (SSH), majd onnan
az adatbáziskezelő parancssori programjával.</li>
</ul>
</p>
<h2>PostgreSQL</h2>
<p>
Az alapértelmezett PostgreSQL kiszolgáló a <i>postgresql.netalfa.net</i> címen
érhető el, a szabványos <i>5432</i> porton. Parancssori alkalmazással a következő
módon lehet kapcsolódni:
<pre class="shellquote">
$ psql -h postgresql.netalfa.net -U <felhasználó> <adatbázis>
</pre>
</p>
<h2>MySQL</h2>
<p>
Az alapértelmezett MySQL kiszolgáló a <i>mysql.netalfa.net</i> címen
érhető el, a szabványos <i>3066</i> porton. Parancssori alkalmazással a következő
módon lehet kapcsolódni:
<pre class="shellquote">
$ mysql -h mysql.netalfa.net -u <felhasználó>
</pre>
</p>
<script language="JavaScript" type="text/javascript">
function openPrintable (url)
{
var w = 600;
var h = 500;
var posx = 0;
var posy = 0;
if (window.screenLeft)
{
posx = window.screenLeft;
posy = window.screenTop;
}
else if (window.screenX)
{
posx = window.screenX;
posy = window.screenY;
}
var x = (document.body.clientWidth - w) / 2 + posx;
var y = (document.body.clientHeight - h) / 2 + posy;
window.open( url , 'netalfa_print', 'toolbar=no,menubar=yes,location=no,hotkeys=no,status=no,scrollbars=yes,resizable=yes,width=' + w + ',height=' + h + ',left=' + x + ',top=' + y);
return false;
}
</script>
<table width="100%">
<tr>
<td height="20">
</td>
</tr>
<tr>
<td align="right" class="text" style="text-align: right;">
<a href="http://www.netalfa.net/doc/database/?print" target="_blank" onClick="return openPrintable('http://www.netalfa.net/doc/database/?print')"><img src="/pic/print.gif" border="0" align="absmiddle"/> Nyomtatás</a>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="10">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td background="/pic/run_line3.gif"> </td>
<!--td width="770" height="36" background="/pic/run_line3.gif"-->
<td width="100%" height="36" background="/pic/run_line3.gif">
<!--table width="770" height="36" border="0" cellpadding="0" cellspacing="0" class="navigator"-->
<table width="100%" height="36" border="0" cellpadding="0" cellspacing="0" class="navigator">
<tr>
<td width="20"> </td>
<td class="greenbar">
<img src="/pic/nyilacska.gif" width="4" height="7" border="0"> <a href="http://www.netalfa.hu" class="greenbar"><strong>Netalfa kft © 2006</strong></a>
</td>
<td width="45%" align="right" class="greenbar">
<a href="/feltetelek/" class="greenbar">Használati feltételek</a>
<img src="/pic/pipe.gif" width="1" height="9" border="0" align="absmiddle">
<a href="/adatvedelem/" class="greenbar">Adatvédelem</a>
</td>
<td width="20"> </td>
</tr>
</table>
</td>
<td background="/pic/run_line3.gif"> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>