Posts by rch1231

hi guys, does anyone can recommend a freeware or any tools to recover a raw hdd drive. The system was suddenly corrupted, hdd can still be detected and shown on my computer but upon clicking on the icon it's asking me to "Reformat my hdd".

Hello,

If this is a one time thing and I suggest downloading UBCD for windows. It is a bootable CD that has partition and file recovery tools available from the system after it boots.

If the data is critical look into photo-rec and testdisk which are free or purchase and R-Studio and their applications.

Hi
I tried the example code and the script still manages to display incorrectly.

The modified code looks like this.

 for( n=21; n<=26; n++ )
         { 
          printf "%-8s %-10s %6s\t %10.2f\n", lname[n]", ", fname[n],
    position[n], TotalSales[n] | "sort -n -k 3"
           } 

The output is the following:

Lazy Acres, Inc.
2009 Sales Associates Ranking
Name                Position    Sales Amount
============================================

Buck,    Fast       Stock Boy       2630.78
Doe,     John       Clerk            134.01
Lindon,  Rosemary   Producer          31.00
Miller,  Dennis     Commedian          9.90
Rush,    George     Salesman        1049.79
Worker,  Susan      Manager          360.00

end quote.

By default sort uses white space (any space or tab) to separate fields so -k 3 would sort Stock, Clerk, Producer, etc. Is it possible to move the column you want to sort to the front of the list?

The other thing I just noticed is that you are running the sort on each individual line. AWK is parsing the file one record at a time and by piping inside awk you are only sorting the current record. Your could try sorting the output before you pass it to awk or put the sort outside the for loop.

I have a desktop i am trying to get it connected with wireless adapter. iam able to configure wireless connection settings. once it connects it keeps dropping the wireless connection and connects back in few mins , this happens for ever.

i have other laptops that are connected to internet through the same router. i am able to connect to internet thru wired on the same router for that desktop.

after connecting (with connections dropping) wirelessly the desktop does not have a ip address , not sure what is the issue.....any help will be big help

Hello,

I have seen this type of activity before when the wireless is getting interference from other devices or even the adapter it's self. If you have a cordless phone move it away from the computer having problems or unplug it and see if the problem goes away. The other thing is that the wireless signal is a very high frequency and if the system is close to the ground floor (cement foundation) it can cause interference with it's self by reflecting off the floor.

If the router is near by then use the wire instead of wireless. Wire max speed with good signal is 54Mb and wire is 100Mb and has no interference. Just a suggestion.

A new site that I have to work with requires me to use putty to connect to the site if I want to work remotely as opposed to logging in to their phpMyAdmin to manipulate my data..
I am unfamiliar; please read that has having no knowledge of how to do this.
So far, from my reading, I have collected the tools to do this, but I do not know how to integrate the tools to get this to work and that is the reason for this email.
I have Putty and HeidiSQL and apparently HeidiSQL has Plink which appears to be of value, but once again I am unclear how to use this.
Given all of the above, can someone point me to a tutorial, an existing series of notes or give me notes on how to run these applications so I can see and manipulate my data on my new hosting service?
Thanks!
WBR

Attached is a doc I worked up on how to use ssh tunnel to connect to mysql with putty..

This site will explain it all...

http://www.winnpsb.org/tutorials/rj45/default.htm

Hello,

The problem is you are not telling sort which column to sort off of. By default is uses the first column. The -k flag in sort tells it what field to use for the sort and the = t flag tells it the separator. You could try:

sort -n  -t - -k 3

You may have trouble with the - as the separator so you could substitute : to separate the info and then replace it with sed afterward.

Is it possible to use PHP and a mysql query combined to allow a whole database backup file to be downloaded?

For example, I'm currently backup up my database by using the export tool in phpmyadmin, but what if I wanted to add a button or link on my site which would essentially allow me to do the same thing?

The backup has to appear as an SQL file btw

Hello,

If you follow the normal standards for config files for php something like this should work.

Source code : config.php , opendb.php, backitup.php

<?php
// This is an example of config.php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';
$dbname = 'phpcake';
?>

<?php
// This is an example opendb.php
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');
mysql_select_db($dbname);
?>

<?php
// This is an example of backitup.php
include 'config.php';
include 'opendb.php';

$backupFile = $dbname . date("Y-m-d-H-i-s") . '.gz';
$command = "mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname | gzip > $backupFile";
system($command);
include 'closedb.php';
?>

Log onto the server and look at the MySQL and httpd logs they will tell you why the import and/or web page is not working correctly.

Hello,

Attached is a table of netmask based on the network selected.

Hello,

I think the problem is that is installation disk is trying to create a separate recovery partition and you have allocated the entire disk to the primary partition. Try leaving 15GB of space unallocated when your are installing XP and see if it works.

I am attaching a word document I put together with screen snapshots on how to connect to MySQL on a remote server using putty. I hope it helps those of you how have questions.

Try removing the foreign key, import the data and then re-create the foreign key and you should be fine. Most of the export/imports scripts I have seen import all of the data first then create the keys at the very end.

Hello,

Quick suggestions are: Create a view instead of a query and make sure you have indexes on the fields you are linking the tables with.

Hello,

Unless I am mistaken all you need to do is forward port 8080 to port 80 via your router and Apache will see the request coming in on port 80. Great thing about linux is there is a log for everything. Go look at the httpd logs (error probably is the one you want) and it will tell you where it failed.

I usually see that when I have not installed the protocol that Windows needs to be able to communicate between systems. IF you go to Open Network Connections, right click the adapter and click "Properties". When the Dialog box opens look in "This connection uses the following items:" to see if "NWLink IPX/SPX NETBIOS Compatible Transport " is installed. If not Click Install, and select Protocol and install it. Even if it does not prompt you it is a good idea to reboot afterward.

First thing I can think of is to make sure that your wireless transmitters are located at least 6 feet above the ground floor. Wireless uses a very high frequency and will interfere with it's self if the transmitters are near the floor.

Check your netmask and gateway settings. Can you provide the IP setup (IP address, Netmask, gateway) for both? I cna tell you more with that info.

Hello,

There are several ways to answer that and it is yes and no.

No windows based application will not work under Linux however there are version available for Linux in some cases that work the same. If not there is probably a free version of an application that performs the same function. For example Open Office is a replacement for Microsoft office and runs on Windows, OS X (Mac's version of Linux) and most Linux distributions.

The yes part comes from running a virtual system with windows installed under Linux. But that can be slow if you don't have multiple processors and a large amount of memory to use.

Download the free version of Mal-ware Bytes and install and run it in safe mode till you get not more infections showing up.

http://www.malwarebytes.org/

thanks for your response.

how would i fit this into my current attempt?

the idea is that i want to display all the due dates that week from my tables and all the ones past their due dates display for that table.

thank you again

OK. I am making a couple of assumptions:
1) Your running this on Monday for the upcoming week.
2) You want all records from Insurance table and Mortgage table where the Due date is from Monday through the next Sunday. And you want the info from the clients table joined to the Insurance and Mortgage tables output.

I see two main queries:
One each for Insurance and Mortgage that are joined to clients. One to get this weeks due and the unpaid for each of the tables.
The Insurance table query could look something like this:

SELECT 
`Insurance Table`.`PolicyNumber`
`Insurance Table`.`Provider`
`Insurance Table`.`DueDate`
`Insurance Table`.`DatePaid`
`Insurance Table`.`Archived`
`Client Table`.`ClientID`
`Client Table`.`FirstName`
`Client Table`.`LastName`
`Client Table`.`DOB`
FROM `Insurance Table` INNER JOIN `Clients Table` ON `Insurance Table`.`Clients_clientID` = `Clients Table`.`Clients_clientID`
WHERE (`Insurance Table`.`DueDate` >= CURRENT_DATE()
AND `Insurance Table`.`DueDate` <= (DATE_ADD(CURRENT_DATE(),INTERVAL 7 DAY))
) OR (
`Insurance Table`.`DueDate` <= CURRENT_DATE()
AND 
(`Insurance Table`.`DatePaid` is null 
OR `Insurance Table`.`DatePaid`= '') )

