Posts by rch1231

Hello,

You would use a desending sort and the LIMIT function to limit your output to the first 7 rows.

select student_id, grade 
from grades 
order by grades desc
limit 7

wrap that inside a query that goes through each student by id and you will have your results.

Dani,

As I see it your problem comes from the fact that both of the routers are using addresses in the 192.168.1.0/24 subnet. It would be easier to solve if say the EA6900 only had IPs in the 192.168.1.2 to 192.168.1.32 range and the E1200 had them in the .33 to .255. If there is some defined cut off then 'we got lots to work with man' and it can be done from the routers with a few static routes. Basically what you looking at is to get data from your workstation on the EA6900 over to the printer on the E1200 we are going to have to either build a bridge between the two routers for the printer traffic or give it a map to follow.

The following site gives a good reference for creating the static routes if the routers are broken down with 2 to 32 on router 1 and 33 to 255 on router 2.
http://www.dd-wrt.com/wiki/index.php/Linking_Subnets_with_Static_Routes

But if all we really need is your workstation (Which I am assuming is Windows if it is Linux then let me know) to be able to send to the printer then we add the following route for the printer to the workstation. We need and administrator command prompt Start, Accessories, then right click and select "run as administrator" (not just cmd in the start box).

First we get a copy of where we are right now

`route print > c:\startingRoute.txt`

You can pull the file up …

Hello,

What video player are you using to view it. Try VLC if you don't have it already should by it properly and plays just about every thing.

Hello,

It depends on what you are trying to do. If you are trying to find out if there are duplicates and how many then this will work:

select name, 
count(name) as NumberOfEntries
from database
group by name
having NumberOfEntries > 1

IF you are trying to find out the id's of the records with more than one entry then that can be done several ways depending on what you really want. Let us know.

Try starting your script like this instead:

USE minecraft;
DROP TABLE IF EXISTS `Users`;
CREATE TABLE `Users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(40) NOT NULL,
`password` varchar(512) NOT NULL,
`accesslevel` int(11) NOT NULL,
`DateCreated` datetime NOT NULL,
`LastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

The question comes down to who owns the directory that you are trying to write the file into. In this case you want it to write the a directory under /home/ankit called csv which probably looks like this:

[root@hpsrvr ~]# ls -lad /home/ankit/csv
drwxr-xr-x 2 ankit ankit 4096 Nov 22  2012 /home/ankit/csv

Now that you know that simply add the mysql user to that group (stored in the /etc/group file) and set the directory permissions to 775. To add the mysql user to the ankit group use:

usermod -a -G ankit mysql
chmod 755 /home/ankit/csv

And it should now look like this:

[root@hpsrvr ~]# ls -lad /home/ankit/csv
drwxrwxr-x 2 ankit ankit 4096 Nov 22  2012 /home/ankit/csv

Let us know how it goes.

I read that wrong and thought you were having trouble with the debian installation. But I still come back to how are you starting mysql. Make sure that you run the startup script for XAMP as the adminstrator ( right click the Icon and sleect "Run as administrator") so that it has the proper permissions to acces the data base files.

Hello,

Based on what you are saying I believe the issue is with how you are starting mysql. You should be using the script which is normally in /etc/init.d to start the database as it sets several variables telling the sysem where to store the data etc.

[root@hpsrvr ~]# ls -la /etc/init.d/mysql
-rwxr-xr-x 1 root root 6305 Apr  9 11:28 /etc/init.d/mysql

and you would start it with something like:

/etc/init.d/mysql start

or

service mysql start

If you are just running the server from the command line then you would see issues like the ones you are describing. NOTE I believe debian uses the same name for the server as the client (both called mysql) where on redhat releases (Red Hat, CentOS, Fedora, etc.) is is called mysqld ( for mysql daemon) and you use:

/etc/init.d/mysqld start

or

service mysqld start

Hope I guessed correctl if not can you tel us how you start the server.

Hello,

What you are looking for is called Internet Connection Sharing by Microsoft and requires that you have two network connections (one wired and one wireless for example).
In windows 7 you got to Network and sharing center then click on Local Internet Connection (or what ever your primary network device is called) and Windows will bring up the Local Internet Connection Status diaog box. Click Properties on the bottom left. When the Local Internet Connection Properties Dialog box comes up click the right tab at the top labeled Sharing. You will see the option to allow other users to connect to the internet through this computer.

Once you turn that option on it will set up so other computers can connect using your computer as the router.

