User Tools

Site Tools


cms_faq

This is an old revision of the document!


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.users 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
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
  • 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.
cms_faq.1308899297.txt.gz · Last modified: 2018/03/24 11:13 (external edit)