Posts by rch1231

Hello,

Depending on the shell you are running (probably bash) you set the path in your .bash_profile file. The file is in your home directory and you can add to the entries there:

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

Ok a couple of things to try:

Freeze the drive. Thats right put it in the freezer and let it sit over night. sometimes the problem is a bad soder joint or something related to the drive warming up. I usually mount the drive in a USB housing so I can take it from the freezer straight to a system running windows and attempt my recovery.

Try either TESTDISK (and Photorec) or purchase a recovery application. I personally like an application called R-Studio. I purchased the software to do some recoveries with and it has paid for it's self several times over. It is not too expensive and it is one of the recovery tools that will allow you to make an image from the drive and then do the recovery from the image.

You need to install samba on the linux box. Samba is an application on Linux that allow you to share directories with windows.

If I understand correctly you are supposed to write the sql statements that will SELECT the records from the tables shown that meet the requirements listed.

For example the second instruction is to list products rented by both customers 1003 and 1101. I normally break this down into a couple of tasks. First I would find the transactions for the date range from TRXN where the customer IDs match. From there find the Products purchased by both where the TRXN id is in the list above. Then use those product IDs to list the products.

These are complex queries that use sub-queries to generate a subset that you select from later. I suggest that you talk with others in the class or go over your notes closly if the abve does not make sense.

Hello,

Linux is a operating system based on the UNIX operating system developed by Bell Labs (AT&T) in the 1960's. It is faster at file operations and more secure than Microsoft Windows but requires more customization than Microsoft Windows. Most software for Linux in Open Source and available for free. Most web servers that host more than one site run a version of Linux annd the protocols for web traffic are based on the original Unix communication standards.

There are many different versions (referred to as distributions) of Linux available but the most popular for Personal desktop or Laprtop use are Ubunto and Fedora. For server there is the top of the line RED HAT Linux, CentOS, SUSE and several others.

To answer your question I would have to say a Linux box is a server that requires very little maintenance when properly configured. The company I work for has 2 Linux techs that are primarly available for configuration questions and building new servers. Compare this to the 8 Windows techs and 6 Exchange techs that are always trying to fix some bug or problem with Microsoft Products.

The error you are getting implies that you are trying to boot from the network instead of running from a CD. PXE is the pre execution environment. Look up PXE Boot.

To work a query like this you have to first select and group the data (name and averages) and then use the HAVING option to select only the entries you want from the selected results. It is not exact but should look something like this:

select 
Person.Name,
Avg(Score.Marks) as Average_Score
from Person 
inner join Score on Person.ID = Score.ID
group by Person.Name
Having Average_score < 3.5

Hello,

If you are trying to use the wired connection then make sure you turn off your wireless adapter. The system will not know which one to use and will stop sending and receiving on the netowrk.
If your having problems with the router then if nothing else try resetting the router to factory defaults and then connecting and entering your connection information again. Make sure if you have a user name set to connect you to your ISP that you know what that is before you reset the router. To reset most routers to original factory (out-of-the-box) settings you press and hold the reset button for 30 seconds.

Hello,
Try this:

    $sql = 'SELECT A.id, A.colA1, A.colA2, B.colB1, B.colB2 FROM
    A LEFT JOIN B ON
    A.id=B.id 
    where A.id IN(1,2,3,4,5)';

the registration for the site has expired:
[root@cwsvr02 ~]# whois simplywriting.co.uk
[Querying whois.nic.uk]
[whois.nic.uk]

Domain name:
    simplywriting.co.uk

Registrant:
    Eddie French

Trading as:
    Edward French

Registrant type:
    UK Individual

Registrant's address:
    The registrant is a non-trading individual who has opted to have their
    address omitted from the WHOIS service.

Registrar:
    Dollamore Ltd t/a StreamlineNet [Tag = STREAMLINENET]
    URL: http://www.streamline.net

Relevant dates:
    Registered on: 13-Aug-2004
    Expiry date:  13-Aug-2012
    Last updated:  27-Jul-2011

Registration status:
    Renewal required.
    *** This registration has been SUSPENDED. ***

Name servers:
    ns1.streamlinedns.co.uk   213.171.208.13
    ns2.streamlinedns.co.uk   213.171.212.13

WHOIS lookup made at 00:44:31 16-Sep-2012

--
This WHOIS information is provided for free by Nominet UK the central registry
for .uk domain names. This information and the .uk WHOIS are:

Copyright Nominet UK 1996 - 2012.

