sonjaya website

Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
November 21, 2016, 9:55 am
Filed under: 2016, access, database, IT, Programing, tutorial, VB | Tags: , , , ,

if you have problem when access file access with password such as ” Cannot start your application. The workgroup information file is missing or opened exclusively by another user.”
here the tips was working :
ConnectionString = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\accesfile.mdb;Jet OLEDB:Database Password=;”

example :
Public Sub accessdb()
cn = New OleDb.OleDbConnection
With cn
.ConnectionString = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\sample.mdb;Jet OLEDB:Database Password=;”
End With
End Sub

source original :


Open DNS recursive For Indonesia Area
February 12, 2016, 3:36 am
Filed under: 2016, dns, Internet, IT, Networking, Secure, server, tutorial | Tags: , , , , ,

I search best performance dns  recursive for query dns for my internet activity .
Here i have been test from indonesia isp and here Top 6:

  1. Nawala  IPv4  and
  2. Verisign IPv4   and  IPv6 2620:74:1b::1:1  and  2620:74:1c::2:2
  3. Google IPv4  and   IPv6 2001:4860:4860::8888 and 2001:4860:4860::8844
  4. OpenDNS IPv4  and
  5. Dyn  IPv4    and
  6.  Hurricane Electric IPv4  IPv6  2001:470:20::2.

So it is close and low latency from Indonesia if you come from other country please chek againt and test.

Happy Browsing

Network Monitoring List
February 2, 2016, 6:55 am
Filed under: 2016, Internet, IT, Linux, Networking, server, tutorial, web-server, Website | Tags: , , ,

Here the list of Network Monitoring  Base on Open Source.

For the review you can check the official website.

  1. Cacti
  2. Nagios
  3. Icinga
  4. Nedi
  5. Observium
  6. Zabbix
  7. NTOP
  8. OpenNMS
  9. Spicework
  10. Ganglia
  11. Collectd
  12. Munim
  13. NetXMS
  14. Zenoss

Enjoy IT.


Source  : Google searching

Puppet Enterprise Quick Install

