Monday, December 21, 2015

Perform SSH Login Without Password Using ssh-keygen & ssh-copy-id

Step 1: Create public and private keys using ssh-key-gen on local-host

goldenjohn@local-host$ [Note: You are on local-host here]

goldenjohn@local-host$ ssh-keygen
Generating public/private rsa key pair.
Enter file in which to save the key (/home/goldenjohn/.ssh/id_rsa):[Enter key]
Enter passphrase (empty for no passphrase): [Press enter key]
Enter same passphrase again: [Pess enter key]
Your identification has been saved in /home/goldenjohn/.ssh/id_rsa.
Your public key has been saved in /home/goldenjohn/.ssh/
The key fingerprint is:
33:b3:fe:af:95:95:18:11:31:d5:de:96:2f:f2:35:f9 goldenjohn@local-host
Step 2: Copy the public key to remote-host using ssh-copy-id

goldenjohn@local-host$ ssh-copy-id -i ~/.ssh/ remote-host
goldenjohn@remote-host's password:
Now try logging into the machine, with "ssh 'remote-host'", and check in:


to make sure we haven't added extra keys that you weren't expecting.
Note: ssh-copy-id appends the keys to the remote-host’s .ssh/authorized_key.

Step 3: Login to remote-host without entering the password

goldenjohn@local-host$ ssh remote-host
Last login: Sun Nov 16 17:22:33 2008 from
[Note: SSH did not ask for password.]

goldenjohn@remote-host$ [Note: You are on remote-host here]

The above 3 simple steps should get the job done in most cases
    That it , please carry on ...with smiles..

Saturday, December 19, 2015

Installion of Snipe-IT on CentOS 7.2 with MariaDB

I have installed a Centos 7.1 with Server GUI installation this is included all the packages , after that I upgraded to Centos 7.2 “yum update”

Figure : 1

Follow the command to be executed on the installation very carefully ,

[root@inventory ~]# cat /etc/redhat-release
CentOS Linux release 7.2.1511 (Core)
[root@inventory ~]# cat /etc/rc.local
# It is highly advisable to create own systemd services or udev rules
# to run scripts during boot instead of using this file.
# In contrast to previous versions due to parallel execution during boot
# this script will NOT be run after all other services.
# Please note that you must run 'chmod +x /etc/rc.d/rc.local' to ensure
# that this script will be executed during boot.

touch /var/lock/subsys/local
setenforce 0
[root@inventory ~]# yum -y install epel-release
Loaded plugins: fastestmirror, langpacks
base                                                                                                                                   | 3.6 kB  00:00:00    
extras                                                                                                                                 | 3.4 kB  00:00:00    
updates                                                                                                                                | 3.4 kB  00:00:00    
Loading mirror speeds from cached hostfile
 * base:
 * extras:
 * updates:
Resolving Dependencies
--> Running transaction check
---> Package epel-release.noarch 0:7-5 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

 Package                                    Arch                                 Version                           Repository                            Size
 epel-release                               noarch                               7-5                               extras                                14 k

Transaction Summary
Install  1 Package

Total download size: 14 k
Installed size: 24 k
Downloading packages:
epel-release-7-5.noarch.rpm                                                                                                            |  14 kB  00:00:01    
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : epel-release-7-5.noarch                                                                                                                    1/1
  Verifying  : epel-release-7-5.noarch                                                                                                                    1/1

  epel-release.noarch 0:7-5                                                                                                                                  

