allow root access in phpmyadmin

skip Configuring phpmyadmin in installation steps

login to mysql

mysql -u root -p mysql

write this mysql command

 update user set plugin='' where user='root'; 
flush privileges; 
exit 
systemctl restart apache2 
 
Advertisements

KOHA Delete All biblio rcords

Log into MySQL

mysql -uroot -p

use koha_library;

Delete all bibliographic details
Run the following commands  . 

SET FOREIGN_KEY_CHECKS=0;

TRUNCATE items; 
TRUNCATE deleted_items;

TRUNCATE biblioitems; 
TRUNCATE biblio; 
TRUNCATE deletedbiblioitems; 
TRUNCATE deletedbiblio; 

Delete transactions (Issue, return)

TRUNCATE old_issues; 
TRUNCATE issues; 

Delete borrowers details

TRUNCATE borrowers; 
TRUNCATE deletedborrowers;

SET FOREIGN_KEY_CHECKS=1;

Setup Tomcat 8 on Debian 8 on port 80

  1. Edit /etc/default/tomcat8.  At the very end, there should be a line that says AUTHBIND=no.  Change this to say AUTHBIND=yes
  2. Edit /etc/tomcat8/server.xml.  In this file, there is an XML tag that starts out with <Connector port=”8080″ ….  Change this to be 80.  There are two sections that you want to change this.
  3. Go to /etc/authbind/byport.  Do the following(note: this assumes that tomcat is running as the tomcat8 user, which it will do if you installed it through apt)
    $ cd /etc/authbind/byport
    $ touch 80
    $ chown tomcat8 80
    $ chmod 744 80
  4. Restart Tomcat   —  $ systemctl restart tomcat8
    You should now be able to access Tomcat on port 80.