Posts by rch1231

Hello,

Instead of ftp use scp (secure copy) or rcp(remoter copy). To copy file1 from myserver in /home/me to newserver1 in /tmp you would enter:

scp /home/me/file1 newserver1:/tmp

System would prompt for your password in scp if you have not configured ssh keys.

If the servers are close together you could mount a directory from one server on the other server and use reqular commands to move files around. You have to configure newserver to allow the directory to be exported (mounted) by the IP of the system that is going to access it and start nfs.

mount newserver1:/tmp /mnt
cp /home/rod/file1 /mnt

This is a copy of an /etc/exports entry to allow another system to mount the /var/extnfs directory on this one:

/var/extnfs 192.168.0.2(ro,sync,no_root_squash)

Hello,

SUDO is to make you have root privileges for executing the script you are about to run not really used for switching to a different user. There are other options. Linux allows you to set up a script so that when it is run it appears to be run by the owner of the file. You will see these in various place throughout the file structure. As an example the mount command in the list below has this set (execute permission for owner shows "s" instead of "x") and it is often referred to as the "sticky bit".

-rwxr-xr-x 1 root root 41368 2010-04-12 14:03 more
-rwsr-xr-x 1 root root 72952 2010-04-12 14:03 mount
-rwxr-xr-x 1 root root 9800 2010-04-26 05:02 mountpoint

Why don't you describe what you are really trying to acomplish and maybe I can provide a better solution.

If you are just trying to change to the other user in the script then drop sudo from and it will work.

It could be your internal firewall or your ISP blocking port 25. Try this from a command prompt and see what you get:

telnet <email server name> 25

If you get a HELO back you are connected to the pop server. IF not check your firewall and see if port 25 is open.

Down load the UBCD from

http://www.ultimatebootcd.com/

It is a linux boot disk with several utilities on in including repartitioning, imaging or copying your hard disk.

Also available is a version for windows but you hve to use your working windows system to create the cd Image.

http://www.ubcd4win.com/howto.htm

I believe there are different versions of shockwave for IE and FF. Check to see if you have the IE plugin.

It could be something as simple as part of the RAM being used for Video memory. I would check the BIOS and see what it shows instralled.

Hello,

Here is something from the reference I use:

<p>
Search the online resources database:<br />
<form action="fulltextsearch.php" method="post">
    Keywords:<br />
    <input type="text" name="keywords" size="20" maxlength="40" value="" /><br />
    <input type="submit" value="Search!" />
</form>
</p>
<?php
    // If the form has been submitted with supplied keywords
    if (isset($_POST['keywords'])) {
       // Connect to server and select database
       $mysqldb = new mysqli("localhost","websiteuser","secret","corporate");
       // Retrieve the search keyword string
       $keywords = $mysqldb->mysqli_real_escape_string($_POST['keywords']);
       // Create the query
       $result = $mysqldb->query("SELECT name, url FROM bookmarks
                              WHERE MATCH(description) AGAINST('$keywords')");
          // Output retrieved rows or display appropriate message
          if ($result->num_rows > 0) {
             while ($row = $result->fetch_object())
                echo "<a href=\"$row->url\">$row->name</a><br />";
          } else {
             echo "No results found.";
          }
       }
    ?>

Hello,

What you need to do is get rid of the variables.

SELECT VendorId From Vendors
WHERE CountryId in (223, 245, 285, 286)
ORDERBY CreatedDate'

It might be easier to use this sort them with the highest contact number and then just get one record.

SELECT 
contacts.forenames, contacts.surname, communications.number, contacts.contact_number
FROM
contacts 
LEFT JOIN communications
ON contacts.contact_number=communications.contact_number
WHERE
  contacts.surname='$sn' AND contacts.forenames='$fn' AND communications.number='$em' 
ORDER BY contacts.contact_number DESC
LIMIT 1

By pointing your domain nameservers to ns1.altprice.com and ns2.altprice.com you are telling godaddy (and the rest of the internet) that any requests to find out the IP for altprices.com will be handled by them. To verify this you can use whois and nslookup like this:

whois altprices.com
[Querying whois.verisign-grs.com]
[Redirected to whois.enom.com]
[Querying whois.enom.com]
[whois.enom.com]
=-=-=-=
Visit AboutUs.org for more information about altprices.com
<a href="http://www.aboutus.org/altprices.com">AboutUs: altprices.com</a>

Contact: espaiz@gmail.com
	
Domain name: altprices.com

Administrative Contact:
   
   Dmitry Brychosetsky (espaiz@gmail.com)
   +1.528332237
   Fax: 
   Jarusalem 23
   Natania,  42301
   IL

Technical Contact:
   
   Dmitry Brychosetsky (espaiz@gmail.com)
   +1.528332237
   Fax: 
   Jarusalem 23
   Natania,  42301
   IL

Registrant Contact:
   
   Dmitry Brychosetsky ()
   
   Fax: 
   Jarusalem 23
   Natania,  42301
   IL

Status: Locked

Name Servers:
   ns1.altprice.com
   ns2.altprice.com
   
Creation date: 22 Dec 2005 22:11:03
Expiration date: 22 Dec 2010 22:11:00

to query your local dns server:

[root@lptp1 ~]# nslookup alt.prices.com
Server:		192.168.1.254
Address:	192.168.1.254#53

Non-authoritative answer:
Name:	alt.prices.com
Address: 74.55.14.50

TO query a specific names server you simply add the nameserver to the nslookup. But ns1.altrice.com is not responding to my queries:

You might also try dig to get information on the nameservers:

dig altprices.com

; <<>> DiG 9.6.2-P2-RedHat-9.6.2-5.P2.fc12 <<>> altprices.com
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: SERVFAIL, id: 33776
;; flags: qr rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 0

;; QUESTION SECTION:
;altprices.com.			IN	A

;; Query time: 342 msec
;; SERVER: 192.168.1.254#53(192.168.1.254)
;; WHEN: Mon Oct  4 12:48:56 2010
;; MSG SIZE  rcvd: 31 …

SO I am confused. If these are nameservers then why are you not running a DNS service on them (bind, tinydns, etc).

Hello,

Ping is generic and does not hit a specific port just the IP. Are you running a firewall? Your right about http being open (port 80) and so is ssh on port 22

Are you sure you want to continue connecting (yes/no)? yse
Please type 'yes' or 'no': yes
Warning: Permanently added '204.236.219.103' (RSA) to the list of known hosts.
rod@204.236.219.103's password:

I bet you have iptables (firewall) running or SELinux. If so you need to open port 53 for the nameservers... And I usually shut SELinux down as it does more harm than good but your call.

Your nameservers are not responding to requests:

nslookup altprices.com ns1.altprice.com
;; connection timed out; no servers could be reached

The name servers are set to:

[rod@lptp1 ~]$ nslookup ns1.altprice.com
Server: 192.168.15.1
Address: 192.168.15.1#53

Non-authoritative answer:
Name: ns1.altprice.com
Address: 204.236.219.103

but I cannot ping them...
rod@lptp1 ~]$ ping 204.236.219.103
PING 204.236.219.103 (204.236.219.103) 56(84) bytes of data.
^C
--- 204.236.219.103 ping statistics ---
11 packets transmitted, 0 received, 100% packet loss, time 10940ms

