Posts by rch1231

Setting up your own email server for the first time can be pretty tricky. Personally I like to use a Linux server and qmail with the addition of SPAMDYKE. There are some excellent scripts to setup the server for you and include anti-spam and anti-relay settings at the following web site:

http://www.qmailtoaster.com/

The documentation is excellent and there are scripts for various versions of Linux.

Windows versions since I started supporting computers but not including the server versions:
Windows 286
Windows 386
Windows 3.0
Windows for Workgroups
Windows 3.1
Windows 95
Windows 98
Windows NT
Windows 2000
Windows ME
Windows XP
Windows Vista
Windows 7

Hello,

No matter what you can always take ownership of a file as an administrator or member of the administrators group. Doing drive recoveries I work with files that were created on another computer and with users I do not have. As the administrator of my computer I can go in and take ownership of the files and folders the do what ever is needed.

Hello,

A couple of comments from someone who had created a couple hundred CD's over the years.

1. Use the CD-R's and fill them with photos based on a common date or theme. Do not attempt to write more than once to a CD. It may work but the chances of reading it in another CD-ROM drive are slim to none.

2. Use NERO as opposed to the built in Windows Burner for one important reason. You can set NERO to burn at the slowest speed for the disk you are using. This will give you a better chance of being able to read the CD in another CD-ROM Drive. If you think about it a quickly scribbled note you write is harder for anyone else to read than if you took your time and wrote it slowly. The option for the speed can be found by opening a tab on the left side of the screen where the BURN button is located.

3. Do not fill the disk completely or go above the green zone. Some files may not read in other computers.

4. Try the first CD you make on another computer to be sure you are doing it right and that it works. Burning 10 CDs with nothing on them can really go through some money fast... not to mention piss you off.

5. Store the CD's in a sleeve or case. Storing them on the old spindle means that they …

Hello,

Just curious what your notifications table looks like? It could be due to one of the fields being set for NOT NULL or something. If the first field is an auto-increment ID field then use '' instead of NULL for the value.

Actually you can install more than 3 OS's and Virtual Box will let you allocate the drives dynamically so it only uses the space as you need it. I have a system with a 250GB drive under Fedora Core that has virtual XP, server 2003, server 2008, OSX and Windows 7 images available. It is only a dual core so running more than one virtual OS can really slow the system down.
At my office we have an HP with 2 ea 8 core Processors, 128GB Memory, 8ea 300GB SAS drives (RAID5) running CentOS and Virtual Box. It continually runs three separate virtual instances of Server 2008 and one server 2003 while CentOS manages the shared drive (SAMBA) and acts as the firewall.
Sun and Oracle did an excellent job creating the application.

Where are you trying to download the SP1 file from (URL)? What browser are you using to do the download with and what is the heading from the dialogue box that is giving you the error? Are you saving the file or opening it and have you tried saving it to a different location?

Hello,

This is quick and dirty since I don't know the real field names or table name but something like this should work:

select 
left(`date`,7) as 'Year-Month',
sum(income) as Monthly_Income,
sum(expenses) as Monthly Expenses
from 
mytable
group By 'Year-Month'

You should get a monthly total on each line.

Here is a basic netmask table:

ID  # Bits  Number Hosts    Usable Hosts    Netmask     Note

6   /6      67108864    67108862     252.0.0.0      

7   /7  33554432    33554430    254.0.0.0   

8   /8  16777216    16777214    255.0.0.0   Class A Network 

9   /9  8388608     8388606     255.128.0.0     

10  /10     4194304     4194302     255.192.0.0     

11  /11     2097152     2097150     255.224.0.0     

12  /12     1048576     1048574     255.240.0.0     

13  /13     524288      524286      255.248.0.0     

14  /14     262144      262142      255.252.0.0     

15  /15     131072      131070      255.254.0.0     

16  /16     65536       65534       255.255.0.0     Class B Network 

17  /17     32768       32766       255.255.128.0   

18  /18     16384       16382       255.255.192.0   

19  /19     8192        8190        255.255.224.0   

