cms_faq
Differences
This shows you the differences between two versions of the page.
|
cms_faq [2012/06/02 10:00] siva_epari |
cms_faq [2018/03/24 11:13] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ==Links== | ||
| - | * [[cms1|Drupal, Day1]] | ||
| - | * [[cms2|Drupal, Day2]] | ||
| - | * [[cms_faq|Frequently Asked Questions, CMS]] | ||
| - | * [[drupal-lms||Library Management System as Assignment]] | ||
| - | |||
| - | ===Frequently Asked Questions(FAQ)=== | ||
| - | |||
| - | ==Reset Mysql password== | ||
| - | |||
| - | /etc/init.d/mysql stop | ||
| - | mysqld_safe –skip-grant-tables | ||
| - | |||
| - | ctrl + shift + t (For new tab in terminal) | ||
| - | |||
| - | mysql | ||
| - | update mysql.users set Password=password('password') where User='root'; | ||
| - | exit | ||
| - | |||
| - | switch back to previous terminal and press ctrl + c | ||
| - | |||
| - | /etc/init.d/mysql start | ||
| - | |||
| - | ==Reset Drupal password== | ||
| - | |||
| - | mysql -u root -ppassword | ||
| - | update d7.user set pass=md5('password'), name='admin' where uid=1; | ||
| - | exit | ||
| - | |||
| - | ==Other Mysql frontends== | ||
| - | |||
| - | apt-get install mysql-query-browser mysql-admin | ||
| - | |||
| - | * open **Applications** > **Programming** > **Mysql query browser** present in Debian desktop menu | ||
| - | * It Opens a Mysql query browser asking for | ||
| - | |||
| - | Server hostname: localhost | ||
| - | |||
| - | username : root | ||
| - | |||
| - | password : hello | ||
| - | |||
| - | now click on connect. | ||
| - | |||
| - | * Now the Mysql query browser will open, click on the Resultset 1,a plain text editor appears on top of the Resultset 1. | ||
| - | * on this plain editor write a query "create database d7" then click on execute. | ||
| - | * open **Applications** > **Programming** > **Mysql Administrator** present in Debian Desktop menu | ||
| - | * It Opens a Mysql Administrator asking for | ||
| - | |||
| - | Server hostname: Localhost | ||
| - | |||
| - | username : root | ||
| - | |||
| - | password : hello | ||
| - | |||
| - | now click on connect. | ||
| - | |||
| - | * Now a Mysql Administrator will open click on the option "user administration" when we click on it a page will appear on right click on the tab "new user" and give the Login information i.e: | ||
| - | |||
| - | Mysql User: | ||
| - | |||
| - | New Password: | ||
| - | |||
| - | Confirm Password: | ||
| - | |||
| - | * Click "Schema Privileges" the second tab on the same page | ||
| - | * Here a page appears having the database which you created in Schema List click on the database you created | ||
| - | * Then a List of Available Privileges will appear on right of that page,click on any one of the available privileges and press ctrl A now all the available privileges are selected now press the arrow **<--** | ||
| - | * Now click on "Apply Changes" | ||
| - | * Your Database is created you can use the Username and database name and password given here in your drupal database. | ||
| - | | ||
| - | ==Check and kill the existing process on the standard port 80(Apache) and 3306(MySQL)== | ||
| - | |||
| - | netstat -nlp | grep 80 | ||
| - | |||
| - | * If you find any service running on port 80 check the pid of the process | ||
| - | |||
| - | kill -9 [PID you obtained from netstat output] | ||
| - | |||
| - | ==How to Uninstall drupal== | ||
| - | |||
| - | * Just drop the d7 database in mysql and delete the /var/www/d7 folder | ||
| - | |||
| - | ==Unable to find php5-gd or any other debian packages== | ||
| - | |||
| - | * add the following line to /etc/apt/sources.list | ||
| - | |||
| - | deb http://ftp.us.debian.org/debian testing main contrib non-free | ||
| - | |||
| - | put **#** in front of all other lines present in the file | ||
| - | |||
| - | apt-get update | ||
| - | |||
| - | ==Php5-gd error== | ||
| - | |||
| - | apt-get install php5-gd | ||
| - | |||
| - | ==Creating multiple sites== | ||
| - | |||
| - | * You can create multiple sites by uncompressing drupal-7.2.tar.gz into folders like /var/www/drupal, /var/www/swecha or /var/www/your-name, creating a database for each one of them and install the individually | ||
| - | |||
| - | ==New menus once create are not visible== | ||
| - | |||
| - | * When you create a new menu, a block will be automatically created in **Structure** > **Blocks** page. You need to just put the new block in a specific region like **Header**, **Footer**, **first sidebar** or **last sidebar** | ||
| - | |||
| - | ==Installing Acquia Marina theme== | ||
| - | |||
| - | To have a theme whose layout or specifications can be changed without getting into code, you can install the acquia_marina theme | ||
| - | |||
| - | * Download 7 version of acquia_marina & fusion theme from drupal.org and put it under /var/www/d7/sites/all/themes | ||
| - | * Download 7 version of skinr from drupal.org and put it under /var/www/d7/sites/all/modules | ||
| - | |||
| - | ==Enable a form in a block== | ||
| - | |||
| - | * Download 7 version of formblock module and put it under /var/www/d7/sites/all/modules | ||
| - | |||
| - | ==Resize images== | ||
| - | |||
| - | apt-get install gimp | ||
| - | |||
| - | * Download a image, right-click and open with GIMP | ||
| - | * Goto **Tools** > **Transform tools** > **Scale** | ||
| - | * Give required height & width and press **Scale** | ||
| - | * Goto **Image** > **Autocrop Image** | ||
| - | * save and exit GIMP | ||
| - | |||
| - | ==For more font related features== | ||
| - | |||
| - | * Download 7 version of ckeditor or tinymce module from drupal.org and place it under /var/www/d7/sites/all/modules | ||
| - | * Enable the module | ||
| - | * Goto **Add content** and now you can see the editor attached the body field | ||
| - | |||
| - | ==Migration of drupal== | ||
| - | |||
| - | * Get a dump of **d7** database from phpmyadmin or mysqladmin or command line as | ||
| - | |||
| - | mysqldump -uroot -ppassword d7 > /var/www/d7/mysql-dump.sql | ||
| - | |||
| - | * Compress /var/www/d7 and take it to your friend's PC and put it in /var/www | ||
| - | * Uncompress files, import the .sql file into phpmyadmin | ||
| - | * edit the /var/www/d7/sites/default/settings.php file and update the username & password in a line which looks like | ||
| - | |||
| - | mysql://root:password@localhost/d7 | ||
| - | |||
| - | with the mysql username & password of the new system and check using http://localhost/d7 | ||
| - | |||
| - | ==Easiest website hosting for testing purposes== | ||
| - | |||
| - | * Create a account using dyndns.org | ||
| - | * After logging in, create a dynamic host | ||
| - | * Check your system ip and put it in the configuration | ||
| - | * Whenever anyone request the dynamic host name you created, the apache server will serve the local instances to the host name. | ||
| - | |||
| - | ==Links== | ||
| - | |||
| - | * [[cms1|Drupal, Day1]] | ||
| - | * [[cms2|Drupal, Day2]] | ||
| - | * [[cms_faq|Frequently Asked Questions, CMS]] | ||
| - | * [[drupal-lms||Library Management System as Assignment]] | ||
cms_faq.txt · Last modified: 2018/03/24 11:13 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
