Posts by rch1231 Page 21

rch1231 169 Posting Shark

14 Years Ago

Is there a reason to use ftp specifically?

Linux has scp (Secure Copy) which like ssh uses encrypted traffic to move files between servers. The following web site has a great explanation of using scp and tells you how to set up the servers with rsa keys so that no password is needed for a specific user on each system to be able to transfer files and even gives sample shell scripts.

http://www.linuxjournal.com/article/8600

Software Development shell-scripting

rch1231 169 Posting Shark

14 Years Ago

Re: SQL DISTINCT Syntax

OK I'm confused either in the way I am reading it or the way you are saying it.

First- What is not true?

Second- When you say a table with one column do you mean that each record only has one field that contains all of the data?

Third - And when you use the entry [Club Name] are you referring to the field called Club_Name like in MS-Access where they use the [] to enclose field and table names or does the data actually say [Club Name]? Distinct implies that every entry character in the field is distinct.

The syntax you posted will work in any of the databases you listed and in mysql if your data has distinct records.

Can your post your query, table and results for the first 10 records so I can figure out what I am miss reading?

Databases mssql

rch1231 169 Posting Shark

14 Years Ago

Re: Please Help...New to MySQL

Did you make sure to use left join and not just join. Left join picks all records from the table name on the left and all matching fields from the table on the right. Once it has the list using HAVING instead of WHERE pulls all records from the result table that match the HAVING entry. I have used this probably 50 times to find unmatched records and know it will work.

Did you try creating the queries separately as I suggested or just see if you could write it from scratch. I used to try and write it all at once and it would take hours to debug and get right. Creating one query at a time makes it easy to debug and verify the data. If you could post the code for your tables based on each of my queries and I will see if I can spot the problem if you like?.

Web Development mysql php

rch1231 169 Posting Shark

14 Years Ago

Re: windows xp setup

ok so run it again

Microsoft Windows windows-nt-2000-xp windows-xp

rch1231 169 Posting Shark

14 Years Ago

Re: Extensions limitations

What is the error you are getting or what is it doing when you use it?

Web Development php

rch1231 169 Posting Shark

14 Years Ago

Re: mysql subquery for sum with limit using filesort

If you have an id field on each record then you could use:

#
SELECT SUM( score ) AS top10_total
FROM answers
WHERE record_id in 
(select record_id from answers 
where question_id=4
order by score DESC)
limit 10

That will do a query first to get only the answers for question 4 and put them in order by descending score, then select the first 10 and sum them

Databases mathematics mysql sql

rch1231 169 Posting Shark

14 Years Ago

Re: comparison site

It's not java but a simple text file that can be a one record file used to transmit regular blocks of records. It can be this simple:

<?xml version="1.0"?>
<note>
    <to>Tove</to>
    <from>Jani</from>
    <heading>Reminder</heading>
    <body>Don't forget me this weekend!</body>
</note>

And I bet you will find the companies you are dealing with are already familiar or have a standard format for you to send data in. It gives you and them the ability to automate the process of getting the quote information.

Web Development php

rch1231 169 Posting Shark

14 Years Ago

Re: What is type of my processor

Found this excellent description on another site:

http://www.linuxforums.org/forum/linux-newbie/28214-rpm-differences-i386-i586-i686-x86_64-ppc-etc-etc.html

Originally Posted by techieMoe
To give a little more information on that, the X86 processors started with the Intel 8086 processor way back in 1978. They were incrementally improved (80186, 80286) and then Intel released the Intel 386 (i386) in 1980. That was then followed by he 486 (i486), the Pentium (i586), and the Pentium 3/4 (i686) and AMD's Athlon/Duron/T-bird (also i686).

Since all these processors were based on the same architecture (basically they read/wrote 1's and 0's in the same way), and their names all contained "86", the whole family was collectively called "X86". All the X86 processors were 32-bit.

The recent trend has been to move toward 64-bit processors, and several different architectures popped up. DEC's Alpha and Motorola's PPC chips have been 64-bit for a while, but Intel's Itanium and Xeon and AMD's Athlon64 are the new kids on the block.

The difference between the Itanium and PPC versus the Athlon64 is that the Itanium and PPC have completely different architectures (they speak different 1 and 0 languages), whereas the Athlon64 speaks the same language as the 32-bit X86 processors, but adds 64-bit registers. Therefore the name of the Athlon64 in generic terms is "X86_64".

Intel, not to be outdone, has since redesigned its 64-bit Xeon processors to use the same kind of architecture as the Athlon64, calling it "Intel 64-bit with Extended Memory Technoloty". Basically they couldn't say they …