Normally what you do for womething like this is to setup a php file with the variables in it you need for every php script (for example vars.php). Then in each of the the php scripts on one of the lines before you attempt to use any of the variables you put:

include 'vars.php';

Here ios a link to a web site that discusses the use of include:

http://www.php.net/manual/en/function.include.php

Yes and you can include java in your php code.

The web site is fine I would be willing to bet it is your internet connection. The site came all the way up on my system in less than 10 seconds. You do have a lot of content to load so the 10 seconds is relative. I would check the speed at which the system you are trying to look at the site with connects to the internet. Try one of the speed test sites.

Hello,

You don't have to install it if you just want to try it our there are several live CD's you can download. The Live CD will boot up in your computer and run Linux without killing your current Windows system but just remember it runs slow from CD and it will run a lot faster if installed on the hard drive.

There are several ASUS laptops that have memory built in and a slot to add memory. I would go to their web site and look up the model number and see what it comes with. To help diagnose problems we really need to know a little more such as the OS. The 0x000000C5 stop error (bsod) indicates a problem with the device drivers. A faulty driver that's acting up or a recent driver update that is incompatible. Try boot into safe mode.

Hello,

Backup your data files for mysql and XAMPP and then uninstall XAMPP and then reinstall it.

reinstall mysql

Works fine for me and I am running fedora 20 on my laptop. What happens?

Hello,

Here is a site that gives good data on what you are looking for.
http://www.aelius.com/njh/subnet_sheet.html

I think the issue is the || try this:

WHERE s.Companyname='tester' and st.state='karnataka'

Hello,

Option 1
How about a little reverse logic and using a sub-query. Run a query that select all unique student id's that do have a course registration in the time frame and then select all students not in that list.

select * 
from student 
where student_id not in (select 
distinct student_id from students 
where course in last 3 semesters)

Option 2
Use what patric suggested but instead of

and courses.id IS NULL 

use

having course.id is null

try just

sudo yum update

If there is a new version of yum it will be updated with the rest.

Hello,

There is not really a list of available domain names because a domain name can be any combination of characters that you want. You could use abc123.com or aaaaaa.com and nobody keeps a list of domains that are available. They do keep lists of domains that are used and there are several ways to query that list. you could use the nslookup command or you could go to any of the Domain name registrars (network solutions, godaddy etc.) and see what is a specific name has been used.

Hello,

The PXE-E61 error is nothing to worry about. PXE is the Pre- eXecution Environment that can be used to boot your computer from the network to load the OS or other system tools straight into memory. If it is failing not long after this then I bet the CMSO battery is dead or dying (possibly the laptop battery itself is the issue). You need to go into setup and set the system time and date and make sure that you see the hard drive properly, then save and exit. Computer will reboot and probably boot from the drive properly.

Hello,

No matter what you do you are going to have to interact with the system in order to observe the activity. For Linux there is a great tool called sysstat which takes snapshots of the system activity peroiditacally and then lets you compile the reports later using sar.

http://www.thegeekstuff.com/2011/03/sar-examples/

Hello,

Based on your comments I would say it is heat related. I have had a few HP laptops over the last decade (Compaq and HP have always made a quality product) and what has probably happened is the heat sync on top of the processor is clogged with dust. You can buy a can of compressed air just about anywhere now a days and I suggest that you blow out the dust (with the computer off or you risk burning out the fan motor) through the vents on the back and sides (sometimes bottom also). Blow it out from both directions and I will bet you see some improvement.

Hello,

That is like asking "How many people will the car hold?" Which car and which manufacturer and it depends on the car and the size of the people. On the RAM it will depend on the motherboard used in the laptop and the memory controller on the board. You have to check the manufacturers specs for each model.

Ok which OS linux or Windows (determines the shell you want to use) and I would use Perl it is designed for sting manipulation.

Hello,

Try INSERT IGNORE in place of INSERT and it will ignore the duplicate key errors.

I would suggest that you go with one of the established CDN services. Why rebuild teh network when they have one already. Edgecast and Amazon are just a couple of companies offering CDN networks. Try this Wiki article for more information:

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

Hello,

Linux has built in scheduler called cron (or crontab) which you can find information on just about anywhere. man cron on any linux system shuld give you the basic manual and if nothing else google man cron and you will get the linix and unix manual pages.
Here is a link to one of many pages on the subject.
http://www.adminschoice.com/crontab-quick-reference/

or if nothing else:

http://lmgtfy.com/?q=how+to+use+crontab+

Hello,

