Posts by rch1231

The easiest way to install in on a windows system is to download the MySQL installer MSI from:
http://dev.mysql.com/downloads/installer/
and running it. It has worked for me every time and I normally do the mysql-installer-community-5.7.12.0.msi file at 384MB.
Although it only references 32bit it installs the 64 bit files if a 64bit system is detected and is noted on the page:
Note: MySQL Installer is 32 bit, but will install both 32 bit and 64 bit binaries.

I have always considered the following when writing a program:
When you write a program that is idiot proof the world builds a better idiot.

I have found it is a good idea to cover the records where the field is blank, 0 or null with something like:

SELECT * FROM settlement WHERE settlement < 0.01 or settlement IS NULL

I realize this will get records where the settlement is not zero but sometimes you need to know about these. I inherited a database that had values like 0.00033 stored for the balance and I queried for value = 0 and was missing records.

I would take a look at what processes are being kicked off in MySQL. You can run the following command to see what is running in MySQL
mysqladmin processlist -u root -p
and it will prompt your for the root MySQL password then give you a list of what is running.
If you are having trouble with the INNODB databases I suggest looking at the tools on the Percona web site. They have several free tools for configutring MySQL and for recovery.
https://www.percona.com/software/mysql-tools

My suggestion is to set up a server with a database you are familiar with and then regularly export the data from the various databases and import it to your master system. I have done something like this and I normally use PERL to generate the export files (normally a CSV since every db will create a CVS file) and then import them into a MySQL database. Once you have all of the data in one place then you can start generating reports. This way your reports will have a similar format and you only deal with coding for one database and can use some of the same code. Another advantage is that you are not dealing with the actual data in their database and don't have to worry about accidentally changing something.
Hope that helps.

Hello,

I noticed your other posts about this recently and thought this might be a little late but will really help.

The best way I have found to allow me to develop a word press site and be able to transfer it to production without having to edit the database is to trick the computers working on the development system into thinking it is the production server. You do this by editing the hosts file (Linux - /etc/hosts, Windows - C:\Windows\System32\drivers\etc\hosts ) to point the domain name to the IP address of the development server. This is a text file with no extension and you will need to be either root or an Administrator to edit the file.

For example: I have a development server on my internal network at 192.168.0.10 and my production server is at 54.148.71.11 hosted at amazon. I edit the hosts file on the development server and any system that needs to access the development environment to have the additional line

192.168.0.10 txlinux.com

When your computer does domain name lookup for an IP address it first checks the hosts file and if it does not have an entry then it checks the local DNS server. You have to edit the hosts file on the computer you are working from so it initially redirects to the development address. You have to edit the hosts file on the development system so it will not redirect the site to the production system because of the way wordpress is designed. …

Service is the command that calls the scripts from /etc/init.d which control the daemon processes. Many people use the terms service and daemon to refer to the same thing however the true name is daemon.

A daemon is a computer program that runs as a background process, rather than being under the direct control of an interactive user. Traditionally daemon names end with the letter d. For example, syslogd is the daemon that implements the system logging facility, and sshd is a daemon that services incoming SSH connections.

The term was coined by the programmers of MIT's Project MAC. They took the name from Maxwell's demon, an imaginary being from a thought experiment that constantly works in the background, sorting molecules. Unix systems inherited this terminology. Maxwell's Demon is consistent with Greek mythology's interpretation of a daemon as a supernatural being working in the background, with no particular bias towards good or evil.

Here is some code from The Perl Cookbook from O'Reilly & Associates, which is where I get the best examples for Perl coding:

You must decide what you will and will not accept. Then, construct a regular expression to match those
things alone.  
Compare it against a regular expression that matches the kinds of numbers you're interested in.
if ($string =~ /PATTERN/) {
# is a number
} else {
# is not
}
Here are some precooked solutions (the cookbook's equivalent of just-add-water meals) for
most common cases.
warn "has nondigits" if /\D/;
warn "not a natural number" unless /^\d+$/; # rejects -3
warn "not an integer" unless /^-?\d+$/; # rejects +3
warn "not an integer" unless /^[+-]?\d+$/;
warn "not a decimal number" unless /^-?\d+\.?\d*$/; # rejects .2
warn "not a decimal number" unless /^-?(?:\d+(?:\.\d*)?|\.\d+)$/;
warn "not a C float"
unless /^([+-]?)(?=\d|\.\d)\d*(\.\d*)?([Ee]([+-]?\d+))?$/;

Hello,

Your going to have to find out what application is using the file. Not as hard as it sounds. Open Task Manager and then go to the tab labled Performance and click the Performance Monitor at the bottom. When it opens up select the Disk tab at the top and then under disk activity find the file that is giving you problems. You should see the process id for the application that is accessing it which should be listed under the top section.

He is right so try something like this:

double fahrenheit = ((9 * celsius) / 5 ) + 32;

or

double fahrenheit = ( 1.8 * celsius ) + 32;

Hello,

I think that you will find that the problem is due to the SD Card having a FAT filesystem and not a Linux file system. FAT doesn't track modification times on files as precisely as, say ext3 (FAT is only precise to within a 2 second window). This leads to particularly nasty behavior with rsync as it will sometimes decide that the original files is newer or older than the backup file by enough that it needs to re-copy the data or at least re-check the hashes.

Try this in your script and obviously you need to replace $Source and $Dest as applicable

rsync --progress --modify-window=1 --update --recursive --times --delete "$SourceDr" "$Dest"

Hello,

If I understand correctly you have two tables. One contains data for 2014 and the other contains data from 2015. What you want is to print a report that contains data from both tables. That is not hard to do if the tables have the same field names like it sounds like yours do. If that is the case then the option you are looking for is called UNION and you basically run something like this:

SELECT * FROM table2014
UNION
SELECT * FROM table2015;

Now if you are trying to provide a single line with a summary of data from the different years it gets a lot tricker depending on what you want. If I read you question right you want to compare the two years with out put on one row. It can be done but it is going to take some work. The easiest way I can think of is to create a temporary table with the fields you are trying to get the result to look like and the update that table with records from each year posting each income record from 2014 to the last year field with the this year field empty and income from 2015 to the this year field and the last year field blank then generate the output using group by and SUM to put what dates you want together. How that makes sense and helps.

Hello,

Well I am not well versed in Oracle but I was able to find a page with several options for Oracle:

http://stackoverflow.com/questions/9332360/oracle-equivalent-to-mysql-insert-ignore

Hello,

You would need to build a special test for consonant pairs (ch,gl,gh,fl sh,th,st,sp kn,sn,sl,pl,wh, and any others you can think of...) like you did for the vowels. You will need to put it before the single consonant process to eliminate them before you get to that part. Also you did not do anything for the numeric word and you will need to test for that.

Hello,

Pretty sure that they still do this but when Windows 3.1 was still supported and Windows 95 and 98 were new, HP always included in their initial printer codes on the code set for the HP Laser Jet Series II printer. It allowed us to hard code in the control set for compatibility in software revisions. When ever we received new HP printers and the driver was not yet available for the OS being used, that was what we installed until it was. Also worked on their Desk Jet (Ink Jet) printers.

Hello,

When you go to start the command prompt right click on CMD.EXE and select Run As Administrator. You should then have thr correct permissions and path to run sfc

IF you don't like Ubuntu you could try Fedora Core which is based on Red Hat instead of Debian. I run Fedora on my laptop and it works with all my hardware (except the finger print scanner) and had drivers for everything else with no special downloads. I would go with the 32 bit version of fedora 20 and try the live CD. With it you can test run fedora 20 from the CD without installing the software over your current system.

https://getfedora.org/

Your computer is not getting an IP address from the router. It could be DHCP is not running. Manually configure the Local Area Connection for
IP: 192.168.1.2
Subnet: 255.255.255.0
Gateway: 192.168.1.1

Then try connecting to the address again from your browser.

Also just mentioning this because I have made this mistake before. Make sure you are not connected to the WAN port from your computer. You should be connected to one of the LAN ports.

Hello,

Well there are a couple of things you can do. The first thing to consider is does the modem already have a configuration that is causing issues or is this a new modem? If this is not the first time the modem has been used then it could have been set for a different network. You can reset most modems back to the default configuration by pressing and holding the modem's reset button while connecting the power and hold the button in for 30 seconds. It could already have been set to act as a access point instead of a router and would not have DHCP running and could be at another address (the active router would be at 192.168.1.1 and the access point would be another address).

If it has been reset or is new it could be setup for a different subnet or could have other problems so go back to the basics and check everything.

Do you have a link light on both the router and computer (if not replace the cable).

With them connected see if you are getting an address from the router. Go to a dos prompt and type in:
ipconfig /all
If you get a 192.168.X.X address then the router is configured for DHCP and on the subnet indicated by the first X and your router will be at the address listed forthe gateway. Try that address in your browser.

If resetting it to factory or the other steps do not …

Hello,

A VPN connection effectively connects you to the local area network so port forwarding is not necessary because you are already inside the routers firewall and part of the LAN.

Hello,

Your going to have to find out where the rpm (or rpm.exe) file is installed on your system and either use the full path or add the path to the location to the PATH variable in your system for your user.

Hello,

What you are seeing here are two partitions both on the first controller and the first disk.
The device naming scheme is:

       /dev/cciss/c0d0         Controller 0, disk 0, whole device
       /dev/cciss/c0d0p1       Controller 0, disk 0, partition 1
       /dev/cciss/c0d0p2       Controller 0, disk 0, partition 2
       /dev/cciss/c0d0p3       Controller 0, disk 0, partition 3

       /dev/cciss/c1d1         Controller 1, disk 1, whole device
       /dev/cciss/c1d1p1       Controller 1, disk 1, partition 1
       /dev/cciss/c1d1p2       Controller 1, disk 1, partition 2
       /dev/cciss/c1d1p3       Controller 1, disk 1, partition 3

Device c0d0p1 is controller 0 disk 0 partition 1 and if you created logical drives with the raid controller you should be seeing a device c0d1 and will need to create partitions on it.

On a separate note you said you were going to use RAID 0 (striping) on the last two drives and make it a NAS storage device. If people are going to be storing important information on that device you had better have good backups. RAID 0 is fast however the big drawback is that because data is split across the two drives, if either drive fails then you lose all of the data on both drives. Why not use all of the drives for one large RAID 5 array and then partition the drives for DATA and NAS. With RAID 5 if one of the drives fails the others know what is missing and the array can be rebuilt and you get the speed of striped data for both your data and NAS storage …

Hello,

I would take a look at a couple of things.
First what type of field are you storing the date in? It should be a Date or Datetime field if it is just a text or varchar field then that is your issue.
Second, What is the format of the date that is stored in your field? Make your test against a field with the same format (YYYY/MM/DD hh:mm:ss).

If nothing else give us the definition of your table and a couple lines of output that includes the DateDeleted and at least one record with DateDeleted has data.

Hello,

The most important issue I am aware of is the speed at which you burned the DVD. Over the past 20 years working with CD's and DVD's I have found it best to burn the disk at the slowest speed available and I normally shoot for 4x or 8x if available. If recording at 4x does not make it readable in other systems then what you may have is a mis-aligned laser head. You can spend the time and effort to repair it or with the prices what they are I would simply buy a new drive. But again when it comes time to burn the disk slow is better.

You have to tell the server which database to use to create the table. Add the following in front of your sql code:

USE project_infracom;

if that does not work try creating the database as the first line:

CREATE database project_infracom;

Hello,

You could try making the default value for the fields 0 or you could add 0 to the value of the field in your query to get a result that you add in the sum.

Hello,

A lot of people "claim" to be hackers and really are nothing of the sort. Your running Linux if you have a secure password, don't have your system set to auto log you in, don't give them the password or give them a login to your system then odds are they are not going to get on your computer. It would be different if it was Windows which has too many security holes to count. If you are really worried that some one might get on your computer then disconnect it from the network when you are not using the internet. That really makes it hard for people to connect. Then keep an eye on your /var/log/secure file to watch for people trying to hack the system or run a program like denyhosts to lock them out when they try to hack their way in.

Without digging into the sql you have so far and based on what you are looking to do I suggest you look into using Group By and then if still needed the HAVING option to limit the output after it has been selected.

The query first selects the CID (or city id from what I see) using the employee city shown on the page or in the query.

Then is selects the eid (employee ID's) for all employees whos cid in the works table is equal to the CID pulled from the company data.

It then selects all fields from the employee table whos city is equal to the CID.

Hope that helps

That is just a Unix/linux shell script that can be invoked one line at a time from the command line (if needed) for testing. If you notice the first line is #!/bin/bash wheich tells the OS what to use to run the script.

The other thing that I noticed is you keep referencing that the vendor has a secure ftp server and all of us have been referencing the ftp application instead of sftp. Try the shell script like this:

#!/bin/bash
# $1 is the file name for the you want to tranfer
# usage: this_script <filename>
FILE=path/file
IP_ADDRESS="xx.xxx.xx.xx"
USERNAME="remote_ftp_username"
domain = sample.domain.ftp
PASSWORD= password
/usr/bin/expect<<EOD
spawn /usr/bin/sftp $USERNAME@$IP_ADDRESS
expect "assword:"
send "$PASSWORD\r"
expect "sftp>"
send "put $FILE\r"
expect "sftp>"
send "bye\r"
EOD

The reason for expect "assword:" is that in some cases it responds with a capital P and others a lower case p and this will accept either one.

Ok a couple of things that ma help. Curl is designed to get files not send them so drop that approach all together. SInce your not on a windows (yea) then I am assuming you have access to ssh and a command line or as you said you want to run it from cron. Here is a shell script that will transfer a file to another server via ftp:

#!/bin/bash    
# $1 is the file name for the you want to tranfer
# usage: this_script  <filename>
IP_address="xx.xxx.xx.xx"
username="remote_ftp_username"
domain = sample.domain.ftp
password= password

ftp -n > ftp_$$.log <<EOF
 verbose
 open $IP_address
 USER $username $password
 put $1
 bye
EOF

You then use crontab -e to edit the crontab and call the script:

05  00  * * * /my/path/to/file/this-script dafile.csv 2&>1

Then it probably is Windows Firewall try turning it off and see if you can turn Network sharing on then, If that makes it so it works then:

Go to
Control panel>>windows firewall
Click on Allow a program or feature through windows firewall
Make sure file sharing and network discovery have been checkmarked.

Hello,

I would be willing to bet that the ones you cannot save the settings on and gave them stay are not Win 7 Professional but either Windows 7 Home or Home Premium. they only support homegroups.

I would grab a copy of hijackthis which is a malware detector that will show you all of the hooks into your system through registry entries and help you track down the culprit.

Hello,

I am not sure if you are looking for the php code or the sql code but here is the sql code for what you need to do. You would either put a real values for the where clauses for Month selected and for userid from login or use php to put the current varible values there. To get January for Tom you would use:

select 
statement.StatementID, 
tom_sawyer_db.TransacID,
tom_sawyer_db.DateID,
tom_sawyer_db.TransacName,
tom_sawyer_db.Deposits,
tom_sawyer_db.Withdrawal,
tom_sawyer_db.Balance
from tom_sawyer_db
join statement on statement.MonthID = tom_sawyer_db.MonthID
where tom_sawyer_db.UserID = 4
and statement.MonthID = 1

Hope ths gives you something to work with.

Hello,

Try this site it has several formats and includes city, region, country, latitude and longitude.

http://www.maxmind.com/en/worldcities

Hello,

The UID is the user id and it is stored in the /etc/passwd file. Below is a link to a site the explains the format of the date in the file:
http://en.wikipedia.org/wiki/Passwd

Hello,

Here is a link to a site that provides multiple examples of importing CSV files into MySQL using PHP. It even has a script for an import page.

http://www.phpclasses.org/blog/post/89-Quickly-importing-data-from-CSV-file-into-PHP-applications.html

Truecrypt works with Windows, MAC and Linux

Hello,

You could always try nmap to see what ports are open on the router. Netgears usually have a built in web server for configuration and you just put the IP address of the router in your browser.

Ewald has a good idea and TrueCrypt will encrypt you whole drive and can be set so that the computer will not boot with out the password. Or as a separate option you could carry a USB drive that was encrypted with encryption software but people get lazy about having to put in a USB drive and the password before they save a document to doing the whole drive is safest.

Hello,

Without writing the code for you basically what you need to do is add a section of code that looks for a record with the image name. If it returns a row then there is an image and show error if not continue processing.

$unique_id = $dbh->quote($_GET['unique_id']);
$sth = $dbh->query("SELECT * FROM database WHERE unique_id = $unique_id");
if ($sth->numRows( )) {
// already submitted, throw an error
} else {
// act upon the data
}

Hello,

I am fuessing that you are running Windows, so based on that would check your windows installation files by using your installation DVD and letting it check the system. You said you changed mother boards if I am reading it correctly so I would go to device manager and look for failed devices and I would install the chipset drivers for the new board you installed.

Hello,

That is a pretty tough one to diagnose. Have you tried Malwarebytes scan on one of the systems that is giving you the errors? You mentioned it is showing up on clients even after they have been reloaded, I am assuming that the systems have been added to the domain. If that is so and this is occuring after they are added to the domain, I would take a look at the group policy settings in the server to see if there is something being passed to the clients that is causing the change to the system. If you have applied the latest updates to the OS then I think I would also suggest that you run something like CCleaner to remove old registry entries that are not longer needed.

You would have to log in to the server via ssh and issue the command as the mysql root user. I would contact the hosting company and tell them you are getting the error and have them look into it.

Hello,

You have to treat them as two separate conditions and you need to code for capitalization like this:

WHERE StudentNames LIKE 'joh%' and (StudentNames LIKE '%smi%' or StudentNames LIKE '%Smi%')

I usually go for the subquery version and I believe this will work:

update table2
set total score = (select sum(score) from table1 where table1.id = table2.id)

First you need to determine what memory is actually in the computer and how many chips (SIMMs - Single Inline Memory Modules) you have. Next figure out what speed or type they are (PC3200, PC2100, PC2700, etc.) and are the chips the same type.
Tell me that and I will be able to tell you more.

Yes it is possible because of a couple of things.

If it is a Dell and is set for OS install mode in the bios. It decreases the available ram to 256MB.
IF you have two ram chips and one is either the wrong speed, bad or a different speed.

Did you uninstall, clean the registry, and reboot then install as if new?