Linux and Unix

rch1231 169 Posting Shark

14 Years Ago

Re: mysql subquery for sum with limit using filesort

Hello,

This link to the mysql dev site will explain where the filesort is coming from:

http://dev.mysql.com/doc/refman/5.0/en/order-by-optimization.html

As far as a way to get the results without querying the whole table, if you have an field with the number of wrong answers or with 100-score then you could build an index on question_id and that field and then limit 10 and it should only hit those 10. Sounds good anyway......

Databases mathematics mysql sql

rch1231 169 Posting Shark

14 Years Ago

Re: Please Help...New to MySQL

Yes, the trick is to get a select query that returns the ID's in newtable that do not have an ID in oldTable.

select newtable.id left join on oldtable where newtable.id = oldtable.id
having oldtable.id is null

The you do an update using that select:

Update newtable 
set newtable.status=2
where newtable.id in (select newtable.id 
left join on oldtable 
where newtable.id = oldtable.id
having oldtable.id is null)

Web Development mysql php

rch1231 169 Posting Shark

14 Years Ago

Re: WiFi connects but browser does not open page

Ok then are you getting an address assigned to your wireless adapter? If you enter the following from a command prompt what do you get?

ipconfig

If your network card is assigned an address then does it have a gateway?
See if you can ping the gateway.

Networking

rch1231 169 Posting Shark

14 Years Ago

Re: How to store flashMovie file name and location?

Having tried this I find (and from reading other posts others agree) it is best to store the .swf file in a directory and store the location in MySQL. You can store the actual binary contents of the file in MySQL by using the BLOB data type however the problems come from the varied size of the .swf files being stored and what it does to the database files.

Databases mysql

rch1231 169 Posting Shark

14 Years Ago

Re: Want to get a pre-made setup, how to judge?

Personally I would go with a DELL or HP/Compaq. Both companies have great customer service and make good long lasting product. Based on the limits of wanting something you can expand (knocks out the slim or SFF - Small Form Factor boxes) and not needing 1TB of space I would recommend the:
Dell - Inspiron Desktop / Intel® Pentium® Processor / 4GB Memory / 500GB Hard Drive
Model: I560-2050NBK | SKU: 9846086
Dell makes great systems and stands behind the product. You don't need more than 4GB of memory on a desktop unless you are doing heavy graphics and PC3 memory is faster than PC2. Dual core processor with 64 bit capabilities will give you a good system. Is a tower vs SFF so you have room to expand.

Hardware motherboards-cpu-ram

rch1231 169 Posting Shark

14 Years Ago

Re: comparison site

If depends on the companies you are querying but look into XML coding. It lets you send a mini data file with assigned fields that can be returned with additional fields that can then be imported to a database.

http://www.w3schools.com/xml/default.asp

Web Development php

rch1231 169 Posting Shark

14 Years Ago

Re: software problem

Download CCleaner from Piriform (free download) and clean the registry. If will remove the references to half installed applications. It also has an option to uninstall applications that may list the file even if it does not show in Add Remove PRograms.

Community Center

rch1231 169 Posting Shark

14 Years Ago

Re: windows xp limited account

If the system stops at a login screen hit <CTRL><ALT><DEL> twice and you should get a place to type in the user name and password that is filled in with your current user. Replace the user name with "Administrator" and leave the password blank and see if you can get in as administrator. If not download UBCD from the following site and use the NT password cracker to reset the administrator account password.

http://www.ultimatebootcd.com/

The password tool is under Data Recovery.

To get to the boot from CD Option you will need to get into the BIOS. Different Manufacturers use different keys but when the system is first booting try hitting <F1> <DEL> <F2> <F9> <F10> <F12> and see if you get either a option for what device to boot from or the BIOS settings. What to boot first is normally under the BOOT menu option. If the BIOS is password protected there is a BIOS password cracker on the UBCD disk also.

Microsoft Windows windows-nt-2000-xp windows-xp

rch1231 169 Posting Shark

14 Years Ago

Re: WiFi connects but browser does not open page

Can you ping either an IP address or site once connected? (i.e. ping 4.2.2.2. or ping google.com) What OS are you running and have you tried "repair" on network connection after connecting? Some free connection sites require you to connect to their main page and accept their terms before you can surf.

Networking

rch1231 169 Posting Shark

14 Years Ago

Re: Compacting Mail

Hello,

