Posts by rch1231

Hello,

My mistake I was thinking it was the windows systems that cannot access via name. In this case all you need to do is edit the /etc/hosts file on the linux clients and add in the entries for the windows servers.
Basically the hosts file is the first place that the system looks for DNS entries. If it does not find one then it queries the DNS server and if that fails the WINS server (if one is listed.) You can either add entries to the hosts file of start the wins client on the Linux servers.

Depending on your configuration you set up wins something along these lines.

To enable WINS resolution in Ubuntu, do the following:

Edit the /etc/nsswitch.conf file, and change this line:

hosts: files dns

to this:

hosts: files wins dns

Then do a sudo aptitude install winbind to install winbind, and everything should work like a charm.

Hello,

Quick note in case you are not aware of this. The system root user and the MySQL root user are two entirely different accounts and passwords. Even though they are both called root the MySQL password is stored in the application and the system root password is stored in /etc/shadow. The system root user does not have root privleges in MySQL and the MySQL root user does not have system root privdgles.

If you were already aware of this then either you have the wrong password for root or the host is incorrect. If you have never set a root password for MySQL server, the server does not require a password at all for connecting as root. To setup root password for first time, use mysqladmin command at shell prompt as follows:

mysqladmin -u root password NEWPASSWORD

You could try root@127.0.0.1 or if you have system root access to the box then there is a procedure that allows you to reset MySQL root to what ever you want.

http://www.thegeekstuff.com/2009/07/how-to-reset-forgot-mysql-root-password-on-unix-linux-windows/

Hello,

You are looking for the cast and convert commands. For example:

SELECT TextID AS ID
FROM W1
UNION
SELECT CAST(NumericID As VARCHAR(20)) AS ID
FROM W2

Or, if you like CONVERT():

CONVERT(VARCHAR(20), NumericID)

A quick and dirty way to have the two local computers find the linux boxes would be to add entries in the hosts file on the windows systems. Windows uses a file normally located at

C:\windows\system32\drivers\etc\hosts

This is the windows equivalent of the /etc/hosts file on Linux systems. On my systems at home I have added a link to a testing server I run and the file looks like this:

# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
#      102.54.94.97     rhino.acme.com          # source server
#       38.25.63.10     x.acme.com              # x client host
# localhost name resolution is handled within DNS itself.

127.0.0.1    localhost
#         Any other entries you had go here (new line no # no space);  

192.168.0.2   srvr4   srvr4.txlinux.com

Normal syntax for the file is:

IP Address <TAB> short_name <TAB> Fully qualified Domain Name

You can then get to the server by putting either the short_name or the full name in your Navigation or Location area:

http://srvr4/page1.html
or
http://srvr4.txlinux.com/page1.html

Hello,

You will probably have to export the Oracle DB to a file (CSV is probably best) and import it into MySQL. I don't think there is an option for importing directly from Oracle but yes it can be done.

Hello,

It depends on the model and year. Check the toshiba support site for your model and see if they put copies of the install cd's on the drive or if there is a separate recovery or restore partition on the hard drive.

Hello,

Two things:
You can use Partition Magic to re-size the partition on the drive to 250 GB.
Yes you can plug the laptop SATA into your desktop I do it all of the time. The power and cable pin-outs are the same.

Hello,

Sorry about not responding sooner. Really it would be more accurate if you Google'd formatting a hard drive. A proper format verifies the media as it sets up the data structure to hold your files.

Hello,

Did you add the XP system to the domain and is Server 2003 set up to be a domain controller for the domain? I think the second question is yes if you have set up active directory and added users. If you need to add the xp system to the domain right click on My Computer and Under the TAB for computer name change the computer from being part of a workgroup to a member of a domain. You will have to have a domain administrators username and password to connect the computer to the domain.

Hello,

First thing I can think of to check would be do you have a fixed IP from AOL in other words do people access your computers from the web. If so you need to be prepared to change your IP address when you get a new one from your new provider.

If you want minimum down time then order the new service first and switch over one system for testing then move the rest after you are sure the service is working properly and shut down AOL. Your MAC address is from your equipment and nothing to do with AOL.

Hello,

I would try running nmap against your server and take a look at this site for some suggestions on security settings to use.
http://www.tldp.org/HOWTO/Security-HOWTO/

I see a couple of problems with the way you set up your data for the database. In several cases the end date is prior to the start date. The table assumes that the start and end date are not null and in many applications they can be, or at least the end date can be. Or the software should be checking when an end date is entered that it is greater than the start date or reject it.

Also when you set the variables for the dates to check against you need to add 00:00:00 (12:00AM) to the start date and 23:59:59 (11:59PM)to the end date (or add one day to the end date and 00:00:00 (12:00AM) and say less than).