[root@inventory ~]# mkdir -p /var/www/html; cd /var/www/html/
[root@inventory html]# wget && chmod 744 && ./
--2015-12-19 06:19:25--
Resolving (
Connecting to (||:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 240 [text/plain]
Saving to: ‘’

100%[====================================================================================================================>] 240         --.-K/s   in 0s     

2015-12-19 06:19:27 (25.2 MB/s) - ‘’ saved [240/240]

--2015-12-19 06:19:27--
Resolving (
Connecting to (||:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 19942 (19K) [text/plain]
Saving to: ‘’

100%[====================================================================================================================>] 19,942      --.-K/s   in 0.001s 

2015-12-19 06:19:27 (19.2 MB/s) - ‘’ saved [19942/19942]


                   _____       _                  __________
                  / ___/____  (_)___  ___        /  _/_  __/
                  \__ \/ __ \/ / __ \/ _ \______ / /  / /
                 ___/ / / / / / /_/ /  __/_____// /  / /
                /____/_/ /_/_/ .___/\___/     /___/ /_/

  Welcome to Snipe-IT Inventory Installer for Centos and Debian!

  The installer has detected centos7 as the OS.
  Q. What is the FQDN of your server? (inventory):
     Setting to inventory

  Q. Do you want me to automatically create the snipe database user password? (y/n) y

##  Add IUS, epel-release and mariaDB repos.
##  Installing PHP and other needed stuff
 ## httpd Installed
 ## mariadb-server Installed
 ## git Installed
 ## unzip Installed
 ## php56u Installing...
 ## php56u-mysqlnd Installing...
 ## php56u-bcmath Installing...
 ## php56u-cli Installed
 ## php56u-common Installed
 ## php56u-embedded Installing...
 ## php56u-gd Installing...
 ## php56u-mbstring Installing...
 ## php56u-mcrypt Installing...
 ## php56u-ldap Installing...

##  Downloading Snipe-IT from github and put it in the web directory.
##  Starting the mariaDB server.
Created symlink from /etc/systemd/system/ to /usr/lib/systemd/system/mariadb.service.
##  Input your MySQL/MariaDB root password
##  Securing mariaDB server.

/usr/bin/mysql_secure_installation: line 379: find_mysql_client: command not found


In order to log into MariaDB to secure it, we'll need the current
password for the root user.  If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.

Set root password? [Y/n] Y

(Before set the root password you need to record your root password for your reference)

New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
 ... Success!

By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] n
 ... skipping.

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] n
 ... skipping.

By default, MariaDB comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] n
 ... skipping.

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] Y
 ... Success!

Cleaning up...

All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!
##  Creating the new virtual host in Apache.
##  Setting up hosts file.
##  Starting the apache server.
Created symlink from /etc/systemd/system/ to /etc/systemd/system/httpd.service.
##  Modifying the Snipe-IT files necessary for a production environment.
                Setting up Timezone.
                Setting up bootstrap file.
                Setting up database file.
                Setting up app file.
                Setting up mail file.
#!/usr/bin/env php
All settings correct for using Composer

