Tag: database


Setup Metasploit Database

Try reconfigure Metasploit dpkg-reconfigure metasploit-frameworkdpkg-reconfigure metasploit-framework Start postgresql systemctl start postgresql.servicesystemctl start postgresql.service Initialize database msfdb initmsfdb init Run metasploit msfconsolemsfconsole Connect to database db_connect -y /usr/share/metasploit-framework/config/database.ymldb_connect -y /usr/share/metasploit-framework/config/database.yml Rebuild cache db_rebuild_cachedb_rebuild_cache Run postgresql at startup systemctl enable postgresql.servicesystemctl enable postgresql.service

Hacking, Penetration Testing

Exploit Database – a repository for exploits and PoCs

The Exploit Database is an archive of public exploits and corresponding vulnerable software, developed for use by penetration testers and vulnerability researchers. Its aim is to serve as the most comprehensive collection of exploits gathered through direct submissions, mailing lists, and other public sources, and present them in a freely-available and easy-to-navigate database. The Exploit …


List table columns in cakephp 3

List table columns $db = \Cake\Datasource\ConnectionManager::get(’default’); $collection = $db->schemaCollection(); $table= $collection->describe(’tablename’); $columns = $table->columns();$db = \Cake\Datasource\ConnectionManager::get(‘default’); $collection = $db->schemaCollection(); $table= $collection->describe(‘tablename’); $columns = $table->columns();


Sanitize data coming out of the database in cakephp 3

A security measure that most programmers forget to take when building database oriented applications is to sanitize-validate data coming out of the database. Let’s see how can we sanitize our data in cakePHP 3. cakePHP 3 book – Entities Create your Entity for ex. Country: namespace AppModelEntity;   use CakeORMEntity;   class Country extends Entity …

Databases, SQLite

SQLite database manager

SQLiteStudio is a SQLite database manager with the following features: Single executable file – no need to install or uninstall. Binary distribution is just the single, ready to use file. Intuitive interface, All SQLite3 and SQLite2 features wrapped within simple GUI, Cross-platform – runs on Windows 9x/2k/XP/2003/Vista/7, Linux, MacOS X, Solaris, FreeBSD and should work …

Databases, Frameworks, Kohana, MySQL, SQL

Kohana MySQL Database Schema

Kohana 3.3 MySQL Database Schema github CREATE TABLE IF NOT EXISTS `roles` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(32) NOT NULL, `description` VARCHAR(255) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uniq_name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;   INSERT INTO `roles` (`id`, `name`, `description`) VALUES(1, ‘login’, ‘Login privileges, granted after account confirmation’); INSERT INTO …


Connecting MS Access Database in C#

Let’s how we can connect to an MS Access database (accdb) in C#. String _database_path = "path/to/database/file"; String _conn_str = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + _database_path + ";Persist Security Info=False";   //connect OleDbConnection _connection = new OleDbConnection(_conn_str); _connection.Open();   //disconnect _connection.Close();String _database_path = "path/to/database/file"; String _conn_str = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + _database_path + ";Persist Security Info=False"; //connect OleDbConnection …