Posts by rch1231

This is not exactly answering your question but I have found it to be an easier method. I use a free zipcode table from the Census I downloaded from http://federalgovernmentzipcodes.us/.

There is a CSV format, xls file and Yes a MySQL dump (The SQL code to do table create and import for you). If on your page ask for the Zip (like a lot of sites do now) instead of the City and State you are dealing with a numerical index instead of a string. You can quickly narrow the list and verify it with the user. Table includes Longitude and Latitude (great for google maps), county, and some other handy data. Table includes various city spellings however the main unique zip code record is indicated by the zprimary='Yes'. I used the data to generate a separate table with zipcode as the primary key and only the zprimary = 'Yes' records and there is really no need to verify the city/State information.

Hope this helps.

My first suggestion in these cases is to see what shows under Network and Sharing Center, View Status, Details. Make sure that you have an IP address in the routers subnet and Name Servers assigned that you can ping and query (from command prompt : nslookup google.com <name-server IP address> ).

If there are no discrepancies then the next thing to try is assign the wireless a static IP address, disable the device, wait 5 seconds then re-enable. See if you get a stable connection then.

Hello,

I am not a guru but pretty well versed in Networking. On average I install 10 to 20 Internet servers per week. Some with multiple networks and others with teamed ports. If you can keep it to a reasonable number of questions I will do my best to provide answers and explainations. Provided they do not appear to be Homework questions pasted into the message. Fair enough?

Your headed in the right direction. Look at the system logs and see what is going on. ls -lart will list files with the most recent entries at the bottom.

How are you connecting to the database server from the application server?

Try "Safe mode with networking" Some of the viruses have missed letting you start in that mode. The only other option is to download something like UBCD4Win (Ultimate Boot CD for Windows on another computer and create a bootable CD Image that you can burn to a CD-ROM. It has Anti-virus and a bunch of other tools to help your get things working again. If you get stuck and don't have another system to download on send me a Private message and I will give you a link to a working copy I created.

It is hard to answer your question without knowing what type of shell you need. What will the script be used for and what will it interact with?
For example a config.inc.php file is sometimes used to set variables for a specific php session.

<?php

/**
 * configuration file
 */


// Database connection info
define("CONN_HOST", "localhost", TRUE);
define("CONN_PORT", 3306, TRUE);
define("CONN_USER", "servicedb", TRUE);
define("CONN_PASS", "nokidding", TRUE);
define("CONN_DB", "Service", TRUE);

What you are trying to do is very easy in any of a hundred different ways depending on the type of script needed. Can you tell us a little more about what you are doing or typing to do?

Read the manual........
Like the rest of us did.

Opps forgot to include this:
http://www.nliteos.com

There is a better way. Download nlite and install it on a system with xp and a copy of the XP install disk in a directory. It will then lead you through creating a custom ISO with the parameters you want including your VLK and user/domain settings. You can also add in Service Packs and hotfixes along with OEM drivers and not have to update each one when done.

The location in the BIOS is different depending on the manufacturer but the quickest fix is to change the boot order so that the floppy is not first in the list. Then you will still be able to use the floppy but stop getting the message. To disable the floppy completely you would disable the Floppy controller and set the drive to disabled instead of 1.44MB 3.5inch .

Can you connect to any site on the web or is this just one server that is a problem?

Hello again,

Well looking at the configuration here is what I would do.

Recap:
SCSI Disk b partition 3 ==>  /dev/sdb3 450G 406G 26G 95% /
SCSI Disk b Partition 2 ==>  Probably Swap space.
SCSI Disk b Partition 1 ==>  /dev/sdb1 99M 17M 78M 18% /boot
SCSI Disk a Partition 1 ==>  /dev/sda1 459G 41G 395G 10% /home2

You have already used 41G on the sda1 partition which is more than the 26G you have available on sdb1.

You have two options depending on what is in /home2. The following steps would need to be done by the user root or with sudo.

OPTION 1: The quick fix.

1) Copy /Backup to /home2/Backup