Composer successfully installed to: /var/www/html/snipeit/composer.phar
Use it: php composer.phar
Loading composer repositories with package information
Installing dependencies from lock file
  - Installing symfony/event-dispatcher (2.8.x-dev 0ef7669)
    Cloning 0ef7669c0af9f62752a96a5d43c1b13c5c2e70e9

  - Installing guzzle/guzzle (dev-master b3f5050)
    Cloning b3f5050cb6270c7a728a0b74ac2de50a262b3e02

  - Installing aws/aws-sdk-php (2.8.x-dev 92642ca)
    Cloning 92642ca4906e6681a1301971cf41500d7c68581c

  - Installing symfony/finder (2.5.x-dev e527ebf)
    Cloning e527ebf47ff912a45e148b7d0b107b80ec0b3cc2

  - Installing symfony/var-dumper (2.8.x-dev 86ae8aa)
    Cloning 86ae8aa7f062c24db75e0a273827d59fde8e409c

  - Installing psr/log (dev-master 9e45edc)
    Cloning 9e45edca52cc9c954680072c93e621f8b71fab26

  - Installing maximebf/debugbar (dev-master 6812102)
    Cloning 6812102772144c85cfe7702d4decfedc12200b9d

  - Installing symfony/translation (2.5.x-dev 165b534)
    Cloning 165b5348cd20f8c4b2fcf1097c9c8300d1093b90

  - Installing symfony/security-core (2.5.x-dev 3a27d7b)
    Cloning 3a27d7b34ee62cb0fdf5ad970e7777912ef4722f

  - Installing symfony/routing (2.5.x-dev 46142c3)
    Cloning 46142c34ea830f47429df6e15faec3a33292d618

  - Installing symfony/process (2.5.x-dev 00a1308)
    Cloning 00a1308e8b5aec5eba7c8f1708426a78f929be8c

  - Installing symfony/http-foundation (2.5.x-dev 08e7838)
    Cloning 08e783861dd9579bac4092814bbfb0cae6666b65

  - Installing symfony/debug (2.5.x-dev ed30195)
    Cloning ed3019589cdadf32c521d1e181f9d72955645c67

  - Installing symfony/http-kernel (2.5.x-dev 3165238)
    Cloning 31652385d94eafc2103a98435d6d5bd7eea61736

  - Installing symfony/dom-crawler (2.5.x-dev 3860edc)
    Cloning 3860edcf7ff7e173cfe2151f0d425e610e77cc35

  - Installing symfony/css-selector (2.5.x-dev d45b306)
    Cloning d45b306421462295e76b94bcf76b963867450327

  - Installing symfony/console (2.5.x-dev a43e750)
    Cloning a43e750b4c74f3bdfca77c79c343033d35a6cd6e

  - Installing symfony/browser-kit (2.5.x-dev b2b78b8)
    Cloning b2b78b850a32251cbbd9915ab61453302e7ecd72

  - Installing swiftmailer/swiftmailer (5.x-dev 6522539)
    Cloning 6522539daf0a7bdada1cc2dccb7ec37dc0712136

  - Installing stack/builder (dev-master 14afc80)
    Cloning 14afc80a5bd9dc160470e3131b697f7d0c070729

  - Installing predis/predis (0.8.x-dev 192dfd6)
    Cloning 192dfd61e54c3d32c9526bba03365fff818e17e4

  - Installing phpseclib/phpseclib (0.3.10)
    Cloning d15bba1edcc7c89e09cc74c5d961317a8b947bf4

  - Installing patchwork/utf8 (dev-master 927caed)
    Cloning 927caedc65ec4f139e9d43fd2589a19a336babc3

  - Installing nesbot/carbon (1.17.0)
    Cloning a1dd1ad9abfc8b3c4d8768068e6c71d293424e86

  - Installing monolog/monolog (1.17.1)
    Cloning 0524c87587ab85bc4c2d6f5b41253ccb930a5422

  - Installing nikic/php-parser (0.9.x-dev ef70767)
    Cloning ef70767475434bdb3615b43c327e2cae17ef12eb

  - Installing jeremeamia/superclosure (1.0.x-dev 4d89ca7)
    Cloning 4d89ca74994feab128ea46d5b3add92e6cb84554

  - Installing ircmaxell/password-compat (1.0.x-dev 9b99377)
    Cloning 9b99377557a33a4129c9194e60a97a685fab21e0

  - Installing filp/whoops (1.1.7)
    Cloning 72538eeb70bbfb11964412a3d098d109efd012f7

  - Installing d11wtq/boris (v1.0.8)
    Cloning 125dd4e5752639af7678a22ea597115646d89c6e

  - Installing symfony/filesystem (2.8.x-dev 287fc0b)
    Cloning 287fc0b1dcb11ff729eeefc20441c08eaf628f29

  - Installing classpreloader/classpreloader (1.0.2)
    Cloning 2c9f3bcbab329570c57339895bd11b5dd3b00877

  - Installing laravel/framework (v4.2.17)
    Cloning 3359de6d6cd322e8a1b251c2f8d9dd42a3e4e232

  - Installing barryvdh/laravel-debugbar (1.8.x-dev 8833c88)
    Cloning 8833c88c40f840de9bfaf71247ffdfb341c0d390

  - Installing cartalyst/sentry (v2.1.5)
    Cloning 0ae4158353e41cc4061631c86c1cddd67c1f23be

  - Installing chumper/datatable (2.3)
    Cloning cff842783f3f4af60c2be295435b2bd812510ef5

  - Installing chumper/zipper (0.5.1)
    Cloning d1ab536b4de2c313cd1c28ea01f5bcefbad33610

  - Installing doctrine/lexer (dev-master 83893c5)
    Cloning 83893c552fd2045dd78aef794c31e694c37c0b8c

  - Installing doctrine/annotations (dev-master f25c8aa)
    Cloning f25c8aab83e0c3e976fd7d19875f198ccf2f7535

  - Installing doctrine/cache (dev-master dd47003)
    Cloning dd47003641aa5425820c0ec8a6f4a85e7412ffcd

  - Installing doctrine/collections (dev-master 866e100)
    Cloning 866e100a425b8b73d15393fd081c6bf067f05bf9

  - Installing doctrine/inflector (dev-master 3a422c7)
    Cloning 3a422c73f7bc556d39571f436b61fd58ccae0eb0

  - Installing doctrine/common (dev-master 9f35e74)
    Cloning 9f35e74fcbe9011b660e0b423e98c83b7a8699c0

  - Installing doctrine/dbal (v2.4.2)
    Cloning fec965d330c958e175c39e61c3f6751955af32d0

  - Installing erusev/parsedown (dev-master fa005fd)
    Cloning fa005fdb954330ae6dccb3bb59481da0172d397e

  - Installing fideloper/proxy (2.1.1)
    Cloning a0ec0f35c82dceecc0d8975f29e6e8e85acbd419

  - Installing react/promise (v2.2.1)
    Cloning 3b6fca09c7d56321057fa8867c8dbe1abf648627

  - Installing guzzlehttp/streams (dev-master d1f8a6c)
    Cloning d1f8a6c55f0f753cfd6f6755856473eb02cedb19

  - Installing guzzlehttp/ringphp (dev-master 9465032)
    Cloning 9465032ac5d6beaa55f10923403e6e1c36018d9c

  - Installing psr/http-message (dev-master 85d6369)
    Cloning 85d63699f0dbedb190bbd4b0d2b9dc707ea4c298

  - Installing guzzlehttp/psr7 (1.2.0)
    Cloning 4ef919b0cf3b1989523138b60163bbcb7ba1ff7e

  - Installing intervention/image (dev-master 44c9a6b)
    Cloning 44c9a6bb292e50cf8a1e4b5030c7954c2709c089

  - Installing league/csv (dev-master 640f57a)
    Cloning 640f57af7abb41d51673cd860041979623cee423

  - Installing guzzlehttp/guzzle (5.3.0)
    Cloning f3c8c22471cb55475105c14769644a49c3262b93

  - Installing maknz/slack (dev-master c8ed3e4)
    Cloning c8ed3e4f919358af43516e7ab8d7fa39d3d2f736

  - Installing aws/aws-sdk-php-laravel (1.0.x-dev ce9a9b5)
    Cloning ce9a9b5144d16c9bebda23f41c2dfc7f8da38471

  - Installing schickling/backup (0.6.0)
    Cloning 5243dc1d9b11390e1eb58202fd07dc3829b1bbe0

  - Installing symfony/config (2.8.x-dev a1e8e51)
    Cloning a1e8e51ed2d591bb1827d04fd1d320cd4f03e5fe

  - Installing symfony/stopwatch (2.8.x-dev 53219df)
    Cloning 53219df2141bab8c9eeabf23e0c508f0b1477ef6

  - Installing symfony/yaml (2.8.x-dev d196cb1)
    Cloning d196cb1ac36901bde7d7fbed74ee31fdb85fd119

  - Installing tecnickcom/tc-lib-color (dev-master 3e1268d)
    Cloning 3e1268d4cc95f55bbe81eac5507c02dccafcb370

  - Installing tecnickcom/tc-lib-barcode (dev-master 3d76d63)
    Cloning 3d76d63b8a622a67664ec60a13d9c33189721784