Here is a subnet mask table that tells how many IP addresses are in a subnet based on the mask used:

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 	
28	/28	16		14		255.255.255.240	
27	/27	32		30		255.255.255.224	
29	/29 	8		6		255.255.255.248 	
30	/30 	4		2		255.255.255.252

Hello,

Depends on how you are trying to start mysql through putty. Normally I run the following command as root or with sudo:

service mysqld start

or you can run mysqladmin start -u root -ppassword

Hello,

The proper way to format it for windows XP and above is to go to Control Panel, Administrative tools, Computer Management, Disk Manager and select the drive from the list. The right click the drive and select to format it. Use NTFS not fat32 or many of the new Windows file names will not work and you will not be able to see the entire hard drive. I recommend a full rather than quick format the first time you format the drive to properly set the drive up. After that you can use quick format to simply erase the directory structure and content and start over.

Hello,

Your problem is the way windows views the hard drive. 298GB is about correct for a 320GB drive. You have to multiply it out to see the correct number.

298.9 X 1024 X 1024 X 1024 = 320941431193.6
320,941,431,193 Bytes or 320 GigaBytes

298.9 times number of MB in GB, times KB in MB times KB in B. When the format is done and you look at the drive properties you will see correct number of total bytes.

Hello,

You could try increasing the number of outgoing queues that qmail is using. By default it is normally 20 remote connections however I run mine at 60 to accommodate one of my clients running a mail list server.

Reference the following qmail page for more information:
http://www.lifewithqmail.org/lwq.html#config-files

Hello,

Yes. If the processor gets to hot the PC should turn off rather than fry the CPU. Without the fan the CPU will cook and have to be replaced within 60 seconds, less time on newer processors.

This might be more efficient. Te find command will do what you want all in one line.

find . -type f -mtime -1 -exec ls -la {} \;

This command looks for files in the current (.) directory and then runs the ls -la command using the file name as a parameter (puts the file name where the French Braces are). The backslash - semi colon ends the line for the command entered. You could logically replace it with your ftp command using the braces where the file name should be.

The nl2br() function adds the <br> tag if it finds the carriage return (\n) in the text. If you text is long and at many places carriage return is present, even then the nl2br() tag will replace all the occurrence of the carriage return with <br> tag.

Hello,

Go in to device manager and un-install the network devices with the Exclamation Point. Shutdown and Power the computer off completely. Wait 30 seconds. Power the computer back on and the system should reinstall the drivers for the devices that have been un-installed. If it cannot install the driver properly then you need to download the drivers from the system MFG web site.

Hello,

Sorry to take so long getting back to you but that sounds like a key stuck error. Try a different keyboard.

Hello,

That is interesting I got 1990 to 2010 and 21338 rows of data. Well if it would help I created a database with three tables from the data that may help. Make, Make_model and Make_model_year which seemed more logical to me. I exported the MySQL database and zipped it and you can download a copy at this URL:

http://txlinux.com/carmodels.zip

txlinux.com is my domain and you should be able to click on the link and down load it. Unzipped it is just a text file from mysqldump for the database. If you create a database and add USE <database_name>; to the from of the text (where database_name is the name of the database you created ) then load/run it as a query it will recreate the database I built indexes and all.

Hello,

In my previous comment my question is really what are the values of the two things you are trying to use in the division calculation. Have you checked to make sure you are not somehow dividing by 0 or showing 0% as a result. What are the values of $totalSpace and $totalUsed just prior to the calculation?

If you comment out every reference to the $percentUsed variable does the script compile and run?

Hello,

have your tried moving the two lines to print the totals

#
print "Total space: $totalSpace\n";
#
print "Total used: $totalUsed\n";

up above the calculation so you can make sure neither one came out 0. And if it is a percent shouldn't you also multiply by 100?

Well this may help. I found an Excel spread sheet on the web that has makes and models from 1990 to 2011 for just about every make and I can think of. There were several for sale but this one was free and you could import it quickly to mysql.

http://www.ecommercesiteowners.com/private/download-your-database-vehicle-year-makes-and-models

Check your network card configuration and see what DNS or name servers you are querying for the information.
You can always try adding a public name server (like the one at 4.2.2.2) to your DNS list as a third server to check with.

Hello,

If you check on the gateway site for listings of beep codes for the BIOS. or here is a site that list the codes for various BIOS manufacturers:
http://www.5starsupport.com/info/beep_codes.htm

Ok thanks and good luck.
Let me know if I can help and if you get it to work...

Hello,

Have you tried right clicking on the txt file and selecting Open With and then selecting Microsoft Word? If it is not in the liet then add it using the option at the bottom...