Does that make sense?

IT Prof. please help me..! I have encountered a problem regarding my ANTI-VIRUS...
My Anti-virus is "AVIRA", and it keeps detecting a Virus that is said to be a "BACKDOOR"...
It infected the explorer.exe.
Whenever I open any folder, it will appear...And also if I will Move it to quarantine, it will not be removed...
Please help me!

This is the actual message of avira when it detects the said virus...

http://www.mediafire.com/i/?hzmbdibgnij

Best Regards....

Hello,

I checked out the link you provided and the first think that I noticed was the path for the file was "c:\WINDOWS.0\EXPLORER.EXE
" instead of "C:\WINDOWS\EXPLORER.EXE". Is your copy of windows installed in C:\WINDOWS.0 ? It could be and if so then try booting to "safe mode with command prompt" and deleting the explorer.exe file and replace it with a copy from your install CD.

Hello,

I think what you are looking for is a way to calculate today plus or minus X number of days. If so this should help:

If you have a reference date and want to calculate another date from it that differs by a known interval, the problem generally can be solved by basic date arithmetic using DATE_ADD( ) and DATE_SUB( ).

The following is an example of calculating new dates from a date based on intervals:

mysql> SET @d = '2003-08-06';
mysql> SELECT @d AS 'start date',
-> DATE_ADD(@d,INTERVAL 7 DAY) AS '1 week',
-> DATE_ADD(@d,INTERVAL 1 MONTH) AS '1 month',
-> DATE_ADD(@d,INTERVAL 3 MONTH) AS '3 months',
-> DATE_ADD(@d,INTERVAL 6 MONTH) AS '6 months';
+------------+------------+------------+------------+------------+
| start date | 1 week | 1 month | 3 months | 6 months |
+------------+------------+------------+------------+------------+
| 2003-08-06 | 2003-08-13 | 2003-09-06 | 2003-11-06 | 2004-02-06 |
+------------+------------+------------+------------+------------+

I think there is more to what you want to do just increment the date but I think this will head you in the right direction. If yo can be a little more specific on the result we may have some oter ideas.

Ok then use WINRAR or WINZIP or 7-Zip and open the file like it was simply a zip file.

Hello,

I found a Microsoft doc that references what happened to you and they have an application and procedure to correct it.

http://support.microsoft.com/kb/314060
Your CD drive or DVD drive is missing or is not recognized by Windows or other programs.

Hello,

The best advice is "Look at the logs". Check and see what your httpd access and error logs show for the request. That will point you in the right direction to solve it.

Hello,

You problem is you need an AS entry to rename the variables. Try this:

select team , sum(points)
from (
select hometeam as team, sum(homepoints) as points
from fixtures
where competitionname = 'prem'
group by hometeam
union
select awayteam as team, sum(awaypoints) as points
from fixtures
where competitionname = 'prem'
group by awayteam
) tmp
group by team

Ok try this.

Before you do anything remember it could be a blown network card and if you have another one handy replace the card.

But if not...
Uninstall the device from device manager. Power the computer off and pull the plug. Wait for at least a minute plug the system back in and let it boot and attempt to install automatically. IF you try to install without the power off it uses the entry it had for the device which we know is incorrect.

If that fails go to the manufacturers web site and down load the correct driver, delete the device and then run the setup for the driver to install it. It will probably not find the device but will unpack the driver files somewhere you can get to them (C:\swsetup\). Run the hardware installation wizard and tell it you will select the driver to install and use the "Have disk" option to install the driver specifically for the adapter the manufacturer says is in the system.