There are several possibilities but basically you need to find out what is accessing your outlook data file. Make sure you do not have more than one copy of outlook running and you are not checking mail while it is trying to compact. Go into the account settings and set the send receive time to 30 minutes or disable it temporarly and restart outlook. IF it is still giving the error then reboot and try again. then check the Task Manager for applications that may be accessing the file. If you have no other choice backup your outlook files (normally to a .pst file format, make two copies just in case.) remove and restore the datafile from the backup.

Microsoft Windows windows-nt-2000-xp

rch1231 169 Posting Shark

14 Years Ago

Re: MySQL Database Size

The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. The following table lists some examples of operating system file-size limits. This is only a rough guide and is not intended to be definitive. For the most up-to-date information, be sure to check the documentation specific to your operating system.

Operating System 	File-size Limit
Win32 w/ FAT/FAT32 	         2GB/4GB
Win32 w/ NTFS 	                 2TB (possibly larger)
Linux 2.2-Intel 32-bit 	         2GB (LFS: 4GB)
Linux 2.4+ (using ext3 filesystem) 4TB
Solaris 9/10 	                 16TB
MacOS X w/ HFS+ 	         2TB
NetWare w/NSS file system 	 8TB

Windows users, please note that FAT and VFAT (FAT32) are not considered suitable for production use with MySQL. Use NTFS instead.

Found by googleing "mysql dev maximum database size" which returned
http://dev.mysql.com/doc/refman/5.0/en/full-table.html

Databases mysql

rch1231 169 Posting Shark

14 Years Ago

Re: Setting up 2 routers to connect through DSL modem

Is the router address 192.168.1.0 or 192.168.1.1?

Networking

rch1231 169 Posting Shark

14 Years Ago

Re: Help with FTP

Fastest way to get you configured is review the setting on this site against yours.

http://www.cyberciti.biz/tips/rhel-fedora-centos-vsftpd-installation.html

Linux and Unix apache

rch1231 169 Posting Shark

14 Years Ago

Re: New motherboard - new problems

Windows does not transfer to new hardware well. If you changed the processor type (Intel to AMD ) or went to a multi-core from a single core you will have to repair the windows installation to continue. Your problem is coming from windows loading drivers specific to your old mother board and CPU without confirming they are present.

Boot from your installation CD and go through the steps till you get the SECOND request concerning repairing windows. At that point tell it you want to repair the installation and it will delete and reload all of the drivers resetting all of the values in the registry for them. If it completes successfully you should be able to boot to your old user name and have all of your apps and documents intact.

Hardware motherboards-cpu-ram

rch1231 169 Posting Shark

14 Years Ago

Re: hd problem

Just in case this helps. If it is an PATA (IDE with 40 pin ribbon cable vs SATA) check to see if the cable is upside down on one end. Normally the cable is keyed but you find some that are not. Pin one (the one with the red stripe) should be closest to the power connection and check pin one on the mother board. I have seen several times where systems would not boot with upside down cables.

Hardware motherboards-cpu-ram troubleshoot-hardware

rch1231 169 Posting Shark

14 Years Ago

Re: Array losing its values outside the foreach loop

Your not losing any variables it is just that . and .. are directories not files.

Web Development php

rch1231 169 Posting Shark

14 Years Ago

Re: php time using now()

It has always worked for me and you post the code in question?

Web Development php

rch1231 169 Posting Shark

14 Years Ago

Re: Counting issue

Cool but I had another script based oon the KISS principal (Keep it simple, stupid)

<?php

$dirs = array("88x31","120x60","120x90","300x250");
for ($x=0; $x < count($dirs); $x++) {
    $output = `find ./binary/$dirs[$x] -iname '*.jpg' -print | wc -l ` ;
    echo "Total in $dirs[$x]  is $output <br>";
    $Totalall = $Totalall + $output;
}
echo "Grand Total is $Totalall";
?>

Web Development php

rch1231 169 Posting Shark

14 Years Ago

Re: pavilion dv41275

Try booting in safe mode.
hit <F8> continually key while system is first booting till you get a windows prompt on how you want to start.
Read the "things to try first" page.

Hardware troubleshoot-hardware

rch1231 169 Posting Shark

14 Years Ago

Re: Setting up 2 routers to connect through DSL modem

Ok here is the way I would set your routers based on your configuration

Router1
WAN: <DHCP from Modem>

LAN:
IP: 192.168.1.1
NM:255.255.255.0

Router2
WAN:
IP: 192.168.1.210
NM:255.255.255.0

LAN:
IP: 192.168.2.1
NM: 255.255.255.0

You have to think of it as a separate network. Treat the second router as if you were connecting straight to the modem without the PPOe login. You could (if you have DHCP for the local network set up on the first router) set the second router to Obtain address DHCP for the WAN and then 192.168.2.1 for the LAN.
I take it the first router is able to connect to the internet OK?
If so try a traceroute from router 2 to the modem and see what you get.

