Posts by rch1231

I had a feeling you had tried it but had to ask. The only other thing I can think of is something in the boot.ini. Do you have anything like Ultimate boot disk for windows or L-softs Active boot that you could boot from and check the ini files and registry?

Logically yes but I had to disable it to get it to work. It might be that windows is loading a drive that conflicts with the internal sata. It is just a suggestion if it does not work re-enable the controller.

I had a similar problem last week and i had to turn off the internal SATA controller in the BIOS to get it to work properly even though it was a sata HD.

Didi you try the <F8> when booting and go back to last known good configuration?

If you are looking to host hundreds of small websites out of which most of them are static, then which would u consider as your server

Intel Xeon 3040 (Dual Core)
1 GB DDR Memory
250 GB Hard Drive
1,500 GB Bandwidth

or

Intel Xeon 3110 (Dual Core)
4 GB DDR Memory
2 X 250 GB Hard Drive
1,500 GB Bandwidth

Hello,

I would go with this system:

Intel Xeon 3110 (Dual Core)
4 GB DDR Memory
2 X 250 GB Hard Drive
1,500 GB Bandwidth

4GB of memory will be enough to keep Linux from having to use the swap partition and mirrored hard drives gives you redundancy for hard drive failures.

I just recently found out that I need a secure tunnel client in order to access an API, OK. Then while researching I find way too much conflicting info about what it is exactly. Could someone shed some light? Is it a subscription? Does it live in my PC or on a server? Why do I need it if I have a SSL via https?

Secure Shell or SSH is a network protocol that allows data to be exchanged using a secure channel between two networked devices. Used primarily on Linux and Unix based systems to access shell accounts, SSH was designed as a replacement for TELNET and other insecure remote shells, which sent information, notably passwords, in plaintext, leaving them open to interception. The encryption used by SSH provides confidentiality and integrity of data over an insecure network, such as the Internet. For additional information see http://en.wikipedia.org/wiki/Secure_Shell

If you do not already have one on your home system pick download and install an SSH Client. Most people use PuTTY. PuTTY can be download from the link below:
http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

I use putty as my ssh client on windows and have my login for my Linux Web server set up to tunnel port 3306 for mysql. As far as the server is concerned I am connected locally to port 3306 and on my windows system I am also connected to the local port 3306.

To set this up you need to start p[utty and …

Hello,

You need a boot disk that will allow you to remove the virus. You can download a copy of the Ultimate boot CD for windows from my server at

httP://txlinux.com/UBCD4WinBuilder.iso

Download the file and then burn it to a CD and bott from the CD on your son's system. Or if you are not sure if you should trust me the google Ultimate Boot CD for windows and download the disk creation software.

I think the one question the everyone has been missing is which filesystem is it saying needs to have the fsck run? Check the /etc/fstab file and see what partitions you are mounting and make sure that you run fsck on all of them.

Hello,

Replace the power supply. I have seen this before on Dell's and they have detected a problem with the power supply and will not boot till replaced.

Hello,

1) I am not sure what you are asking on question 1 unless it is why to you set a primary key to Auto Increment. The answer is so the system will assign the next available integer to the field when the other fields are populated.
Auto Increment (Number/Currency only)
The AUTO INCREMENT attribute can be used to generate a unique identity for new rows. To start with the AUTO INCREMENT value other than 1, you can set that value in Options.

2) You don't have to assign a default value and the user will be forced to put in a value in when adding data because of the 'not null'

TEXT(tinytext, text, mediumtext and longtext) and BLOB(tinyblob, blob, mediumblob and longblob) data type cannot have DEFAULT values.

Glad it worked.

Yes there would but both systems would complain about a system being on the same IP. That is why I suggested that you use .100 for the IP. DHCP will always use the lowest IP's available first and as long as you are not connecting over 90 systems to your home network, it will probably never occur.

Since it is seeing the router properly now you can try going back to the get an IP address automatically setting and see if it still connects ok when it has been disconnected for a day or two. But you fon't have to change what you have now if you don't want to.

Check out qmail toaster. I use it on several servers that I manage and it is pretty secure. They have step by step instructions and shell scripts to do the work for you for several distributions (CentOS, Fedora, Debian, suse, etc.) and even talk you through the initial OS installation. In the process it installs Apache, PHP and MySQL and sets them up for you.

Hello,

Try giving it a fixed address in the upper part of your normal DHCP range. You need to check one of your other computers to see what range your router is using for DHCP. For example if it is a Linksys Router set the following for your network address on the wireless card:
IP: 192.168.1.100
Netmask: 255.255.255.0
Gateway: 192.168.1.1

DNS1: 192.168.1.1

Save the information and see if you connect. If it works then reset it for DHCP and see if you can connect without the fixed IP.

Add a switch or hub instead of a router. They are cheaper than a router or if you already have a router there may be an option to turn off the router and make it a dumb switch.
If not then you need to plug the line coming from the main router into the WAN port and then set DHCP on the upstairs router to a different IP range. Linksys normally uses 192.168.1.X and gives it's self the address of 192 168.1.1. You would need to set the upstairs router to use DHCP for the WAN and set the DHCP for it's LAN to something like 192.168.2.X . Hope that makes sense.

Hello,

Your problem is you need a driver for the RAID card for XP. Server 2003 has several built in but XP does not. Download one from the RAID card MFG's web site and put it on a floppy disk (yes a floppy, XP will only loook at a floppy for new drivers). Then when you are booting the XP CD you will see a message about pressing <F6> to load SCSI or other drivers. Press the <F6> key and follow the prompts to load the driver.

Good luck.

IF nothing else see what address is assigned to the ether net port on the windows system and give the xbox an address in the same range and if I remember correctly (no promise here) you make the gateway the IP of the ether net on the computer so it will route to it for the internet.

Correct. Did you look into internet connection sharing for the wireless port?

An old router should work if you plug both into the LAN ports and not the WAN. For the cross connect cable try this site:

http://en.wikipedia.org/wiki/Ethernet_crossover_cable

To connect two ether net ports you either have to have a hub (or switch) or have a cross connect cable. Once you have that look into ICS (Internet connection sharing ) under windows for how to route the xbox through your wirerless.

can you send the whole section of code? By the way what does 00:b0 reference? If it is supposed to be a time the b does not belong.

Disconnect all peripherals (HD, CD-ROM, etc ) and remove all expansion cards then try again. Double check the connections from the front panel to the mother board and make sure the power switch is connected to the right set of jumpers.

Then you are going to have to request the addition of the ServerAlias entry from your provider. To use the htaccess file they have to first get to your web site and if www.domain.com is not redirecting there then they would never get to the point where they would access the file. Does that make sense?

I am just curious why you don't simply use a ServerAlias entry in the hpptd.conf file like most sites:

<VirtualHost *:80>
        ServerAdmin webmaster@txlinux.com
        DocumentRoot /var/www/html/txlinux.com
        ServerName txlinux.com
        ServerAlias www.txlinux.com
        ErrorLog logs/txlinux.com-error_log
        CustomLog logs/txlinux.com-access_log common
</VirtualHost>

Did you verify your download and upload speeds at one of the speed test sites. I like http://speakeasy.net/speedtest. It lets you check against several cities.

Try cleaning out your temporary internet files and the cache. Here is a Microsoft site that tells you how...

http://support.microsoft.com/kb/260897

Hello,

I hope this helps I finally managed to get into Total DNS manger and did an export of the zone file for my server:

; NS Records
@ 3600 IN NS ns25.domaincontrol.com
@ 3600 IN NS ns26.domaincontrol.com

; A Records
* 3600 IN A 66.100.167.20
txlinux.com 3600 IN A 66.100.167.20

; CNAME Records
mail.txlinux.com 3600 IN CNAME txlinux.com
email 3600 IN CNAME txlinux.com
pop 3600 IN CNAME txlinux.com
smtp 3600 IN CNAME txlinux.com
my.txlinux.com 3600 IN CNAME txlinux.com
www 3600 IN CNAME @
imap 3600 IN CNAME imap.secureserver.net
ftp 3600 IN CNAME @
webmail 3600 IN CNAME webmail.secureserver.net
e 3600 IN CNAME email.secureserver.net

; MX Records
@ 3600 IN MX 10 txlinux.com

; TXT Records
@ 3600 IN TXT "v=spf1 a mx ptr ~all"

If you are going to be using the system for a mail server then you need to make sure you add the TXT entry and also contact the company you got the IP address from and make sure that they set up a rDNS (reverse DNS entry) for your domain. Many mail servers (including mine) will not accept mail from an email server that does not have a matching rDNS entry.

Check to see if you have a domain DNS server designated and if it is working. From command prompt try:
nslookup google.com
you should get a sresposnse saying something like this:
C:\Users\Rodney>nslookup google.com
Server: dns-cac-lb-01.rr.com
Address: 209.18.47.61

Non-authoritative answer:
Name: google.com
Addresses: 74.125.47.105
74.125.47.106
74.125.47.147
74.125.47.99
74.125.47.103
74.125.47.104

the first part tells you what dns server you are asking for the ip address. if that does not work try this and I bet you get an answer:

nslookup google.com 4.2.2.2

That will query the primary nameserver on the web. If that works and the first one did not your problem is your do not have a valid DNS server set for the network card. Set it under the "Local Area Connection X" and the Properties for Internet Protocol (TCP/IP) at the bottom. If obtain IP automatically is set the set DNS to the same thing and OK out of the properties then reboot. If it is set differently send the data and I will try to give you an idea.

Looking at the settings you have I believe I see the problem. I also have godaddy and it can be confusing as to what you should put where. You need to point mail.frostcity.com to frostcity.com instead of smtp.frostcity and pop.frostcity.com or change the entries for smtp and pop to point to frostcity.com. If you look at the settings you have the only location you point to the IP address is the frostcity.com one.
I when to get a snapshot for my server from godaddy and can't get to the totalDNS server right now they are doing maintenence...

Total DNS: (Available)
ARecord * 66.100.167.20
ARecord txlinux.com 66.100.167.20
CNAME mail.txlinux.com txlinux.com
CNAME email txlinux.com
CNAME pop txlinux.com
MX @ txlinux.com

Hello,

It really depends on what you are setting the variable for. If it is for this session you can use something like this to set the variable TESTVAR equal to Hello and export it to your current shell:

[root@srvr3 ~]# TESTVAR="Hello"; export $TESTVAR
[root@srvr3 ~]# echo $TESTVAR

echo $TESTVAR will tell you if it is set correctly.
To set a variable for every time you log in you have to add it to your .bash_rc file in your home directory.

Check to see if you have the server and not just the client installed.

yum list | grep mysql

will list all of the packages and you can see what is installed. My centOS 5 systems listed the following:
[root@srvr3 ~]# yum list | grep mysql
mysql.i386 5.0.77-4.el5_4.1 installed
mysql.x86_64 5.0.77-4.el5_4.1 installed
mysql-bench.x86_64 5.0.77-4.el5_4.1 installed
mysql-devel.i386 5.0.77-4.el5_4.1 installed
mysql-devel.x86_64 5.0.77-4.el5_4.1 installed
mysql-server.x86_64 5.0.77-4.el5_4.1 installed
perl-DBD-mysql.x86_64 4.013-1.el5.rf installed
php-mysql.x86_64 5.1.6-24.el5_4.5 installed

Hello,

As the system is booting use the <F8> key to get to the windows startup options and select VGA mode. It will load the VGA driver and let you get back into the system to repair the regular driver.

Opps...