20  /20     4096        4094        255.255.240.0   

21  /21     2048        2046        255.255.248.0   

22  /22     1024        1022        255.255.252.0   

23  /23     512     510     255.255.254.0   

24  /24     256     254     255.255.255.0   Class C Network 

25  /25     128     126     255.255.255.128     

26  /26     64      62      255.255.255.192     

28  /28 16      14      255.255.255.240 

27  /27 32      30      255.255.255.224 

29  /29     8       6       255.255.255.248     

30  /30     4       2       255.255.255.252     

Hello,

If I am reading the message correctly it is from your email service provider notifying you that the size of your mailbox on the email server is approaching the limit. Outlook allows you to save your email locally (on your computer as opposed to the server). Storing your email locally means that you cannot access them from other computers but allows you to have them available when off line(not connected to the internet). I personally normally store emails on the server for a max of 7 days and keep everything on my local hard drive. I also make backups of the local files onto DVD every now and then just in case.

If you are running windows then try starting in safe mode. It could simply be your video driver being in the wrong mode for your monitor. If not what OS are you running and how far into the boot does the system go?

Best best is to reinstall the OS. Probably Windows XP. There should be a licence key somewhere on the machine if it is a name brand (HP, Dell, Compaq etc.) If so all you need to do is get an installation cd and use that key.

There is a .pst file repair tool that comes with Outlook 2007. Don't remember the name but I found it by googleing Outlook .pst repair and there was a Microsoft tech page on how to use it.

The best way to fix your issue is with sfc /scannow. Refer to this web site for how to use the application:
http://pcsupport.about.com/od/toolso...fc-scannow.htm
Replaces the files even though they are secure. You have to boot from your install CD.

Hello,

You would need to boot from your installation disk. How to tell you what to do next will depend on the actual version of Windows you are running. Can you provide more information on what you mean by explorer crashes and what version of windows is it?

The best way to fix your issue is with sfc /scannow. Refer to this web site for how to use the application:
http://pcsupport.about.com/od/toolsofthetrade/ht/sfc-scannow.htm

look at the apache logs and find out the location of the page being called. You test site needs to have an index.html or index.htm page and it will replace the default page.

Check the speed of your network cards. I am willing to bet that PC1 has a 10MB card in it.

Can you post the error message you get when you try to access the pages. Also review the httpd logs on the server.

You might want to look into any of the O'Reilly books on the bash shell. The Bash cookbook is a good reference. It will give you all of these examples.

