Posts

DSPace 6 Local.cfg common variables with mirage2

 dspace.dir=/repository/auwir dspace.hostname = localhost dspace.baseUrl = http://localhost:8080 dspace.ui = xmlui dspace.url = ${dspace.baseUrl}/ dspace.name = AUW Institutional Repository assetstore.dir = ${dspace.dir}/assetstore solr.server = http://localhost:8080/solr db.url = jdbc:postgresql://localhost:5432/dspace db.driver = org.postgresql.Driver db.dialect = org.dspace.storage.rdbms.hibernate.postgres.DSpacePostgreSQL82Dialect db.username = dspace db.password = passwd db.schema = public #email mail.server = smtp.gmail.com mail.server.username = repository.service@tld mail.server.password = passwd mail.server.port = 587 mail.from.address = library@tld feedback.recipient = library@tld mail.admin = mdahsandu@gmail.com mail.helpdesk = library@tld mail.helpdesk.name =  Library Repository alert.recipient = mdahsandu@tld registration.notify = library@tld mail.extraproperties = mail.smtp.socketFactory.port=587, \                        mail.smtp.starttls.enable=true, \                

DSPace Send Email

 mail.extraproperties = mail.smtp.socketFactory.port=587, \                         mail.smtp.starttls.enable=true, \                         mail.smtp.starttls.required=true, \                         mail.smtp.ssl.protocols=TLSv1.2

systemd service file to run node.js service using pm2

FileName: /lib/systemd/system/app.service [Unit] Description=Node.js Application After=syslog.target network.target [Service] Type=simple User=root WorkingDirectory=/repository #Environment=NODE_ENV=production #ExecStart=/usr/bin/node nodeapp.js ExecStart=/usr/local/bin/pm2 start dspace-deploy.json ExecStop=/usr/local/bin/pm2 stop dspace-deploy.json Restart=always [Install] WantedBy=multi-user.target

Install solr on ubuntu 22.04

 wget https://archive.apache.org/dist/lucene/solr/8.11.1/solr-8.11.1.tgz tar -xvzf solr-8.11.1.tgz ./solr-8.11.1/bin/install_solr_service.sh solr-8.11.1.tgz systemctl enable solr systemctl start solr systemctl status solr su - solr -c "/opt/solr/bin/solr create -c mycollection -n data_driven_schema_configs" Check status http://localhost:8983/solr/admin/cores?action=STATUS&core=mycollection

Enable Remote Access on Postgresql and PhpPGadmin (ubuntu 22.04)

1. Install phppgadmin apt install phppgadmin 2. Set Listen_address to "*" nano /etc/postgresql/14/main/postgresql.conf change this line to listen_address "*" 3. Set local address to remote address (0.0.0.0/0 means all) nano /etc/postgresql/14/main/pg_hba.conf Add this line before any host line host all all 0.0.0.0/0 md5 4. restart the server service postgresql restart 5. Enable remote access to phppgadmin nano /etc/apache2/conf-enabled/phppgadmin.conf Comment the line "require local" #require local 6. Restart apache2 sever service apache2 restart 7. Access Phppgadmin from remote browser http://serveraddress/phppgadmin

FEderated Server connection

 CREATE SERVER eduvai FOREIGN DATA WRAPPER mysql OPTIONS (USER 'eduvai_remote', HOST 'localhost', PORT 3306, DATABASE 'eduvai_db');

DBD::mysql::db do failed: Unknown or incorrect time zone: 'Asia/Dhaka' at /usr/share/koha/lib/Koha/Database.pm

  mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql -p