Posts by rch1231

Hello,

Your going to need to uninstall SQL Server, clean out the registry entries for SQL server and then reinstall it to correct the issue.

Hello,

You would have to have the same host entry on the client also or use the IP address of the server.

Hello,

Unless I am mistaken the issue is with the Home Premium version of Windows 7. It is only designed to see computers in a Homegroup and does not support other networks or domains. Below is a link to the Microsoft page that shows the capabilities of each version of Windows 7. You need at least Windows 7 Professional to see the XP systems on the network.

Windows 7 Compare

So there is no user called garrett with Host = localhost but it could be in there another way (i.e. garrett@%). Try just this and see what you get:

select * from mysql.user where User = 'garrett';

If you still get 0 rows then he does not exist. To add the user you will need something like this to create the user and them give them access to a specific database:

CREATE USER 'garrett'@'localhost' IDENTIFIED BY 'some_password';
GRANT ALL PRIVILEGES ON some_database.* TO 'garrett'@'localhost'
WITH GRANT OPTION;

let us know how it goes.

Rubberman, as usual, is correct.
One of the most important things you can do to make your cache more efficient is to make sure there is plenty of RAM in the server. To make the most efficient use of real memory, Linux automatically uses all free RAM for buffer cache.

Here is a site that will give you a good idea of what a cache buffer is used for and how a linux system uses it to make it more effecient.
The Buffer Cache

Hello,

The warning you are getting is telling you that the hostname of the server (which you said has no full stops) cannot be resolved to a IP address. You can fix this in one of two ways:

1. The easy way. edit the /etc/hosts file and add the name you have given the server to the line starting with 127.0.0.1. For exsample if the name you have given the server is mycpanelserver then the line would look like this:

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 mycpanelserver

1. You have to have a domain of some sort if you are on the internet and you can give your server it's own name in your domain. For example if you own the domain name mysite.com then you could use server1.mysite.com or svr1.mysite.com or one.mysite.com. As long as you don't use either www.mysite.com or just mysite.com (these should point to your website on the server) you will be fine. Just make sure that you get with your domain registar and have an entry added that points to the primary IP address of the server so CPanel license does not cause issues.

Hello,

Your going to have to test to see if the number is in a list of the prime numbers. They are fixed after all and you can find out what they are in multiple places on the internet.

For example here is a site that has the first 1000 primes:

http://primes.utm.edu/lists/small/1000.txt

Hello,

Since you already found the site for the driver what you are missing is the order to install them. The first driver you need to download is the chipset driver. You have to have the chipset driver loaded before you can access any additional devices in the computer properly. Without it any driver you try to install for a built in device will not be able to communicate with the device. Once you install the chipset driver I will be willing to bet you can install the others without any problems.

Hello,

The problem is that you do not ahve the mysql serve running which is called mysqld. You may not have it installed but and the client and server are two different packages.

Hello,

I would import the CSV file into the MySQL database as a different table. For example if the table in the current database is customers then make the import table customers1. Then use sql queries to compare the two tables. This type of query is what MySQL is designed for.

MySQL has an import function called mysqlimport that can be run form the command line and is designed to import text files like csv files. If you have any type of GUI interface (like phpmyadmin or mysqlworkbench ) most of them have built in options to load a csv file.

The a query to find matching records or records in table1 not in table2 is easy to write.

Hope this helps.

Hello

Your missing a few things in your crontab file. Simply placing the file in /etc/cron.hourly is not enough. The format of an entry in a crontab file is like this sample file. Lines that start with a # are comments and ignored by cron:

     # use /bin/sh to run commands, overriding the default set by cron
     SHELL=/bin/sh
     # mail any output to `paul', no matter whose crontab this is
     MAILTO=paul
     #
     # run five minutes after midnight, every day
     5 0 * * *       $HOME/bin/daily.job >> $HOME/tmp/out 2>&1
     # run at 2:15pm on the first of every month -- output mailed to paul
     15 14 1 * *     $HOME/bin/monthly
     # run at 10 pm on weekdays, annoy Joe
     0 22 * * 1-5    mail -s "It's 10pm" joe%Joe,%%Where are your kids?%
     23 0-23/2 * * * echo "run 23 minutes after midn, 2am, 4am ..., everyday"
     5 4 * * sun     echo "run at 5 after 4 every sunday"

The easiest way to create a crontab file is while logged in to a shell as garrett type the following:

crontab -e

To see your crontab use:

crontab -l

To remove the current crontab for the user:

crontab -r

Hope this helps.

Hello,

This is a know issue with Mint. You need to install the gnome-screensaver and add it to gnome-session-properties.

http://www.linuxmint.com/rel_nadia_whatsnew.php

What you are seeing is the GRUB boot loader. It allows you to boot multiple operating systems from the same drive. If you leave the system at the screen it should go ahead and boot Ubunto after a few seconds. Here is a link to more information:
https://en.wikipedia.org/wiki/GNU_GRUB

Hello,

Can you provide a little more information?
What version of windows are you running?
DO you show any problem devices in Device Manager?
what sould device are you using (built in, expansion card, etc.)?

Hello,

Rubberman was right about having to escape the ? in the file names and you will have to do that for the spaces also. Try this to get rid of one of the file A????cd new????cat> >> A:

/bin/rm -i A\?\?\?\?cd\ new\?\?\?\?cat\> \ \>\>\ A

As an example of what the shell can autofill in for you try typing and do not hit enter:
/bin/rm -i A\?e

and then hit the <TAB> key the shell will try to fill as much of a unique name as it can and you should get this:
/bin/rm -i A\?echo\ A
If you hit enter now it should prompt you to remove the file.

Hello,

I am not sure what caused the file names however you can look back throught your command history by typing history at the command prompt.

To remove the files I suggest you use something like:
/bin/rm -i /full_path_to_directory/*

The -i will cause rm to prompt you about deleting each file.
You might want to use ls -la instead of ls to review the directory listing so you get one file per line and more details on the file size, permissions and date modified.

Hello,

I think you are missing the DATE_ADD and have the wrong quote marks around the field name. Try something like this from the mysql manual:

SELECT something 
FROM tbl_name
WHERE `tbl_net_centre.reg-date` <= DATE_ADD(CURDATE(),INTERVAL 3 MONTH) ;

If it is the Tandy DBMS then this page might help with the definitions and they can look up filePro for manuals and information.;
http://www.wikipeetia.org/Filepro

The data is stored in flat files called key and data and I am willing to help if I can. send me a private message with your email address and I will respond.

It depends on how old an application you are looking at. There was a database called proFile on the Tandy 16 and 6000 series computers and later for Tandy Xenix on the T2000 or T3000 (80386) Systems. It was also sold seperately as FilePro and was a Relational database that had applications with the following names:

clerk, report, cabe, menu, moedef, etc.
or
dclerk, dreport, dcabe, dmenu, dmoedef, etc.
or
rclerk, rreport, rcabe, rmenu, rmoedef, etc.

It used a series of *If Then *statements for porcessing information in the database.

If this is what you need information on I have most of the manuals boxed up in the shed along with my MS-DOS manuals...

Hello,

You need a join for this but getting all of the tags on the same line could be tricky. Start with something like this:

select articles.title, 
articles.descripton,
tags.tag
from articles
left join tags on articles.id = tages.articleID

This will give you every record from articles (even those without an entry in the tags table) and all matching records from the tags table.

Personally I use an IDE that runs on both Windows and Linux and provids a License key that works on both. Editrocket is the application name and it works with multiple languages and includes code snipites and what I have found to be many other great utilities. The price was within reason too.

Web site for Editrocket

Hello,

A class A subnet contains 16777216 IP addresses. A class A network starting at 192.0.0.0 would extend to 192.255.255.255 and contain all of the addresses in that subnet (i.e. 192.0.0.1, 192.0.0.2, ...., 192.255.255.254, 192.255.255.255)

A Class B starting with 192.0.0.0 would extend to 192.0.255.255 and would contain 65536 addresses (i.e. 192.0.0.1, 192.0.0.2, ...., 192.0.255.254, 192.0.255.255) another example could be 192.168.0.0 to 192.168.255.255 (i.e. 192.168.0.1, 192.168.0.2, ...., 192.168.255.254, 192.168.255.255)

A Class C contains 256 addresses and might be 192.168.0.0 through 192.168.0.255 . Which means the Class B starting at 192.168.0.0 has 256 class C subnets:

Class C Network           Range
    1            192.168.0.0 - 192.168.0.255
    2            192.168.1.0 - 192.168.1.255
    3            192.168.2.0 - 192.168.2.255
                          .
                          .
                          .
    255          192.168.254.0 - 192.168.254.255
    256          192.168.255.0 - 192.168.255.255

Hope this helps.

Hello,

In order to telnet to a port you have to have an application listeningn on that port. For example if you have IIS running then it listens on port 80 for any http traffic. You need to know that Windows XP is not a server OS. It is designed to allow only one person to connect or use it at a time. There is a built in applicaton and access program called Remote Desktop (referred to as RDP) that listens on port 3389 when activated and can be reached with the client which is normally found under accessories.
To turn on that ability to connect with RDP, right click on My Computer and select Properties. The select the Remote tab at the top and check the option to allow remote access.

What you are asking about is the BIOS (Basic Input Output system). It is called when the computer starts and determines what hardware is connected and if the hardware is sufficient for the system to be able to boot. If not it gives errors such as my personal favorite

Key board not present Press F1 to continue

Once the BIOS determines the system has enough hardware it attempts to boot from the Primary boot device then the secondary etc. Check out this article for more info:
Click Here

It could be one of two things:
1) either you have not gone in to the computer BIOS Setup and told the computer there is a second device (or let it detect there is a second device) on the cable. OR
2) You have the master/slave settings wrong on the drives. Make the DVD the master and the CD Rom the slave put the DVD at the end of the cable and the CD in the middle.

One quick note. The DVD RW is also a CD RW and can be used to create CD's.

The only thing I see out of place is the quote marks arount the Document Root Normally I use the path /var/www/html/domainname.com. Below is the first entry from one of the servers I manage.

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

Hello,

You need a backslash to tell the script to escape the normal use of the next character. Try this:

while read line; do echo -e "${"${line:21}"/\//-}"; done < Albums-linux.txt

Hello,

I tried that sshdfilter and found denyhosts to be a much easier application to install and configure. And it works.

Hello,

It is really very simple but it took me a while to find it too.

create table newtable
SELECT adp.adsPageId,adp.adsSpaceId, DATE_FORMAT(adp.dayClick, '%Y-%m-%d') AS dateReport, 
(SELECT COUNT(*) FROM ads_display att WHERE att.adsSpaceId = adp.adsSpaceId AND att.adsPageId = adp.adsPageId AND att.dayClick = adp.dayClick) as TotalView,
(SELECT COUNT(*) FROM ads_click acc WHERE acc.adsSpaceId = ack.adsSpaceId AND acc.adsPageId = ack.adsPageId AND acc.dayClick = ack.dayClick) as UniqueClick

FROM ads_display adp

LEFT JOIN ads_click ack

ON adp.adsSpaceId = ack.adsSpaceId

AND adp.adsPageId = ack.adsPageId

AND adp.dayClick = ack.dayClick 

GROUP BY dateReport,adp.adsPageId,adp.adsSpaceId

ORDER BY dateReport,adsPageId,adsSpaceId ASC

Hello,

I cheated and used the following app in windows or dos based systems:
http://www.informatics-consulting.ch/software/namedate.htm

Hello,

This should work provided you have access to the file and directory listed:

copy "\\ServerNameOrIP\c$\Program Files\Microsoft Sql server\backup\test.bak" C:\backup\

You can try moving either your wireless router or the wireless antenna for your card to a higher position while leaving it in the same room. If the antenna on either is to close to the floor the high frequency signal can cause interference with its self. Moving it to a higher location gives you a stronger signal. Or you can create a simple signal booster by placing the router antenna about 2 inches from the corner of the 90 degree angle (corner) cut from a box and lined with foil. Try Googleing wireless antenna booster. They can boost the signal by a factor of 10.

Hello,

Try this. open a terminal and become the root user (using su or sudo) then execute the following two commands and it should refresh the YUM distribution cache.

yum clean all
yum list

You should get a list of all applications available via YUM and your add remove packages application should now be working.

Try this sql statement instead:

"SELECT group_id, rec_id FROM RandPtrack where type='R' order by group_id desc limit 1"

This will select all records sort them in descending group_id order (with the largest group_id first) and them limit the output to one (the first) record.

XP by it's self does not recognise the ext3 filesystem partition so you will need some sort of application that knows about ext3. Unix filesystem utilities for windows, Paragon HD manager, partition magic, etc.

Hello,

Generally speaking a hard drive is a hard drive no matter what packaging it has. The main things you have to watch out for are the interface (SATA, PATA, SCSI, SAS, Fiber-SCSI, etc.) Most external storage systems sold for home or small office use now a days are simply SATA drives in some sort of housing. Logically YES you should be able to pull the drive our of the unit and use it in another.

Hello,

Try changing the WHERE MAX(Votes) to

WHERE Votes = (select MAX(Votes) from $portfolio )

Hello,

My mistake I was thinking it was the windows systems that cannot access via name. In this case all you need to do is edit the /etc/hosts file on the linux clients and add in the entries for the windows servers.
Basically the hosts file is the first place that the system looks for DNS entries. If it does not find one then it queries the DNS server and if that fails the WINS server (if one is listed.) You can either add entries to the hosts file of start the wins client on the Linux servers.

Depending on your configuration you set up wins something along these lines.

To enable WINS resolution in Ubuntu, do the following:

Edit the /etc/nsswitch.conf file, and change this line:

hosts: files dns

to this:

hosts: files wins dns

Then do a sudo aptitude install winbind to install winbind, and everything should work like a charm.

A quick and dirty way to have the two local computers find the linux boxes would be to add entries in the hosts file on the windows systems. Windows uses a file normally located at

C:\windows\system32\drivers\etc\hosts

This is the windows equivalent of the /etc/hosts file on Linux systems. On my systems at home I have added a link to a testing server I run and the file looks like this:

# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
#      102.54.94.97     rhino.acme.com          # source server
#       38.25.63.10     x.acme.com              # x client host
# localhost name resolution is handled within DNS itself.

127.0.0.1    localhost
#         Any other entries you had go here (new line no # no space);  

192.168.0.2   srvr4   srvr4.txlinux.com

Normal syntax for the file is:

IP Address <TAB> short_name <TAB> Fully qualified Domain Name

You can then get to the server by putting either the short_name or the full name in your Navigation or Location area:

http://srvr4/page1.html
or
http://srvr4.txlinux.com/page1.html

Hello,

Two things:
You can use Partition Magic to re-size the partition on the drive to 250 GB.
Yes you can plug the laptop SATA into your desktop I do it all of the time. The power and cable pin-outs are the same.

Hello,

I would try running nmap against your server and take a look at this site for some suggestions on security settings to use.
http://www.tldp.org/HOWTO/Security-HOWTO/

I see a couple of problems with the way you set up your data for the database. In several cases the end date is prior to the start date. The table assumes that the start and end date are not null and in many applications they can be, or at least the end date can be. Or the software should be checking when an end date is entered that it is greater than the start date or reject it.

Also when you set the variables for the dates to check against you need to add 00:00:00 (12:00AM) to the start date and 23:59:59 (11:59PM)to the end date (or add one day to the end date and 00:00:00 (12:00AM) and say less than).

Hello,

Yes. If the processor gets to hot the PC should turn off rather than fry the CPU. Without the fan the CPU will cook and have to be replaced within 60 seconds, less time on newer processors.

Check your network card configuration and see what DNS or name servers you are querying for the information.
You can always try adding a public name server (like the one at 4.2.2.2) to your DNS list as a third server to check with.

Most CPU's have a maximum temperature that they can operate at before they fry. Usually it is around 80 to 90 degrees Celsius which is 10 to 20 degrees below the boiling point of water (100 degrees Celsius). So the answer is it would not work,

hello,

The first thing I can see looking at the report is that you have two different speed and size chips in the system. Based on what it says you have one 256MB PC-3200 200MHz chip and one 1024MB PC-2100 133MHz chip. The system will slow down to the speed of the slowest chip installed which in this case is the PC-2100. Although you only have one processor so it is not as important, however normally it is best to install the same size and speed chips in each pair of sockets (i.e. 2 ea 1024MB PC-2100 for 2048MB total or 2 ea 256MB PC-3200 for 512MB total). Since your system is seeing the PC-3200 I am willing to bet that it is designed to run at the higher 200MHz speed. Personally I would purchase a 1024MB PC-3200 DDR chip from your nearest retailer and replace the PC-2100. I would be willing to be you notice a speed increase.

As far as fixing the wrong values reported by BIOS error. When you install the new memory the system should detect the change and update the BIOS. I am willing to bet that the error is coming from the 200MHz chip only running at 133MHz because of the other chips speed.

Hello,

have you tried a different cable and did you check both ends for a link light?

Double check the port you are going to on the hub/switch/router.

Internal NIC may be blown.

Hello,

A few things to check.

Have you moved the router to a new location? It should be kept high off the floor because the high frequency signal can interfere with its self if close to a reflective surface (concrete floor or FireWall).

Is the modem hot? Usually when they they fail it is due to an internal circuit that overheats and causes problems. It could also be a solder joint that has cracked and when it gets hot expands and breaks the connection. But a hot modem is a sure sign of old age and failure.

Do you have any new electronic equipment in the house (or in your neighbours house) such as cordless phones, Wireless speakers, wi-fi music service, etc. It could be interference from another wireless device. Although you did mention that you changed channels and it did not help.

Hope this helps...

Hello,

No you don;t have to have a separate procedure for each and (sorry hericles) I can think of a hundred reasons to insert into multiple tables from a single record. a simple example would be adding an item to inventory that is a part of another item and you have to create the accounting records at the same time.

But I digress, basically all you have to do is treat each insert as a separate query and then put them together after each one works. Below is a query I used to link an unlimited number or items to other items. It will probably not make a lot of sense since you don't have the original tables but I was all part of a procedure called by the insert trigger. SID (server ID), CID (Customer ID), SLAB (Server Label), RID (Rack ID) were some of the parameters passed into the procedure. SOID was the server Object ID. Trust me you don;t want to know what we did but the example is what you are trying to do.

begin

declare SOID INT;

declare ROID INT;

declare COID INT;

declare PSUOID INT;

declare PSUPOID INT;

declare NICOID INT;

declare NICPOID INT;

insert into objects (`object_type_id`, `device_object_id`, `label`, `date_created`)

values(1 , SID, SLAB, now());

set SOID=Last_Insert_ID();

SELECT ObjIDClient.object_auto_id

FROM ObjIDClient

WHERE ObjIDClient.client_id = CID into COID;

SELECT ObjIDRack.object_auto_id

FROM ObjIDRack

WHERE ObjIDRack.rack_id =  RID into ROID;

insert into objects (`object_type_id`, `device_object_id`, `label`, `date_created`)

values(26 , 0, 'PSU', now());

set …

i still maintain that the file you were trying to attach was to large. The error message you posted even tells you this:

The message could not be sent because its size exceeded the server's limit.

There is nothing you can do on your local computer to change the size of the file the server will except. Email error messages are pretty straight forward and this one is a regularly seen error. Either the email server that you transmit your email through or the one at the other end that holds the message till the recipient retrieves it, has a limit to the size of a file you can attach.