Looks like you missed the $ in front of value1

$sql="INSERT INTO finaltable (value0, value1, value2)
VALUES
('$value0','value1','$value2')";

I believe you need an ODBC connection (available from mysql) to the MySQL server in order to make the connection.

try using this:

select 
DISTINCT productID, 
regionID 
min(price) as MINP 
from sales_db 
where available_volume>5 
group by productID, regionID 
order by min(price) desc

Hello,

The problem is you are missing the ON that tells the join how to connect the two tables. There has to be a reference field in employees to link it to job titles but your query will look something like this.

use Dwight_wk2
Select * from employees
Left Join Job_Titles on Job_Titles.Job_Title_ID = employee.Job_Title_ID
WHERE employee.Salary BETWEEN 20000 and 35000

You will probably want to change the specific fields you are getting from employee and job_titles so you only get the fields you want to show. Without the tables I am guessing at the names.

use Dwight_wk2
Select 
employees.Lastname
employees.Firstname
employees.salary
job_titles.job_title
from employees
Left Join Job_Titles on Job_Titles.Job_Title_ID = employee.Job_Title_ID
WHERE employee.Salary BETWEEN 20000 and 35000

Have you tried hijackthis to see what it shows?

Hello,

I have put a few of these together in the past and the best way I have found is to include a reference to the parent sales person in the sales person record. Something like

Person_ID
Parent_ID
First_Name
Last_Name
...