Networking

rch1231 169 Posting Shark

14 Years Ago

Re: Counting issue

I would try outputting the individual variables and see if you can find out where the total is going wrong. Any reason you would not use something like this?

<?php
$output = `find ./binary -iname '*.jpg' -print | wc -l ` ;
echo "Total JPG files $output"; ?>

and get the OS to do the work?

Web Development php

rch1231 169 Posting Shark

14 Years Ago

Re: How to the SELECT max statement return both 2 columns having same max values?

select * from table1
where myvalue = (select max(myvalue) from table1)

or something along those lines but I think you will get the idea. The system will perform the sub-query first to get the value you want then apply the result to your original query. Here is a sample I just ran on my system that worked.

SELECT * FROM Domain D where D.`Date_Created` = (SELECT max(`Date_Created`) FROM Domain )

Databases mssql

rch1231 169 Posting Shark

14 Years Ago

Re: "Network cable unplugged" problem..doesn't really make sense..help!

Normally you cannot connect two computers directly with a standard ethernet cable. You have to have a hub or switch involved to swap the send and receive wires to the right outputs. There are crossed cables available that will do the pin swapping for you but you are better off with a small hub. A standard cable pin one goes straight through to pin one and two to two etc. A crossed cable swaps pin one to pin two, two to one, three to four four to three, etc. so transmit on one computer goes to receive on the other and visa versa. Hubs and switches handle that for you. Some of the newer network adapters are designed to auto detect the cable configuration and allow you to connect without a cross connect cable but the older VIA adapters are not on the list. I bet you are not getting a link light on the network port when they don't connect. And when you get one on the new computer it takes a second to come on instead of the moment you plug it in.

Networking

rch1231 169 Posting Shark

14 Years Ago

Re: Help with FTP

Have you tried using a simple ftp in from a command line client and see if you connect? From either windows command prompt of linux shell

ftp <IP Address>

should prompt you for user name and then password.

Linux and Unix apache

rch1231 169 Posting Shark

14 Years Ago

Re: chmod permission

Hello,

Looks like linux which does not need safe mode..... The problem is coming from one of two things:

1) You apache is set to prevent people from posting files to the server and making them executable (try chmod 666 <Filename> instead of 0777). Using 0777 gives read, write, execute permission to the owner, owners group and everyone else that touches the site. you don't want a world writeable - executable file on the server. someone will post a script over it and hack the server.

2) You don't own the file you are trying to change. try running the following from command line and see who ownes the file:

ls -la <filename>

For a solution check out "umask". It is the file creation mask that sets permissions for files created by a specific user. There is a umask variable set in the /etc/bashrc file.

setting a umask of 111 prior to the upload would give the same result as doing a chmod 666.
system subtracts the values from 777 to get permissions (i.e 777 - 111 = 666)
umask 022 is the same as chmod 755.

Web Development php

rch1231 169 Posting Shark

14 Years Ago

Re: Security Tool - yeah right

I have seen this before. Create a file called unhookexe.inf with notepad or another simple text editor, on another system and put the following in the file:

Version]
Signature="$Chicago$"
Provider=Symantec

[DefaultInstall]
AddReg=UnhookRegKey