Hello,

I am not sure exactly what fields you are trying to post to the second file but here is the way i normally do what you are attempting.

Step 1. Figure out the record ID or something unique you can use to select the records needed for your insert.

select table1.ID 
from table1
where IS_In_table2 is null

Step 2. Create a select statement that generates output in the order and format needed for the insert into the new table. i.e. if I want to insert into table2 fields table2.f1, table2.f2, table2.f3, table2.f4, and table2.f5 in that order. In table one the corresponding fields are table1.f3, table1.f5, table1.f7, table1.f9, and table1.f15 then my query from would be:

select table1.f3, table1.f5, table1.f7, table1.f9, table1.f15
from table1

Step 3. Merge the two to get the data you need to insert:

select table1.f3, table1.f5, table1.f7, table1.f9, table1.f15
from table1
where table1.ID in (select table1.ID 
from table1
where IS_In_table2 is null)

Step 4. add the insert statement to the query:

Insert into table2 (f1, f2, f3, f4,f5)
select table1.f3, table1.f5, table1.f7, table1.f9, table1.f15
from table1
where table1.ID in (select table1.ID 
from table1
where IS_In_table2 is null)

I hope this helps.

Hello,

To be honest I have never configured the service they are referencing so I would not be able to help in that respect. I have seen it in use so I knew about the need to provide the destination addresses which I believe were partially enabled by adding the destination server to the Public servers /etc/hosts file. But beyond that I am not sure.
Sorry.

I think the part you are missing is that during the initial configuration of the Public server the addresses of the Protected servers are provided in a configuration file. Without the configuration file the Public server does not know where to redirect the requests.

Most CPU's have a maximum temperature that they can operate at before they fry. Usually it is around 80 to 90 degrees Celsius which is 10 to 20 degrees below the boiling point of water (100 degrees Celsius). So the answer is it would not work,

Hello,

Look into Gallery2 which is a PHP and MySQL based photo gallery application that is easy to install and configure. Creates the thumbnails for you and lets you create albums as needed as well as having public and secure login options.

hello,

The first thing I can see looking at the report is that you have two different speed and size chips in the system. Based on what it says you have one 256MB PC-3200 200MHz chip and one 1024MB PC-2100 133MHz chip. The system will slow down to the speed of the slowest chip installed which in this case is the PC-2100. Although you only have one processor so it is not as important, however normally it is best to install the same size and speed chips in each pair of sockets (i.e. 2 ea 1024MB PC-2100 for 2048MB total or 2 ea 256MB PC-3200 for 512MB total). Since your system is seeing the PC-3200 I am willing to bet that it is designed to run at the higher 200MHz speed. Personally I would purchase a 1024MB PC-3200 DDR chip from your nearest retailer and replace the PC-2100. I would be willing to be you notice a speed increase.

As far as fixing the wrong values reported by BIOS error. When you install the new memory the system should detect the change and update the BIOS. I am willing to bet that the error is coming from the 200MHz chip only running at 133MHz because of the other chips speed.

Hello,

We would probably need to see your code to be able to give you an idea of why you are getting the error.

Hello,

have you tried a different cable and did you check both ends for a link light?

Double check the port you are going to on the hub/switch/router.

Internal NIC may be blown.

Hello,

DO you have a firewall installed that might be blocking that port. Try iptables -L to list the settings.

I am not sure what you mean by your latest post. Are you trying to create a custom field name based on something that is input by the user? When you add the new column to the table a field to hold that piece of information is added to every record. An example would be if you had a table of names with addresses and decided that you needed to add an Second address line to every record.

Prior to altering the table it might look like:

ID             int     11 primary key, auto-increment, not null
Company_Name   varchar 55 Not Null
Address        varchar 55
City           varchar 55
State          varchar  2
Zip            varchar 10

You would use alter table to add an additional field to hold the second address line:

ALTER TABLE table1 ADD COLUMN Address2 varchar(55)

Your table would now look like this:

ID             int     11 primary key, auto-increment, not null
Company_Name   varchar 55 Not Null
Address        varchar 55
City           varchar 55
State          varchar  2
Zip            varchar 10
Address2       varchar 55

If you are looking at add a record or updating the contents of an individual record then you would use INSERT or UPDATE queries.

Hello,

If I am reading your post correctly the product field already exists and New_Oppourtunities is the new field you want to add. Your problem is the AS entry. AS is used to rename an output column heading when a query is run against the table and is not an acceptable parameter for an ALTER TABLE query.