I would run malwarebytes (download from cnet's download.com) and see if anything has got onto your system. Then take a look in task manager at the processes tab to see processes that are running and sort them by the CPU time(click the CPU heading twice) to see what is taking up all of the processor time at the top. Make sure you have the option to see processes from all users at the bottom checked.

Hello,

Off the top of my head how about if you sum the availability status and select only those where the sum is 0.

What you need is a select inside a select to do this:

select @i:=0;
select @i:=@i+1 as position, data1.song_id, data1.averagerank 
from 
(Select distinct(rank.songid) AS song_id, (
SELECT AVG( rank.rank )
FROM rank
WHERE rank.songid = song_id
) AS average_rank  
FROM rank
ORDER BY average_rank )as data1


DESC

Try this I think it is pretty close..

Communications speeds when transferring data are usually, but not always, measured in bits per second. A bit is a binary or logical 1 or 0. Data transfer speeds when transferring data, etc. in a computer, such as between memory and a hard disk drive, are often, but not always, measured in bytes per second. A byte of data is a chunk of bits used to represent a character, but not always. There are usually eight bits in a byte, but not always. So, roughly speaking in general and common terms, one byte equals eight bits. Bytes are abbreviated with a capital B and bits are abbreviated with lower-case b, but not always. Microsoft Windows often shows communications speeds in bytes per second. Thus the confusion, which I hoped this unscrambled a little.

However, to complicate matters even more... The Hertz is often used as a unit in the measurement of data transfers. A Hertz is one cycle per second. A cycle is a single occurrence of a periodically repeating phenomenon. For example, one revolution of a bicycle wheel is a cycle. Plot the vertical height (amplitude) of a spot on the tire versus distance or time on a graph and you will have a sinusoidal waveform. Your house electrical power is a sinusoidal wave.

A communications waveform may have a repeated shape. For example, the Ethernet can be measured in cycles per second (Hz). Roughly speaking, and for measurement purposes, it can be considered a repeated "square wave," …

Hello,

If your system is running linux you can install lynx which is a text based web browser.

Hello,

Can you ping the site from a command prompt?

and try nslookup to see if you are able to resolve the domain name.

nslookup www.example.com

Your missing the second l in null

'email' varchar(100) NOT NUL,

OK
two questions:
What does the bios see the drive as?
What does windows see the drive as?

http://www.sudantribune.com/spip.php?article36215

Pure fiction.

Replace the chips. You probably only need to replace one and It will most likely be in the highest numbered slot (DIMM 4 or 3)

Hello,

You have a bad memory chip. What is happening is it is in the upper memory and you are not using that register till after you have been running a bit.

Try this:

LIMIT 10, row_count.

OK quick question... which field holds the rank the user gave the song?

Hello,

The message is telling you one of two things:

1. That you did not give the root mysql password when trying to connect.

2. MySQL is not up and running.

Try connecting to mysql from the command line with the following

mysql -u root -p database_name

SHould prompt you for the root password. If there is not one you should set one.

Hello,

several options.

1. Export to excel then save as a .CSV file and import to MySQL.

2. Find a copy with the hack of Access2MySQLSync and it will do the work for you.

3. export to a tab delimited file and import.

Well it is possible to send from a domain you have access to or through a different email server but you need a login to send from on that domain.

You really need the password or to contact the vendor of the system and verify ownership of the system and they can direct you to a service center to have it reset. Without the password the harddrive controller on the drive is disabled.

You would still use DHCP but most DSL providers require a login to verify your account. Once set in the router you would only see it if you reset the router to factory settings or got a new router. Check with your service provider and I will bet you find out I am correct. The only other connection verification I have seen is using the MAC address of the modem for verification but that is not used that much any more because routers have the ability to set a false MAC address or use another cards address when connecting.

You would run into a lot of issues with authenticating as a valid email server for the domain you are trying to send as. I know my email servers would reject your messages as being bogus spam due to your server not being a valid server for that domain. You can only send email from your email addresses.

When I have seen this in the ast it has been due to not having software installed for burning DVCD's. Normally something like NERO or Sonic.

/ is the wrong direction slash and what if you plug it in too a system that already has a drive G: as something else. try using this instead:

./myapp.exe

where myapp.exe is the program you want to run.

Your old roter was probably logging in to the DSL network for you using PPP. Check in your old router setup for your login and password or contact your service provider and tell them you need the PPP login information for a new router you are installing.

Hello,

I would be willing to bet it is depending on the distribution you choose. Try Fedora Core. It is retty good with laptops.

Hello,

Follow peter_budo not searchec. searchec having you regenerate the GPG key makes no sense however the ps aux is correct and killall is good for killing a specific application (example: killall html ).

trx_datetime = concat(trx_date, trx_time)

or something pretty close.

Is there a floppy disk in the drive and have your gone into the CMOS and verified the system sees the disks and the order they are booting?

A backbone network is normally independent of the internet and used for traffic between your servers that you do not want either slowed down by the internet traffic or to slow down the internet traffic its self. Lets say you have 4 servers (two load balanced web servers with their own database servers. The reasons to set up a backbone would be:

1. You don't want to be charged for the traffic between your systems as part of your bandwidth.
2. You want the web servers to talk to the database servers without web requests interferring.
3. You want the database servers to replicate data back and forth without web traffic interference.
4. You would not even have to have the database servers on the internet which would make them more secure.

Does that help?

Because it is not sql code but a command line executable. Run it from the command prompt.

Hello,

MySQL has a build in application for both Linux and Windows called mysqldump that creates a text file with the SQL code needed to create the databases, tables, indexes, and insert the data back into your database. You can either export all databases or specific databases to a or several files. Usually I compress the file after creating it to save space.

I run the following every night to backup all databases:

/usr/bin/mysqldump -u root -pmysqlRootPW --all-databases > /var/www/html/txlinux.com/mysql_DB_backup

The big mistake people make is there is no space after the -p when putting in your password but there is a space after the -u for user name.

Hello,

Try right clicking on the file and selecting "save as". Should prompt you wheere to store the file.

Hello,

There is a cool tool called jdiskreport which will show you where all of your disk space is being used. You can download it through download.com by CNET.