Home / user-43743

rumz's questions

Martin Hope
rumz
Asked: 2012-07-25 22:54:40 +0800 CST
  • 0

Someone asked me to update the times on 4 servers that are not connected to the internet and they have no ntp server.

e.g

/etc/hosts 

146.92.25.3     jollibee  
146.92.25.4     mcdonalds  
146.92.25.5     burgerking  
146.92.25.6     chowking

The easiest thing for me to do would be to run

date -s "25 Jul 2012 14:40:00"

for each of the 4 servers.

I know they will want me to do this again in the future and I find it a pain to set the time manually. What i want to do is set the time on one box and then set the times on the other boxes off this box.

e.g. if i set jollibee's time to the correct date i would then run

[root@mcdonalds /]# date -s `ssh jollibee 'date +"%d %b %Y %T"'`

and so on for my other servers

Thing is I'm getting:

date: too many non-option arguments: 2012 ...
Try `date --help' for more information.

Can anyone tell me what I'm doing wrong here?

linux
Martin Hope
rumz
Asked: 2010-10-27 10:25:42 +0800 CST
  • 1

An acquaintance complained about something not running on their system and asked for some help. I did a crontab -e and it mysteriously was blank! We were able to restore their crontab from a backup but she wants to find out what happened so they could take steps to avoid this happening in the future.

I checked history to see if someone accidentally ran a crontab -r and that wasnt the case. Someone mentioned that if someone was editing the crontab while the system is rebooting could also cause its disappearance. Checked too and that wasnt the case, the box has been up for 20 days.

Anyone have any ideas what could have caused crontab to just up and disappear?

cron
Martin Hope
rumz
Asked: 2010-08-10 12:27:53 +0800 CST
  • 6

I am running a simple query in SQL Server 2005 and want it to export to a file via sqlcmd. I was hoping to get the results in a csv format without the headers and the query metadata (how many rows are affected). for the headers you can actually specify -h -1 but how can you get rid of the ending text?

Right now i have

sqlcmd -S klingon -d stardb -i C:\testscript.sql -o C:\testresults.csv -h -1 -s ","

with the script being something simple to the tune of

select x, y, z from agent

Unfortunately, results are like so:

         24 aingles1         creablegs            
         25 tbails12         bull2dog12           
         26 jtaylor3         Leandon62606         
         27 forrestw1        nuke19211            

(4 rows affected)

I can't seem to find anything in the help file that will tell me how to remove the last part which tells me how many rows are affected.

Ideas anyone?

sql-server sql-server-2005