Add a Column
ALTER TABLE table1 ADD COLUMN col_5 MEDIUMTEXT
Change a Column Type
ALTER TABLE table1 CHANGE col_3 col_3 TEXT
Remove a Column
ALTER TABLE table1 DROP COLUMN col_4
Rename a Column
ALTER TABLE table1 CHANGE col_3 col_4 TEXT
Rename a TABLE
ALTER TABLE table1 RENAME TO table2
Add an Index
CREATE INDEX indexname ADD INDEX (col_1)

Hello,

Try running fdisk and get a list of what drives and partitions the system sees connected.

fdisk -l

Your problem is coming from the fact that MySQL requires a user be defined for every connection to the databases. It can also restrict what each user coming from specific IP addresses can access. If you look at the mysql database and the users table (you have to be the mysql root user to alter it) you will that the users are listed by the name of the host they connect from. A good example is the root user which normally has three entries:

root@localhost
root@127.0.0.1
root@<yourservername>

Depending on how you connect to the server you may have different root permissions for the databases.

In your case you need to add the user myuser@204.11.1.111 and give them access to the database they are requesting data from.

Hello,

A few things to check.

Have you moved the router to a new location? It should be kept high off the floor because the high frequency signal can interfere with its self if close to a reflective surface (concrete floor or FireWall).

Is the modem hot? Usually when they they fail it is due to an internal circuit that overheats and causes problems. It could also be a solder joint that has cracked and when it gets hot expands and breaks the connection. But a hot modem is a sure sign of old age and failure.

Do you have any new electronic equipment in the house (or in your neighbours house) such as cordless phones, Wireless speakers, wi-fi music service, etc. It could be interference from another wireless device. Although you did mention that you changed channels and it did not help.

Hope this helps...

Hello,

No you don;t have to have a separate procedure for each and (sorry hericles) I can think of a hundred reasons to insert into multiple tables from a single record. a simple example would be adding an item to inventory that is a part of another item and you have to create the accounting records at the same time.

But I digress, basically all you have to do is treat each insert as a separate query and then put them together after each one works. Below is a query I used to link an unlimited number or items to other items. It will probably not make a lot of sense since you don't have the original tables but I was all part of a procedure called by the insert trigger. SID (server ID), CID (Customer ID), SLAB (Server Label), RID (Rack ID) were some of the parameters passed into the procedure. SOID was the server Object ID. Trust me you don;t want to know what we did but the example is what you are trying to do.

begin

declare SOID INT;

declare ROID INT;

declare COID INT;

declare PSUOID INT;

declare PSUPOID INT;

declare NICOID INT;

declare NICPOID INT;

insert into objects (`object_type_id`, `device_object_id`, `label`, `date_created`)

values(1 , SID, SLAB, now());

set SOID=Last_Insert_ID();

SELECT ObjIDClient.object_auto_id

FROM ObjIDClient

WHERE ObjIDClient.client_id = CID into COID;

SELECT ObjIDRack.object_auto_id

FROM ObjIDRack

WHERE ObjIDRack.rack_id =  RID into ROID;

insert into objects (`object_type_id`, `device_object_id`, `label`, `date_created`)

values(26 , 0, 'PSU', now());

set …

i still maintain that the file you were trying to attach was to large. The error message you posted even tells you this:

The message could not be sent because its size exceeded the server's limit.

There is nothing you can do on your local computer to change the size of the file the server will except. Email error messages are pretty straight forward and this one is a regularly seen error. Either the email server that you transmit your email through or the one at the other end that holds the message till the recipient retrieves it, has a limit to the size of a file you can attach.

Hello,

Your problem is that the file you are trying to attach to the email is too large. Most email servers limit the size of an attachment to less than 10MB.

Hello,

Looking at the order of the output I would be willing to bet that the variable type for Aantal_Duiven is varchar or char and is string based and not Integer of Float which are numerically based. What you are seeing is a sort based on alphanumeric characters instead of numbers. If treated as a character it evaluates each position in turn so that ax comes before ba (a being less than b). Using an alphanumeric sort the 3 in the first position of 3<blank> is greater than the 1 in the first position of 12. Does that help?

We are getting there. Why not enable the wireless on the private router and enable WPA2 security and connect your laptop to it. Then we don't have to worry about gateway conflicts and you can use DHCP on the wireless connection also. For more protection (after you connect successfully one time and set the key) you can set the router Broadcast SSID to Not broadcast and to connect to your wireless they have to know the SSID and the pass-phrase.

In order to help I would like a little more information. What is the purpose of the database or report you are trying to run? Is it to verify supervision, plan a schedule, or what?

If you are trying to plan a schedule then I think you need to know what jobs need to be filled (ie 2 LVN's 1 RN) and what level nurse it takes for that job and what level the supervisor nurse needs to be.

More info would help.

Job(WardNo, Nurse_Level,