Here my little note install puppet enterprise in ubuntu .

  1. Install ubuntu x64 fresh
  2. Login and change to super user
  3. Update online  and patch as you need
  4. Download puppet enterprise setup free version ( 10 node include master )
  5. Choice Instalation method
    1. Monolithic Instalation ( for up to 500 nodes )
    2. Split installation ( for 500-1500 nodes)
  6. Extrax download instaler puppet master.
  • root@puppet:/home/icon# tar -zxvf puppet-enterprise-2015.2.0-ubuntu-14.04-amd64.tar.gz
  • root@puppet:/home/icon# cd puppet-enterprise-2015.2.0-ubuntu-14.04-amd64
    6.root@puppet:/home/icon/puppet-enterprise-2015.2.0-ubuntu-14.04-amd64# ls -la
    total 412
    drwxr-xr-x 8 root root   4096 Aug 11 09:20 .
    drwxr-xr-x 4 ison ison   4096 Aug 11 09:20 ..
    drwxr-xr-x 2 root root   4096 Aug 11 09:20 answers
    -rw-r–r– 1 root root  10394 May 28 18:17 db_import_export.rake
    -rw-r–r– 1 root root  10189 May 28 18:17 environments.rake
    drwxr-xr-x 2 root root   4096 Aug 11 09:20 erb
    drwxr-xr-x 2 root root   4096 Aug 11 09:20 gpg
    -rw-r–r– 1 root root  19151 Oct 24  2014 LICENSE.txt
    drwxr-xr-x 2 root root   4096 Aug 11 09:20 modules
    drwxr-xr-x 2 root root   4096 Aug 11 09:20 noask
    drwxr-xr-x 3 root root   4096 Aug 11 09:20 packages
    -rw-r–r– 1 root root  18172 Jul 23 07:24 pe-classification.rb
    -rw-r–r– 1 root root  10235 Jul 23 07:24 pe-code-migration.rb
    -rwxr-xr-x 1 root root 128802 Jul 23 07:24 puppet-enterprise-installer
    -rwxr-xr-x 1 root root  20580 Jul 23 07:24 puppet-enterprise-support
    -rwxr-xr-x 1 root root  26275 Jul 23 07:24 puppet-enterprise-uninstaller
    -rw-r–r– 1 root root   1225 May 28 18:17 README.markdown
    -rw-r–r– 1 root root    206 Jul 23 07:25 supported_platforms
    -rw-r–r– 1 root root   3221 Jul 23 07:24 update-superuser-password.rb
    -rwxr-xr-x 1 root root 109656 Jul 23 07:24 utilities
    -rw-r–r– 1 root root      9 Jul 23 07:25 VERSION
    root@puppet:/home/icon/puppet-enterprise-2015.2.0-ubuntu-14.04-amd64#7. install
    root@puppet:/home/icon/puppet-enterprise-2015.2.0-ubuntu-14.04-amd64# ./puppet-e                                                                                        nterprise-installer
    ================================================================================Puppet Enterprise v2015.2.0 installer

    Puppet Enterprise documentation can be found at                                                                                        15.2/



    Before you begin, choose an installation method. We’ve provided a few paths to c                                                                                        hoose from.

    – Perform a guided installation using the web-based interface. Think of this
    as an installation interview in which we ask you exactly how you want to
    install PE. In order to use the web-based installer, you must be able to
    access this machine on port 3000 and provide the SSH credentials of a user
    with root access. This method will login to servers on your behalf, install
    Puppet Enterprise and get you up and running fairly quickly.

    – Use the web-based interface to create an answer file so that you can log
    in to the servers yourself and perform the installation locally. If you
    choose not to use the web-based interface, you can write your own answer
    file, or use the answer file(s) provided in the PE installation tarball.
    Refer to Answer File Installation
    (, which
    provides an overview on installing PE with an answer file.

    ?? Install packages and perform a guided install? [Y/n] y

    Installing setup packages.

    Please go to in your browser to continue
    installation. Be sure to use https:// and that port 3000 is reachable
    through the firewall.

    open web browser open https://ipserverpuppet:3000

  • installe-web3I choice for Monilithic because only for testinginstalle-web4installe-web5


Your infrastructure has finished installing.
Thank you for installing Puppet Enterprise!

root@puppet:/home/icon# nmap localhost

Starting Nmap 6.40 ( ) at 2015-08-11 10:35 WIB
Nmap scan report for localhost (
Host is up (0.000013s latency).
Other addresses for localhost (not scanned):
Not shown: 994 closed ports
22/tcp   open  ssh
53/tcp   open  domain
443/tcp  open  https
5432/tcp open  postgresql
8080/tcp open  http-proxy
8081/tcp open  blackice-icecap

Nmap done: 1 IP address (1 host up) scanned in 2.63 seconds

8.login to web  https://ipaddress  user : admin pass : xxx


Ok that alll now you have Puppet master  Engine

Install NoSQL DBMS OrientDB in linux ( ubuntu )

Here tutorial   instalation NoSQL  DBMS OrientDB in linux server ( Ubuntu)

Little brief of about OrientDB

Welcome to OrientDB – the first Multi-Model Open Source NoSQL DBMS that brings together the power of graphs and the flexibility of documents into one scalable, high-performance operational database. OrientDB is sponsored by Orient Technologies, LTD.

OrientDB has features of both Document and Graph DBMSs. Written in Java and designed to be exceptionally fast: it can store up to 150,000 records per second on common hardware. Not only can it embed documents like any other Document database, but it manages relationships like Graph Databases with direct connections among records. You can traverse parts of or entire trees and graphs of records in a few milliseconds.

OrientDB supports schema-less, schema-full and schema-mixed modes and it has a strong security profiling system based on users and roles. Thanks to the SQL layer, OrientDB query language is straightforward and easy to use, especially for those skilled in the relational DBMS world.


Basic authentication on an Apache HTTP Server

Here little tutorial make protection your webpage with flatfile

I do it in machine  : GNU Linux Ubuntu + apache2 + htpasswd ( apache2-utils )

1.Create password file with utility htpasswd ( you can grab with apt-get install apache2-utils (for debain user ).

I put in apache2 folder configuration to easy to maintenance

root@karedox:/home/pupet# mkdir -p /etc/apache2/htpasswd/

2.Create flat file with htpasswd , because this is firts time you need option -c
root@karedox:/home/pupet# htpasswd -c /etc/apache2/htpasswd/.htpasswd ujangkemod

New password:
Re-type new password:
Adding password for user ujangkemod

To update password user you can do it :

root@karedox:/home/pupet# htpasswd /etc/apache2/htpaswwd/.htpasswd ujangkemod
New password:
Re-type new password:
Updating password for user ujangkemod
3. Edit apache2 configuration
root@karedox:/home/pupet# vi /etc/apache2/apache2.conf
<Directory /var/www/>
Options Indexes FollowSymLinks
AllowOverride None
Require all granted
edit like this bellow

<Directory /var/www/>
Options Indexes FollowSymLinks
AllowOverride None
AuthType Basic
AuthName “Authentication Required”
AuthUserFile “/etc/apache2/htpasswd/.htpasswd”
Require valid-user

Then restart apache2

root@karedox:/home/pupet# apache2ctl restart

and you can test  at browse

http-authok that all is easy you can doit in 10 minute 🙂

Make own POP3 Client with Delphi

here little example of POP3 Client with delphi.

The basic was from  and i have modification for support SSL ( which gmail  user need id to access pop3 account) .

This example application made with delphi 7 and test it working using indy component with openssl

This source only access pop3 with ssl and read it the email dan counting how many email dan how big mailbox size.

Ok for the source code you can grabe in here pop3client  and i hope everyone can use and modification for more feature

Remove popup message proxmox 3.1 web interface login

hi .. all

this article was from promox forum ,  last night I try to upgrade from proxmox-ve 2.3 to proxmox-ve 3.1 .

After finish upgrade from console I try access web interface https://promoxpublicip:8006/    and login with user root  .

Then show popup message say “You do not have a valid subscription for this server. Please visit to get a list of available options.”

They I search in proxmox forum  new license schema for promox-ve 31 still free as GPL3 but every you login to web interface will be show popup messages.

So I think is annoying they look me using illegal version of proxmox-ve .

Then I search in Google and find interest patch ( patch for remove popup message )

and here how to patch it  :

1.Please login to your server proxmox-ve 3.1 as root  this in your terminal

#wget -O – | patch -p0

And don’t forget to reboot your proxmox-ve 3.1 and I try login with web interface and message popup already gone.

sorry here the source of patch :  patch proxmox-ve 3.1

so that i want share to day .


check database and table in mysql
September 29, 2013, 4:01 am
Filed under: 2013, database, how to, Internet, IT, Linux, MySQL, server, tutorial | Tags: , , , , , ,

hi all

today i want share tips how to check databases and table in mysql with console .

here i paste from my server

[root@cone logs]# mysqladmin -p create openfire -u root
Enter password:
[root@cone logs]#
[root@cone logs]# mysql -u root -p -r openfire
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 62
Server version: 5.0.95 Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> show databases;
[root@cone logs]#

| Database           |
| information_schema |
| asterisk           |
| asteriskcdrdb      |
| call_center        |
| meetme             |
| mya2billing        |
| mysql              |
| openfire           |
| roundcubedb        |
| sugarcrm           |
| test               |
| vtigercrm521       |
12 rows in set (0.00 sec)

mysql> show tables;
| Tables_in_openfire   |
| ofExtComponentConf   |
| ofGroup              |
| ofGroupProp          |
| ofGroupUser          |
| ofID                 |
| ofMucAffiliation     |
| ofMucConversationLog |
| ofMucMember          |
| ofMucRoom            |
| ofMucRoomProp        |
| ofMucService         |
| ofMucServiceProp     |
| ofOffline            |
| ofPresence           |
| ofPrivacyList        |
| ofPrivate            |
| ofProperty           |
| ofPubsubAffiliation  |
| ofPubsubDefaultConf  |
| ofPubsubItem         |
| ofPubsubNode         |
| ofPubsubNodeGroups   |
| ofPubsubNodeJIDs     |
| ofPubsubSubscription |
| ofRemoteServerConf   |
| ofRoster             |
| ofRosterGroups       |
| ofSASLAuthorized     |
| ofSecurityAuditLog   |
| ofUser               |
| ofUserFlag           |
| ofUserProp           |
| ofVCard              |
| ofVersion            |
34 rows in set (0.00 sec)

mysql> \q;
[root@cone logs]#

missing nslookup in default elastix installer
September 28, 2013, 3:02 am
Filed under: 2013, how to, Internet, IT, Linux, server, tutorial | Tags: , , , , , , , , , , ,

hi all

today i want share my expirence about install software in CentOS 5.9 .

After i finish install leastix 2.4 x86  i missing tool nslookup , this tool help us to query information about domain and other information helpfull.

so bellow  my log in my elastix.

[root@cone etc]# yum install bind-utils
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* addons:
* base:
* commercial-addons:
* elastix-base:
* elastix-extras:
* elastix-updates:
* epel:
* extras:
* updates:
Excluding Packages from CentOS-5 – Addons
Excluding Packages from CentOS-5 – Base
Excluding Packages from CentOS-5 – Extras
Excluding Packages from CentOS-5 – Updates
Setting up Install Process
Resolving Dependencies
–> Running transaction check
—> Package bind-utils.i386 30:9.3.6-20.P1.el5_8.6 set to be updated
–> Processing Dependency: bind-libs = 30:9.3.6-20.P1.el5_8.6 for package: bind-utils
–> Processing Dependency: for package: bind-utils
–> Processing Dependency: for package: bind-utils
–> Processing Dependency: for package: bind-utils
–> Processing Dependency: for package: bind-utils
–> Processing Dependency: for package: bind-utils
–> Processing Dependency: for package: bind-utils
–> Running transaction check
—> Package bind-libs.i386 30:9.3.6-20.P1.el5_8.6 set to be updated
–> Finished Dependency Resolution

Dependencies Resolved

Package                 Arch              Version                             Repository            Size
bind-utils              i386              30:9.3.6-20.P1.el5_8.6              updates              174 k
Installing for dependencies:
bind-libs               i386              30:9.3.6-20.P1.el5_8.6              updates              864 k

Transaction Summary
Install       2 Package(s)
Upgrade       0 Package(s)

Total download size: 1.0 M
Is this ok [y/N]: y
Downloading Packages:
(1/2): bind-utils-9.3.6-20.P1.el5_8.6.i386.rpm                                     | 174 kB     00:00
(2/2): bind-libs-9.3.6-20.P1.el5_8.6.i386.rpm                                      | 864 kB     00:08
Total                                                                     108 kB/s | 1.0 MB     00:09
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing     : bind-libs                                                                          1/2
Installing     : bind-utils                                                                         2/2

bind-utils.i386 30:9.3.6-20.P1.el5_8.6

Dependency Installed:
bind-libs.i386 30:9.3.6-20.P1.el5_8.6

[root@cone etc]#