1 / 36

Welcome to Advanced Networking with Simply 2008 & 2009 Gregg Goede Product Specialist

Welcome to Advanced Networking with Simply 2008 & 2009 Gregg Goede Product Specialist. AGENDA. Introduction Main Issues connecting to Server Using the command line Checking Error Logs Linux Demo Q & A. Reminder. Will not be covering Terminal Server Remote Desktop

briar
Download Presentation

Welcome to Advanced Networking with Simply 2008 & 2009 Gregg Goede Product Specialist

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Welcome to Advanced Networking with Simply 2008 & 2009 Gregg Goede Product Specialist

  2. AGENDA Introduction Main Issues connecting to Server Using the command line Checking Error Logs Linux Demo Q & A

  3. Reminder • Will not be covering Terminal Server • Remote Desktop • Using PC Anywhere type service • Windows 2000 Server no longer supported • All the above do connect but are not covered

  4. Benefits • Save time • Be proactive • Reassure clients • Take home tools

  5. Assumptions Made • You know how to set folder permissions • Know how to configure firewall and routers • Recognized BIOS drive • Understand the client/server environment • Know how to configure a Server • Understand TCP/IP jargon

  6. Have you experienced these Error Messages • Read Only • Has experienced a network error… • Cannot find connection manager….. • Database has timed out…… • Simply Accounting cannot open the database…. • If you have not experienced these types of errors then this session will give tools to enhance the connection manager’s performance

  7. Three main reasons for unable to connect DHCP/DNS issues .NET installation Permissions

  8. DHCP/DNS issues

  9. Like most programs Simply has incorporated .NET into its report functionality • Many advantages to have reports internet ready • .NET must bind to the TCP/IP • Problems develop if there is host name resolutions

  10. DHCP/DNS Questions to ask • Who is handing out the IP addresses • Is the Workstation’s host name resolution different than the Server • Is there static IP addresses or dynamic • Is the DNS server private or public • Are private IP addresses being blocked

  11. Host Name Resolution • Check if name is same as localhost name. (hostname) • Search local DNS Client resolver cache. (ipconfig /displaydns ) • Query the designated DNS server (nslookup) • If host name is < 16 characters, convert to NetBIOS name -> Lookup local NetBIOS name cache. (Enable NetBIOS over TCP/IP) • Query WINS server. (use nslookup debug mode check TCP/IP settings. See wins query.txt on CD) • Use ping to broadcast to local subnet 3 times • Search local LMHosts file. C:\windows\system32\drivers\etc

  12. DOT NetFramwork installation issues

  13. On the server….. Check .NET installation Check C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 Run utility tool (netfx_setupverifier.exe) Uninstall using Add/Remove and Reinstall .NET with Simply Run clean-up tool (cleanup tool.exe) Visit Microsoft website for more cleanup options

  14. Permissions and Authentication

  15. Permissions Revisited • Check the “log on as service” make sure the user is added as a service • Use the network wizard • Check mysqld-nt.exe process must be system (open up task manager) • Super Admin user for Dell computers • Upgrade yourself to a true admin user 'net user administrator /active:yes' • If sharing parent folder do not share child • As a TEST use the specialized data provided on the session CD

  16. AGENDA Introduction Main Issues connecting to Server Using the command line Checking Error Logs Linux Demo Q & A

  17. Command Line Help • mysqld-nt.exe (open the data without user interface) • ipconfig (trouble shoot DNS issues) • netstat (port avaliability) • telnet (port avaliability over network) • nslookup (DNS issues) • using portquery (port avaliability on server)

  18. mysqld-nt.exe • To test MySQL without the connection manager • Msqld-nt –h server –P 13540 C:\data\universl.saj • If successful window will remain open • Can open with MySql query and check data

  19. Ipconfig • Ethernet adapter Local Area Connection 5: • Connection-specific DNS Suffix . : domain.invalid • Description . . . . . . . . …. ……. . : VIA Rhine II Fast Ethernet Adapter • Physical Address. . . . . . …… . . : 00-0A-E6-EB-BB-11 • Dhcp Enabled. . . . . . . . …… . . : Yes • Autoconfiguration Enabled . . . . : Yes • IP Address. . . . . . . . . . ……… . : 192.168.1.64 • Subnet Mask . . . . . . . . . …….. . : 255.255.255.0 • Default Gateway . . . . . . . …… . : 192.168.1.254 • DHCP Server . . . . . . . . . …..... . : 192.168.1.254 • DNS Servers . . . . . . . . . …….. . : 192.168.1.254 • Lease Obtained. . . . . . . . .. …... : Sat 4 October 2008 11:36:21 AM • Lease Expires . . . . . . . . ….. … : Sun, 5 October 2008 11:36:21 AM

  20. Netstat -n • Proto Local Address Foreign Address State • TCP 127.0.0.1:1661 127.0.0.1:13541 ESTABLISHED • TCP 127.0.0.1:1662 127.0.0.1:13541 ESTABLISHED • TCP 127.0.0.1:2085 127.0.0.1:13541 TIME_WAIT • TCP 127.0.0.1:2086 127.0.0.1:13541 TIME_WAIT • TCP 127.0.0.1:2103 127.0.0.1:13541 TIME_WAIT • TCP 127.0.0.1:2122 127.0.0.1:13541 TIME_WAIT • TCP 127.0.0.1:13541 127.0.0.1:1661 ESTABLISHED • TCP 127.0.0.1:13541 127.0.0.1:1662 ESTABLISHED TIME_WIAT is healthy… waiting for connection Many other variations – b lists Simply and MySQL Can also use freeware program ports watch for realtime activity

  21. telnet • Quick way to test if port is open • Open data with Simply or mysqld-nt.exe • telnet server<>name 13540 • telnet will time out after a few seconds • telnet is often restricted by security policies • Better to use queryports

  22. nslookup output Server: Unknown Adress:192.168.254 No response from server ….. DSL modem configuring Cannot find server name for address : Timed out There is no DNS server, possible connection problems Cannot find server name for address 127.0.0.1: Timed out There is a DNS server running somewhere but is not defined Default Server: server.com Address 10.140.53.4 The best output, query server for name resolution Nslookup (set type ns) to find which DNS servers are available –ping test

  23. Port Query • Find local server ports currently open (portqry.exe –local) • Find Simply port local ( portqry -n 127.0.0.1 –e 13540 ) • Find port on a server ( portqry -n 10.152.21.4 –e 13540 –p udp) • To specify a specific source port –sp 80 –n 10.152.20.53 –e 13540) to identify if there are ports being filtered or block from workstation to server • Find port on a server ( portqry -n 10.152.21.4 –e 13540 –p udp -sl) to determine if there is a slow link • Endless permutations and combinations

  24. Registry Checks • Reminder 2008 A and B controlset issue…. unable to map network drive HKLM\SYSTEM\CurrentControlSet\Services\lanmanserver\shares HKLM\SYSTEM\ControlSet001\Services\lanmanserver\shares Check CD for more infor • Busy server with many users it is possible to increase the number of ports HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters MaxUserPort Data Type: REG_DWORD Value: 65534, TcpTimedWaitDelay Data Type: REG_DWORD Value: 30 Check CD for technote

  25. AGENDA Introduction Main Issues connecting to Server Using the command line Checking Error Logs Linux Demo Q & A

  26. Checking the Error Log Error in my_thread_global_end(): 2 threads didn't exit Error: Cannot find table simply/tusrprf2 from the internal data dictionary ERROR: the age of the last checkpoint is 3771360 which exceeds the log group capacity 3771188. If you are using big BLOB or TEXT rows, you must set the combined size of log files at least 10 times bigger than the……. ERROR :Page dump in ascii and hex (16384 bytes): len 16384; hex 7d255d6e0000025f000002560000026800000000006190e945bf

  27. Event Viewer – five different types • .Net Runtime 2.0 Error can signify damaged data or some .NET components are not installed properly • MySQL Will generate if there is a problem with the database structure ie. cannot find table • Simply Will generate if there is a problem with records when a query is run • Simply Accounting Database connection manager Will generate if the connection cannot load (1053/1069 errors) • Side by Side errors Ignore these errors, French foundation class not loaded

  28. A Word About the Free AVG anitvirus program

  29. AGENDA Introduction Main Issues connecting to Server Using the command line Checking Error Logs Linux Demo Q & A

  30. Linux Review • 2009 Linux driver available • Redhat • SuSE • Rumour that the driver has been installed on other Linux flavours • Mono 1.9 must be installed • ODBC installed

  31. Linux Gotha's • Always install from command line root • ODBC 5.0 will not work must uninstall and reinstall 3.5 • Do not install mono 2.0 from download. Install from install CD • Run <command> do not rely on process report • Do not run IP 6.0

  32. AGENDA Introduction Main Issues connecting to Server Using the command line Checking Error Logs Linux Demo Q & A

More Related