Netalfa ISP Portal - Adatbázis</titletitlebackground="/pic/run_line2.gif"> <link href="/res/netalfa.css" type="text/css" rel="stylesheet"> <script type="text/javascript" src="/res/nawa.js"></script> <script language="JavaScript" type="text/javascript"> function menuFireShowElementTooltip (menu) { window.status = 'Netalfa - ' + menu; } function menuFireHideElementTooltip (menu) { window.status = 'Netalfa'; } </script>>background="/pic/netalfa_line_vertical.gif" <script src="http://www.google-analytics.com/urchin.js" type="text/javascript"> </script> <script type="text/javascript">href="mailto:info@netalfa.hu" _uacct = "UA-131142-1"; urchinTracker(); </script> </</href="mailto:support@netalfa.net"head> <body bgcolor="#eeeee9" leftmargin="0" topmargin="0" marginheight="0" marginwidth="0"> <table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#eeeee9"> <tr> <td align="center" valign="middle" bgcolor="#eeeee9"> <table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td height=""href="http://www.netalfa.net/kapcsolat/?print"29" background="/pic/headline.jpg"> </td> </tr> <tr src="/pic/print.gif"> <td height="81"> <table width="100%" height="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="81"><img src="/pic/header.jpg"/></td> <td background="/pic/header_right.jpg"><table border="0" cellspacing="0" cellpadding="0"><tr><td width="1"></td></tr></table></td> </tr> </table> </td>>background="/pic/run_line3.gif" </tr> <tr> <td valign="top" height="10"> <table width="100%" height="100%" backgroundborderbackgroundborderbackground="/pic/run_line3.gif"="0" cellpadding="0" cellspacing="0"> <tr> <td background="/pic/run_line1.gif"> </td>  <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==src"="/pic/nyilacska.gif"20"> </td> <td class="greenbar"> <a hrefhrefhref="http://www.netalfa.hu"="/" class="greenbar">Netalfa ISP Portal</a> - Online Ügyfélszolgálat </td> <td width="45%" align="right" class="greenbar"> <a href="/kapcsolat/" class="greenbar">Kapcsolat</a>href="/feltetelek/" </td> <td width="20"> </td> </tr> </table>>src="/pic/pipe.gif" </td>  </tr> </table> </td> </tr> <tr> <td href="/adatvedelem/"valign="top"> <table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0"> <tr>   <td width="100%" valignvalignbackground="/pic/run_line3.gif"="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"> <tr> <td> <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" cellspacing="0"> <tr> <td width="20"> </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> </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/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> <td width="32" background="/pic/run_line2.gif"> </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="/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> <tr> <td valign="top"> </td> </tr> </table> </td> <td width="9" background="/pic/netalfa_line_vertical.gif"> </td> <td width="100%" valign="top" class="content"> <h1>Adatbázis</h1> <p> 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>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="100%" height="36" background="/pic/run_line3.gif">  <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>

>background="/pic/run_line2.gif" <>href="/software/" Netalfa ISP Portal - Adatbázis</titletitlebackground="/pic/run_line2.gif"> <link href="/res/netalfa.css" type="text/css" rel="stylesheet"> <script type="text/javascript" src="/res/nawa.js"></script> <script language="JavaScript" type="text/javascript"> function menuFireShowElementTooltip (menu) { window.status = 'Netalfa - ' + menu; } function menuFireHideElementTooltip (menu) { window.status = 'Netalfa'; } </script>>background="/pic/netalfa_line_vertical.gif" <script src="http://www.google-analytics.com/urchin.js" type="text/javascript"> </script> <script type="text/javascript">href="mailto:info@netalfa.hu" _uacct = "UA-131142-1"; urchinTracker(); </script> </</href="mailto:support@netalfa.net"head> <body bgcolor="#eeeee9" leftmargin="0" topmargin="0" marginheight="0" marginwidth="0"> <table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#eeeee9"> <tr> <td align="center" valign="middle" bgcolor="#eeeee9"> <table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td height=""href="http://www.netalfa.net/kapcsolat/?print"29" background="/pic/headline.jpg"> </td> </tr> <tr src="/pic/print.gif"> <td height="81"> <table width="100%" height="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="81"><img src="/pic/header.jpg"/></td> <td background="/pic/header_right.jpg"><table border="0" cellspacing="0" cellpadding="0"><tr><td width="1"></td></tr></table></td> </tr> </table> </td>>background="/pic/run_line3.gif" </tr> <tr> <td valign="top" height="10"> <table width="100%" height="100%" backgroundborderbackgroundborderbackground="/pic/run_line3.gif"="0" cellpadding="0" cellspacing="0"> <tr> <td background="/pic/run_line1.gif"> </td>  <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==src"="/pic/nyilacska.gif"20"> </td> <td class="greenbar"> <a hrefhrefhref="http://www.netalfa.hu"="/" class="greenbar">Netalfa ISP Portal</a> - Online Ügyfélszolgálat </td> <td width="45%" align="right" class="greenbar"> <a href="/kapcsolat/" class="greenbar">Kapcsolat</a>href="/feltetelek/" </td> <td width="20"> </td> </tr> </table>>src="/pic/pipe.gif" </td>  </tr> </table> </td> </tr> <tr> <td href="/adatvedelem/"valign="top"> <table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0"> <tr>   <td width="100%" valignvalignbackground="/pic/run_line3.gif"="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"> <tr> <td> <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" cellspacing="0"> <tr> <td width="20"> </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> </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/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> <td width="32" background="/pic/run_line2.gif"> </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="/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> <tr> <td valign="top"> </td> </tr> </table> </td> <td width="9" background="/pic/netalfa_line_vertical.gif"> </td> <td width="100%" valign="top" class="content"> <h1>Adatbázis</h1> <p> 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>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="100%" height="36" background="/pic/run_line3.gif">  <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>