Your problem is going to be most laptops have the processor built in to the mother board and they do not normally have options for upgrading. I have seen very few that will take different chips. If you are going to get a laptop go with the known brands and if you are really going for a bargain then check out pawn shops in the big cities. Sometimes they do not know what they have and you can get something like an i7 cheap because it says Windows 7 on the case and not Windows 8 (I know.... ). The clerk said the i7 (2.5GHz) for $299 was worth less than the core duo (2.5GHz) at $499 because it had Windows 7 and not Windows 8.

As far as the Laptop and what it can handle you are just going to have to check out the manual on line and see what it can take. Hope this helps.

Hello,

As I see it you have two choices:
1. You create a new csv file by substituting all of the single quotes with backslash single quote. If it is Linux you can do this with sed and if it is Windows you can use Wordpad and find-replace (you could use notepad but does not work well on large files) or you can script it with powershell.

2 Use Excel to read the file and then save it as a new csv. Excel will put double quotes around any fields cantaining single quotes.

Hello,

This is about like saying "My car won't start." It tells us nothing about what happens when you try to start the computer.

Does it start to post?
Do you see any messages on the screen?
What lights come on on the laptop?
what happens if you plug it into an external monitor?
Are there any erors?

You are the eyes and ears for us to be able to help you.

Hello,

I am not sure if I will get this right but here is what I believe they are trying to get you to consider. If you wanted to run a chat room on the internet what would you have to have as far as a system:

1. Network: Fixed location on the internet via DNS and preferrably a fix IP address.
2. Network: Enough bandwidth to handle multiple chats with multiple chat rooms.
3. OS: Enough drive space to allow storage and chat session information.
4. Network: Security for the system and protection from hackers(firewall).
5. OS: Powerfull enogh server to handle multiple chats.
6. OS: Chat web site or interface for clients.
7. OS: Security for the chats and registration protection like captcha.
8. Network: Port to run chat on.
9. OS: Database to hold user infor, chats and logs.

Again I may have the wrong idea and I amy not be specific enough on the answers but this may get you started.

Hello,

Try the Acer web site as Packard Bell is a Dutch computer manufacturer and a subsidiary of Acer. They may have some docs. Probably an MS-Dos system able to run Windows 3.0 or 3.1 if I remember correctly.

Hello,

One suggestion would be to go into the Computer BIOS setup and see if you can manually set the drive specs (heads, cyl, sectors) instead of using the AUTO settings. How old is the mother board you are trying to connect it to? If it is too old it may not know how to deal with a 2 TB drive an you could try another computer and see what you get.

If it comes up and starts to see the drive correctly use a drive recovery program if you havve one. If not then I would download testdisk and photorec which are programs written by the air force to recover hard drive partitions and data.

Hope that helps.

Hello,

The you need to redirect the output somewhere else which it looks like you are trying to do. Here is a link to a page that cover it very well:
http://www.robvanderwoude.com/battech_redirection.php

Hello,

You probably need an entry in the hosts file (not lmhosts) it is a file in c:\windows\systems32\drivers\etc and it you edit it with notepad MAKE SURE YOU DON'T SAVE IT AS A TEXT FILE. If it has the .txt extension it will not work.

Hello,

Try this instead:

@echo off
REM start of batch file
echo BEFORE
REM wait for them to press a key
pause
echo AFTER

You will notice that the REM lines are not printed as they are remarks

Hello,

What you are seeing here are two partitions both on the first controller and the first disk.
The device naming scheme is:

       /dev/cciss/c0d0         Controller 0, disk 0, whole device
       /dev/cciss/c0d0p1       Controller 0, disk 0, partition 1
       /dev/cciss/c0d0p2       Controller 0, disk 0, partition 2
       /dev/cciss/c0d0p3       Controller 0, disk 0, partition 3

       /dev/cciss/c1d1         Controller 1, disk 1, whole device
       /dev/cciss/c1d1p1       Controller 1, disk 1, partition 1
       /dev/cciss/c1d1p2       Controller 1, disk 1, partition 2
       /dev/cciss/c1d1p3       Controller 1, disk 1, partition 3

Device c0d0p1 is controller 0 disk 0 partition 1 and if you created logical drives with the raid controller you should be seeing a device c0d1 and will need to create partitions on it.

On a separate note you said you were going to use RAID 0 (striping) on the last two drives and make it a NAS storage device. If people are going to be storing important information on that device you had better have good backups. RAID 0 is fast however the big drawback is that because data is split across the two drives, if either drive fails then you lose all of the data on both drives. Why not use all of the drives for one large RAID 5 array and then partition the drives for DATA and NAS. With RAID 5 if one of the drives fails the others know what is missing and the array can be rebuilt and you get the speed of striped data for both your data and NAS storage …