You may not access the .uk WHOIS or use any data from it except as permitted
by the terms of use available in full at http://www.nominet.org.uk/whois, which
includes restrictions on: (A) use of the data for advertising, or its
repackaging, recompilation, redistribution or reuse (B) obscuring, removing
or hiding any or all of this notice and (C) exceeding query rate or volume
limits. The data is provided on an 'as-is' basis and may lag behind the
register. Access may be withdrawn or restricted at any time.

I would do it before it gets to sql if I were you with perl (Linux or Windows) or VB (Windows). Perl has a split function that will parse the data based on a delimiter you supply. VB could do it several ways also. You can then use PERL or VB to import the data straight into the database.

It is easy in Excel. Select the column with the data in it and make sure that the columns to the right of it are empty. Then under Data use the option for text to columns, select delimited text and select other and put the pipe for the delimiter. If you have empty columns make sure that the box is unchecked for "Treat multiple delimiters as one"

Does the video card require a separate power connection. Some of the newer cards have a 4 or 6 pin connection at the end of the card opposite the video connectors. They need the extra power to operate.
I am assuming that when you turn it on the fans start to spin etc. ??

Hello,
SOmething like this should give you the number of times each value shows up with the value and number of times it was seen. Then just select the first row with Limit 1.

select 
data1.my_value
sum(my_counter)
from
(select
numb_1 as my_value,
1 as my_counter 
from 
mytable
union
select
numb_2 as my_value,
1 as my_counter 
from 
mytable
union
select
numb_3 as my_value,
1 as my_counter 
from 
mytable
) as data1 
group by data1.my_value

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.

Try the query I gave you and I believe it is what you are asking for. The date part was just me trying to limit the orders to specific daytes so you can drop it. DO you want output for a supplier if there are no orders for them? There a 50 different ways you could generate the data just trying to give you the easiest. Which looks easier a for loop like you want to do or the code I gave you. Trust me you will be suprised when you see the results.

Hello,

I think you are trying to run from the wron table. don't run from suppliers run from the table you are trying to get results for. In this case it would be the order_items table. If you run for all supliers then you get supliers with nothing ordered. If you run from order_items then you get all iteems and their supliers. That is what the join does. It links the data in the individual record to a record in the other table. If you change the select I gave you the new output will be sorted by supplier and give one line per product with a total quantity.

Select
Suppliers.supplier_name,
Suppliers.supplier_email,
orderitems.product_id,
orderitems.product_name,
sum(orderitems.product_qty) as quantity
from
orderitems
Inner join orders on orderitems.order_id = orders.order_id
Inner join suppliers on orderitems.supplier_id = suppliers.supplier_id
where
orders.order_date > '01/01/2012' AND
orders.order_date < '02/01/2012'
group by orderitems.product_id
order by orderitems.product_id asc, 
Suppliers.supplier_name asc

Your output should be like this:

supplier_name   supplier_email       product_id    product_name     quantity
Tom             tom@thumb.com        67455         Widget                14    
Tom             tom@thumb.com        67456         Widget Large           4
Victory         orders@victory.com   A5551212      Smoke                100

The only problem I have with using a dual boot system is you can only use one OS at a time. If gaming is one of your main focus points then boot Windows and run Linux virtually. Linux does not require half the memory or processing power that Windows does and can do just fine as a VM. Even the Linux games work great on the VM. I personally run Linux on my laptop and love it although I do have Windows 7 as a VM but not for playing games. Windows as a VM does not always work with the Graphics settings that some new games (starcraft II) need. There are a few applications that I use that are only available for Windows (at this time) or require WINE (Windows emulator). For Games I have a desktop that has WIndows 7 (64 bit) and a 1GB graphics card and a 1TB HD.

Hello,

Generally you put them in a different table in the same database but you do not have to. You can use a different database but you have to establish a connection to that database too. It is easier to connect to one database and make the table only readable for login.

Hello,

You need to check the ports on the router and modem. The moden should go to the cable and have a LAN PORT. The Netgear should have a WAN and several LAN ports. Run a cable from the WAN port on the netgear to the LAN port on the modem.

If that does not help then to trouble shoot this we need a few things:
Can you connect to the netgear from the computer?
Do you get a dhcp address and what is it?
What was the old address of your old router?
What is the LAN IP address of the modem (if it has one) or what is the address of the modem?
Can you plug the modem directly into the computer and have it wrok?

Hello,

I think what you are trying for could look something like this:

Select 
Suppliers.supplier_name,
Suppliers.supplier_email,
orderitems.product_id,
orderitems.product_name,
orderitems.product_qty
from
orderitems
Inner join orders on orderitems.order_id = orders.order_id
Inner join suppliers on orderitems.supplier_id = suppliers.supplier_id 
where 
orders.order_date > '01/01/2012' AND
orders.order_date < '02/01/2012'

What the code does:
The Inner join causes SQL to create a row of output for every record in the orderitems table where there is a record in the suppliers and order table. It joins the suppliers table using the supplier_ID and the orders table using the order_id and only print the records where the order date is between the dates listed. Hope that makes sense...

Ubantu is a good distribution and now a days it is pretty easy to install however when you mentioned gaming it kind of forced the OS back to Windows. Most PC games are Windows based and very few have ported their game to the Linux world. Although many run on the MAC so the transition would not be tough there is just no effort on the part of most game manufacturers.
With that said may I suggest this:
Find a decent system pre-configured at your favorite retailer or online store that includes Windows 7 64 Bit. Once you have the system look in to adding something like Oracle Virtual Box. It is free and runs on Linux, Windows or MAC and will allow you to run Ubantu in a virtual system under windows. You will be able to access Linux via the virtual NIC it will create as if it were another computer on your network. Ubantu will be able to access the internet through your Windows system in much the same manner.
This way you can use all of the power of the system for Gaming and when you need to bring the Virtual Linux system on line for development.

You know I told myself I was not going to comment on this thread again but I just have too now that I have stopped laughing. As if 2TB of ram on laptop was not funny enough to begin with, you forgot to edit and change it from a 32 bit OS ..... and I will bet you don't even know why that is funny.
Good luck with your life and try not to make as big a fool of your self next time.
ROFLMAO

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

The only one whining in any of the posts is you. And the only one claiming that people must use a specific OS is again you... You are entitled to your opinion like every one else, just don't make things up to make your story sound good.

At least I am not limited to one OS by ignorance and bias.

I still am curious, in your post you said

I tried running the same amount of videos on Ubuntu Linux (99)
As you would imagine, Ubuntu is not very good at opening mass videos.
I had sufficient RAM (1TB) and was using an SSD card and had intel i5.
after opening 50 in about 3 minutes (unlike the Windows machine in 2 seconds, as demonstrated in the video I had provided) I got a black terminal window. And then, the laptop died.

Are you now claiming to own a supercomputer like the one sited in the Yahoo article? And a supercomputer laptop with 1TB of RAM I am impressed. I guess we can just expect this claim is as valid as all your others.

So who makes your laptop carrying case?

You said:

No, Linux cannot do that, at all.
I tried running the same amount of videos on Ubuntu Linux (99)
As you would imagine, Ubuntu is not very good at opening mass videos.
I had sufficient RAM (1TB) and was using an SSD card and had intel i5.
after opening 50 in about 3 minutes (unlike the Windows machine in 2 seconds, as demonstrated in the video I had provided) I got a black terminal window. And then, the laptop died.

I want to know how you installed 1TB of RAM.

Here. It is possible

You might try reading the posts that you site. I did and it says that it currently cannot be done. So how did you do it?

Quit being such a snob.

I find it hypocritical of you to call me a snob.

Really! I use both Windows and Linux and know the limits of each. I also only make claims I can back up with facts. Still no answer on the longest uptime for a Windows system with a reboot or crash?

Hello,

If you are using the service instead of NetworkManager then you need to make changes to the /etc/sysconfig/networking-scripts/ifcfg-eth0 file. Change the for boot ( or onboot I never can remember but you will see it) to BOOT=yes from BOOT=no.

Some versions of redhat have an application called setup that can be run while logged in as root that is menu driven and allows you to set the IP address, netmask, gateway etc. and decide if the port is on or off by default.

I want to know how you installed 1TB of RAM. Windows 2008 64bit max ram is 256GB. I can explain to you how Linux in the server roll out runs a Windows server but I can't make you understand it. Quit being such a snob.

By the way still not comment on the uptime question I ask before?

Cool so mark the thread solved already.... LOL

I just read these and Have to add this:

Sure, all that - try gaming on linux, and even harder, try to get it to go faster than 2 fps.
And of course, what happened to Photoshop?
MS SQL, right? You can do that on Linux, cant you? (sarcasm)
I can see how Linux is so, so... great :P

