Posts by rch1231

Take a look at OSTicket. Pretty good and will work with Gmail and other email systems.

OS Ticket

I have set it up for a few customers and they all like it and the options available.

Hello,

From what I am reading it was upgraded for INNODB tables and replaced with
INSERT [LOW_PRIORITY | HIGH_PRIORITY]
If you use the LOW_PRIORITY keyword, execution of the INSERT is delayed until no other clients are reading from the table. This includes other clients that began reading while existing clients are reading, and while the INSERT LOW_PRIORITY statement is waiting. It is possible, therefore, for a client that issues an INSERT LOW_PRIORITY statement to wait for a very long time.
If you specify HIGH_PRIORITY, it overrides the effect of the --low-priority-updates option if the server was started with that option. It also causes concurrent inserts not to be used.

Your name server are available on the internet anyway. If you are on a system with whois installed (rwhois) then you can enter

whois <domainname>

And you get all of the information about that domain including who owns it, the registrar, and what the primary name servers are. You can get the same information from any of the whois sites out on the internet.

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.

Under Linux you can use the time command to give you the amount of time taken to run a command. To review the manual entry for time use:
man time

TIME(1)                       Linux User's Manual                      TIME(1)

NAME
       time - time a simple command or give resource usage

SYNOPSIS
       time [options] command [arguments...]

DESCRIPTION
       The  time  command  runs  the  specified program command with the given
       arguments.  When command finishes, time writes a  message  to  standard
       error  giving  timing statistics about this program run.  These statis‐
       tics consist of (i) the elapsed real time between invocation and termi‐

There is a wierd issue with linux files systems it they ever are completely filled (0 bytes free). If you try deleting files to recover the space it does not show that there is space available. The trick is to find a file that you know you can get rid of and then instead of deleting the file cat /dev/null and redirect it to the file:
cat /dev/null > /home/mydir/some_file
The system is able to update the inode table with the smaller file size and it frees up the space and then you can start deleting files.
Since it sounds like you have already attempted to delete some files and it did not recover the space you need to run an fsck on the filesystem and let it correct the inode tables and disconnect the deleted files. Get in touch with your sysadmin and tell them you need fsck run on the root file system (normally what /dev/sda1 is).

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.

If you get out to a command prompt and do an nslookup on your domain what do you get?

nslookup <yourdomain.com>

it will tell you what IP address it is returning and where it got the address from (which DNS server). For example my if I do my domain I get:

C:\Users\Rodney>nslookup txlinux.com 
Server:  UnKnown
Address:  192.168.0.1

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

Which tell me it got the address 54.148.71.11 from the DNS server at 192.168.0.1 which is my local router. You can also query a specific DNS server by adding its address:

C:\Users\Rodney>nslookup txlinux.com 4.2.2.2
Server:  b.resolvers.Level3.net
Address:  4.2.2.2

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

let us know how it goes.

You can use any delimiting character with sed and the backslash and astereisk need to be escaped. If you use a # as your delimiter this should work:

sed -i 's#c:\\dct\\#\*raw#g' adm2014.do

Have you tried:

        if [ "$DEV_ORA" -eq 0 ]
        then

Also on line 23 should the output file be /tmp/dump.txt like the others?
and what is the output of
grep -ic ORA /etc/multipath.conf

I realize this is not what you were asking for but have you considered creating a PDF instead of an image. Smaller file and there are several free PDF creators for PHP that can be found on gethub
https://github.com/search?utf8=%E2%9C%93&q=create+pdf+php&type=Repositories&ref=searchresults

There is an option built into the OS to do a drive wipe. Here is a link to a page that explains the procedure with screen shots, etc. :
http://www.howtogeek.com/179284/how-to-securely-wipe-a-hard-drive-on-your-mac/

Over 30 years of writing scripts and debugging code that I and others have written, I find it makes it easier if you simply echo (or print) the variables as you go through the code. If right before your test echo the variable and you will know two things: 1) it made it to the line before the test and 2) what the valuse of the variable is right before the test.
How can you claim that if is not working when you have not examined what is being tested....

You can always comment out the lines later when you go to production.

    ls -l /dev/mapper/mpath* | egrep -v "mpath0|p1" | awk '{print $10}'> /tmp/dump.txt
        echo "$DEV_ORA"
        if [ $DEV_ORA -eq 0 ]
        then

You said 32 bit but I am including both just for reference.
32 bit.
On windows7 all the database are referred by a number in the file named pg_database under C:\Program Files\PostgreSQL\<version>\data\global. Then you should search for the folder name by that number under C:\Program Files\PostgreSQL\<version>\data\base. That is the content of the database.
64 bit.
On windows7 all the database are referred by a number in the file named pg_database under C:\Program Files (x86)\PostgreSQL\<version>\data\global. Then you should search for the folder name by that number under C:\Program Files (x86)\PostgreSQL\<version>\data\base. That is the content of the database.