A while back someone suggested having, as part of your antimalware arsenal, some app that could be installed on a flash drive which could supposedly detect any spyware / malware on whatever computer the flash drive was plugged into. (I think the app was DOS-based, and it could work even if the system was severely compromised, although I'm not sure about those two points.) Could anybody tell me about this app? And would it detect a key logger?

Edit: Sorry, this should have been posted in the viruses & spyware forum.

Hello,

Check out the following site. It lets you create a bootable CD or USB drive with multiple applications for repairing windows. Make sure you update the various applications definitions before you create the ISO. The update options are available under Plugins and are listed next to the application as <CONFIG- to update> if it can be updated.

http://www.ubcd4win.com/

Hello,

Check and see if "NWLink IPX/SPX, NetBIOS.... " protocol is installed under the properties of the Network card. If not then install it and reboot.

So did it work OK? Looks like it should have.

Hello,

I would try booting from another disk and attempting to clean out the VIRUS. Something like Ultimate Boot CD for windows will let you create a boot disk with anti-virus and/or anti-spyware on it. If you just need an ISO that will work email me and I will tell you where to download one of my server.

<snip>

Try right clicking the file and selecting Extract. Usually they will extract just fine without being executed. Also try replacing all but the last period with underscore (_) and see if that fixes it.
Right click on the file and select properties. Then look at the lines "Type of File" (should be application) and if there is one the "Opens With" options show.

Hello,

Just a few ideas off the top of my head. Do they show up under Disk Manager (Control Panel, Administrative tools, Computer Management)?

Do they show up in the Computer setup (CMOS) and is the controller for them enabled?

You can try the procedure at the following link to show you hidden devices in Device Manager:

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

and see if they have been disabled for this user profile.

Try disconnecting the cable to the secondary (slave) drive and see if the primary returns.

hi
can you help me with this
i have a network of 3 routers
he number of hosts on each network
Net1 60
Net2 90
Net3 60
Net4 30
Net5 60
Net6 128

there are 6 Pcs

how can i calculate the subnet mask and knowing the subnet ,default getway,,,

ID # Bits Number Hosts Usable Hosts Netmask Note
6 /6 67108864 67108862 252.0.0.0
7 /7 33554432 33554430 254.0.0.0
8 /8 16777216 16777214 255.0.0.0 Class A Network
9 /9 8388608 8388606 255.128.0.0
10 /10 4194304 4194302 255.192.0.0
11 /11 2097152 2097150 255.224.0.0
12 /12 1048576 1048574 255.240.0.0
13 /13 524288 524286 255.248.0.0
14 /14 262144 262142 255.252.0.0
15 /15 131072 131070 255.254.0.0
16 /16 65536 65534 255.255.0.0 Class B Network
17 /17 32768 32766 255.255.128.0
18 /18 16384 16382 255.255.192.0
19 /19 8192 8190 255.255.224.0
20 /20 4096 4094 255.255.240.0
21 /21 2048 2046 255.255.248.0
22 /22 1024 1022 255.255.252.0
23 /23 512 510 255.255.254.0
24 /24 256 254 255.255.255.0 Class C Network
25 /25 128 126 255.255.255.128
26 /26 64 62 255.255.255.192
27 /27 …

Hello,

First the security problem... Do you realize that by adding apache to the sudoers file you are giving any user from the web rights to be root on your server?

The sudo problem... Sudo normally prompts for the users password the first time it is run for that user from a new shell and any time longer than five minutes since it last ran a command for that user in that shell.

what do you get if you run the restart.sh script from the command line? If nothing slse when you are logged in as root do:

su - apache

and you will become the apache user then see what it takes to get the restart.sh script running. Probably apache does not have the service command in it's search path so cannot execute it. You would have to have:

#!/bin/bash
/sbin/service nagios restart

in your restart.sh script

Hello,

What you need to use is CONCAT to merge the information as you put it into the field. Something like:

INSERT INTO newtable ( ID, newfield, otherfield )
select  ID, 
CONCAT('Location_or_Path' , oldtable.oldfield ),
otherfield 
FROM oldtable

I looked at the code at the URL listed and the problem is on line 8 there is no closing ` on the variable name:

`sizelimit BIGINT,

The other problem you are going to run into is that you are using reserved words (variable types ) as field names. timestamp and text are both variable types. You might use creation_date and text1 instead.

Hello,

Your problem is you are really trying to do two different queries and get the results in one output. To do that you need to run the selects separately and then use UNION to merge the results. Something like:

SELECT * FROM table1 INNER JOIN table2 ON table1.ID = table2.ID WHERE table1.someotherfield='a'
UNION
SELECT * FROM table1 INNER JOIN table3 ON table1.ID = table3.ID WHERE table1.someotherfield='b'

see how that does.

Hello,

You need to install net framework. Free download from Microsoft or should be on your SQL server disk.

Hello,

Try hooking up an external monitor and see if it works. Most HP laptops have a key sequence to switch to an external monitor. Usually <Fn> <F4> but could be different. Does it show hard drive activivty?

Try Malware Bytes at the following locaton. Does a good job of removing spyware.

http://www.malwarebytes.org/

There has to be at least one partition to install the software on. Even if you used the entire drive it is still the primary partition. Check under Control Panel, Administrative Tools, Computer Management then Disk Manager and it will probably tell you what is wrong as it starts. Glad I as able to help a little. Good luck.

The results will be based on where you are connecting to for the test. Try

http://speakeasy.net/speedtest

It will give you options for various major cities. Try one close and one far away. Remember the packets still have to compete with all of the other traffic on the internet.

Hello,

Can you connect with the wireless not far from the router without the cable? It may be that your router has security options and you need the security key. Check in your routers settings and see if there is a WEP key or tell us what options are selected in the router under wireless.

Hello,

RAID (Redundant Array of Independent Disks) is used to either speed up access to the data or prevent loss of data if one of your hard drives fails. RAID 1 is mirroring where one or more disks are mirrored to another set of identical disks. If you set up two disks in a RAID 1 configuration and one of the dries fails the other drive takes over as the primary and you replace the defective drive and the system automatically re-mirrors the new drive. Look at this web sie for a better description:

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

Look into BartPE. It will let you make a windows installation using your current configuration.

Hello,

Ok without looking at it here is what I can think of. The first thing I can think of is to check the power switch and reset switch connections from the front panel and make sure they are on the right pair of pins. Next, did you ever run the CPU without a heat-sink and did you put the conductive paste between the heat-sink and the CPU? If not you may have toasted the CPU.
Next check to make sure the CMOS jumper and battery are in correctly (sometimes the factory sets the CMOS to clear or tapes the battery to prevent draining the battery till you use it. Next disconnect/remove every thing (hard drives, CD ROM, USB ports, remove any expansion cards) but the speaker and the video and see if it boots without them. Lastly if you are using IDE drives with the ribbon cable make sure that it is right side up on both ends. Many systems will not boot with the cable upside down.

Check and see if you have option 'Allow Indexing Service to index this drive for faster file searching' set for the external drive (under properties for the drive). If the system is trying to index the files it would keep it busy for a while. Make sure you don't have any windows open to the drive or applications that are active that have saved to the drive recently(i.e. MS-Word will keep the drive active if you save to it and don't close or go to a different directory to save something else.).

What does it show in the BIOS as the boot hard drive? And is the hard drive an option in the boot order?

If not check to make sure the primary partition is active.

Mirrored means that everything that is written to the first drive is written milliseconds later to the second drive. It is like having a continuous backup that is current up to the second. This way if the first drive fails the second drive is an exact copy. You lose a little speed when writing to the drives due to accessing both drives but you gain in the fact that if a drive fails you have little or no down time.
Using it as a backup disk if your primary drive fails your data is only current up to your last backup. You have to have a new primary drive with the OS installed and then restore the last backup to get your sites running again. That can take a few hours with all of the sites down. If the backup is corrupt or a week old you will have angry clients.