1. Most of your gaming servers are Linux or Unix boxes hosting the on line game.
2. Photoshop under Linux has many names but the first one that comes to mind is GIMP which looks runs and works just like photoshop, AND IS FREE!
3. MySQL is the database of choice for Linux and even microsoft admist that it run circles around MS-SQL Server. Here is technet article which compare the two and says basically "sure mysql is faster but we have features they don't." Click Here And most of those features are to stop windows hacks.

Quit being such a snob about Windows. You remind me of people that said "Stick with your horse those Automobiles are crap."

I use both Windows and Linux on a daily basis. Windows is a great GUI and Linux is a great server. Use the right tool for the job. You can drive a screw in with a hammer but it is not going to look pretty and may fail.

A few comments I just have to make.

1. The simplest reason the Linux/Unix/OSx are so popular is they work constantly for years and years without reboot or issues. I work in a data center where we have a few thousand servers, some on the web and some on private networks not visable to the web. The ratio is about 65% Windows Server to 35% Linux. However in most cases One Linux server does the same job faster that the 2 to 4 Windows servers performing the same task, hence the ratio. Most of our customers using Windows reboot once every week or at least every two weeks to flush the memory and clean up issues. When we do updates to the OS we reboot at the beginning or the process and of course when the updates finish. We constantly monitor all of the servers and most of our support staff spend their time fixing Windows issues.

The Linux servers on the other hand run for years without reboots and rarly have issues requiring attention. We can and regularly do upgrades to the Kernel, upgrade or install software, remove aplications or add drive space all without rebooting the server. We have …

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.

Just read your response. The only way I can see to do that would be to add another directory level to the picture. For example: create /home/useratop/usera and make it thier home directory. Set the permissions on /home/useratop to r-x------ or 500 owned by them . The other users will not be able to get past the first directory level to see the sub dir and then permissions on /home/useratop/usera to 755 they will not be able to give permissions to get to their new home. Make sure to make their home directory in /etc/passwd is set to /home/useratop/usera to set the value for ~

Call their tech support. It could be anythig from the browser you are using to their site is broken. You get what you paid for and if you are trying to get a site for free then I would not count on the support being the greatest.

You can run it one of two ways either by having your script called by php

0,10,20,30,40,50 * * * * /usr/local/php5/bin/php /home/<USER NAME>/path/to/script.php

or by running a text based webpage reader which will run the application for you:

0,10,20,30,40,50 * * * * /usr/bin/links -dump http://mysite.com/support/auto.php

Hello,

What you are asking for is really mutually exclusive. In order for the user to be able to write files and create directories i their home directory they must have write permissions to the directory. What you are saying is "I want the user to be able to write to their directory but not be able to write to their directory." and you can't have it both ways. Like every other switch or bit in a computer it is either on or off not both.

Sorry.

What smantscheff is suggesting is really more like a true sql solution. You store statuses in a seperate table that contains the original table_id, status number so in the first table you have the original information and you join to the second table to find out what statuses are active.
Your statustable would be something like

CREATE TABLE `statustable` (
    `ID` int(11) NOT NULL AUTO_INCREMENT,
    `tablenameid` int(11),
    `status_id` smallint(4),
    PRIMARY KEY (`ID`),
    KEY `tablenameid` (`tablenameid`)
    );

Create a record for each status that the original table was assigned and link them using the original table id

Select * from tablename 
left join statustable on tablename.id = statustable.tablenameid 
and statustable.status in (2,4,5)

would get all vehicles with a status of 2 or 4 or 5.

Hello,

If you are trying to be able to find which vehicles have only one specific status then using like in your where statement will do the trick

where status like 1% 
or
where status like %2%

If you are going to want to be able to find which vehicles have a status of 1 and 3 the I would do one of two things:

1. Have a seperate field for each status and make it 0 or 1 (0 not this status 1 has this status)

   Where status1 = 1 and status3 = 1

2. Make your statuses 2 to the (status-1) power and store the sum (1=1, 2=2, 3=4, 4=8, 5=16, 6=32, 7=64, etc.) Status one only is stored as 1, status one (1) and three (4) are stored as 5 (1+4), one (1) and two (2) are stored as 3 (1+2), 2 (2) and 5 (16) are stored as 18 (2+18). Then your where statement just becomes the sum you are looking for. and finding statuses that contain a specific number (lets say you want all things that have a status of 2 included)

   where status in (2,6,10,18,34,66)
   or for status contains 3 it would be:
   where status in (3,6,11,19,35,67)
   

And finding all vehicles with only a status of 2 and 4 would be:

where status = 10

