Ivorde Unix/Linux/Database/Web/Mail Forum

View unanswered posts
View active topics
It is currently Sat Feb 04, 2012 11:19 pm


News News of Ivorde Unix/Linux/Database/Web/Mail Forum

Site map of Ivorde Unix/Linux/Database/Web/Mail Forum » Forum : Ivorde Unix/Linux/Database/Web/Mail Forum

Welcome to ivorde.ro forum

 [ Total topics 139 Go to page 1, 2, 3, 4, 5, 6, 7 ... 14

Message
 Post subject: MySql drop unique key/index/constraint
PostPosted: Thu Feb 03, 2011 1:19 am 
To find out what unique indexes are in a table issue:
Code:
mysql> SHOW CREATE TABLE table_name
...
  UNIQUE KEY `unique_user` (`user`),
...


In the above case, there is a unique index / key named 'unique_user' on 'user' column.

To drop the unique key run:
Code:
mysql> ALTER TABLE table_name DROP INDEX unique_user;
Query OK, 6 rows affected (0.05 sec)
Records: 6  Duplicates: 0  Warnings: 0


Read more : MySql drop unique key/index/constraint | Views : 1925 | Replies : 1 | Forum : Mysql

Top
 Post subject: MySql rename table
PostPosted: Thu Feb 03, 2011 1:15 am 
To rename a mysql table from old_name to new_name, command is:
Quote:
mysql> RENAME TABLE old_name TO new_name

Read more : MySql rename table | Views : 327 | Replies : 2 | Forum : Mysql

Top
 Post subject: FreeBSD PF supported icmp types
PostPosted: Fri Jan 28, 2011 4:15 pm 
Here are the ICMP types supported by FreeBSD / OpenBSD PF firewall:

Here is the pf.conf syntax for allowing icmp packets:
Code:
icmp_types="{ echoreq, unreach}"
pass in log on $ext_if1 inet proto icmp from any to $dmz_net icmp-type $icmp_types keep state #queue icmp

And below is a list of supported icmp types:
Quote:
"net-unr",
"host-unr",
"proto-unr",
"port-unr",
"needfrag",
"srcfail",
"net-unk",
"host-unk",
"isolate",
"net-prohib",
"host-prohib",
"net-tos",
"host-tos",
"filter-prohib",
"host-preced",
"cutoff-preced",
"redir-net",
"redir-host",
"redir-tos-net",
"redir-tos-host",
"normal-adv", ...

Read more : FreeBSD PF supported icmp types | Views : 688 | Replies : 0 | Forum : TCP/IP Networking

Top
 Post subject: How Does OSPF Neighbor State Change
PostPosted: Thu Jan 20, 2011 11:53 am 
Q1. What are OSPF packets? What do they do?
Answer: There are 5 OSPF packets:
Hello: Discover neighbors.
DD (Data Description): Exchange LSDB catalog (LSA headers).
Request: Ask neighbor to send LSA that I don't have.
Update: Send LSA requested by neighbors.
Ack: Tell Update sending router that I have received your Update.
Q2: What are neighbor states? What do they do?
Answer: There are 7 states:
Down. Neighbor is gone. E.g. neighbor is down, ...

Read more : How Does OSPF Neighbor State Change | Views : 889 | Replies : 1 | Forum : TCP/IP Networking

Top
 Post subject: OSPF Simulation Tutorial for Beginners (Interactive, Visual)
PostPosted: Thu Jan 20, 2011 11:51 am 
OSPF is a complex protocol. To help beginners grasp abstract its concepts, a different approach is taken -- Visualizing OSPF simulation. This tutorial, OSPF basic, simulates the basic OSPF activities on a simple topology: H1-R1-R2-H2. R1 and R2 are routers. H1 and H2 are hosts. This simulation shows 4 stages:
1) R1 and R2 are not running OSPF. H1 ping H2. It fails.
2) Start OSPF on two routers. R1 and R2 discover each other ...

Read more : OSPF Simulation Tutorial for Beginners (Interactive, Visual) | Views : 885 | Replies : 0 | Forum : TCP/IP Networking

Top
 Post subject: Re: Search engine optimization
PostPosted: Sun Jan 30, 2011 6:01 pm 
You can try Indian seo company for this. India seo company do seo at responsible price.


http://www.creativecreationsite.com

Read more : Re: Search engine optimization | Views : 384 | Replies : 0 | Forum : Apache, Nginx, Lighttpd and other web server software

