Mysql Server Password
Login to mysql server for the first time without a password
root@ubuntu:~# mysql –u root
Set a new password for root in mysql server
root@ubuntu:~# mysqladmin -u root password ‘secret_password’
login to mysql with a password
root@ubuntu:~# mysql –u root –p
Enter the password when prompted
Manage database in mysql server
List all the databases on the mysql server
mysql> show databases;
To create a new database in mysql
mysql> create database database_name;
To delete a database from mysql
mysql> drop database database_name;
Users and privileges management in mysql server
Create a user testuser with permission to connect to the server from local host using a password ‘helloworld’ in mysql
mysql> grant usage on *.* to testuser@localhost identified by ‘helloworld';
And finally we grant all privileges on the database_name database to this user in mysql
mysql> grant all privileges on database_name.* to testuser@localhost ;
Show the list of users in mysql
mysql> select user,host from mysql.user;
To find the privilege(s) granted to a particular MySQL account:
mysql> show grants for ‘root’@’localhost';
To find privilege of the current MySQL account (account logged in with):
mysql> show grants;
database backup and restoration in mysql server
To backup a mysql database
root@ubuntu:~# mysqldump -u root -p database_name > dumpfilename.sql
to restore mysql database, the database must exist in mysql
root@ubuntu:~# mysql -u root -p databse_name < dumpfilename.sql
It ain’t what you don’t know that gets you into trouble. It’s what you know for sure that just ain’t so —MARK TWAIN
What is confirmation bias?
Confirmation bias is a general tendency of people to favor or to be receptive to information that confirms their previous understanding of the subject matter. They look for the evidence they would expect if their hypothesis were true, rather than what to expect if it were false; this naturally makes them to ignore the opposing view.
This type of bias can be observed when one gathers, remember information or be receptive to information interpret selectively in a subconscious. This bias is also re-enforcing due to such nature.
We should not feel bad about being a victim of confirmation bias as it is a natural human tendency, but overcoming our confirmation bias is probably one of the best things you can do to improve your world view and reduce polarizing opinions and conflicts.
Outcomes of confirmation bias
Re-enforcing nature of confirmation bias can makes our views extreme, resulting in conflict. In such cases people with opposing views interpret new information in a biased way, their views can move even further apart. This is called “attitude polarization”.
Effected by confirmation biases we prone to think we are right and we find friends and from groups to agree with us. Confirmation bias brings in issues like overconfidence therefore poor decision making ability. This bias effects organizations, politics and law, religious viewpoints, in finance, in physical and mental health, self-image and even in science. Stronger our opinions are, the more we ignore sources of information that challenge our view. Conservatives are less likely to read liberal source of news, which alienate groups or individuals even farther.
The emotional aspect and re-enforcing aspects of confirmation bias can make polarizations extreme. This makes people to use ambiguous evidence and explain is as it fits their argument losing objectivity. It is observed that disagreement can become more extreme even though same evidence is presented to both the parties.
How can we avoid confirmation bias?
To start with, one must be aware of the phenomena of “confirmation bias”. This awareness is the first step to protect one against this bias. Paradoxically, the best way to check if one is affected by this bias is to look for neutral source of information that challenges your opinion.
Once we are aware of these phenomena, we should always try to acquire accurate opinion by e.g. being the devil’s advocate and argue in both sides, collect information from liberal news group and finally listen to the opposing point of view with an open mind.
As a system integrator and designer I always have a preference towards open source technology such as Alfresco. I have done several implementation of Alfresco for a few organizations, include educational institution and for service business using free edition of Alfresco.
After the age of windows file sharing, document collaboration platforms has come a long way more accessible. Today we have many matured document collaboration platforms such as EMC Documentum, MS SharePoint, KnowledgeTree, Liferay Portal, Alfresco etc.
Alfresco is one of the leading open source ECM (Enterprise Content management) Platform, which can be used on-premise as well as in the cloud. Alfresco is feature reach, built on open standards. Alfresco implements technologies like Workflow, Business Process Integration, task management and assignment, Version Control, Online Previews, Repository access via CIFS/SMB, FTP, WebDAV, NFS and CMIS, On-premise to Cloud Sync (dropbox like sync), Desktop integration with Microsoft Office, OpenOffice.org and LibreOffice, Comprehensive Search, Pluggable authentication. These features are supported out of the box. Alfresco being an open Source, open standard product. Many other application integration is also possible with little effort.
About This Book
As the title suggests this book is written for Alfresco 4 Enterprise edition (commercial), however most of these examples should work on the free edition as well. “Alfresco 4 Enterprise content management and implementation” is probably the only Alfresco ECM book out in the market for “Version 4” as on Dec 2013. It is needless to say this book has no competition. Never the less this book is a well written one. Following Alfresco 3 Enterprise content management, which makes it the second version even more solid.
This Alfresco book covers but not limited to topics such as installation, getting started, security, workflow, other application integration, alfresco share, UI customization, search, imaging and Forms Processing and systems administration. The topics are explained with appropriate diagrams, configuration screen shots, example configuration files and java scripts; which makes this book easy to follow. This book can be used as a cookbook as well.
Audience of this book
Some of the chapters can be useful for business owner, process owners or project managers who wants to take full advantage of alfresco ECM, in terms of mapping business process to the application or leveraging application features in the business e.g. introduction to Alfresco, Implementing Business Rules, Implementing Workflow etc.
Hope you find this book useful as I did.
Use of Internet in a school/educational institution
Early internet was developed from an ARPANet, later on adapted by some of the leading universities in USA and eventually became the Internet as we know it today. Since the mid-1990s, the Internet has had a revolutionary impact on culture and commerce, including the rise of near-instant communication by electronic mail, instant messaging, Voice over Internet Protocol (VoIP) “phone calls”, two-way interactive video calls, and the World Wide Web with its discussion forums, blogs, social networking, and online shopping sites. Today’s Internet has become a major backbone for all communication and electronic content distribution.
Today’s education system relies on internet for a major portion of its educational contents. Internet is also used as a distribution network of school/institution hosted contents for students for remote access.
Why do we need content filter
In an international School we have students of all ages. Internet as we know it is unregulated and requires an additional security and access layer to ensure access to age appropriate content. Teachers and administrators need to control web contents by various categories for example, social network, education, downloads, email, dating, porn, violence, hate sites etc. Read the rest of this entry
Moodle 2.5 is out for a while, initially released on 14th May 2013. Eventually with 2 minor releases, new Moodle has fixed of many of known issues. In my line of work many users asks me if they should upgrade to Moodle 2.5 or continue on with 2.4. or older. Moodle 2.6 release is going to come up soon as I write this article. Moodle 2.5 brings some interesting new features for teachers, students and administrators. I will try to skim through some of these features, enhancements and changes in Moodle 2.5 You can find the full details of the new release at Moodle 2.5 Release notes.
Badge is an interesting new addition to Moodle, which has been anticipated for a while now. The Mozilla Open Badges (Open Badge Infrastructure or OBI) project is a program by Mozilla that issues digital badges to recognize skills and achievements of individuals participating in various online learning programme. The badge structure allows one to display real-world achievements and skills which may help with future career and education opportunities. The OBI allows badge issuers and developers to build badges, and allows online learners to choose from a number of different pathways for development. New Moodle supports issuing badges to a student based on the users meeting various predefined criteria compatible with Mozilla Open Badges. Badges created in Moodle can be displayed on a user’s profile and/or published on their Open Badges backpack and public badge collections in their backpack will display in their Moodle profile. There are two categories of badges:
- Site badges – available to users site-wide and related to the site wide activities, like finishing a set of courses.
- Course badges – available to users enrolled in the course and related to the activities that happen inside the course.
Why backup is critical
In 21st century all organization are having a technology infrastructure, some hosting locally some in the cloud. A school/educational institution is no different. In a school we store all our data electronically. We have electronic student records, results, student works, curriculum data, administrative data, emails, various configurations, systems data and much more. Without a proper backup recovery plan data is valuable.
Data loss can be categorized in these three following areas:
- Human error at any level of the organization, students, staff, systems administrator, external attacks etc.
- Systems or hardware failure: failure of server hardware, data storage media or corruption of software systems
- Natural disaster and act of God: flood, fire, earth quick, thunder strike
To ensure service continuity, data needs to be available despite any type of anticipated failure. To protectant against data failure we use redundant hardware as well as industry standard backup system. Redundant hardware protects us against hardware failure and maximizes systems uptime. A properly implemented backup process shall protect against human error, software or systems error and any natural disaster.
Having a regular backup provides, required availability of school’s/ educational institutions data; backup needs to be performed regularly in time using an autonomous system, stored and archived as required, all backup error should be addressed and finally the backup data should be restorable. It is critical the institution has a backup policy and implements the polity to protected data at all times criticality.
International schools are required to have the ability to recover data in such failure or error. Read the rest of this entry
Schools multimedia management requirement:
Today’s school depends on multimedia content for their learning delivery. Multimedia content are pictures, movies, music, podcasts, presentations, interactive tutorials etc. Schools collect multimedia content from various internet sources. Teachers also create a lot of content by themselves. As education systems start relying on more multimedia content, the size and number of elements of this content starts growing rapidly.
The challenge is to manage this content in a system where the content can be stored in a catalog, which can be searched, previewed, and published. Multimedia files are usually large in size. When stored in a network file system, users tend to create multiple copies of these files, which add to the storage and retrieval problem. Usually users responsible for managing these files cannot maintain a complex manual workflow to maintain a proper catalog system; which makes multimedia repository on a network file system, almost un-searchable and it takes up many times the minimum space that is required.
Solution to digital asset management with ResourceSpace
ResourceSpace is an Open Source digital asset management server/multimedia server. It’s a web based application, which allows users to upload content with proper cataloging, using a simple workflow, resulting in content that can be searched, shared and published. Such a system can serve institutions to manage all their digital assets/multimedia content.
Resource Space is a single repository for your entire digital content, with an easy way to catalogue and control your organization’s access.
ResourceSpace can be used to store and catalog multimedia and other digital assets.
ResourceSpace comes with
- Web interface with Intuitive design, Works with all major browsers
- Rich search interface
- Advanced cataloging
- Auto previewing, conversion with audio video players
- Quick and easy search with advance search options and Intelligent Ordering
- Supports collaboration; users can contribute or make request for content
- Publication of content directly to youtube, flicker, wordpress, joomla and more
- Supports various reports on the content, search trends etc.
- Batch file editing and uploading with HTML5 interface
- Supports various access levels based on users, group etc.
- Can be integrated with your central authentication system/LDAP
- Built on Open Source Open Standard with no licensing Cost
- ResourceSpace is a modular application, supports external plugins
- Supports Multilanguage interfaces
As it is a web application, all these features are accessible from the organization’s LAN or over the internet as per the institutions requirement.
Document and file collaboration is a process which should allow multiple people work together on a single document or file and produce a final document. For example if you plan to develop an IT policy for your institution, and you assign a 5 member team to develop it and come up with an approved version; all these users will be working on a single file to come up with a final version; in this case some will contribute, some will review, some will approve. However at the end we will have a final version of the document without losing any changes made.
In last few decades after the birth of internet, collaboration is becoming one of the major means for creation and productivity. There are many from of collaboration among all document collaboration is one of the standard from. Collaboration used in business world is equally important for children to learn as a method starting from Schools just like any other discipline.
All organization requires document and other media contents available to various group of user for consumption and contribution. These files require having different permission sets according to their access level. Electronic resources need to be accessed easily from standard computing devices; also one should be easily search and locate the right file.
Traditionally file sharing is done through windows file sharing technology also known as SMB or CIFS. These system allows windows OS to easily access files stored in a central server with user logging. Windows file sharing supports user home drive and different level of access to different group of users. This system is sometimes limited to local area network.
A basic windows file sharing system is an essential IT service for any educational instruction. May still uses windows file sharing for storing personal data of the user in a central server and share files among different group of users.
Enterprise content management/Document management System:
Technology has moved a long way from the day of simple windows file sharing. A document management system (DMS) or an enterprise content management system (ECM) is a computer system (or set of computer programs) used to track and store electronic documents and other medias. It is usually also capable of keeping track of the different versions modified by different users (history tracking). The term has some overlap with the concepts of content management systems. It is often viewed as a component of enterprise content management (ECM) systems and related to digital asset management, document imaging, workflow systems and records management systems.