Generating autoload files
{"error":{"type":"ErrorException","message":"date_default_timezone_set(): Timezone ID '' is invalid","file":"\/var\/www\/html\/snipeit\/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/start.php","line":167}}
  ***If you want mail capabilities, open /var/www/html/snipeit/app/config/production/mail.php and fill out the attributes***

  ***Open http://inventory to login to Snipe-IT.***

##  Cleaning up...
##  Done!

After that you need to follow the below execution command in terminal

cd  snipeit
vi  app/config/app.php

Open it and “line #16 change the time zone to ‘America/Los_Angeles’, find the below reference


return array(

    | Application Timezone
    | Here you may specify the default timezone for your application, which
    | will be used by the PHP date and date-time functions. We have gone
    | ahead and set this to a sensible default for you out of the box.

    'timezone' => 'America/Los_Angeles',

Now we just have to do one final step to get everything configured and running. Just run this command to configure your first user:

php artisan  app:install           (In the path of /var/www/html/snipeit)

[root@inventory html]#
[root@inventory html]# cd snipeit/
[root@inventory snipeit]#
[root@inventory snipeit]# vi app/config/app.php
[root@inventory snipeit]# php artisan app:install

  Step: 1

    Please follow the following
    instructions to create your
    default user.


Please enter your first name: golden
Please enter your last name: john
Please enter your username: goldenjohn51
Please enter your email:
Please enter your user password (at least 8 characters):
Please confirm your user password:
Do you want to seed your database with dummy data? y/N (default is no): y


  Step: 2

    Preparing your Application


Application key [NtLAxUpL3p4ydWdKTrXcuNeI1MrHL5yi] set successfully.
Migration table created successfully.
Migrated: 2012_12_06_225921_migration_cartalyst_sentry_install_users
Migrated: 2012_12_06_225929_migration_cartalyst_sentry_install_groups
Migrated: 2012_12_06_225945_migration_cartalyst_sentry_install_users_groups_pivot
Migrated: 2012_12_06_225988_migration_cartalyst_sentry_install_throttle
Migrated: 2013_03_23_193214_update_users_table
Migrated: 2013_11_13_075318_create_models_table
Migrated: 2013_11_13_075335_create_categories_table
Migrated: 2013_11_13_075347_create_manufacturers_table
Migrated: 2013_11_15_015858_add_user_id_to_categories
Migrated: 2013_11_15_112701_add_user_id_to_manufacturers
Migrated: 2013_11_15_190327_create_assets_table
Migrated: 2013_11_15_190357_create_licenses_table
Migrated: 2013_11_15_201848_add_license_name_to_licenses
Migrated: 2013_11_16_040323_create_depreciations_table
Migrated: 2013_11_16_042851_add_depreciation_id_to_models
Migrated: 2013_11_16_084923_add_user_id_to_models
Migrated: 2013_11_16_103258_create_locations_table
Migrated: 2013_11_16_103336_add_location_id_to_assets
Migrated: 2013_11_16_103407_add_checkedout_to_to_assets
Migrated: 2013_11_16_103425_create_history_table
Migrated: 2013_11_17_054359_drop_licenses_table
Migrated: 2013_11_17_054526_add_physical_to_assets
Migrated: 2013_11_17_055126_create_settings_table
Migrated: 2013_11_17_062634_add_license_to_assets
Migrated: 2013_11_18_134332_add_contacts_to_users
Migrated: 2013_11_18_142847_add_info_to_locations
Migrated: 2013_11_18_152942_remove_location_id_from_asset
Migrated: 2013_11_18_164423_set_nullvalues_for_user
Migrated: 2013_11_19_013337_create_asset_logs_table
Migrated: 2013_11_19_061409_edit_added_on_asset_logs_table
Migrated: 2013_11_19_062250_edit_location_id_asset_logs_table
Migrated: 2013_11_20_055822_add_soft_delete_on_assets
Migrated: 2013_11_20_121404_add_soft_delete_on_locations
Migrated: 2013_11_20_123137_add_soft_delete_on_manufacturers
Migrated: 2013_11_20_123725_add_soft_delete_on_categories
Migrated: 2013_11_20_130248_create_status_labels
Migrated: 2013_11_20_130830_add_status_id_on_assets_table
Migrated: 2013_11_20_131544_add_status_type_on_status_labels
Migrated: 2013_11_20_134103_add_archived_to_assets
Migrated: 2013_11_21_002321_add_uploads_table
Migrated: 2013_11_21_024531_remove_deployable_boolean_from_status_labels
Migrated: 2013_11_22_075308_add_option_label_to_settings_table
Migrated: 2013_11_22_213400_edits_to_settings_table
Migrated: 2013_11_25_013244_create_licenses_table
Migrated: 2013_11_25_031458_create_license_seats_table
Migrated: 2013_11_25_032022_add_type_to_actionlog_table
Migrated: 2013_11_25_033008_delete_bad_licenses_table
Migrated: 2013_11_25_033131_create_new_licenses_table
Migrated: 2013_11_25_033534_add_licensed_to_licenses_table
Migrated: 2013_11_25_101308_add_warrantee_to_assets_table
Migrated: 2013_11_25_104343_alter_warranty_column_on_assets
Migrated: 2013_11_25_150450_drop_parent_from_categories
Migrated: 2013_11_25_151920_add_depreciate_to_assets
Migrated: 2013_11_25_152903_add_depreciate_to_licenses_table
Migrated: 2013_11_26_211820_drop_license_from_assets_table
Migrated: 2013_11_27_062510_add_note_to_asset_logs_table
Migrated: 2013_12_01_113426_add_filename_to_asset_log
Migrated: 2013_12_06_094618_add_nullable_to_licenses_table
Migrated: 2013_12_10_084038_add_eol_on_models_table
Migrated: 2013_12_12_055218_add_manager_to_users_table
Migrated: 2014_01_28_031200_add_qr_code_to_settings_table
Migrated: 2014_02_13_183016_add_qr_text_to_settings_table
Migrated: 2014_05_24_093839_alter_default_license_depreciation_id
Migrated: 2014_05_27_231658_alter_default_values_licenses
Migrated: 2014_06_19_191508_add_asset_name_to_settings
Migrated: 2014_06_20_004847_make_asset_log_checkedout_to_nullable
Migrated: 2014_06_20_005050_make_asset_log_purchasedate_to_nullable
Migrated: 2014_06_24_003011_add_suppliers
Migrated: 2014_06_24_010742_add_supplier_id_to_asset
Migrated: 2014_06_24_012839_add_zip_to_supplier
Migrated: 2014_06_24_033908_add_url_to_supplier
Migrated: 2014_07_08_054116_add_employee_id_to_users
Migrated: 2014_07_09_134316_add_requestable_to_assets
Migrated: 2014_07_17_085822_add_asset_to_software
Migrated: 2014_07_17_161625_make_asset_id_in_logs_nullable
Migrated: 2014_08_12_053504_alpha_0_4_2_release
Migrated: 2014_08_17_083523_make_location_id_nullable
Migrated: 2014_10_16_200626_add_rtd_location_to_assets
Migrated: 2014_10_24_000417_alter_supplier_state_to_32
Migrated: 2014_10_24_015641_add_display_checkout_date
Migrated: 2014_10_28_222654_add_avatar_field_to_users_table
Migrated: 2014_10_29_045924_add_image_field_to_models_table
Migrated: 2014_11_01_214955_add_eol_display_to_settings
Migrated: 2014_11_04_231416_update_group_field_for_reporting
Migrated: 2014_11_05_212408_add_fields_to_licenses
Migrated: 2014_11_07_021042_add_image_to_supplier
Migrated: 2014_11_20_203007_add_username_to_user
Migrated: 2014_11_20_223947_add_auto_to_settings
Migrated: 2014_11_20_224421_add_prefix_to_settings
Migrated: 2014_11_21_104401_change_licence_type
Migrated: 2014_12_09_082500_add_fields_maintained_term_to_licenses
Migrated: 2015_02_04_155757_increase_user_field_lengths
Migrated: 2015_02_07_013537_add_soft_deleted_to_log
Migrated: 2015_02_10_040958_fix_bad_assigned_to_ids
Migrated: 2015_02_10_053310_migrate_data_to_new_statuses
Migrated: 2015_02_11_044104_migrate_make_license_assigned_null
Migrated: 2015_02_11_104406_migrate_create_requests_table
Migrated: 2015_02_12_001312_add_mac_address_to_asset
Migrated: 2015_02_12_024100_change_license_notes_type
Migrated: 2015_02_17_231020_add_localonly_to_settings
Migrated: 2015_02_19_222322_add_logo_and_colors_to_settings
Migrated: 2015_02_24_072043_add_alerts_to_settings
Migrated: 2015_02_25_022931_add_eula_fields
Migrated: 2015_02_25_204513_add_accessories_table
Migrated: 2015_02_26_091228_add_accessories_user_table
Migrated: 2015_02_26_115128_add_deleted_at_models
Migrated: 2015_02_26_233005_add_category_type
Migrated: 2015_03_01_231912_update_accepted_at_to_acceptance_id
Migrated: 2015_03_05_011929_add_qr_type_to_settings
Migrated: 2015_03_18_055327_add_note_to_user
Migrated: 2015_04_29_234704_add_slack_to_settings
Migrated: 2015_05_04_085151_add_parent_id_to_locations_table
Migrated: 2015_05_22_124421_add_reassignable_to_licenses
Migrated: 2015_06_10_003314_fix_default_for_user_notes
Migrated: 2015_06_10_003554_create_consumables
Migrated: 2015_06_15_183253_move_email_to_username
Migrated: 2015_06_23_070346_make_email_nullable
Migrated: 2015_06_26_213716_create_asset_maintenances_table
Migrated: 2015_07_09_014359_add_currency_to_settings_and_locations
Migrated: 2015_07_21_122022_add_expected_checkin_date_to_asset_logs
Migrated: 2015_07_24_093845_add_checkin_email_to_category_table
Migrated: 2015_07_25_055415_remove_email_unique_constraint
Migrated: 2015_07_29_230054_add_thread_id_to_asset_logs_table
Migrated: 2015_07_31_015430_add_accepted_to_assets
Migrated: 2015_09_09_195301_add_custom_css_to_settings
Migrated: 2015_09_28_003314_fix_default_purchase_order
Migrated: 2015_10_01_024551_add_accessory_consumable_price_info
Migrated: 2015_10_12_192706_add_brand_to_settings
Migrated: 2015_10_22_003314_fix_defaults_accessories
Migrated: 2015_10_23_182625_add_checkout_time_and_expected_checkout_date_to_assets
Migrated: 2015_11_05_061015_create_companies_table
Migrated: 2015_11_05_061115_add_company_id_to_consumables_table
Migrated: 2015_11_05_183749_image
Migrated: 2015_11_06_092038_add_company_id_to_accessories_table
Migrated: 2015_11_06_100045_add_company_id_to_users_table
Migrated: 2015_11_06_134742_add_company_id_to_licenses_table
Migrated: 2015_11_08_035832_add_company_id_to_assets_table
Migrated: 2015_11_08_222305_add_ldap_fields_to_settings
Migrated: 2015_11_15_151803_add_full_multiple_companies_support_to_settings_table
Migrated: 2015_11_26_195528_import_ldap_settings
Migrated: 2015_11_30_191504_remove_fk_company_id

Admin group created successfully.

Reporting group created successfully.

Users group created successfully.

Your user was created successfully.

That is Now you can check the firewall and open the ‘http” and https” for others

Open your firefox and http://localhost/ you can enjoy with your snipe it installation.

                        Thanks ours Golden John S

Friday, December 18, 2015

Restoring a System without formatting the system in CentOS

When you installed some program or file system related issue means please run the below command .

Before that please take the backup of necessary files.

This is  the command to execute .


Best of Luck .

Friday, November 20, 2015

Partkeepr Installation on Centos 6.4

PartKeepr is an electronic parts inventory management software. It helps you to keep track of your available parts and assist you with re-ordering parts.
We’ll be starting with a base install of CentOS 6.3 assuming nothing already installed. Don’t forget to enable port 80 on the firewall or disable it if you prefer.

Disable SELinux

setenforce 0

Disable SELinux on startup

vi /etc/syscofig/selinux

Change the enforcing parameter


We’ll need the EPEL repository for Imagick

rpm -Uvh

Install base requirements

yum install httpd mysql-server mysql php php-mysql php-pear php-pecl-imagick php-gd

Install Doctrine requirements

pear channel-discover
pear channel-discover
pear install
pear install
pear install
pear channel-discover
pear install twig/Twig

Set Apache and MySQL to autostart

chkconfig httpd on
chkconfig mysqld on

Start Apache and MySQL

service httpd start
service mysqld start

Let’s secure the MySQL server


In order to log into MySQL to secure it, we’ll need the current
password for the root user. If you’ve just installed MySQL, and
you haven’t set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
OK, successfully used password, moving on…
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
Set root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
… Success!
By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] y
… Success!
Normally, root should only be allowed to connect from ‘localhost’. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] y
… Success!
By default, MySQL comes with a database named ‘test’ that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] y
– Dropping test database…
… Success!
– Removing privileges on test database…
… Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] y
… Success!
Cleaning up…
All done! If you’ve completed all of the above steps, your MySQL
installation should now be secure.
Thanks for using MySQL!