Top
 Post subject: Linux - Unable to login (and authentication succeeds) - File size limit exceeded
PostPosted: Fri Oct 08, 2010 5:22 pm 
This is most probably because of the /var/log/wtmp file which, if it goes over ~4.5GB, getty processes will not be able to create virtual terminals and all sorts of login problems from here on (sshd, telnet and so on).

Read more : Linux - Unable to login (and authentication succeeds) - File size limit exceeded | Views : 932 | Replies : 3 | Forum : Tutorials for general Unix

Top
 Post subject: "checking for libnet_build_ip in -lnet... no"+"ERROR! Libnet library not found"
PostPosted: Fri Sep 24, 2010 11:08 am 
It can happen that nemesis installation to fail because the configure script cannot find libnet. THis is not nemesis's fault, it's the admin's fault (mine and yours :D ).
Nemesis configure script error:
Quote:
checking for an ANSI C-conforming const... yes
checking for gawk... (cached) gawk
checking for a BSD-compatible install... /usr/bin/install -c
checking whether ln -s works... yes
checking for fabs in -lm... yes
checking for ...

Read more : "checking for libnet_build_ip in -lnet... no"+"ERROR! Libnet library not found" | Views : 1507 | Replies : 1 | Forum : Package and Software Management

Top
 Post subject: CentOS Install Nemesis packet crafting tool + Libnet
PostPosted: Fri Sep 24, 2010 11:00 am 
You can download Nemesis tool from http://nemesis.sourceforge.net/ and libnet library from http://code.google.com/p/ips-builder/downloads/detail?name=libnet-1.0.2a.tar.gz&can=2&q=

Untar Libnet first and enter the directory:
Code:
$ ./configure
...
$ sudo make && make install


make sure your PATH variable contains the directory where libnet-config is. (after installing libnet, it should be in /usr/lib)
Install nemesis:
Code:
$ ./configure
...
$ sudo make && make install


Now Nemesis is ready to use.

Read more : CentOS Install Nemesis packet crafting tool + Libnet | Views : 1562 | Replies : 1 | Forum : Server and Network Security

Top
 Post subject: ffmpeg: error while loading shared libraries: libavdevice.so.52: cannot open shared object file: No
PostPosted: Fri Aug 27, 2010 2:10 pm 
ffmpeg: error while loading shared libraries: libavdevice.so.52: cannot open shared object file: No such file or directory

After installling ffmpeg on CentOS 4.8 the above error apears when running ffmpeg for the first time.
Code:
# ffmpeg
ffmpeg: error while loading shared libraries: libavdevice.so.52: cannot open shared object file: No such file or directory

Running ldd utility shows that ffmpeg binary is dynamically linked to libraries which cannot be found:
# ldd `which ffmpeg`
libavdevice.so.52 => ...

Read more : ffmpeg: error while loading shared libraries: libavdevice.so.52: cannot open shared object file: No | Views : 7345 | Replies : 0 | Forum : Package and Software Management

Top
 [ Total topics 139 Go to page 1, 2, 3, 4, 5, 6, 7 ... 14


Last 10 active topics


Package and Software Management

No new posts FreeBSD list files installed by a specific software package - "pkg_info -L"
View the latest post
No new posts FeeBSD list installed software packages with pkg_info
View the latest post
No new posts Can't compile ssldump on FreeBSD 6 - compile fails
View the latest post

VPNs

No new posts FreeBSD to FreeBSD - OSPF over GRE over Ipsec transport mode (racoon) - Part 1
View the latest post

TCP/IP Networking

No new posts How Does OSPF Neighbor State Change
View the latest post

BSD Operating Systems

No new posts Changing man path when having multiple man files from daemons with the same name
View the latest post

Mysql

No new posts MySql drop unique key/index/constraint
View the latest post

Datacenter Magazine

No new posts DATA CENTER - Storage & Backup
View the latest post

Networking

No new posts Ivorde DNS & Network Tools
View the latest post

Tutorials for general Unix

No new posts Fix shell terminal after cat-ing a binary or echoing some encrypted content
View the latest post

Login

Username:   Password:   Log me on automatically each visit  

Statistics

Statistics

Total posts 188 | Total topics 681 | Total members 811



News News Site map Site map SitemapIndex SitemapIndex RSS Feed RSS Feed Channel list Channel list


Delete all board cookies | The team | All times are UTC + 2 hours [ DST ]

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
DAJ Glass 2 template created by Dustin Baccetti

phpBB SEO