Hi, I'm pretty new to Access. I have an update query that is working, it compares to fields and if both of them match, it updates a third field in table 1 from a third field in table 2. The problem is that sometimes the data matches more than one time and I need both results to be inserted...
Hi,
I'm starting to use Access 2007. I'm pretty good with Excel but Access is new to me. I've figured out how to use a query to display a list of unique date in my table, but what I want to is display a second row that has a count of how many times the unique value occured. I know how to use...
I'm pretty sure that on Linux I used to be able to copy files and directories using "cp -al dir1 dir2" to make a copy of the directory that only updated the file count but didn't take up any more space on the disk.
However, on OSX Snow Leopard, the cp arguments are way different and this...
I am researching a problem in a sybase database and I need to know the table structure. I've gotten sp_tables to list the tables, but there are 383 of them and you can only scroll up to the last 20 or 30. How can I pipe the output or limit it so that I can see all of the tables? I am logged...
I have multiple scripts in the /etc/cron.daily/ directory on server running Redhat. Each day I get an email with the output of the scripts, but I do not wish to get this email. How can I turn it off? Since these scripts are in the daily directory, they are not actually in the crontab so I...
I have a server running Suse Enterprise Server 10.2 which backs up 10 other linux web servers once a month. Recently, I've been noticing that the server displays a clean desktop instead of having windows open on it. This tells me that the server rebooted, but I have not done it.
Can anyone...
Ok, I wrote a script that does exactly what I want, but for the life of me, I cannot get it to run at bootup. I put the script in /etc/init.d/ and linked it in the /etc/init.d/boot.d directory using "ln -s ../boot.backups S15boot.backups".
Then I rebooted. I was sure this would work, but it...
I have two questions about scripts:
1) How can I write a shutdown script for a script that runs automatically. For instance, I have a script that runs backups as soon as the computer boots, and then shuts down the computer when it is done. Periodically, I want the computer to stay up. I...
Anyone know the location of the apache page that gets copied to the users homedir when you create a new site? I want to replace the default page with a customized one that I made, but I can't find it.
I'm trying to find a CMS that is ASP and uses flat file/MS Access storage. I can find a CMS that is ASP and uses MS SQL, but I don't have that option. Any suggestions?
I'm trying to make a simple shell script which contains a few commands that delete certain files and also set a few aliases since they have to be set every time the user logs in. I know that I could set aliases in the .login file, but this is not an option for me. I would like to be able to...
Ok, here's the problem. I have a linux server in my garage that runs automated backups of my web servers that are hosted in a professional NOC. I want the backup server to send me emails on a weekly basis with the backup status, but since my ISP blocks outgoing mail, I can't. When I send thru...
Currently I am backing up 7 webservers to a backup server using rsync. After the initial backup, the differentials went pretty fast and the system works pretty good. I have the backups set to run nightly. The only problem with this scenario is that it only protects me against disk failures...
When I run "ps -ef", I see alot of entries that say the localhost IP is logged into the server thru FTP. To me, this means that a script on the webserver is logging in (or attempting to) via FTP. How can I find out who this is?
Here is some examples of the ps output:
nobody 13833 27617 0...
Hi,
I want to know if there is someway to monitor all the traffic coming into a server. More specifically, I want to know what site is being accessed. If I run "tail -f var/log/httpd/access_log" there are entries, but it appears to be only logs for the main IP of the webserver. Virtual sites...
Ok, I have a dedicated server, and every time I reboot it, the kernel panicks. The thing is that I didn't do any kernel updates, but thats not the point, the point is I need to make it so it boots with the older kernels by default. Can anyone give me a quick run down on how to do that?
Ok, I want to run a find command on specified directories and I want to search for multiple file types like *.exe, *.scr, *.bat, *.pif, etc. The problem is that I can't seem to figure out how to make the find command include multiple file types. Excluding multiple file types (or names) would...
Hi all. After getting hit with phishing attacks left and right, we need to implement some kind of script to search the servers for specific files and notify admin via email of their existence.
I'm sure that someone must have done this already, and I don't want to re-invent the wheel.
If...
Hi. I want to run rsync jobs automatically at midnight. The thing is that I want to be able to see the job in the workspace (or desktop, not quite sure what the proper linux term is for the GUI). I know I can run the jobs automatically with cron, but I won't be able to see them right? They...
Hi all. I would like to change the mount point of /dev/sdb1 from /backup to /home2. I tried just changing it in the fstab file, but the volume didn't mount when I rebooted the system. I already disabled fstab-sync, so that is not it. Maybe there is something I need to change in the mntab as...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.