General :: Run Queries Against Microsoft Sql Server From System?
Jan 9, 2009
Is there a way to run queries against a Microsoft sql server from linux? Here is what I would like to do. When I create apps that us db back end I would like to quickly check results of my queries. so if I could do something like "select * form Orders" from the terminal or another app that would be great.
I'm trying to connect to a Win XP computer via Remote Desktop/Terminal Server. (Note: WinXP refers to Remote Desktop, or RDP; Ubuntu uses Terminal Server client for this function.)
The problem is that my XP computer requires the use of Microsoft's RDP version 6 because it uses a Terminal Server Gateway. The TS client in Ubuntu is compatible with version 5, not version 6.
Is there a MS RDP version 6 compatible program/client for Linux?
I have this game for the pc called international football 2000. Its a bit old I know, but I want to see if it will work on my computer. I am still running on the 8.04 ubuntu and will be upgrading soon hopefully. Will a game this old and also made by microsoft work for the ubuntu system?
We are using Linux as our database server and Microsoft Sever 2008 as our file server. Both are on independent servers. We would like to be able to mirror each server on the other for disaster recovery purposes. I am completely new to Linux.
I am currently running the latest version of Bind, and for some completely unknown reason I can NOT get queries to work for PTR records. All queries to the servers for reverse name lookup get query denied:
Using domain server: Name: 66.150.173.1 Address: 66.150.173.1#53 Aliases:
Host 27.173.150.66.in-addr.arpa not found: 5(REFUSED)
And it shows in my logs:
I am at my wits ends with the piece of crap. Can anyone shine some light on why this damn Bind install won't respond to these queries?
I have internal-only email server that has internal BIND9 running. Thought it only has its IP address defined in /etc/resolv.conf, it is still resolving outside addresses.
we want to complete replace isa 2000 Microsoft by squid proxy server. the role of server is simple as regular proxy server. using rhel5, but when i enter into squid proxy world i found tons of parameters, and stuff to read. and optimization and performance tuning needed.
which is best suitable proxy squid, there is regular,transparent i need to define 2 rules, 1 for office hours internet let say 10 hours, 1 for 24 hours internet, where certain people comes in 10 hours and some in 24 hours group also can some one suggest is there any no GUI control from web broswer or linux machine itself we can define control access list?
How often are dns queries sent? Assume I want to connect to a ssh server, will I send one dns-query in order to do that or do I send multiple during my connection? What if I request web-pages, do I send a query only when I enter a site or will I send queries every time I visit a new page on that site?
I'm asking since I'm considering getting an account at dyn.com (the standard account for $30/yr) and it comes with 600 000 queries per month (which is way more than I expect to get but knowing exactly what it means is always good).
I have my bind9 DNS server running on Ubuntu with logging on. What's bothering me is that I have log full of localhost queries instead of from IP of the computer which actually asked.DNS queries log:/var/log/named.queries.log
Code: 24-Feb-2011 16:01:19.413 client 127.0.0.1#38022: query: clients4.google.com IN A + (127.0.0.1)
I chose -Server-, if this is more appropriate in -Networking-, just let me know. Basically, I need to be able to merge responses stored in a zone file with responses from an "upstream" authoritative server. I'm in the sad position of needing to "intercept" requests to *part* of a domain (but not restricted to a sub-domain!) and return results for *some* hosts that use an internally routed address, and results for the rest using the public internet addresses. Unfortunately, it's not my domain, so I can't just use views (although I suspect they could end up having some part to play in this, at least potentially)... but instead I have to actually send requests recursing to the other site's external DNS for any hosts my server doesn't have records for in the zone file.
Some background on the situation: I work at a local government, which has a private link / VPN connection to a state government entity, and needs to use internal addresses for some of the state servers, which then get routed over an "internal" network link. But the state uses the same domain name internally and externally, just presenting views to internal clients vs. external clients. -- However, we are only being allowed access to certain of their servers through the internal link, which means that for any other servers that we don't have internal/private access for, we have to visit the public addresses just like anyone else on the internet... So, I can't just send all requests to their internal DNS and get responses, because we'd get IPs for some servers (e.g. their main web site) that we wouldn't then be able to reach using the internal network link.
For Example: Say I have a client machine, "client1", on my network ("my.net"), which uses "mydns1.my.net" for name resolution ... and which needs to access 2 servers on the state network, "private.st.us" and "public.st.us" -- so named based on how "my.net" needs to access them.
The external state DNS server/view ("ext-dns.st.us") responds to requests with something like: private.st.us -- 1.2.3.456 public.st.us -- 1.2.3.457 (Those are just crap addresses, obviously.
The internal state DNS server/view ("int-dns.st.us") responds to requests with something like: private.st.us -- 10.0.0.8 public.st.us -- 10.0.0.10 This works on their network because their own clients have access to all such IPs.
But for us, they only allow traffic flowing between "my.net" and their internal network to reach the 10.0.0.8 address, blocking all other address destinations. So, when "client1.my.net" asks "mydns1.my.net" for the address of "public.st.us", I need "mydns1" to recurse out to "ext-dns.st.us" to get an answer (1.2.3.457) and then return that IP to "client1" -- because "my.net" is blocked from accessing the server's 10.0.0.10 address. But, when client1 asks mydns1 for "private.st.us" I need to pull the IP (10.0.0.8) from a local zone file instead of asking either of the state DNS servers -- or optionally forward the request to "int-dns.st.us" I suppose -- because the state blocks access to certain services (which we need and are the whole cause of this problem!) via the public (1.2.3.456) address.
trying to configure a Centos 5.5 server (simple file server with DHCP and DNS relay). I configured and tested the config (by 'service dnsmasq configtest') of dnsmasq and I got the message 'dnsdomain:host unknown (translation of the real message : hte inconnu) and I didn't find where I could define this host ! The hostname of the server is well defined and I can see it from all Windows PC's on the LAN. dnsmasq starts (with hte same message as in configtest) but when querying DNS from PC's te.g. trying to surf the Internet), I don't get replies (3 DNS servers are also well defined and operational).
I am bit new to Linux and have setup caching-only name server with Centos 5.5. when i do dig server, it provide resolutions. but when i use the server IP as DNS on my windows client, it says, "connection refused" on the NSlookup output. (IP table didn't enable) My server Ip is 192.168.1.253 and bellow is the configuration of "/var/named/chroot/etc/named.conf"
The NS triggering the warning is running openSUSE 10.2 and the other one 11.1. Both configuration files /etc/named.conf are equivalent (well, forwarders are different). There is no such warning for the NS with 11.1. When I add "recursion no;" to the options in /etc/named.conf the warning goes away, but FF or SeaMonkey running on the server no longer get their DNS requests resolved.
I recently turned on query logging on our name server and immediately saw repeated queries for . (dot). I've not seen this before. It looks like a really sloppy DOS. What would this return if my NS was misconfigured?
May 13 18:11:41.710 queries: info: client 91.202.63.129#56089: query: . IN NS May 13 18:11:42.083 queries: info: client 91.202.63.129#62826: query: . IN NS May 13 18:11:42.788 queries: info: client 91.202.63.129#13620: query: . IN NS
I have a linux box (Ubuntu 10.04) in a microsoft environment at work. IT wants it to auto-register in the DNS. I have next to no knowledge about networking, so any hints would be appreciated (google didn't give anything useful). Is there a specific configuration file for this?
i want to know about the partition size of linux in my system..i have pentium 4 with 512 mb ram and 15 gb hard disk for opensuse 11.1..i want to know how much space should be allocated for /,/home ,swap etc and under what kind of partition they should be formatted (like primary,logical,extended etc)...kindly help me in this regards...I have windows xp and want to install opensuse with it.
I have a daily routine task of checking the size of mysql tables in a database in Mysql Database Server.
I want to achieve this task through a bash script that runs daily and calculate the size of mysql tables and finally mail it to DBA email-id fore.g adarsh.sharma@orkash.com
I recently had the need to relay SMTP mail through our organizations hosted MS Exchange server. I had to do a little troubleshooting, so I wrote a concise summary of the procedure I followed.
I have been sent some file sI need to open but they are in .pub format. Having them sent in another format is not an option. I need to open them on Linux. Is there a tool which I can convert it into another format (preferably PDF) rather than having to mess around getting publisher installed on wine etc etc?
1. What difference will it make if I set the mount point to "/" instead of "/boot" and vice-versa ?
2. I heard somewhere that the data on a primary partition can be easily recovered in case of some failure.
If it is so then what out of the following should IDEALLY be created as primary partition ? /usr /home /boot
I think /usr and /home both need a primary partition , then what about /boot, Will I be not able to recover something in case of failure if I don't set /boot as a primary partition ?
I currently have 2 operating systems on my main hdd: Ubuntu and WinXP My current setup - [storage NTFS partition, solely data][17GB WinXP partition][{extended partion}Ubuntu + swap]: [URL] I have a second SATA hdd that I would like to install Arch Linux on to. It uses GRUB Legacy, and Ubuntu uses GRUB 2. I would like to know how I would go about booting this, and figure out where my current bootloader is installed to. i.e. /dev/sda or /dev/sda5 (the / ubuntu partiton)
I have a Debian testing system on a laptop that used to have Windows 8 on it. I kept the EFI boatloader and its partition, but now every time the system boots, it first tries to boot into Windows (which isn't there anymore). Removing /boot/efi/EFI/Microsoft just leads to an error message when booting, with some component of Windows still trying to load and not finding those files.
The workaround for now is to go into the UEFI boot menu on every boot and selecting the "debian" entry, which works but is a bit cumbersome.How can I get rid of the Microsoft loader completely? I find a lot about repairing or re-adding the Windows bootloader, but nothing about removing it.
Just picked up a Microsoft Designer Bluetooth Mouse.Whenever I try to pair it, my system hangs and I have to hard power it down. The mouse is Bluetooth 4.0, but my Bluetooth connectivity is provided by my Intel Wireless 3160 card which does support Bluetooth 4.0.I'm using Blueman as a front end, and one other thing of note is that it shows as "Unknown" after a scan.If I need to return it, I need to return it, but it seems like a good mouse and I'd like to keep it if I can make it work.
I've took this out of syslog: Code: Select allAug 1 14:58:04 Noah-LEMUR kernel: [ 317.772054] BUG: unable to handle kernel NULL pointer dereference at 0000000000000398 Aug 1 14:58:04 Noah-LEMUR kernel: [ 317.772090] IP: [<ffffffff81569f7e>] mutex_lock+0xe/0x30 Aug 1 14:58:04 Noah-LEMUR kernel: [ 317.772113] PGD 0 Aug 1 14:58:04 Noah-LEMUR kernel: [ 317.772123] Oops: 0002 [#1] SMP
i am a project student and i am purposing an enterprise to change all client OS's to ubuntu, but problem is that enterprise want to stay with server 2008R2(They Dont want to change it). so my job is to make a ubuntu image which can integrate microsoft server 2008 R2. the enterprise want Ubuntu to work with
1. MS Domain/AD 2. MS Proxy Server 3. Radius Server 4. Exchange Server etc.
i am looking forward to distribute Ubuntu. if said above is possible then how?? which version of ubuntu i have to use?
I am looking for an equivalent software of Microsoft Exchange server. Right now we are using MS Exchange Server with 40 users. Can I transfer this setup to any equivalent RHEL programs? Is There A Linux Equivalent To Microsoft Exchange?