LOVD 3.0 user manual Build 3.0-beta-07
Contents
1. Entrez Gene Locuslink ID This information has been filled in for you and can t be changed OMIM Gene ID This information has been filled in for you and can t be changed Provide link to HGMD If you wish to include a link from the gene homepage to the gene s page on the HGMD site enable this checkbox Provide link to GeneCards If you wish to include a link from the gene homepage to the gene s page on the GeneCards site enable this checkbox Provide link to GeneTests If you wish to include a link from the gene homepage to the gene s page on the GeneTests site enable this checkbox This gene has a human readable reference sequence Although GenBank files are the official reference sequence they are not very readable for humans If you have a human readable format of your reference sequence online please select the type here Coding DNA or Genomic Human readable reference sequence location To create a human readable reference sequence file you can use our Reference Sequence Parser It retrieves the reference sequence from Mutalyzer and formats it into a human readable format with good annotation of the upstream sequence the exons the introns the downstream sequence the predicted protein sequence and the alternative stop codons Fill in the complete URL of the file including http or https Customizations LOVD allows you to customize the gene homepage by adding citation references2. be undone X Delete log entry Options menu button 14 3 LOVD Setup Uninstalling LOVD 3 3 Uninstalling LOVD Only the database administrator can uninstall Required level Database administrator LOVD provided the uninstall lock has not been Available from LOVD 3 0 Build 01 set during installation of LOVD The uninstall lock is set within the MySQL database and can only be removed by directly accessing MySQL If you know how to handle MySQL you can also uninstall LOVD through MySQL directly by removing all LOVD tables but this is not recommended To uninstall LOVD and remove all data stored in LOVD click on the Uninstall LOVD link on the setup area This link is only available if the uninstall lock is disabled You will need to fill in the database administrator s password twice to complete the uninstallation process T Once you have uninstalled LOVD you have lost all variant and individual informa tion If you wish to store these data elsewhere make sure you download all data first Please note that the LOVD uninstaller will not remove the LOVD files itself just the database tables that it has created during install Thus to completely remove LOVD from the system also remove the files from the server 15 4 Gene databases Although in LOVD 3 0 you can enter data into the database without having genes in your installation the genes still embody an important part
3. brute force attempts where in general the attacker will try many random passwords If a user can t log in because of the IP restriction on the account the current IP restriction is also stored in the log entry Please note that it is recommended to have LOVD lock user accounts after three failed login attempts See subsection Security settings for more information General events Event General events are logged to show a user s activity to allow collaborating users to track each other s activities or to check what happened to a certain data entry over time 13 3 LOVD Setup System logs General errors Error Whenever an unrecoverable error occurs LOVD logs the error and stops processing Also some non fatal errors are logged such as when only part of the requested action could be completed In principle during any database event an error can occur This is then logged under the name of the event so any of the event names used in the general event log can also be found in the error log Installation and upgrade events Install LOVD creates a log entry on completion of the LOVD installation procedure Also after each upgrade LOVD will add an entry stating from which version to which version it has been upgraded and how many database queries have been used for the upgrade Also errors during an LOVD upgrade might they occur will be logged here Viewing and searching through the logs To browse the
4. form LOVD redirects you automatically back to the gene s homepage 4 4 Deleting a gene database Only managers and up can delete gene databases Required level Manager from LOVD To delete the gene database in Available from LOVD 3 0 Build 01 question first proceed to the gene s homepage Click on the Options menu button to open up the gene entry s menu and select the Delete gene entry option To complete the removal you need to fill in your password and submit the form U Removing a gene can not be undone you will need to create the gene database again Please note that deleting a gene removes also its transcripts in the database and therefore all variant annotation on the gene in question but it does not remove the variants from the database 20
5. headers footers notes and a disclaimer The header and footer will also be shown on the variant listings Citation reference s Using our PubMed custom link you can add links to PubMed articles to cite your database or that you want to point visitors to Include disclaimer If you want a disclaimer added to the gene s LOVD gene homepage select your preferred option here 18 4 Gene databases The gene homepage Text for own disclaimer HTML enabled Only in case you selected the Use own disclaimer in the field above you can enter the text here Text in this field will be ignored if you disabled the disclaimer or selected the standard LOVD disclaimer Page header HTML enabled If you want a gene specific header on all public gene specific pages please enter the text here Header aligned to In case you defined a page header here you can select how you want it aligned left center or right Page footer HTML enabled If you want a gene specific footer on all public gene specific pages please enter the text here Footer aligned to In case you defined a page footer here you can select how you want it aligned left center or right Notes for the LOVD gene homepage HTML enabled Text entered here will appear in the General Information box on the gene s homepage In general curators put additional information about the database here such as how the data in the database was collected grants supporting th
6. mation reference sequence information and available transcript information Usually retrieving this information takes about 1 3 seconds but this depends on the internet connection between the server and the internet and the current load on the webservices which are contacted When LOVD has retrieved all the information you are forwarded to the data entry form where you can review the retrieved information and complete this gene s settings General information This part describes the bare essentials of the gene information Therefore most of the infor mation in this section has been filled in for you and some values are fixed to ensure the data is correct Full gene name This information has been filled in for you and can t be changed Official gene symbol This information has been filled in for you and can t be changed Chromosome This information has been filled in for you and can t be changed Chromosomal band The chromosomal band on which the gene lies is retrieved from the HGNC You may modify it if you wish 16 4 Gene databases Creating a new gene database Imprinting If known please fill in if this gene is imprinted maternal or paternal or not Date of creation Note This field can only be filled in when creating a gene database and can never be edited afterwards The database s date of creation is mentioned on the gene homepage Today s date will automatically be stored if you leave this fie
7. name 0 Proxy server port number 0 Customize LOVD Here you can customize the way LOVD looks We will add new options here later System logo Ol gfx LOVD_logo130x50 jpg Currently only images already uploaded to the LOVD server are allowed here Global LOVD statistics The following settings apply to the kind of information your LOVD install sends to the development team to gather statistics about global LOVD usage Send statistics es Include in the global LOVD listing eN Security settings Using the following settings you can control some security settings of LOVD Lock users after 3rd failed login eN Allow locked users to retrieve a new password Enable submitters to change data es Enable getting counts of hidden entries Not yet implemented Force SSL only access to LOVD o0 Use data versioning of biological data Not yet implemented Disable LOVD uninstall ON Continue Figure 2 5 The system settings form with example data filled in After filling in the form click Continue If everything was filled in correctly LOVD will register the LOVD system settings Click Next to continue to the last step Almost done 2 Installing LOVD Install process Done When everything has been filled in and stored correctly the installation is complete Now that you re done installing LOVD click the Continue to Setup area button to be for
8. system logs click the View system logs option of the Setup tab dropdown menu or the View search and delete system logs link on the setup area The system log overview is fully searchable and sortable allowing you to find log entries quickly The Log column shows the type of log every Auth Event Error or Install The Date column shows the date the log entry was created The User column shows if available which user caused the log entry to be created The Event column lists the type of event that occurred Finally the Entry column provides more information about the event that has occurred For login attempts it will contain the IP address of the user attempting to log in For most event types it will include the ID of the entry that was created edited or deleted Removing log entries To remove a single log entry click on the red cross in the 6th column To remove multiple log entries at once first apply as many search terms on the log entries as needed to restrict the view to the entries you want to delete Either manually select the checkboxes next to the entries you want deleted or click the option button on the top left of the log overview and select the Select all entries option after which you can deselect log entries you do not want deleted Then open the option menu again and click the Delete selected entries option Please note that deleting log entries can not
9. L is recommended Use data versioning of biological data Note Not yet implemented Versioning allows you to see all previous versions of a certain data entry individuals variants phenotype information etc and allows you to return the entry to a previous state Please note that this feature requires quite a lot of space in the database Disabling this feature later will not free any space just prevent more space from being used 3 2 System logs System logs were introduced in LOVD 2 0 to al Required level Manager low authorized users to keep track of events in f Available from LOVD 3 0 Build 01 LOVD This can be for security purposes to fol low each other s progress when working together or to track down errors in case something went wrong The logs are initiated when LOVD is installed What is logged by LOVD LOVD logs four types of events authorization events and errors general events general errors and installation and upgrade events In case the event or error was triggered by an authorized user the username of this user is also logged Authorization events and errors Auth This list stores all successful and unsuccessful login attempts and password reset attempts In all cases the IP address from where the login or password reset attempts have been made is also logged For successful and unsuccessful login attempts the given username and the length of the given password is stored so you can easily uncover
10. RO 7D Leiden Open Variation Database LOVD 3 0 user manual Build 3 0 beta 07 Ivo F A C Fokkema Leiden University Medical Center Last updated 2012 07 19 LOVD has received funding from the European Community s Seventh Framework Programme FP7 2007 2013 under grant agreement no 200754 the GEN2PHEN project Contents Contents 1 2 Introduction Installing LOV D 241 Bere YOR meall o eee ey pent Ror pea kos piens pop pian IE a 22 Install process ss cte ecce AAA A LOVD Setup S1 LOVD system setlis caso a ea eS Ae A OSS A k REE Se Unmetaline LOUVO oi tia ee ee we ede SS a Gene databases 4 1 Creating a new pene database 2 2 oe ek a eae DR GEE RR ee eS a Ae Ooms homepsfe is ecis erbo ea be SORES a e SEER RSE HR RSE Aa Eding Age database 2 ck a ke ee ee ae ee eS ee we a 4 4 Deleting a gene database ee 10 10 13 15 1 Introduction This is the manual for the Leiden Open source Variation Database LOVD version 3 0 LOVD 3 0 is a partial rewrite of LOVD 2 0 which first stable release was completed in 2007 Also LOVD 3 0 has a greatly improved database model and includes lots of new features aimed at making LOVD useful for more research environments LOVD is designed to provide a flexible freely available tool for gene centered collection and display of DNA variations LOVD 3 0 extends this idea to also provide patient centered data storage and storage of NGS data e
11. atively experienced computer user Done The installation progress bar at the top of the screen shows how far you are in the installation process The installation steps are shown at the left of the screen Start gt gt Powered by 2004 2012 Leiden Univ LOVD v 3 0 Build beta 04 University Medical Center Figure 2 2 If all requirements are OK you re ready to start installing LOVD Administrator account details Fill in the database administrator data to install LOVD The database administrator will be the first user registered with LOVD and has full access to all of LOVD s functionalities The database administrator is the only user capable of creating manager accounts Managers can only create curator and submitter accounts Most of the form is pretty straight forward but I will highlight one field Allowed IP address list An IP address is an address a computer is known by on the network To help prevent others to try and guess the username password combination you can restrict access to the database administrator account to a number of IP addresses or ranges This also means you need to be very careful with this setting as being too restrictive may lock you out of your account The default unrestricted value is The database administrator is the absolute owner of the LOVD installation Not only is he the only one that can uninstall LOVD from the database using the unin stall
12. be possible for different submitters to work together cooperatively on the same 1 Introduction data Searching through the data is improved extensively and webservices of many different sources are used to automatically retrieve gene and transcript information Also new in 3 0 is full Next Generation Sequencing NGS support with the ability to import VCF or SeattleSeq formats For VCF file imports LOVD allows for automatic annotation of the variants Both formats support the automatic creation of genes and transcripts in the system greatly reducing the amount of work required by curators to get LOVD set up for their research data LOVD 3 0 reached beta stage in January 2012 Currently the latest release is 3 0 beta 07 Keep an eye on our news page for the latest information on LOVD 3 0 development Where ever you see he or his written in this manual it should read he or she and his or her respectively Please note that this manual is work in progress Since LOVD 3 0 is still under development and the development is the focus of our efforts most features in LOVD 3 0 are not yet described in this manual Also features described in this manual may become inaccurate or even incorrect in later versions of LOVD 3 0 Please bear with us while we finish this manual 2 Installing LOVD Installing LOVD is a piece of cake However you might require help from your system administrator sin
13. ce there are a few dependencies that need to be taken care of first 2 1 Before you install LOVD is a web based software project Therefore installation requires a correctly set up webserver LOVD has been extensively tested with the Apache webserver but any webserver able to run PHP scripts should suffice You ll need PHP 5 1 0 or higher and MySQL 4 1 2 or higher LOVD may work with other database platforms but we are not developing for other database backends You are welcome to try other database backends and report the results to us but we can t provide any support for it For more information see the FAQ about software needed A suitable server with the necessary software installed is available at virtually all academic institutions and countless commercial hosting providers Before installing LOVD be sure you have the required credentials for connecting to the MySQL database You need a hostname username password and a database name to be able to install LOVD If you are installing LOVD on a remote server be sure to have the FTP username and password to be able to copy the necessary files to the server Download amp Extract To download LOVD go to the LOVD website and click on the Download tab You can download LOVD in two formats GZIPped TARball and ZIP archive The first format is com mon for Unix and Linux systems while the ZIP archive is popular on the Windows platform Usually you will be able to open both format
14. cess is completing the initial configuration of the LOVD system settings These settings can be changed after installation at any time through the LOVD setup The only setting that cannot be changed at a later time is the install lock which is checked by default Setting the uninstall lock will prevent uninstallation of LOVD by the database administrator The only way to remove this lock is directly through the MySQL database backend KOD LOVD 3 0 Leiden Open Variation Database LOVD v 3 0 Build beta 04 o L 0 100 EEEE Configuring LOVD system settings Please complete the form below and press Continue to continue the installation We re almost done Administrator account details General system settings Title of this LOVD installation LOVD Leiden Open Variation Database Installing database tables Institute optional Leiden University Medical Center Database URL optional http databases lovd nl shared check Configuring LOVD system LOVD email address noreply lovd ni settings Forward messages to database admin eM Human Build to map to UCSC NCBI hg19 GRCh37 fae List database changes in feed for how long Not yet implemented Connection settings optional Some networks have no access to the outside world except through a proxy If this applies to the network this server is installed on please fill in the proxy server information here Proxy server host
15. de to rewrite all of LOVD from scratch to be able to include a long list of upgrade suggestions that were hard to implement in LOVD 1 1 0 Aimed at modularity and data redundancy LOVD 2 0 was meant to be a more flexible and more powerful successor of the popular 1 1 0 version and soon it received the interest of LOVD users eager to try out the all new version With more features being added and bugs fixed rapidly LOVD 2 0 reached beta stage in April 2007 after which more and more users started to upgrade their 1 1 0 databases to 2 0 Finally in October 2007 LOVD 2 0 reached the stable stage after which LOVD 2 0 was con tinuously improved with monthly releases for two years after which the releases became less frequent LOVD 2 0 is described in the second LOVD paper By 2009 it had became clear that although LOVD 2 0 was a great step forward there were still key improvements to be made Since the complexity of necessary changes had become to great to gradually upgrade LOVD 2 0 systems to include these options it was again decided to start from scratch writing LOVD 3 0 This allowed us to redesign the complete data model in full freedom although it should still be possible for existing LOVD 2 0 databases to have all data transferred to LOVD 3 0 LOVD 3 0 adds even more flexibility allowing users to focus exclusively on sequence vari ants whilst also allowing an exclusive focus on individuals and clinical data and anything in between It will
16. er he will also be able to create edit or delete all user accounts in the system and depending on the settings receive submission and registration notifications After completing the database administrator account details click the Continue button at the bottom LOVD will apply a simple username and password quality check If LOVD tells you that the provided details are OK click the Next button Installing database tables The next step is to create and fill all necessary LOVD database tables LOVD will do this automatically and you can watch the progress bar complete while the tables are created the country list filled the database administrator account created the custom columns preconfig ured the standard columns enabled and the custom links generated This may take a while 2 Installing LOVD Install process K0 Dd LOVD 3 0 Leiden Open Variation Database LODO Bord pele Ot le 0 100 Introduction Administrator account details Please fill in the Administrator s account details and press Continue to continue the installation Administrator account Js User details Name Ivo F A C Fokkema Installing database tables Institute Leiden University Medical Center Department optional Human Genetics Configuring LOVD system Postal address Einthovenweg 20 pitana 2333 ZC Leiden Done Email address es one per line LF A C Fok
17. ew all genes menu option Then locate the gene you wish to edit by searching or browsing through the given genes listing Clicking the entry will direct you to the gene s homepage Once on the gene s homepage the gene will be selected its name will appear on the very top of the page which allows faster navigation to information related to the gene of interest For instance when a gene is selected and you click the Variants tab you are directed to the gene specific variant overview If no gene is selected clicking on the same tab shows all genomic variants in the database If you do not like this behavior simply move your mouse over a tab and select a different option from the dropdown menu 4 3 Editing a gene database Curators appointed to a gene database have the Required level Curator rights to edit its settings Managers and up can Available from LOVD 3 0 Build 01 edit all gene databases in the LOVD installation To edit the gene s settings first proceed to the gene s homepage Click on the Options menu button to open up the gene entry s menu If you do not see the Options menu button you Options are not logged in or you do not have rights to edit this gene s Options menu button settings In the opened menu click Edit gene information to open up the gene s edit form The fields on the form are explained in the section Creating a new gene database After you submit the
18. f available transcripts from Mutalyzer Mutalyzer currently only supports NCBI reference sequences Please select which transcript you want to use to name the variants in this gene If there are more transcripts usually you would pick the transcript that encodes for the longest protein or the transcript that is expressed in the tissue you focus your research on Links to information sources Here you can add links to other resources that will be displayed on the gene s LOVD gene homepage such as Entrez Gene OMIM HGMD or GeneTests but you can also add links to any website you want Homepage URL If you have a separate homepage about this gene you can specify the URL here For the format use the complete URL including http or https 17 4 Gene databases Creating a new gene database External links Here you can provide links to other resources on the internet that you would like to link to such as other gene variant databases or websites with more information about diagnostics If you want to include more than one link put every link on a new line in this field If you do not want to include a title for this link simply paste the full URL in this field such as http DMD LOVD nl If you do want to include a title use the format Description lt URL gt such as Other LOVDs on this gene lt http DMD LOVD n1 gt HGNC ID This information has been filled in for you and can t be changed
19. is work or news Notes for the variant listings HTML enabled Text entered here will appear below the gene s variant listings Security settings Using the following settings you can control some security settings of LOVD Allow public to download variant entries This controls whether or not the public can also make downloads of your gene s variants Allow my public variant and individual data to be indexed by WikiProfessional Note Not yet implemented If you ll allow the WikiProfessional concept web to index your variant and individual data enable this checkbox 4 2 The gene homepage LOVD automatically generates a gene homepage Required level None public for every gene created within LOVD The gene Available from LOVD 3 0 Build 01 homepage is the entry point for visitors of a locus specific database In installations where LOVD is used for next generation sequencing the gene homepage serves more as a summary page of the gene specific data in LOVD Besides showing the basic information known about the gene in question symbol name chromosome band variant statistics etc curators also have quite a few options to customize the gene s homepage 19 4 Gene databases Editing a gene database If the gene you wish to view is already selected its name is on the top of the page simply click the Genes tab to open the gene s homepage Otherwise move your mouse over the Genes tab and select the Vi
20. it will remain to be supported When hg20 will come out LOVD will start supporting multiple genome builds per installation List database changes in feed for how long Note Not yet implemented LOVD includes a newsfeed that allows users to get a list of changes recently made in the database Select here how many months back you want changes to appear on this list Set to Not available to disable the newsfeed Connection settings optional Some networks have no access to the outside world except through a so called proxy server more info on WikiPedia If this applies to the network this server is installed on please fill in the proxy server information here Proxy server host name The host name of the proxy server such as www cache institution edu Proxy server port number The port number of the proxy server such as 3128 11 3 LOVD Setup LOVD system settings Customize LOVD Here you can customize the way LOVD looks Right now there is only one option included we will add more later System logo If you wish to have your custom logo on the top left of every page instead of the default LOVD logo enter the path to the image here relative to the LOVD installation path If left empty it will be set to the default value which is gfx LOVD_ logo130x50 jpg Currently only images already uploaded to the LOVD server are allowed here Global LOVD statistics Your LOVD installation can send some ge
21. kema LUMC nl Telephone optional Username ifokkema Password AS Password confirm AS Referencing the lab Country Netherlands gt City 0 Leiden Reference optional O Security Allowed IP address list Q Your current IP address 127 0 0 1 Please be extremely careful using this setting Using this setting too strictly can deny the user access to LOVD even if the correct credentials have been provided Set to to allow all IP addresses use to specify a range and use to separate addresses or ranges Continue 3 0 Build b Figure 2 3 The database administrator registration form with example data filled in on non optimal conditions so please be patient When everything is done a Next button appears click it to continue OVD LOVD 3 0 Leiden Open Variation Database oe aaa Installation steps Introduction Installing LOVD Installation progress 0 100 82 Administrator account details Creating LOVD account amp LOVD database administrator account Installing database tables Configuring LOVD system settings Figure 2 4 Watch the progress bar complete while LOVD informs you which part of the database table installation is currently in progress 2 Installing LOVD Install process Configuring LOVD system settings The final form in the installation pro
22. ld empty but in case you already had a gene database but you re moving it to this LOVD installation you may want to fill in a different date Relation to diseases This gene has been linked to these diseases By linking the gene to disease s LOVD can help predicting next steps in data submission and the link to the disease information will be shown on the gene homepage If a disease you need is not present in this list you can click the configure more diseases link below the selection list to create a new disease now Afterwards reload the gene form so you can select the new disease Alternatively create the disease after the gene has been created Reference sequences Collecting variants requires a proper reference sequence Without a genomic and a transcript reference sequence the variants in this LOVD database cannot be interpreted properly or mapped to the genome When properly configured LOVD will add links to the Ensembl NCBI and UCSC genome browsers from the gene homepage Genomic reference sequence Select the genomic reference sequence NG NC or LRG accession number Only the references that are available to LOVD are shown Whether there is an LRG available is determined by contacting the EBI Checking for an available NG reference sequence is done at the NCBI The NC reference sequence is always available and depends on the chromosome on which the gene lies Transcript reference sequence s LOVD retrieves a list o
23. neral information on your installation back to us We use this information to see how many LOVDs there are worldwide which versions of LOVD are currently in use how LOVD is being used amount of data to see what type of software is used to run LOVD and to construct the public list of LOVD installs Send statistics When this setting is enabled LOVD will collect general usage statistics and send this to us The following information is sent the number of submitters genes individuals variants and unique variants in your system No specific information is sent just the numbers Include in the global LOVD listing On our website we keep a list of public LOVD installations This list is also feeding our worldwide LSDB list through which submitters can locate databases for a specific gene to submit data to If you enable the Include in the global LOVD listing setting your LOVD installation will send us all the information we need to build these lists the LOVD installation s name the URL the available gene databases the date of last update of the gene databases the disease abbreviations and names of the diseases related to these genes and finally the names institutes and email addresses of the curators of these gene databases If you change this setting please allow one day for the setting to take effect Security settings In this section you can control some security settings of LOVD Lock users after 3rd failed login With thi
24. of LOVD Configuring genes in LOVD allows you to see the effects of variants on transcript level and draws submitters with variant data to your installation Gene databases can also be created automatically for you when you are importing VCF or SeattleSeq annotated files in LOVD However this chapter deals with manually creating gene databases You can create new genes through the LOVD setup area Editing and deleting genes is done through the Genes tab Curators assigned to genes can also edit these after they ve been created but can not delete genes This chapter describes how to create edit and delete gene databases in LOVD 4 1 Creating a new gene database Creating a new gene database in LOVD is largely Required level Manager automated Click the Create a new gene entry Available from LOVD 3 0 Build 01 option of the Genes tab dropdown menu or the Create a new gene database link on the setup area Fill in the HGNC ID or the gene symbol of the gene you want to create and click Continue LOVD will check if the gene already exists in this LOVD installation and if the gene symbol or HGNC ID is correct For this it contacts the HGNC website If the gene symbol you used has been replaced by a new one or if LOVD can find genes for which the given symbol is an alias LOVD will report back the official symbol s LOVD will show a progress bar while it contacts several webservices to retrieve gene infor
25. p php to be accessed as setup More information about htaccess files http httpd apache org docs 2 0 howto htaccess html More information about AllowOverride http httpd apache org docs 2 0 mod core html allowoverride If you use a different webserver make sure to configure it to deny access to the config ini php file LOVD will access the file through the filesystem Also the htaccess file sets a couple of PHP options and enables mod_rewrite If you use a different webserver please disable the following PHP options register_globals magic_quotes_gpc mysql trace_mode Also make sure there is MultiViews func tionality which allows a PHP file like setup php to be accessed as setup 2 2 Install process To install LOVD on a remote webserver upload the LOVD directory with all the files to the webserver by for instance FTP If you install LOVD on your own computer you do not need to follow this step Next point your web browser to the directory where you ve uploaded the LOVD files This could for instance be http localhost LOVDv 3 0 or http www your domain org LOVD LOVD will tell you it s not installed yet and include a link to the install directory KO D LOVD 3 0 Leiden Open Variation Database LODO Bult beta os LOVD was not installed yet Please install LOVD first Powered by LOVD v 3 0 Build beta 04 2004 2012 Leiden University Medical Center Figure 2 1 When
26. pointing your browser to the LOVD location it will tell you it s not installed yet Click the link to start the install process LOVD will first check a few requirements Both the PHP and MySQL versions will be checked to make sure your LOVD will function properly on your webserver environment Also some settings of the web server PHP and MySQL will be checked Finally LOVD will check if your config file has been hidden If all looks well LOVD will tell you all requirements are OK and you re ready to start installing LOVD 2 Installing LOVD Install process Installing LOVD consists of only 4 simple steps and will take only a couple of minutes or less LO iD LOVD 3 0 Leiden Open Variation Database EOD Bebe pete Ot 0 100 Introduction Welcome to the LOVD v 3 0 beta 04 installer System check for requirements all OK Administrator account details Y PHP 5 3 5 5 1 0 required Y PHP function mb_detect_encoding Y PHP function xml_parser_create Installing database tables MySQL 5 1 62 4 1 2 required Y MySQL InnoDB support enabled required Y MultiViews mod_rewrite or equivalent enabled required Configuring LOVD system tti iia The installation of LOVD consists of 4 simple steps This installer will create the LOVD tables in the MySQL database create the Administrator account and will help you configure LOVD Installation and initial configuration of LOVD should be simple for a rel
27. s Download the file of your choice and save it to your hard drive Now extract the file using GZIP TAR or ZIP to the desired location On a server common directories may be var www on Unix or Linux servers or C htdocs on a Windows server To be sure consult the documentation of the webserver software you are using Pre install Setup You will need to rename the standard config file config ini php lovd to config ini php and edit it in for example a basic text editor This is absolutely mandatory because you will need to enter the MySQL hostname database name username and password here Please go through the entire config ini php file to determine if you need to change any of the other settings 2 Installing LOVD Install process Q A htaccess file is put in the root directory of your LOVD installation protecting the config ini php file This will prevent the config file from being accessed by others on Apache HTTP servers if configured properly the most commonly used webserver If you use Apache please check that your version and configuration support this feature Make sure you have the htaccess file into your LOVD directory on Unix and Linux systems it s a hidden file so it can be missed easily For the htaccess file to work you need to have Limit and Options enabled in Apache s AllowOverride setting Also make sure you have MultiViews or mod_rewrite enabled This allows a PHP file like setu
28. s setting enabled submitters curators and managers will be locked out of the system after they have provided the wrong password three times A manager or in the case of a locked manager the database administrator needs to unlock the user s account once it s locked This does not affect the database administrator account Allow locked users to retrieve a new password If a submitter curator or manager has lost his password enabling this I forgot my password feature allows them to receive a unlocking code in their email with which they can unlock their account and choose a new password Enable submitters to change data This setting allows submitters to make changes to data previously submitted by them or assigned to them 12 3 LOVD Setup System logs Enable getting counts of hidden entries Note Not yet implemented Enabling this feature allows the public to find the number of entries in the database including hidden entries matching one or more search terms on a specified set of columns This feature will only mention the number of variant entries matched without showing them Force SSL only access to LOVD SSL is a secure protocol allowing for encryption of data sent between you and LOVD When you record sensitive individual information in LOVD you should enable this setting as the individual information can otherwise be sniffed off the network If you do not record sensitive information enabling SS
29. the URL with which the database can be accessed by the outside world including http or https and is not necessarily the URL you are using right now to access the database It will also be used in emails sent by LOVD This field is mandatory if you select the Include in the global LOVD listing option If you click the check link LOVD will verify or try to predict the value LOVD email address This email address will be used to send emails from LOVD to users LOVD needs this address to prevent problems with spam filters to make sure that emails from LOVD arrive Please note that although strictly speaking this email address does not need to exist we recommend that you use a valid address to make sure that bounces of emails sent from LOVD to submitters or curators are still caught by someone so that they can be handled Forward messages to database admin With this setting enabled LOVD will forward messages to the database administrator about submitter registrations submissions and such Human Build to map to UCSC NCBI This value can only be set during installation and cannot be changed later It defines on which version of the Human Build hg18 Build 36 1 or hg19 GRCh37 genomic variants are described Links to the UCSC and Ensembl genome browsers and the NCBI sequence viewer also depend on this setting From LOVD 3 0 beta 07 the hg18 setting is no longer available for new LOVD instal lations although
30. ugh their own tab s dropdown menus In this chapter we will describe changing the LOVD system settings how to check search and clean up the LOVD system logs and how to uninstall LOVD The other actions available from the LOVD setup are described in their respective chapters see the table of contents 3 1 LOVD system settings The LOVD system settings allow you to adapt Required level Manager your LOVD installation to your preferences For Available from LOVD 3 0 Build 01 instance by changing the installation s displayed name or email address general settings proxy server settings connection settings settings on statistics or the security settings To view or edit the LOVD system settings click on the Setup tab then on View and change LOVD System settings or move your mouse over the Setup tab and click the LOVD system settings menu option from the dropdown list General system settings Title of this LOVD installation This title will be shown on the top of every page above the menu tabs The default value is LOVD Leiden Open Variation Database Institute The institute which runs this database is displayed in the public area and in emails sent by LOVD It s commonly set to a laboratory name or a website name If it s not specified LOVD will use the autodetected website name LOVD has been installed on 10 3 LOVD Setup LOVD system settings Database URL This is
31. ven of variants outside of genes LOVD was developed approaching the LSDB in a Box idea for the easy creation and maintenance of a fully web based gene sequence variation database that is platform independent and uses PHP and MySQL open source software only The design of the database follows the recommendations of the Human Genome Variation Society HGVS and focuses on the collec tion and display of DNA sequence variations but it has fully implemented methods for storing complete clinical data as well The open LOVD setup also facilitates functional extensions with scripts written by the community The development of then nameless LOVD started in late 2002 while it was first officially released in January 2004 Before that LOVD was only in use by the Leiden Muscular Dystrophy pages as a not so modular system with lots of characteristics specific for that website only With the official release of LOVD in 2004 the system had become much more dynamic and customizing LOVD was made easy mostly by editing text files In 2004 LOVD became available under the open source license GPL and with the 1 1 0 release most of the text files had been replaced by online forms so customizations can be per formed through the web interface Early in 2005 the first LOVD article was published and in 2005 the development of LOVD was more targeted at improving the ease of use of the system In 2006 the development of LOVD 2 0 started after the decision was ma
32. warded to the LOVD setup area From there you can perform the most important actions for managers in LOVD such as creating new gene databases or disease information entries registering new user accounts or authorizing curators or manage the custom columns and links The button to create a new gene will be highlighted as a suggestion of your next step 3 LOVD Setup To change system wide settings but also to perform actions with system wide effects start at the LOVD setup area The setup area is only available for managers and the database administrator and can be accessed by clicking on the Setup tab in the menu If you do not see a Setup tab you first need to log into the system with a manager or administrator account The LOVD setup shows some statistics on the left of the screen like date of installation number of registered users and variant counts separated by status Furthermore there are two columns of options The left column has options for the system settings authorized users the custom columns custom links full data download and the LOVD system logs The right column has options for genes transcripts diseases individuals and variants Some of the gen eral options from the LOVD setup are also available through the Setup tab s dropdown menu allowing you to quickly navigate to other setup options without having to go through the setup main page The other options shown in the setup area are available thro
Download Pdf Manuals
Related Search