Setup the partkeepr database

Login to mysql shell

mysql -u root -p

Create database


Create user and assign permissions

GRANT ALL PRIVILEGES ON partkeepr.* TO partkeepr@localhost IDENTIFIED BY 'partkeeprpass';

Download the current version of PartKeepr.  I like to keep most of my files in the home directory for simple backup purposes, but put these where ever you want.

cd /home

Link ‘partkeeper to the version specific directory. This way for unpgrade we can easily keep our old version files and just update the link to the new version.

ln -s /home/partkeepr-0.1.8 /home/partkeepr
Make the data directory writable by apache
chmod 777 /home/partkeepr/data -R

Create an empty config file and make writeable by apache

touch /home/partkeepr/config.php
chmod 777 /home/partkeepr/config.php

Now create an apache config file
vi /etc/httpd/conf.d/partkeepr.conf
Add this content and adjust as neccessary for your configuration
<VirtualHost *:80>
ServerName partkeepr
DocumentRoot /home/partkeepr/frontend
DirectoryIndex index.php
rewriteEngine on
php_value date.timezone America/Chicago

<Directory "/home/partkeepr/frontend/">
    Options Indexes FollowSymLinks
    AllowOverride All
    Order allow,deny
    Allow from all

Alias /setup "/home/partkeepr/setup"
<Directory "/home/partkeepr/setup/">
    Options Indexes FollowSymLinks
    AllowOverride All
    Order allow,deny
    Allow from all

Restart Apache

service httpd restart

Open browser to your server


Tuesday, October 13, 2015

Windows to Linux File transfer

The below mentioned Hardware requirements are need to complete this scenario.
PCI Network Port - 1

Default network port it attached by motherboard.

Step: 1

You having the two network port in one machine,

One should be configured in linux and second one should be configured in windows.

.Windows – 10.XX.XX.XX

Linux – 10.XX.XX.XX

1.2          Configuring the Secondary port.

You could reserve the particular IP for windows and both cable should be connected to machine , You need to be create the share folder in that particular machine.

Step: 2

Create any folder on the below it should be perform in windows.
รจ     E:File_share/

Step: 3


You need to mount the “file_share” folder in the particular linux machine.
The below command for mounting the “file_share” directory.

mount.cifs  //10.20.33.XX/file_share/ /mnt –o sysadmin= administrator

it was promoting the password for the “administrator”

You should be given administrator password : ? which one you have.

             That's is you can able to transfer the file to windows to linux