cp -RP /Backup /home2/
or if you want to monitor the progress.
cp -RPv /Backup /home2/

2) Verify the copy got everything by confirming the directories use the same amount of space. If not find out what is different.

du -s /Backup
du -s /home2/Backup

3) Once you are SURE everything made it run a list command to check you are deleting the right directory then replace the ls with rm :

/bin/ls -R /Backup/*
/bin/rm -R /Backup/*

4) check available disk space

df

5) remove the old /Backup directory now that it is empty and create a link called /Backup that points to /home2/Backup. rmdir will only let you remove an empty directory.

rmdir /Backup
…

Try this web site it gives a good discussion and some good examples.

http://computer.howstuffworks.com/vpn.htm/printable

Hello,

It is all in the redirects you use. > writes over the file if there is one and >> appends to the file.

echo "second line of code" >> \test.bat

A couple of question before I make a suggestion:

What are you actually backing up (which directories)?

What application do you use for the backup (tar, cpio, customer utility, etc.)?

You have 395GB free in /home2. If you data is all in the / directory and so are your backups and the filesystem crashes you would lose both. Why don't you backup to the /home2 partition? If /home2 fills up you would still have room in / so email and your web sites would continue to work.

Hello,

Yes you can put in a higher wattage power supply. The wattage really depends on the devices you are going to run from the power supply. There is a pretty good calculator on the ASUS web site but it is primaryl for theior mother boards but it will give you an idea.

http://support.asus.com/PowerSupplyCalculator/PowerSupplyCalculator_right.aspx

Hello,

You should be able to simply change the document root in the apache configuration to the new location.

<VirtualHost *:80>
    ServerAdmin webmaster@dummy-host.example.com
    DocumentRoot /www/docs/dummy-host.example.com
    ServerName dummy-host.example.com
    ErrorLog logs/dummy-host.example.com-error_log
    CustomLog logs/dummy-host.example.com-access_log common
</VirtualHost>

<VirtualHost *:80>
    ServerAdmin webmaster@dummy-host.example.com
    DocumentRoot /www/docs/dummy-host.example.com/forum
    ServerName dummy-host.example.com
    ErrorLog logs/dummy-host.example.com-error_log
    CustomLog logs/dummy-host.example.com-access_log common
</VirtualHost>

Hello,

I seem to remember one for old MFM or RLL drives but I don't think it worked on IDE drives. Did you google it?

There are a couple of ways to exit a shell directly from the command line either sending an "end of file" which is a <CTRL> d or typing exit. However I think you are referring to closing a specific window you have open on the Desktop. To do that you have to know something unique about the open window and then kill the process has the window open. If you know the name of the application or the image then you could use:

ps aux | grep <info about open window> | grep -v grep

This would show the processes associated with the info you entered. You need the process id, which is the second column, to kill the process. For example if I received the following lines from the grep:

root 23274 0.0 0.1 90744 3196 ? Ss 08:33 0:00 sshd: rod [priv]
rod 23276 0.0 0.0 90744 1680 ? S 08:33 0:00 sshd: rod@pts/1
rod 23277 0.0 0.0 64208 1472 pts/1 Ss 08:33 0:00 -bash
root 23306 0.0 0.0 101252 1300 pts/1 S 08:33 0:00 su -
root 23307 0.0 0.0 64212 1528 pts/1 S 08:33 0:00 -bash

and wanted to kill the bash shell run by rod I would enter the following to kill it:

kill -9 23277

Is that what you are looking for?

You can execute a remote command on another system via ssh. However most smart sysadmins disable remote login as root. You have to connect to the system first then switch to root.

If root access is enabled the ssh command would be:

[rod@srvr4 ~]$ ssh rod@192.168.0.53 ls -la /tmp
The authenticity of host '192.168.0.53 (192.168.0.53)' can't be established.
RSA key fingerprint is 53:58:25:cc:5d:53:41:ed:03:80:47:68:e8:1c:a4:2a.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '192.168.0.53' (RSA) to the list of known hosts.
rod@192.168.0.53's password:
total 144
drwxrwxrwt 26 root root 4096 Jul 4 05:40 .
drwxr-xr-x 30 root root 4096 Jul 3 09:28 ..
srwxrwxrwx 1 clamav clamav 0 Jun 24 02:42 clamd.socket
drwx------ 2 root root 4096 Jun 26 18:39 .exchange-root
drwxrwxrwt 2 root root 4096 Jul 3 09:29 .font-unix
drwx------ 3 rod rod 4096 Jul 2 18:55 gconfd-rod
.
.
.
.

etc.

You would have to supply the password but the key confirmation would only be in the first connection.

Hello,

My suggestion is to grab a copy of wireshark and read the website facts and the manual. You can download and run it for free and it will give you a real look at what goes on with your system ports.

Hello,

Since you put this in the 2000/NT/XP forum I am guessing XP. If it was me I would:

1) Verify the hardware actually in the computer by getting the manufacturers specs and opening the system and getting the models and versions off of the mother board and expansions cards. Definitely double check the expansion cards just in case.

2) Check in Device Manager and confirm that the devices match your list complied in step one. Be sure to turn on hidden devices in case there is a conflict in address ranges.

3) Make sure you also loaded the chip-set drivers for your motherboard. Without them the OS cannot properly communicate with or identify the peripherals.

4) Google each manufacturers web site to confirm there is not a later driver.

Hope this helps.

Well I tried the quick and easy answer. Sorry. How about this:

Start with the basics and work your way up. Double check the cable is plugged in all of the way at both ends. You would be amazed at how many loose cables cause intermittent problems and look like they are properly connected.

What does ifconfig (ipconfig for windows) report?

Can you ping the computers network port?

Can you ping any other systems?

Does this just happen some time or all of the time?

Can you ping the gateway, and each of the nameservers?

Can you query the nameservers like this:

[root@cwsvr02 cur]# nslookup txlinux.com
Server: 66.101.58.2
Address: 66.101.58.2#53

Non-authoritative answer:
Name: txlinux.com
Address: 66.100.167.20

Also try traceroute (or tracert for windows) to an IP and domain and see if there are any bottlenecks along the way?

Post what you find and we will do what we can.

1. You have computer parts in your house older than 19.......that you bought new.

2. You have actually used an 8" floppy disk.

3. Your first modem was 300 BAUD.

4. You were a beta tester for Windows 3.1

And I qualify on all counts. Ouch.

LOL

chmod can be trick to figure out till somebody passes this on to you. Each character has a specific number value. r=4, w=2 and x=1. To set the permissions for rw-rw-rw you add 4+2+0, 4+2+0, 4+2+0 and get chmod 666 filename. To set rwxr-xr-x it would be 4+2+1, 4+0+1, 4+0+1 or chmod 755. SO chmod 770 sets it to rwxrwx--- so directory is read write execute for the owner and group but cannot be read or written to by eveyone else. The next step with the -R recursively changes the permissions on every file and directory below /var/www/html/uploaded. I am curious as to why you are creating individual users on the server. Look into .htaccess in apache and how you can use it to limit access to specific directories and files depending on the users connection via apache.

Well it was pretty quick and dirty to begin with. Best suggestion I can make is to create a table from the data that does have an id and post non-null information information to it based on the your criteria. Then generate your report from the result table.

Use a VIEW instead. It creates an internal temp table that is continuously updated.

select distinct concat(INIT_SURNAME, EMAIL)
INIT_SURNAME,
EMAIL,
MAX(PHONE),
MAX(OTHERID)
from table
order by INIT_SURNAME, EMAIL
group by INIT_SURNAME, EMAIL

might just work but no promises...
I would love to know what happens...

Try disconnecting one and see if you can get to just one drive. IF they are on the same cable check and see if they are both set to master or both set to slave. Should be one master and one slave, both set to cable select or one at the end of the cable set to master and other set to slave or cable select.

Download and run Malwarebytes free scanner. It will tell you if there is something redirecting your web activities.

Dos prints directly to the printer and windows spools the files and prints them in the background. When printing from dos you wait till it finishes sending the file to the printer till it continues processing.

Hello,

If I understand correctly windows is starting OK but once up yu are getting a prompt for a CD to be put in the drive to finish the installation of an application.

Does it say what the installer is trying to load?

Can you confirm that windows is loading or give a full description of how far it gets?

What version of windows do you have?

Hello,

1. Double check your IP address by running ipconfig from a command prompt.

2. Since it is wireless make sure you have not connected to another wireless network by mistake.

3. If the card cannot ping it's self then TCP/IP may not be properly loaded. Go to the network cards properties and remove TCP/IP. OK the change then go back in and add it back.

4. You could have a conflict with the internal port being set for 192.168.1.104 even if it is not active.

5. Check to see if NetBIOS protocol is loaded for the adapter if you are tryiung to connect to a windows network.

6. If the ipconfig shows you to be on another subnet 169.254.0.X go in to the properties and give it a static IP on your network confirm you can connect then reset it back to DHCP and it should pick up the router correctly.

Post the results from ipconfig if you are still having problems.

My computer keeps redirecting me.I not too smart at all this stuff but i do have this log file.

Logfile of Trend Micro HijackThis v2.0.4
Scan saved at 4:40:47 PM, on 7/2/2010
Platform: Windows XP SP3 (WinNT 5.01.2600)
MSIE: Internet Explorer v8.00 SP3 (8.00.6001.18702)
Boot mode: Normal

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\csrss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\system32\spoolsv.exe
C:\WINDOWS\Explorer.EXE
C:\WINDOWS\system32\svchost.exe
C:\Program Files\LSI SoftModem\agrsmsvc.exe
C:\Program Files\Common Files\Apple\Mobile Device Support\AppleMobileDeviceService.exe
C:\Program Files\iTunes\iTunesHelper.exe
C:\Program Files\Java\jre6\bin\jqs.exe
C:\Program Files\ThreatFire\TFTray.exe
C:\Program Files\Norton 360\Engine\4.2.0.12\ccSvcHst.exe
C:\Program Files\Nero\Update\NASvc.exe
C:\WINDOWS\system32\ctfmon.exe
C:\Program Files\Norton PC Checkup\Engine\2.0.3.271\SymcPCCULaunchSvc.exe
C:\Program Files\Norton PC Checkup\Engine\2.0.3.271\ccSvcHst.exe
C:\WINDOWS\system32\svchost.exe
C:\Program Files\ThreatFire\TFService.exe
C:\Program Files\Yahoo!\SoftwareUpdate\YahooAUService.exe
C:\Program Files\Norton 360\Engine\4.2.0.12\ccSvcHst.exe
C:\Program Files\Norton PC Checkup\Engine\2.0.3.271\ccSvcHst.exe
C:\Program Files\Yahoo!\Messenger\ymsgr_tray.exe
C:\Program Files\iPod\bin\iPodService.exe
C:\WINDOWS\System32\alg.exe
C:\Program Files\Messenger\msmsgs.exe
C:\Program Files\Internet Explorer\iexplore.exe
C:\Program Files\Internet Explorer\iexplore.exe
C:\Program Files\Internet Explorer\iexplore.exe
C:\Program Files\Trend Micro\HiJackThis\HiJackThis.exe

R1 - HKCU\Software\Microsoft\Internet Explorer\Main,Search Bar = http://us.rd.yahoo.com/customize/ie/defaults/sb/msgr9/*http://www.yahoo.com/ext/search/search.html
R1 - HKCU\Software\Microsoft\Internet Explorer\Main,Search Page = http://us.rd.yahoo.com/customize/ie/defaults/sp/msgr9/*http://www.yahoo.com
R1 - HKCU\Software\Microsoft\Internet Explorer\SearchURL,(Default) = http://us.rd.yahoo.com/customize/ie/defaults/su/msgr9/*http://www.yahoo.com
F2 - REG:system.ini: UserInit=C:\WINDOWS\system32\Userinit.exe
O1 - Hosts: 74.125.45.100 safebrowsing-cache.google.com
O1 - Hosts: 74.125.45.100 urs.microsoft.com
O1 - Hosts: 74.125.45.100 www.securesoftwarebill.com
O1 - Hosts: 74.125.45.100 secure-plus-payments.com
O1 - Hosts:

For FreeBSD to rotate the Slow or General Query log the following can be added to /etc/newsyslog.conf:

# rotates the mysql logs when they reach 1 meg
# and keeps 7 copies
/var/db/mysql/file-name.log mysql:mysql 600 7 1000 * J
/var/db/mysql/file-name.err mysql:mysql 600 7 1000 * J

Alternatively from version 5.1.12 the log can stopped and started from mysql admin without stopping the server by doing the following:

# login to mysql
mysql -u root -p (prompts for password)
SET GLOBAL general_log = 'OFF';
# log file may now be renamed/moved/deleted
# then restart logging
SET GLOBAL general_log = 'ON';

Finally the MySQL manual states that you can simply rename (or delete) the log file and then FLUSH LOGS:

cd /path/to/datadir
mv log-file.name log-file.name.old
# login to mysql
mysql -u root -p (prompts for password)
FLUSH LOGS;
# creates a new file with log-file.name

pscp.exe
It is a part of "putty" (http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html ) that connects via ssh and copies files using the user name and password you supply.

One day Windows will catch up with where Linux/Unix is now.....

You have to make two separate entries in the httpd.conf file like this:

NameVirtualHost *:80

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

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

The NameVirtualHost *:80 above the first entry tell apache witch site is the default for the server if no URL is given just the IP address.

There are several free utilities that will copy it for you. I suggest that you download and generate UBCD4WIN (Ultimate Boot CD For Windows). It uses your OS to create an image of a CD that you can burn to a CD and boot from. It gives you applications to duplicate disks while resizing partitions along with many other cool tools.

http://www.ubcd4win.com/

Have you tried changing the channel on the router or setting it to a fixed channel and speed?

Since it is a desktop and is not used with other networks how about giving it a fixed IP address and see if it stays on line.

IF I remember correctly Netgear configures the local IP as 192.168.0.1 and DHCP for the range 192.168.0.100-192.168.0.150. If this is how your is setup the I suggest either setting the desktop at the address below (or setting it under "Alternate Configuration" with it set for DHCP initially):

IP: 192.168.0.50
NM: 255.255.255.0
GW: 192.168.0.1

NS1: 192.168.0.1
NS2: 4.2.2.2

If it down not work can you send the results from running the following commands from the command line:

ipconfig
ping 192.168.0.1 <Or your gateway address>
ping 4.2.2.2
ping google.com
tracert google.com

Hello,

You also need to add a user (or have a user added by the hosting company) to the MySQL users table that connects from the remote IP. (i.e. dbuser@192.168.1.2 ) to tell MySQL it is OK to accept connections from that host as that user to the specified database.

Hello,

PHPmaker by e.world. You can find a limited demo version all over the web and it is the best, fast and secure php page generator I have found. I actually bought a copy and it has paid for its self many times over. Their latest version is 7.0.1 so be careful you get it when you download. 6.0.1 was pretty good and has some great tools but they really did some cool things in 7. It has the ability to connect to your MySQL database on the server directly (if you have remote access set up) or via a php page you move onto the server which connects you. The help manual is very well written and covers the simple to complex with good examples.

Can you ssh to the system and login to a command line?

Can you physically get to the system where you can edit the system before it starts (grub you hit "e" when the splash screen id up as it starts to boot. I can give you a series of commands that will boot to a shell as root.

Do you have any cordless phones in your house. Or the base station for one near the system with problems? They use frequencies very close to each other and sometimes interfere. It it is only one wireless that has problems then it is usually the environment causing the issue.

Also double check the IP4 settings for the network connection in question and make sure it is set to get settings automatically for IP and DNS.

I take it you are still not getting the result you expected...

The best suggestion I can make from here is to break it down to one join at a time and review the results. start with the first table and make sure you are pulling the records from there you want to start with.

SELECT tblSteps.stepName,
FROM tblSteps 
WHERE tblSteps.done = FALSE

then add the first join and recheck:

SELECT  tblSteps.stepName, 
tblWorkflows.stepIdFK
FROM tblSteps 
RIGHT JOIN tblWorkflows ON 
tblSteps.ID = tblWorkflows.stepIdFK  
  WHERE tblSteps.done = FALSE

And keep going till the results fail.

Since the httpd daemon is managing your web sites and running as the user apache (or on some systems nobody) then anything they do is created, written or run by the user apache. That user needs access to read and write to the directory in question. Hope that helps... It does not matter what name they use to connect via the web page they are still all just apache to the server when they come in via browser.

Try this site they explain it pretty good.

http://www.roseindia.net/jsp/execute-sql-query.shtml

Hello,

My best suggestion is to take it one join at a time and watch the results. Can you post your current query here?

In the mean time based on what you said in your post I would start the query in the tblTasks table and pull your data from there. I don't see any place where you list what the current step is for the task. If you had a field in tbl.Task that showed the current task step called "CurrentStepId":

Select tblTask.ID as Task_ID,
tblTask.taskName as Task_Name,
tblPersons.lastName as Last_Name
from tblTask 
INNER JOIN on tblWorkflow where tblTask.ID = tblWorkflow.taskIdFK 
INNER JOIN on tblTaskAssignment where tblTask.ID = tblTaskAssignment.TaskIdFK
where tblTask.CurrentStepId = 0

should get you started....

Hello,

If you do a listing of the /var/www/html directory you will see something like

[root@srvr4 ~]# ls -la /var/www/html
total 44
drwxr-xr-x  7 root   root    4096 Jun 24 22:32 .
drwxr-xr-x  9 root   root    4096 Apr  4 16:22 ..
drwxr-xr-x  8 cherry apache  4096 May  5 19:41 cherryoak1.com
drwxr-xr-x  8 cherry apache  4096 May 24 02:58 cherryoak.com
drwxr-xr-x  9 cherry apache 12288 Apr 16 23:11 cherryoak.net
drwxr-xr-x 10 root   root    4096 Jun 24 22:32 txlinux.com
drwxrwx---  6 apache apache  4096 Jun 24 22:24 vegadns

The d at the front of the line tells you it is a directory.
The three sets of rwx are the permissions for Owner, Group and World.
For the directory cherryoak.com the owner is cherry and the group is apache.

Normally you will have a directory for each domain on the server like on my test server directory listing above and in that directory you put the index file and any download directories. In the listing below the "images" directory is where images are posted to and if you notice it has rwxrwxrwx or read, write and executer permissions for everyone.

[root@srvr4 ~]# ls -la /var/www/html/cherryoak.com
total 448
drwxr-xr-x 8 cherry apache   4096 May 24 02:58 .
drwxr-xr-x 7 root   root     4096 Jun 24 22:32 ..
drwxr-xr-x 5 cherry apache   4096 May 24 02:57 calendar
-rw-r--r-- 1 cherry apache  25014 May 24 03:02 categorieslist.php
-rw-r--r-- 1 cherry apache  10497 May 24 03:02 cherryoak.css
-rw-r--r-- 1 cherry apache    969 May …

Hello,

I suggest that you use the second setup.
Modem --> Router --> (Server, PC1, PC2, PC3, etc)
for several reasons.
1. You don't have to open ports on the routers firewall to allow the Windows systems to get to the server.
2. You can use the firewall in the router to limit access to the all of the systems and the server's samba drive share from the WAN.
3. It will also make it easier for the windows systems to find the server if they are in the same subnet. (i.e. 192.168.1.1-192.168.1.255)

Hope this helps.

Hello,

Your best bet is to look at their help page and see what they intend it for. I believe what they are referring to could be needing a rDNS (reverse DNS record) so theat queries against the IP address of your site respond with your site name. OR maybe your need a special MX recocrrd to point mail.mydoamin.com to a different server.