[UnhookRegKey]
HKLM, Software\CLASSES\batfile\shell\open\command,,,"""%1"" %*"
HKLM, Software\CLASSES\comfile\shell\open\command,,,"""%1"" %*"
HKLM, Software\CLASSES\exefile\shell\open\command,,,"""%1"" %*"
HKLM, Software\CLASSES\piffile\shell\open\command,,,"""%1"" %*"
HKLM, Software\CLASSES\regfile\shell\open\command,,,"regedit.exe "%1""
HKLM, Software\CLASSES\scrfile\shell\open\command,,,"""%1"" %*"
HKCU, Software\Microsoft\Windows\CurrentVersion\Policies\System,DisableRegistryTools,0x00000020,0

Put the file on a usb drive or copy it to the hard drive. Right click the file and select install and you will then be able to run exe files again.

Information Security cybersecurity virus-malware windows-virus

rch1231 169 Posting Shark

14 Years Ago

Re: Help with FTP

Do you have a firewall or SELinux installed? If so make sure that port 21 is open for ftp. The port 21 entry in /var/log/secure can you post it (without the password)?

Linux and Unix apache

rch1231 169 Posting Shark

14 Years Ago

Re: Help with FTP

Wrong file, my msitake. xferlog is what has transferred on off the server. look in /var/log/secure and see what the connection and login are doing.

Linux and Unix apache

rch1231 169 Posting Shark

14 Years Ago

Re: How to reduce the nested if else statement

Have you looked at using a "CASE" statement?
switch ($roll){
case 1:
$romValue = “I”;
break;
case 2:
$romValue = “II”;
break;
case 3:
$romValue = “III”;
break;
case 4:
$romValue = “IV”;
break;
case 5:
$romValue = “V”;
break;
case 6:
$romValue = “VI”;
break;
default:
print “This is an illegal die!”;
} // end switch

Web Development php

rch1231 169 Posting Shark

14 Years Ago

Re: Help with FTP

Check the vsftpd log file to see why it is loging you off.
/var/log/xferlog

And did you restart vsftpd after making the changes?

Linux and Unix apache

rch1231 169 Posting Shark

14 Years Ago

Re: XP install from external drive

Sorry about that I misunderstood the last sentence. With the USB installed on the port check to see if there is a CD-ROM Boot order or device. If you have an on-board then disable the on-board CD-ROM and see if it boots from the USB CD-ROM. Watch close for otion to get to boot menu (I think dell uses <ESC>).

Microsoft Windows windows-nt-2000-xp

rch1231 169 Posting Shark

14 Years Ago

Re: how can i do this

So what in plain english are you trying to do? Find the difference in two dates?

Databases mssql

rch1231 169 Posting Shark

14 Years Ago

Re: website is hacked.

Hello,

It sounds like someone has posted a site on your server and is generating sam form it. I would start by checking the /tmp /var/tmp /usr/tmp directories for posted files or directories. Make sure when you do directory listings you use:

ls -la

I have always found they like to hide things in directories that look like they belong like ... instead of just . and .. or ..<space> or along those lines. if nothing else there may be something in one of your users home directories. If it is a linux box and you would like some help send me a Private Message and a login and I can take a look.

Web Development cybersecurity php

rch1231 169 Posting Shark

14 Years Ago

Re: XP install from external drive

If it is an HP then you can usually press <F9> or <F12> and get a boot menu and select the external drive.

Microsoft Windows windows-nt-2000-xp

rch1231 169 Posting Shark

14 Years Ago

Re: Help ! public_html/.htaccess unable to check

Well it is hard to provide a step by step guide when we do not know your OS, how your access your site, if you are on a shared or private server. Also remember this is a service we do without compensation so you can ask but you may not get what you ask for.
On linux from the command prompt you type

ls -la

and compare the permissions to the ones I originally provided.

Web Development html-css php

rch1231 169 Posting Shark

14 Years Ago

Re: Make a row and it's data unchangeable/undeleteable

Don't give the user permission to write to that table.

Databases mysql

rch1231 169 Posting Shark

14 Years Ago

Re: Multiple users, same file

Normally it is a feature you enable when creating the NAS storage group.

Hardware client-server storage

rch1231 169 Posting Shark

14 Years Ago

Re: I cannot create my own restore point??

Try clicking on other dates on the calendar to see if there is a restore point created for one of them. Normally dates with restore points are highlighted somehow. The option for Create my own restore point is to generate a new point for the state the system is in now to be able to restore later.

Microsoft Windows windows-nt-2000-xp

rch1231 169 Posting Shark

14 Years Ago

Re: Multiple users, same file

By warning them the file is already open by another user and giving them the option to open it read only or not open it.

Hardware client-server storage

rch1231 169 Posting Shark

14 Years Ago

Re: XP install from external drive

What is the boot order set to in BIOS and is the option for "Boot from other device " enabled?

Microsoft Windows windows-nt-2000-xp

rch1231 169 Posting Shark

14 Years Ago

Re: Periodic

If you are on a linux server then the easiest way is to write the mysql or php code to perform the action and then call it from cron. cron will run jobs at a specific date, time, or day of the week based on what you set up.

Calling a php script to run the first of the month at 10 after midnight you add an entry like this to cron:

10 00 1 * * /usr/bin/php /path/to/your/cron.php

to verify where our php executable is from a command prompt type:

which php

to edit your crontab from a command prompt type:

crontab -e

As far as the script to do what you want we would need more detail on the tables involved and calculations.

Web Development php

rch1231 169 Posting Shark

14 Years Ago

Re: Help ! public_html/.htaccess unable to check

Ok based on the error message the problem is not the content of your file but permission for apache to read it to begin with. If you check the file ownership and read write permissions and compare it to your web pages permissions I believe you will see the problem.

Web Development html-css php