Gigabit transfer requires cat 5e or cat6 cable. Cat 5 will not transfer at 1GB.
from:
http://www.lifehacker.com.au/2013/04/ask-lh-whats-the-difference-between-cat5-cat5e-and-cat6-cables/
Cat5: A Little Older, A Little Slower

Category 5 cabling, also known as Cat5, is an older type of network cabling. Cat5 cables were made to support theoretical speeds of 10Mbps and 100Mbps. You may be able to get gigabit speeds on a Cat5 cable, particularly if the cable is shorter, but it isn’t always guaranteed.

Since Cat5 is an older type of cabling, you probably won’t see them very much in the store, but you may have gotten some with an older router, switch or other networking device.
Cat5e: Faster with Less Interference

Category 5 enhanced cabling, also known as Cat5e, is an improvement on Cat5 cabling. It was made to support 1000 Mbps “gigabit” speeds, so in theory, it’s faster than Cat5. It it also cuts down on crosstalk, the interference you can sometimes get between wires inside the cable. Both of these improvements mean you’re more likely to get fast, reliable speed out of Cat5e cabling compared to Cat5.

I would also have to say no. To remove it from the domain you are going to have to use a Domain Admin account and if you can't get to the domain controller then how are you going to remove it???

I would try a different converter and/or cable. Some of the converters do not pass all of the pins that VGA can use just the ones that they have to for you to get a picture. Also try updating the monitor driver from device manager.

I think what you are trying to ask is how to install the MySQL database on a server and how to access that MySQL database from the client computers. If you install MySQL on the individual systems then each one would be running a local copy of the database and you would not have consistent data which is the purpose of a centralized database server.

To have one database server with multiple clients able to access and write queries against the data simply install the MySQL database server on your server system and install MySQL Workbench (or another client app) on the client systems.

An alternative is to run a web server with PHP installed and then access the database from web pages you create or with the web based client phpMyAdmin which does a limited set of what the MySQL Workbench will allow you to do.

The real question you need to ask is how do you intend for people to access the database and what will they access it for. Are they programmers (developers) or just people need to see, query and update the data. If they are developers go with WOrkbench or phpMyAdmin. If they are web browsers or office workers the you need to create an app to provide the access for them.

Hope this helps.

It is going to depend on what type of result you want from the data.
For example: are you wanting it to be selected if the individual elements of the search string are in the data string
If you have a search string '1,3,5' from and llok for each element in '1,2,3,4,5,6' would be true for this search since 1,3,5 and elements in the data string. If this is what you want then you will have to separate out the individual elements and search the data for them. Sub set of this would also need to know if every element has to be present in the data string or if at least 50-60 percent are there.

Or are you looking for the comma separated search sting to exist intact in the data.
search string '1,3,5' from '1,2,3,4,5,6' would not be selected in the data string because 2 is between 1 and 3 in the data but searching for
'1,2,3' would select because the elements are present and in the same order.

Once you lock down all of the parameters and if you aere still puzzled the tell us better what you are looking for.

Here is a pdf that is a few years old but covers the basics pretty good without being very big. Their license says I can share it as long as I don't edit it and that it must be shared in it's original form. So here it is.

If the drive is on the same disk then when you go into Administrative Tools, Computer Management, then Disk Management. In the center frame you will see the Volume List at the top and a Graphical Representation of the drives at the bottom. If you look at the drive in question in the bottom of the center frame you will be able to see any partitions that exist on the drive. If the partition has a drive letter assigned it should show here and it will also show if the partition is formatted and the format used something like mine are shown in the attached image.

If the partition still exists but simply does not have a drive letter assigned you can assign one by right clicking on the partition and selecting Assign Drive Letter or Path. Let us know what you find if you are still having problems after this.

The next question then is which version of Windows are you running? I am running Windows 7 and if you notice my primary HD has a System Reserved partition and it does not have a drive letter assigned. This is normal for Windows 7 as it boots from the System Reserved partition and switches the second partition to have the drive letter C: during the boot process.

Hello,

If that is your CD-ROM/DVD drive like in most windows systems now a days then the solution could be as simple as putting a disk in the drive. I know on my Windows 7 desktop system when there is no disk in the drive it is not visible on Explorer. If it is not your CD-ROM then I would go into Control Panel, Device Manager and look under Drives to see what device drivers are loaded. In Disk Management did you look at the bottow to see if the drive was there or only at the top listing?

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.

My brother received a call that was from the IRS about the middle of December and they wanted him to go to Kroger and buy Prepaid credit cards and give them the card numbers, pins and CVS or the treasury agents were coming by his house to pick him up today.... Since he owes back taxes he almost fell for it.....