cwarn23 is correct about it being the grave (`) and not the single quote ('). I was looking at the code I have and did not pay enough attention to what I was posting..... The example cwarn23 provided is the correct syntax.

The domain does not resolve at the moment and that may be the problem. When I tried to see where the domain was registered I got:

whois jdomain.co.uk
[Querying whois.nic.uk]
[whois.nic.uk]

No match for "jdomain.co.uk".

This domain name has not been registered.

Hello,

Go to control panel and then 'Add remove programs' and see if it is listed. If so use the option to change remove and get rid of it. if not the get CCCleaner (free ware) and use the uninstall option then clean the registry.

Hello,

Check and see if the CPU cooling fan is working properly. You should feel air coming out of one of the vents on the back. In most cases you can look through the bottom of the case and see the fan and tell if it is spinning. If it is not spinning get it replaced ASAP. If it is clogged with dust or dirt by a can of compressed air and clean the vents. You can also get a laptop cooling pad with fans built in to help for around $10 - $20 at Fry's or other computer stores.

The table name and fields that have spaces in the name must be inclosed in single quotes:

INSERT INTO 'employee record'('Employee ID', 'Employee type', 'First Name', 'Last name', 'Farm location', 'Farm type') VALUES('34', 'caretaker', 'Michael', 'Hipolito', 'lara', 'nursery' )

Hello,

Ok if you are running the trigger from another table (such as location) then you still need a field to hold the season and then the trigger you have will work with the addition of a where clause to tell mysql what record in category to update. If you add the season field to location table the following trigger used as an after insert trigger on location will update the first record in category every time a location is added.

Does that make sense?

Hello,

I don't know exactly why, but all of a sudden, my computer shows at the bottom right of the screen that it is not connected to the internet. However, it is connected to the network and the internet. This is odd and I would like it to be fixed. Does anyone have any suggestions? I ran MBAM and it came up clean. Below is a post of HijackThis. Thank you for any suggestions.

Logfile of Trend Micro HijackThis v2.0.2
Scan saved at 10:48:19 AM, on 1/21/2010
Platform: Windows Vista SP1 (WinNT 6.00.1905)
MSIE: Internet Explorer v8.00 (8.00.6001.18813)
Boot mode: Normal

Running processes:
C:\Program Files (x86)\Skype\Phone\Skype.exe
C:\Program Files (x86)\Sophos\AutoUpdate\ALMon.exe
C:\Program Files (x86)\Google\Google Talk\googletalk.exe
C:\Program Files (x86)\iTunes\iTunesHelper.exe
C:\Program Files (x86)\Mozilla Firefox\firefox.exe
C:\Program Files (x86)\Trend Micro\HijackThis\HijackThis.exe

R1 - HKCU\Software\Microsoft\Internet Explorer\Main,Search Page = http://go.microsoft.com/fwlink/?LinkId=54896
R1 - HKLM\Software\Microsoft\Internet Explorer\Main,Default_Search_URL = http://go.microsoft.com/fwlink/?LinkId=54896
R1 - HKLM\Software\Microsoft\Internet Explorer\Main,Search Page = http://go.microsoft.com/fwlink/?LinkId=54896
R0 - HKLM\Software\Microsoft\Internet Explorer\Search,SearchAssistant =
R0 - HKLM\Software\Microsoft\Internet Explorer\Search,CustomizeSearch =
R0 - HKLM\Software\Microsoft\Internet Explorer\Main,Local Page = C:\Windows\SysWOW64\blank.htm
R0 - HKCU\Software\Microsoft\Internet Explorer\Toolbar,LinksFolderName =
O1 - Hosts: ::1 localhost
O2 - BHO: btorbit.com - {000123B4-9B42-4900-B3F7-F4B073EFC214} - C:\Program Files (x86)\Orbitdownloader\orbitcth.dll
O2 - BHO: AcroIEHelperStub - {18DF081C-E8AD-4283-A596-FA578C2EBDC3} - C:\Program Files (x86)\Common Files\Adobe\Acrobat\ActiveX\AcroIEHelperShim.dll
O2 - BHO: Sophos Web Content Scanner - {39EA7695-B3F2-4C44-A4BC-297ADA8FD235} - C:\Program Files (x86)\Sophos\Sophos Anti-Virus\SophosBHO.dll
O2 - BHO: BitComet ClickCapture - {39F7E362-828A-4B5A-BCAF-5B79BFDFEA60} - C:\Program Files (x86)\BitComet\tools\BitCometBHO_1.3.7.16.dll
O2 - BHO: …

thnx for your interest in my question, my main goal is to when a hotel is inserted automatically the (that's why the trigger) the category.num_summer or category.num_winter is updated and added one,
so i'll know how many hotels are used in Summer and how many on Winter.
A trigger that count hotels based on the season when a hotel is inserted on table location.
I hope i made clear what i want this to do. thnx again...

OK. Then my suggestion would be this:

Add a field to the location table for season so that when the row is added to location they post if it in summer or winter. Then use the query below to find out how amny in summber and winter...

SELECT location.season as Season,
count(location.season) as 'Number per Season'
FROM
location
GROUP BY
location.season
ORDER BY
location.season ASC

and you should get a accurate count.

Hello,

I suggest checking two things:
1. Check the CMOS jumper on the mother board and make sure it is not on the RESET or CLEAR CMOS setting. Normally jumpering pins 1 - 2 is for normal operation and 2 - 3 is to clear the CMOS which is where the BIOS settings are stored.
2. Change/Replace the CMOS battery. If it is dead the BIOS would reset to default when you poer the system off but will hold if you just do a reboot.

Hope that helps.

i have 2 tables: category, location.
i create the tables:

create database tourist;
grant all on tourist.* to dbuser;
use tourist;
create table category(id integer NOT NULL AUTO_INCREMENT,season varchar(20),num_summer integer,num_winter integer,PRIMARY KEY(id));
create table location(code integer NOT NULL AUTO_INCREMENT,town varchar(20),hotel varchar(20),price integer,star integer,media varchar(70),PRIMARY KEY(code));

i want now to create a trigger on category that when is inserted in field <season> a season , if it is inserted before to count how many for that season.
Inserted winter and then again winter the num_winter should be 2.

i created this but doesn't work:

create trigger count_hotels
after insert on category
for each row
begin
if season='Summer' then
update category 
set categoty.num_summer = category.num_summer + 1
else if season='Winter' then
update category 
set categoty.num_winter = category.num_winter + 1
end if;
end;

If anyone could help i would appreciate it.

Hello,

OK I see a couple of things but want to make sure I have the right idea. If I am reading the code correctly you are running this trigger from the category table to update the record in category that you just entered....

One problem is you can't add to a field with a value of NULL so you need to change your default for the fields to be:

create table category(id integer NOT NULL AUTO_INCREMENT,season varchar(20),
num_summer integer default '0',
num_winter integer default '0' ,
PRIMARY KEY(id));

Based on that the row would always be 1 in either category.num_summer or category.num_winter in every record you add. In …

Hello,

If it shows up in Disk Manager then it is probably working ok. Based on what you have posted I would be willing to bet it is simply that the old drive was labeled as c: and there is already a drive c: (your new HD). At the bottom of Disk Manager you will see the physical drives and your old drive should show as Disk1. If you right click on it you get an option to change the drive letter (to f: for example) and you should then be able to see the drive under explorer.

Ouch. If memory server me correctly there is a virus that creates this type of loop. Try booting in safe mode and see if you can get past it. If not try booting with something like the "Ultimate boot CD for windows" and run the virus checker.

Any of the books published by O'Reilly. The have a great book on shell scripting and and other one specifically on awk and sed. Classic Shell scripting will give you a good introduction to awk and sed and many others.

Hello,

It might depend on the version but normally if you dump a specific database it does not include the USE statement.

mysqldump my_cool_db -u root -p > mysqldumpfile.sql

Or you could set up a script that will create individual dumps for databases who's names are listed in a file. For example if your file that contains the list of databases you want to create mysql dumps for is called:
/home/me/mydb.list
And you want the files to be created in /var/backups/databases. the script could look like:

#!/bin/bash
for x IN `cat /home/me/mydb.list `
do
mysqldump -u <USER> -p<PASSWORD> $x > /var/backups/database/$x
done

*******Notes..
1. The DO should be lower case do but it keeps showing as DO when I review my post.
2. You will need to use a real user name with access to the database in place of <USER> and <PASSWORD> and there is a space between -u and the user name but not between -p and the password.

Hope this makes sense and helps.

distro is short for Distribution and also referred to as the "Flavor". The source code is Public license so it can be customized for specific purposes. check out this link for a better discussion and answer.

http://en.wikipedia.org/wiki/Linux_distro

Hi,

Let's say I am opening my start up company and don't want to spend money on software. I have 2 questions for you who has experince in Linux.

1. I need a Linux server machine with GUI which should be Linux ... ? I heared that SUSE is good for server! More ideas? What about Ubuntu's server?

2. I need my employees to use a Linux distro which should be Linux ... ? I use Ubuntu which is good and your ideas ? If I go for SUSE server than should I go for SUSE Linux Enterprise Desktop?

Thanks in advance

Hello,

The distribution you use depends on several things including your level of expertise in Linux. If you look at most of the major web hosting providers ( I have worked for a few over the past 10 years) for the really security conscious/long time Linux users they offer FreeBSD and Ubuntu. For people who know less about Linux and need something more user friendly, they offer CentOS or Fedora Core distributions of Red Hat. Fedora and CentOS are both pretty up to date with the latest Red Hat kernels and updates, they also look and feel the same but there are some minor differences. Personally I have found Fedora more orientated to desktop and laptop support with really good wireless and DHCP tools. While CentOS is geared to be more for the Server environment With static and/or multiple IP addresses and Virtual hosting.

I would …

Personally if it was me I would go get a utility containing the Linux find application. It will search a directory structure for files and/or directories that: Have a name like, were created x days ago, were last accessed x days ago, and then exec a command on that found item. Google 'man find' for a copy of the linux find command parameters. A zip file containing Unix utilities for windows can be found at:

http://sourceforge.net/projects/unxutils/

And includes the man pages.

The reason I suggest this is I put together a script to do a similar thing in about 20 minutes with the linux utility find.exe that took a very decent Visual Basic Programmer over a day to get working (almost).

Any activity or lights on the system?
You said the led comes on to show it is getting power does the HD led show any activity?
Do you have an external monitor you could hook up. Could be the display is going out or the wires connecting to it are breaking.
When you say it shuts down what do you mean? DO all the led's go out, is the fan still running, do you see any messages?
If you get it running again and it is a windows system then see if there is anything in the event viewer (Control panel, Administrative tools, Event Viewer) and look in the Windows System log for errors.

Did you reset the local modem or gateway. Check for link light on network port and on modem/gateway. If no link light check or replace cable. IF there is another computer find out what it's settings are and mimic them adding 1 to the ip address it has (i.e. if the other computer is 192.168.1.14 use 192.168.1.15 for the address on this computer) and the same gateway and netmask.