Like I said in the posting it would be added after the domain name
http://<any domain on the server>/support
Basically it says if you receive a domain name with /support after the name then redirect it here...

MySql looks in a set of predefined locations. But you can specify the option file (that's how they call the config file) by using the --defaults-file parameter. Note this parameter has to precede all other parameters at the command line.

More info: http://dev.mysql.com/doc/refman/5.1/en/option-files.html#option-file-options

Normally trying to have two gateways is a bad thing. The gateway s the portal through which the system is to send all traffic that it does not have on the local subnet or a route for. Depending on your operating system I would do a route or route print to find out what routes are set up in the system and see if the problem servers subnet is routed properly.

Depends on the version of Apache but this should work in all of them. You can create a configuration file in /etc/httpd/conf for the site your trying to access when the URL is entered. Below is the configuration file I use to redirect http://<any domain on the server>/support/ to the subdirectory where I have the support application:

[root@hpsrvr conf]# more support.conf
<IfModule mod_alias.c>
Alias /support /var/www/html/support
</IfModule>
<Directory /var/www/html/support >
   Options None
   Order allow,deny
   allow from all
</Directory>

Once you have the support.conf file (or what ever you call yours) you then add a line to the bottom of the httpd.conf file that reads:

Include /etc/httpd/conf/support.conf

You can either create one master fiel to add all of yor special configurations in or create a separate file for each project.

Hello,

I would take a look at a couple of things.
First what type of field are you storing the date in? It should be a Date or Datetime field if it is just a text or varchar field then that is your issue.
Second, What is the format of the date that is stored in your field? Make your test against a field with the same format (YYYY/MM/DD hh:mm:ss).

If nothing else give us the definition of your table and a couple lines of output that includes the DateDeleted and at least one record with DateDeleted has data.

Hello,

Then it has to be something in the browser. Either it is set for a proxy server or you don't have the LAN connection setup under Internet Options.

By the way on the earlier post where you were getting non authoritative answer when you do the NS Lookup that will always be the casse unless you query the nameserver that actually controls an IP address. For example ns2.google.com is one of the nameservers that are the authority for google.com.

[root@hpsrvr ~]# whois google.com
[Querying whois.verisign-grs.com]
[Redirected to whois.markmonitor.com]
[Querying whois.markmonitor.com]
[whois.markmonitor.com]
Domain Name: google.com
.
.
.
Tech Fax Ext:
Tech Email: dns-admin@google.com
Name Server: ns2.google.com
Name Server: ns4.google.com
Name Server: ns1.google.com
Name Server: ns3.google.com

If you query one of them you get:

[root@hpsrvr ~]# nslookup google.com ns2.google.com
Server:         ns2.google.com
Address:        216.239.34.10#53

Name:   google.com
Address: 74.125.225.103
Name:   google.com
Address: 74.125.225.110

Normally I try to limit the nameservers I query to 2 or 3 and include 4.2.2.2 as the second.

Finally I would check to see if the following file has any bad entries in it. Open Notepad and then select file open and put in the following location:

c:\windows\system32\drivers\etc
Once in that directory at the bottom right of the Open File box change the FIle Type to All FIles and you should see a file called hosts and it should look something like this:

# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP …

I would check to see if you can ping your DNS servers. You can also view all of the Network settings with ipconfig. You said you can get to sites by ip what happens when you do a nslookup from a command prompt. It whould tell you which DNS server it is connecting to if nothing else. Try setting your secondary Name server to one of the public names servers like 4.2.2.2.

Hello,

The most important issue I am aware of is the speed at which you burned the DVD. Over the past 20 years working with CD's and DVD's I have found it best to burn the disk at the slowest speed available and I normally shoot for 4x or 8x if available. If recording at 4x does not make it readable in other systems then what you may have is a mis-aligned laser head. You can spend the time and effort to repair it or with the prices what they are I would simply buy a new drive. But again when it comes time to burn the disk slow is better.

You have to tell the server which database to use to create the table. Add the following in front of your sql code:

USE project_infracom;

if that does not work try creating the database as the first line:

CREATE database project_infracom;

You can't really get the port speed of their system without logging into the system in question. You can check to see how well they respond to internet requests and the path between you. Look into MTR (aka WINMTR) which uses trace route and ping to give a server to server route evaluation.

http://en.wikipedia.org/wiki/MTR_%28software%29