But for those of us who enjoy making the scammers squirm a little you will enjoy this TED talk where the tech responded to one of the spam emails. I laughed till my sides hurt.
https://www.youtube.com/watch?v=_QdPW8JrYzQ

Really need to see what your tables look like.
If Category is a seperate table with ID and Name and the doctors table only has Cat_ID not Cat_Name then your query is not joining to the category table to get the category name.

Just a guess....

I may be wrong but I believe the issue you are having is in line 6 which reads:
header("location:accountSummary.php");

You should have some sort of path to the accountSummary.php file from document root. It may be that you were in a specific sub-directory when you were executing the script before and the php file was in the same sub-directory and was available for execution but you are running from a different location on the server now and it is no longer available without the relative path.

Examples I found always showed something like:

header("location: /accountSummary.php");
or
header("location: ../accountSummary.php");

And in every case there was a space between location: and the file name

I hope this helps and makes sense.

I would check to make sure that your video card is properly seated. I have knocked mine loose a few times when connecting cables. Does the computer power on and are you getting any lights or beep codes when it does. Normally there is a led of some sort on the mother board to show when you have power to the computer. Check the manual for your mother board and find the CMOS reset jumper and clear the CMOS out. Do you get anything when you power it on? Fans spinning, any lights and is there a built in video port on the back of the system?

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

You could do this quite easily with SQL by creating the new tables in your current database and then exporting the tables to be imported to the new database.

To dreate the NEW CITY you could use:

drop TABLE IF EXISTS `NEW CITY TABLE`;
CREATE TABLE `NEW CITY TABLE` 
(
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `City` VARCHAR(50) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `City` (`City`)
) 
SELECT DISTINCT
`OLD EMPLOYEE TABLE`.City as City
FROM
`OLD EMPLOYEE TABLE`
GROUP BY
`OLD EMPLOYEE TABLE`.City

Then create the new employee table with :

drop TABLE IF EXISTS `NEW EMPLOYEE TABLE`;
CREATE TABLE `NEW EMPLOYEE TABLE` 
(
  `USER_ID` int(11) unsigned NOT NULL,
  `FIRST_NAME` VARCHAR(50) NOT NULL,
  `LAST_NAME` VARCHAR(50) NOT NULL,
  `CITY_ID` int(11) NOT NULL
  PRIMARY KEY (`USER_ID`)
) 
SELECT
`OLD EMPLOYEE TABLE`.`USER_ID`,
`OLD EMPLOYEE TABLE`.`FIRST_NAME`,
`OLD EMPLOYEE TABLE`.`LAST_NAME`,
`NEW CITY TABLE`.ID as `CITY_ID`
FROM
Clients
INNER JOIN `NEW CITY TABLE` ON `OLD EMPLOYEE TABLE`.`CITY` = `NEW CITY TABLE`.City

You would now have your two new tables and just have to export them to CSV or as sql and then import them to new database.
Hope that helps...

My guess would be a IRQ conflict which Windows has always had issues allocating properly.

Click "Start," then click "Control Panel" to open the Control Panel window. Double-click the "System" icon to open the "System Properties" window.

Click the "Hardware" tab, then click the "Device Manager" button. This opens the Device Manager.

Click the "View" menu at the top of the Device Manager window. Select "Resources by type" from the drop-down list. This displays a list of resource types.

Click the expansion box next to the "Interrupt request (IRQ)" icon. This displays a list of system devices and the IRQ numbers assigned to them. Devices with conflicting IRQs will be identified by an exclamation mark inside a yellow circle. Make a note of the IRQ number issued to the conflicting devices.

We would need to see the code in question in order to be able to help.
What database are you using?
Do you have any indexes created on the tables?

Hello,

In mysql you can use LIMIT to limit the number of rows of output:

    SELECT OrderLine.LineNo, Order.OrderNumber, Order.Description, WarehouseOrder.WhsRef, 
           WhsPick.PickRequired, WhsPick.PickAvailable, WhsPick.EstimatedDispatch, Carton.CartonNumber
      FROM WhsPick 
           INNER JOIN WarehouseOrder ON WhsPick.ID = WarehouseOrder.PickID 
           INNER JOIN OrderLine 
           INNER JOIN Order ON OrderLine.OrderID = Order.ID 
                            ON WarehouseOrder.ID = Order.WarehouseOrderID 
           INNER JOIN Carton ON WhsPick.ID = Carton.PickID
           LIMIT 1

limit uses the following parameters:

SELECT ... FROM ... ORDER BY ... LIMIT 0, 20; retrieve first 20 rows
SELECT ... FROM ... ORDER BY ... LIMIT 20, 20; skip 20 rows, retrieve next 20
SELECT ... FROM ... ORDER BY ... LIMIT 40, 20; skip 40 rows, retrieve next 20
etc.

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 can see what is causing your problem but just telling you will not help you solve this in the future. What I do when a piece of code is not giving me what I expect is to print the variables before and after any calculation or changes to the variables. At line 13 put in some print statements to see what values you are passing to the code at that point. Something like this but for every variable involved:

System.out.println("hrlyrate = "+hrlyrate);
System.out.println("hrswrk = "+hrswrk);
System.out.println("payrate = "+payrate);

I think you will see what is causing your problem then.

What really helps is if you put the code you are using and the error you are getting like you did initially. We can't debug your code without seeing it.

Hello,

How to geek as a good discussion of how to do this in WIndows Vista and later.
http://www.howtogeek.com/howto/windows-vista/add-any-application-to-the-desktop-right-click-menu-in-vista/

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. …

Hello,
When are you getting the error about firstname not in field list? Is it when you are running the create table query or at another point in the process?
Is there already a table called customer in the customerdb database? If so is there a firstname field already defined?
If you are testing creating the database and/or table from scratch then here is a sample of the sql code I use that drops the table first then recreates it. I did not include the rest of the select since it is a long query with a couple of JOINs and UNIONs.

DROP TABLE IF EXISTS `TagLinks`;
CREATE TABLE `TagLinks` 
(
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ProductID` int(11) DEFAULT NULL,
  `TagID` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `tag` (`TagID`),
  KEY `prod` (`ProductID`)
) 
SELECT * FROM 

One other thing I will mention just in case, Is the script running from your local machine at the 197.253.66.85 address, or is it running on a server through a web browser? If it is running from w web browser then the IP addressw is the servers address or 127.0.0.1 or localhost. What will really tell you what is going on is the mysql log file. If you take a look through it you will be able to see the address that made the request as well as more information as to why it was refused (it could be the request came in under your IPV6 address not the IPV4.

Hello,

If you have root access to the mysql server then you can run the following from the mysql prompt to get a list of users and permissions:

mysql> select user,host from mysql.user;

Will give you a list of users and hosts they are configured to have access from. If your user is in the list with the correct IP address then you can check the privledges with:

mysql> show grants for 'point3hu_leo'@'197.253.66.85';

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.

Hello,

The MAC OS is based on Linux and normally loads web pages as fast or faster than a comparable Windows system. In an system it will depend on the browser, processors, available memory and the stability of your network connection to access the internet. If you don't feel the CPU or memory are issues you can check the network performance with mtr (or WINMTR) which combines ping and trace route commands to check connection performance and packet loss.

You can get MTR for the MAC at:
https://support.safesoftsolutions.com/index.php?pg=kb.page&id=1395

You can get mtr for Windows (called winmtr) at the following site for comparason:
https://sourceforge.net/projects/winmtr/

This may be over simplfying it but I used the following to give me the load average depending on the OS .

For Linux

<?php
$output = shell_exec('w | head -1 ');
echo "<pre>$output</pre>";
?>

For Windows

<?php
     echo system('typeperf "\Processor(*)\% Processor Time"');
?>

I noticed you were checking a windows system after I had added the Linux script so I added the WIndows one.

So what error are you getting?

Hello,

The first question is are you doing a quick format or not. If the USB filesystem becomes corrupted a quick format, which basically just deletes the entries in the Master File Table, will not fix it. Uncheck the quick format option and try it again and if it works then you should be fine. If not then it is probably time to buy a new USB.

Hello,

I have seen this before and it took me a minute to find the reference I used to fix it. The error is due to Windows Update running out of available memory during the update process. Here is a link to the Microsoft page on how to fix it:

http://windows.microsoft.com/en-us/windows7/windows-update-error-80070008-or-8007000e

Hello,

I would start with what processes are running on the server and what is calling the offending scripts. If you run
ps auxf
you will see all of the processes in a tree format showing what called what so you can stop the scripts. CPanel has some built in security applications that can help you stop the scripts and block their future installation. Check them out.

I came across a python script for Windows 7 called GWX Control Panel that allows you to disable the GWX application and also disables the ability for Windows upgrade your OS as part of your routine updates. I am providing links for PC World article that discusses the changes to Microsoft's update policy and to the Control Panel:

http://ultimateoutsider.com/downloads/

http://www.pcworld.com/article/3012613/windows/microsoft-prepares-for-massive-windows-10-upgrade-strategy.html

Hello,

Here is a shell script for what you are requesting but I home you are not really going to do a wget 20 times. If you do you will probably trigger DDOS attack filters that will block your IP address. The "while true " loop will continue to execute (since it is always true ) until you do a <CTRL> C

#!/bin/bash
while true
do
        i=0
        while [ $i -lt 20 ]
        do
                wget http://test.com
                i=$[$i+1]
        done
        sleep 2
done

To tell you more I would have to see a copy of the definition of the students table (i.e. field list) but basically the system is telling you it does not see a field by that name under students. Your not getting a database not found or table not found error so double check the field name.