This may seem a wild way to store the numbers but it is only limited by the size of the integer variable chosen to …

Hello,

I ran into the same thing and here is what you need:
set-executionpolicy remotesigned

Open up a command shell and run that line and you will be able to execute scripts locally without them being signed.

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>

I had the same issue. You need to go to Control Panel and then sound and change the default device to be the headphones. I also found that if I was running VLC I needed to exit VLC and restart after I had made the change to the default device then it was fine.

Yes it is possible but I would not count on it being the fastest thing in the world. 100 is probably a good number but it will depend on how much is being downloaded at a time. Your limit for speed is probably going to be the network connection.
As far as reloading the apache file I normally use

service httpd reload

to reload the config without bringing apache down.

Hello

You are using the syntax for an INSERT statement instead of an UPDATE statement. Update data in mytable1 with data from mytable2 looks like this

UPDATE mytable1, mytable2 
set mytable1.myfield1 = mytable2.myfield1,
mytable1.myfield2 = mytable2.myfield2
where mytable1.item_number = mytable12.gigname

If you are posting from php or some other input then replace the mytable2 references with the variable information and do not fut the table2 entry on the UPDATE line.

Hello,

I see a couple of things that are causing your problem. First of all you are only selecting fields from the child table to be displayed so the join servves no purpose. Try adding a field from the partent table to the output and get the first join providing the results you want then use the HAVING post selection condition to just select the records that meet the second condition:

$getquery = mysql_query("select  child.id as child_ID, 
child.`name`, parent.id as parent_ID, child.position,
child.start, child.pending
from `mytable` child inner join `mytable` parent
on parent.id=child.parentid
where child.start='1' ORDER BY child.id DESC
HAVING pending=1");

Or something along those lines should work.

Hello,

Try a backslash in front of the # sign.

    qw(\#338833 \#33AAAA \#AA33AA  \#AA3333 \#3333AA);

or if that does not work you could add the # sign when you actually use the data and store just:

qw(338833 33AAAA AA33AA AA3333 3333AA);

Well you basically have two choices:
1) Go to the Dell Support Web site and enter the service tag off of the computer and download the driver from them.
2) Go to the intel site and download the driver for the 82801FB Chip set and the AC97 audio controller.

I have to agree with rubberman and mike_2000-17 for most of the same reasons. I run a couple of different Linux systems depending on what I am using it on. For servers on the web I run CentOS and for my laptops and desktops I run Fedora 14. I do run Windows 7 on one desktop that is primarlly for gaming. When I need Windows 7 and Windows Server 2003 I run them on the Linux systems inside Virtual Box by Oracle for applications that are not available for the Linux OS (MS SQL Server, Games, Dataconversion utilities.). Linux provides the firewall and security to keep the Windows systems from being attacked.

One other comment is that Microsoft does have a larger market share in the United States but if you look at systems world wide and what our own government uses on their systems you will find Linux in one flavor or another because it is secure.

Hello,

This may help. You can save an excel file as a CSV (Comma Seperated values) and then use mysqlimport or the load command.

Data files in CSV format contain values that are delimited by commas rather than tabs and that may be quoted with double-quote characters. For example, a CSV file mytbl.txt containing lines that end with carriage return/linefeed pairs can be loaded into mytbl using LOAD DATA:

mysql> LOAD DATA LOCAL INFILE 'mytbl.txt' INTO TABLE mytbl
    -> FIELDS TERMINATED BY ',' ENCLOSED BY '"'
    -> LINES TERMINATED BY '\r\n';

Or like this using mysqlimport:

% mysqlimport --local --lines-terminated-by="\r\n" \
               --fields-terminated-by="," --fields-enclosed-by="\"" \
               cookbook mytbl.txt

Hello,

The having command takes place after the inital query is complete and you need to referr to the fields by the name in the result. try
HAVING Month = " & TextBox2.Text &"
and it should work. If not post the erorr you are getting.

Hello,

The first command you ran (fdisk -l) was perfect for showing the partitions and did give you the information about your drive. The tricky part is you are using some sort of virtual system and not seeing true disks. Your drive (/dev/sda) or device scsi disk a is a 21.5GB Hard disk and is partitioned into 2 partition (sda1 and vg_virtualcomputerelmo ) sda1 is the boot partition and vg_virtualcomputerelmo is a volume group containing 2 logical volumes (root or /, and the swap logical volumes). The commands vgdisplay and lvdisplay will show you the volume group and the logical volumes created in that volume group.