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=;”
.Open()
End With
End Sub

source original :

http://bit.ly/2fJZsOq

 



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 180.131.144.144  and 180.131.145.145
  2. Verisign IPv4 64.6.64.6   and   64.6.65.6  IPv6 2620:74:1b::1:1  and  2620:74:1c::2:2
  3. Google IPv4 8.8.8.8  and  8.8.4.4   IPv6 2001:4860:4860::8888 and 2001:4860:4860::8844
  4. OpenDNS IPv4 208.67.222.222  and 208.67.220.220
  5. Dyn  IPv4 216.146.35.35    and 216.146.36.36
  6.  Hurricane Electric IPv4 74.82.42.42  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
    root@puppet:/home/icon/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 http://docs.puppetlabs.com/pe/20                                                                                        15.2/

    ——————————————————————————–

    STEP 1: GUIDED INSTALLATION

    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
    (http://docs.puppetlabs.com/pe/2015.2/install_automated.html), 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 https://puppet.leschaco.id:3000 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
    eerror-httpseerror-https-detailsinstalle-web2

  • 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/puppet-enterprise-2015.2.0-ubuntu-14.04-amd64#
installe-web6

root@puppet:/home/icon# nmap localhost

Starting Nmap 6.40 ( http://nmap.org ) at 2015-08-11 10:35 WIB
Nmap scan report for localhost (127.0.0.1)
Host is up (0.000013s latency).
Other addresses for localhost (not scanned): 127.0.0.1
Not shown: 994 closed ports
PORT     STATE SERVICE
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
root@puppet:/home/icon#

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

puppetwebpuppetweb2puppetweb3puppetweb4

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.

(more…)



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
root@karedox:/home/pupet#

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
root@karedox:/home/pupet#
3. Edit apache2 configuration
root@karedox:/home/pupet# vi /etc/apache2/apache2.conf
<Directory /var/www/>
Options Indexes FollowSymLinks
AllowOverride None
Require all granted
</Directory>
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
</Directory>

Then restart apache2

root@karedox:/home/pupet# apache2ctl restart
root@karedox:/home/pupet#

and you can test  at browse

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

 

http://sonjaya.web.id/?p=162



Make own POP3 Client with Delphi

here little example of POP3 Client with delphi.

The basic was from http://www.delphi-treff.de/tutorials/netzwerk-und-internet/indy/pop3-tidpop3/  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 http://indy.fulgan.com/SSL/Archive/indy_openssl096.zip

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 www.proxmox.com 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

2.do  this in your terminal

#wget http://www.tolaris.com/blog/wp-content/uploads/2013/08/no_subscription_popup_pvemanagerlib.js-3.1.patch -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
owners.

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

mysql> show databases;
Bye
[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;
Bye
[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: centos.biz.net.id
* base: centos.biz.net.id
* commercial-addons: elastix.vozbox.mx
* elastix-base: elastix.vozbox.mx
* elastix-extras: elastix.vozbox.mx
* elastix-updates: elastix.vozbox.mx
* epel: mirror.smartmedia.net.id
* extras: centos.biz.net.id
* updates: centos.biz.net.id
Excluding Packages from CentOS-5 – Addons
Finished
Excluding Packages from CentOS-5 – Base
Finished
Excluding Packages from CentOS-5 – Extras
Finished
Excluding Packages from CentOS-5 – Updates
Finished
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: libdns.so.26 for package: bind-utils
–> Processing Dependency: libisccfg.so.1 for package: bind-utils
–> Processing Dependency: libbind9.so.0 for package: bind-utils
–> Processing Dependency: liblwres.so.9 for package: bind-utils
–> Processing Dependency: libisc.so.15 for package: bind-utils
–> Processing Dependency: libisccc.so.0 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
==========================================================================================================
Installing:
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

Installed:
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

Complete!
[root@cone etc]#