Oracle List Privileges and Table
SELECT * FROM SESSION_PRIVS;
select * from all_tables where table_name =’…’ ;
select * from user_tables where table_name =’…’
select * from user_tab_privs_recd where table_name = ‘…’;
Ubuntu NTP Ayarları
sudo apt-get update
sudo apt-get install ntp
sudo nano /etc/ntp.conf
# /etc/ntp.conf, configuration for ntpd; see ntp.conf(5) for help
driftfile /var/lib/ntp/ntp.drift
# Enable this if you want statistics to be logged.
#statsdir /var/log/ntpstats/
statistics loopstats peerstats clockstats
filegen loopstats file loopstats type day enable
filegen peerstats file peerstats type day enable
filegen clockstats file clockstats type day enable
# Specify one or more NTP servers.
# Use servers from the NTP Pool Project. Approved by Ubuntu Technical Board
# on 2011-02-08 (LP: #104525). See http://www.pool.ntp.org/join.html for
# more information.
#server 0.ubuntu.pool.ntp.org
#server 1.ubuntu.pool.ntp.org
#server 2.ubuntu.pool.ntp.org
#server 3.ubuntu.pool.ntp.org
server 10.14.20.245
server 10.14.20.246
# Use Ubuntu’s ntp server as a fallback.
server ntp.ubuntu.com
# Access control configuration; see /usr/share/doc/ntp-doc/html/accopt.html for
# details. The web page <http://support.ntp.org/bin/view/Support/AccessRestrictions>
# might also be helpful.
#
# Note that “restrict” applies to both servers and clients, so a configuration
# that might be intended to block requests from certain clients could also end
# up blocking replies from your own upstream servers.
# By default, exchange time with everybody, but don’t allow configuration.
restrict -4 default kod notrap nomodify nopeer noquery
restrict -6 default kod notrap nomodify nopeer noquery
# Local users may interrogate the ntp server more closely.
restrict 127.0.0.1
restrict ::1
# Clients from this (example!) subnet have unlimited access, but only if
# cryptographically authenticated.
#restrict 192.168.123.0 mask 255.255.255.0 notrust
# If you want to provide time to your local subnet, change the next line.
# (Again, the address is an example only.)
#broadcast 192.168.123.255
# If you want to listen to time broadcasts on your local subnet, de-comment the
# next lines. Please do this only if you trust everybody on the network!
#disable auth
#broadcastclient
update-rc.d -f ntp remove
Removing any system startup links for /etc/init.d/ntp …
/etc/rc1.d/K77ntp
/etc/rc2.d/S23ntp
/etc/rc3.d/S23ntp
/etc/rc4.d/S23ntp
/etc/rc5.d/S23ntp
update-rc.d ntp defaults
update-rc.d: warning: default stop runlevel arguments (0 1 6) do not match ntp Default-Stop values (1)
Adding system startup for /etc/init.d/ntp …
/etc/rc0.d/K20ntp -> ../init.d/ntp
/etc/rc1.d/K20ntp -> ../init.d/ntp
/etc/rc6.d/K20ntp -> ../init.d/ntp
/etc/rc2.d/S20ntp -> ../init.d/ntp
/etc/rc3.d/S20ntp -> ../init.d/ntp
/etc/rc4.d/S20ntp -> ../init.d/ntp
/etc/rc5.d/S20ntp -> ../init.d/ntp
root@myserver:~# service ntp status
* NTP server is running
root@myserver:~# service ntp restart
Kaynak : Özgür Tuğrul’a teşekkürler.
Ubuntu Linux IP DNS Ayarları
sudo nano /etc/network/interfaces
# This file describes the network interfaces available on your system
# and how to activate them. For more information, see interfaces(5).
# The loopback network interface
auto lo
iface lo inet loopback
# The primary network interface
auto eth0
iface eth0 inet static
address 10.1.20.244
netmask 255.255.255.0
network 10.1.20.0
broadcast 10.1.20.255
gateway
# dns-* options are implemented by the resolvconf package, if installed
dns-nameservers 8.8.8.8 8.8.4.4
ifdown eth0
ifup eth0
Ubuntu Linux JDK8 Kurulumu
$ sudo add-apt-repository ppa:webupd8team/java $ sudo apt-get update $ sudo apt-get install oracle-java8-installer mtezgider@mtezgider:~$ java -version java version "1.8.0_66" Java(TM) SE Runtime Environment (build 1.8.0_66-b17) Java HotSpot(TM) 64-Bit Server VM (build 25.66-b17, mixed mode)
sudo apt-get install oracle-java8-set-default
Java PKIX path building failed Çözümü
“javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed:”
Javada https kullanan bir web servisine client yazarken “Java PKIX path building failed ” hatasıyla karşılaştım. Araştırmalarım sonucundan bilgisayarımın sertifikayı tanımamasından kaynakladığının farkına vardım. Bunun çözümünü aşağıdaki şekilde gerçekleştirdim.
1. Adım keytool aracının bilgisayarımıza kurulu olması gerekmektedir. keytool aracını indirip kuruyoruz
2.Bağlanacağımız web servisin https adresine gidiyoruz. Chrome tarayıca https taryıcı sertifika alanına tıklayıp sertifikayı cer uzantılı olarak kaydediyoruz.
3.Java Store içine sertifakayı aşağıdaki şekilde aktarıyoruz
cmd yi yönetici olarak çalıştırıyoruz.
keytool -import -alias alias -keystore path-to-jre/lib/security/cacerts -file path-to-certificate-file
örnek:
keytool -import -alias sunas -keystore “C:\Program Files\Java\jdk1.7.0_71\jre\lib\security\cacerts” -file C:\Users\Murat\Desktop\yoksis.cer
Şifre isterse varsayılan şifre : changeit olur.
Linux Postgres 9.1 Kurulumu
Kurulum için
sudo apt-get install postgresql-9.1 sudo apt-get install pgadmin3
Varsayılan şifreyi değiştirme
1.Yöntem
sudo -u postgres psql postgres=> alter user postgres password 'benimsifrem'; postgres=> create user yerusername createdb createuser password 'somepass'; postgres=> create database yerusername owner yerusername; postgres=> \q
2. Yöntem
sudo passwd postgres
Hadoop Kurulumu Video Anlatım
1- Download the JDK from Oracle: JDK 7.xx
2- Extract the contents:
tar xvf jdk-7u4-linux-x64.tar.gz
java.lang.IllegalStateException: PWC3999: Cannot create a session after the response has been committed çözümü
java.lang.IllegalStateException: PWC3999: Cannot create a session after the response has been committed problemine javascript değişkenine json verisini set ederken karşılaştım.
Çözüm:
<dependency>
<groupId>org.glassfish</groupId>
<artifactId>javax.faces</artifactId>
<version>2.1.8</version>
</dependency>
/glassfish/modules altına javax.faces 2.1.8.jar kütüphanesini javax.faces.jar ile güncellediğimde problem çözüldü.
Create a new LineString from joint two LineString
SELECT ST_AsText(ST_MakeLine(g.x,g2.y)) from (select st_astext(geom)as x from deneme where id=1) as g, (select st_astext(geom)as y from deneme where id=2) as g2;
sonuç : linestring(1,2,3,5) + linestring(4,2,2,5)= linestring(1,2,3,5,4,2,2,5)