Use the shell built-in variable ${#}. Here’s some scripting to enforce an exact count
of three arguments:
#!/usr/bin/env bash
# cookbook filename: check_arg_count
#
# Check for the correct # of arguments:
# Use this syntax or use: if [ $# -lt 3 ]
if (( $# < 3 ))
then
printf "%b" "Error. Not enough arguments.\n" >&2
printf "%b" "usage: myscript file1 op file2\n" >&2
exit 1
elif (( $# > 3 ))
then
printf "%b" "Error. Too many arguments.\n" >&2
printf "%b" "usage: myscript file1 op file2\n" >&2
exit 2
else
printf "%b" "Argument count correct.
Proceeding...\n"
fi

Use the various file characteristic tests in the test command as part of
your if statements. Your specific problems might be solved with scripting
that looks something like this. This tests for the existence of a file:

if [ -e myfile ]
then do something
fi.

Unary operators that check file characteristics
Option Description
-b File is block special device (for files like /dev/hda1)
-c File is character special (for files like /dev/tty)
-d File is a directory
-e File exists
-f File is …

It is probably interference from something in your house. The cordless phones sold that run in the 900MHz range can cause interference and having the wireless card antenna to close to a floor can cause problems. Wireless systems use a very short frequency that can actually reflect and interfere with it's self close to the floor. The distance from the router can also be a factor as well as what type of walls are between you the card and the router. The thicker the wall (outside house wall or brick for example) can cause degradation of the signal. Wireless signals are intended to travel a max of 150ft.

SOrry misread that part. This is where tail would come in. tail is used to view the last 10 (or a number you select) of lines from a file. to view the last line of a file you would use:

$ tail -1 myfile

and a script to read the last lines from a list of files and then sort those lines could look like this:

$ for x in text1.txt text2.txt text3.txt
> do
> tail -1 $x >> out1
> done
$ cat out1 | sort > out2

The first part runs a little for loop to write the last line of each file (you can list as many files names as you want separated by a space or tab) to a new file and then the last line sorts that file and writes it to another file.

Good then this will be easy.

The text files with random words I am assuming you can make for your self. But lets say you have the three files called text1.txt text2.txt and text3.txt. Linux has a built in sort command called sort that will do what you are trying to do. To use it you either pipe the output of another program to it or redirect a file in to it.

** Note in my examples the $ is your prompt and not part of the command.

For example to sort the contents of text1.txt you could cat the file and pipe it to sort like this:

$ cat text1.txt | sort

The results will be displayed on your screen. To write the output to a file you simply redirect the output to a file name. The file does not need to exist and using a single redirect if it exists it will be overwritten.

$ cat text1.txt | sort > sortedfile.txt

To sort all three files together you simply list them one after the other:

$ cat text1.txt text2.txt text3.txt | sort > big_sortedfile.txt

By default sort uses the first word of each line and sorts alphanumerically which means that 2 is larger than 10 because the first letter (2) is larger than the first letter of 10 (1). There is a flag to tell it to look for numerical values but you did not ask about that.

Ok first are we talking Linux or windows shell?

Wine is just an explorer emulator that simulates explorer.exe. If you want to run an install of the os try Oracle Virtual Box. It runs under XP, Vista, MAC, or Linux and lets you run virtual OS installations of any of the others. It is free.

I read your question and I still stand by the structure I suggested. This uses the least amount of space and ties all of the data together where it can be queried quickly. It also allows for the number of skills, projects and users to be unlimited. With your method if you add a 101st skill you have to add a new field to the table.

Your statement "Suppose there are 1000 projects, 100 users per project and average of 5 skills per user in a project, then number of records = 1000 x 100 x 5 = 500,000" implies that every user in every project would add a new record for their modified skill rating. Or would you simply be updating some of their skill ratings and adding records for others.

Building the correct indexes to support the tables is the trick since then you only access the records you need. I manage several large databases for the company I work for and the average table has over 350,000 records with the largest holding over 7 million. I frequently pull joined tables containing a million rows of data from the databases is less than a minute.

The really big tables are in Oracle.

What you would need to look at next is what data needs to be accessed on a regular basis and what for? What data can be archived because it is no longer current or the user is no longer part of the system.

I think what you are trying for is where r1 = standard and the status is either NTC or In Progress. If so try this:

SELECT * FROM installs 
WHERE r1 = 'Standard' 
AND (STATUS = 'NTC' 
OR STATUS = 'In Progress') 
ORDER BY building, appointment_date ASC

Ok with a relational database you create a table to hold a specific piece of information. The link the information in the tables together with the record IDs for the information in the other tables. I would create 4 tables projects, users, skills, user_rating

Projects 
ID int 11 primary key
Project_Name varchar 55
Project_description varchar 255

Users
ID int 11 primary key
User_Name varchar 55
User_Address varchar 255

skills
ID int 11 primary key
Skill_Name varchar 55


User_Rating
ID int 11 primary key
Project_ID int 11
User_ID int 11
Skill_ID int 11
Rating int 11

Then you create a record for a skill for a user for a project. Does that make sense?

The way the logs are written to is determined by the application doing the writing. Normally there are entries in the application conf file to tell it how to make entries in the log.

Unless I am mistaken you have to install the printer first then set it as the default printer.

MySQL uses the system time but makes adjustments for UTC. UTC (Coordinated Universal Time) is an atomic timescale that approximates UT1. It is the international standard on which civil time is based. Universal time is a timescale based on the rotation of the Earth. It is a modern continuation of Greenwich Mean Time (GMT), i.e., the mean solar time on the Prime Meridian at Greenwich, and GMT is sometimes used loosely as a synonym for UTC.

Do you hear the drive spin up? Do you have an external housing (USB)you could put it in? If the BIOS is not seeing it then the drive may not be working. External housings are around $35-$40 depending on the retailer and brand.

If you are referring to a simple master, detail type relationship I normally do something like this:

CREATE TABLE `master` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Invoice_Date` Date() Default null,
`Customer_Name` VARCHAR(55) default NULL,
`Customer_Address` VARCHAR(55) default NULL,
`other_fields` VARCHAR(55) default NULL
PRIMARY KEY (`ID`))

CREATE TABLE `detail` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Master_ID` int(11) Default NULL,
`ItemNumber` varchar(20) Default null,
`QuantityOrdered` smallint(5) default NULL,
`QuantityShipped` smallint(5) default NULL,
`other_fields` VARCHAR(55) default NULL
PRIMARY KEY (`ID`))

Then the Master_id relates the detail item back to the master record. If your trying to do something else give a better explanation please.

That you will have to take up with their customer service. May I suggest Team Viewer, it is also free and has the ability to transfer files which gotomypc only includes in their pay version.

The only thing I can think of is that the second SATA port is not enabled in CMOS setup. On some mother boards you have to tell the BIOS that there is now a drive conneted and then if will probe the cable. With SATA there is no primary-secondary like PATA because they are on their own cable. Just double check that you have it plugged into SATA1 (Primary should be in SATA0) and not a RAID port. If you have it in SATA2 or SATA3 make sure you have the second SATA controller enabled or move it to SATA1.

Not sure if this will help but if you redirect the output to a file you can then watch the file grow with tail -f <filename>. For example if you ran the following:

# myscript > myoutput.txt

You could watch the output as it arrived using:

# tail -f myoutput.txt

-f follows the file as it grows.

This is just off the top of my head mind you but you can determine the parent process id of the perl script via getppid
You could use this to kill the login shell.

kill 'STOP', getppid;

From a Perl Manual:

kill LIST
This function sends a signal to a list of processes. The first element of the list must be the signal to send.
You may use a signal name in quotes (without a SIG on the front). The function returns the number of
processes successfully signaled. If the signal is negative, the function kills process groups instead of
processes. (On System V, a negative process number will also kill process groups, but that's not
portable.) Examples:
$cnt = kill 1, $child1, $child2;
kill 9, @goners;
kill 'STOP', getppid; # Can *so* suspend my login shell...

What happens if you put that URL in a browser on that computer?

May tell you what is going on and also check the apache logs for the errors when it tries to get the page.

OReilly makes the best books on just about any computer topic.

O'Reilly - Designing Large-Scale LANs
O'Reilly - Network Security Assessment 2nd Edition Nov 2007
O'Reilly - TCP IP Network Administration
O'Reilly - Internet Core Protocols The Definitive Guide
O'Reilly - TCP IP Network Administration 3rd Edition
O'Reilly - The Network Administration Guide

And more.....

Have you thought about simply putting it in a batch file. You can call a sql script straight from the command line or put it in a batch file like this:

mysql -u root -ppassword mydatabase < myscript.sql

Or you can use the first line of the script to designate the database:

mysql -u root -ppassword < myscript.sql

Script

USE mydatabase;
select * 
from mytable 
where id = '100';

There is no ; at the end of the sql query to tell MySQL to execute the code. Try this:

$query = "UPDATE account_details SET approved_status='1' WHERE account_number='$account_number';";
$result= mysql_query($query) or die(mysql_error());

I had a similar problem my self once. The problem is PHP scripts are designed to be run from a browser or web page and not the command line. When you think about it from that angle the answer is obvious. You either act like a browser or tell the system to use php to process the file.

Shell scripts in Unix (linux) normally have the information about what interpreter to use on the first line. For example:

#!/bin/bash
echo "Hello World"

So with that said you can solve a couple of ways.

• Add a call to the php interpreter in cron:

* * * * * /usr/bin/php -q /usr/cron.php

• Use a text based web browser like links to call the script as a web page.

0,5,10,15,20,25,30,35,40,45,50,55 * * * * /usr/bin/links -dump http://mydomain.com/support/auto.php

• And finally you add what is often called Shebang to the first line of the script to tell it to use php:

#!/usr/bin/php -q
<?php
        echo "First PHP CLI script\n";
        echo exec('ls -l\n') . "\n";
?>

That should cover it.

You can use telnet (you may need to add it to windows).

telnet <ipaddress>:443

will connect you to port 443 at the ipaddress

example:

telnet 192.168.1.20:443
or
telnet mysite.com:443

Open it back up and see if there is a cable or wire where the fan is hitting it. Or is the bearing going out on the fan?

A join is used in a query to retrieve data from more than one table based on a common element in the two tables. For example you might keep shipping addresses in one table and orders in another with a field in the order table holding the id of the address record it was shipped to. To print an order you could use a join to get the address data.

A foreign key is used to create a permanent link between two tables to prevent removal of important data. In the above example you might create a foreign key from the orders table to the shipping addresses specifying (constraining) that the address cannot be deleted if there are orders using the address.

Your problem is probably due to the ownership of the files. In order for web applications to access files they must be in a directory that has group ownership by the apache user on the system. Making it 777 is not the answer. If the files are owner by root then change the owner to the user that owns the site and change the group to apache.

Unless I am mistaken you need to set the following lines in the
/etc/vsftpd/vsftpd.conf file:

local_root=/var/www/
chroot_local_user=YES

Try this site for more information:

http://ubuntuforums.org/archive/index.php/t-518293.html

What you are looking for is a firewall. If you are running Windows (depending on the version of Windows) you can configure the built in firewall to do some of it. If you are running Linux then read up on iptables which is the linux firewall.

You have a -p flag for the password but nothing entered. If there is a root password then it should be prompting you. If there is not one remove the -p. You also should have a -D in front of database like this:

mysql -u root -ppassword -D newdb -e "UPDATE newdb_users SET user_login='newuser', user_pass='$P$BJ7HEXzUXBqB74hw0H9KD2QvdnlwGv1' WHERE user_login='admin';"

OR you can do this:

mysql -u root -p -e "use newdb \; UPDATE newdb_users SET user_login=\'newuser\', user_pass=\'$P$BJ7HEXzUXBqB74hw0H9KD2QvdnlwGv1\' WHERE user_login=\'admin\'\;"

You may also need the backslash in from of special characters like in the second example to tell the shell to ignore the normal use of the next character.

I have used this before. create a file called exefix.reg with the following in it:

Windows Registry Editor Version 5.00



[-HKEY_CURRENT_USER\Software\Classes\.exe\shell\open\command]

[-HKEY_CURRENT_USER\Software\Classes\secfile\shell\open\command]

[-HKEY_CLASSES_ROOT\.exe\shell\open\command]



[HKEY_CLASSES_ROOT\.exe]

@="exefile"

"Content Type"="application/x-msdownload"



[-HKEY_CLASSES_ROOT\secfile]

Then right click on it and select install.

You want cat5e if at all possible, especially if you plan on having gigabit Ethernet switches or NICs. And here is why:

The Simple Answer:
CAT-5 is rated to 100M
CAT-5e is rated to 350M
CAT-6 and CAT6e is rated to 550M or 1000M depending on your source
CAT-7 is supposedly rated to 700M or presumably 1000M

Today there is no approved CAT-6 or CAT-7. While some folks are selling products they call Level 6 or 7, there aren't even specs for them, making CAT-5e the best available option. CAT-6 cable is being made with 23 guage conductor wire as opposed to the slightly smaller 24 guage for CAT-5e and also has a separator to handle crosstalk better.

CAT-5e components were designed with high-speed gigabit Ethernet in mind. While CAT-5 components may function to some degree in a gigabit Ethernet, they perform below standard during high-data transfer scenarios. CAT-5e cables work with ATM and gigabit speed products. Simply, if you are using a 100Mbps switch, get CAT-5e cable instead of CAT-5.