Disabled Front Page:-
body.page-node-1 header#main-content-header{display: none;}
body.page-node-1 header#main-content-header{display: none;} //-----> Change your Article page node number insted of 1
Importing a SQL db into mysql using the terminal :-
root@chinna:~# mysql -u username -p password databasename < filename.sql
Ex:
root@chinna:~# mysql -u root -p techlearn < /home/chinna/Desktop/techlearnin.sql
Password : *******
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Exporting a SQL db into mysql using the terminal :-
root@chinna:~# mysqldump -u root -p databasename > databasename.sql
Enter password: *******
Ex:
root@chinna:~# mysqldump -u root -p techlearn > techlearn.sql
Password : *******
Unblocking an account :-
Say you accidentally "block" your admin account and cannot log in. From within a MySQL client you can run this command to unblock it.
mysql > update users set status = 1 where uid = 1;
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Reset user/root password :-
Find a way to reset my root level password in Drupal 7 with only access to phpMyAdmin and ftp.
mysql--> database--> users --> edit users --> add below password hash code in pass insted of old code field.
password hash code : $S$C6x2r.aW5Nkg7st6/u.IKWjTerHXscjPtu4spwhCVZlP89UKcbb/
New pwd : NEW_TEMP_PASSWORD
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Import large .sql files to phpmyadmin in LAMP :-
root@chinna:~# nano /etc/php5/apache2 /php.ini
Find:
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M
Change to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 300
max_input_time = 540
memory_limit = 1000M
Save the changes.
root@chinna:~# /etc/init.d/apache2 restart
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
PHP block code :-
<div class="logo">
<div class="img-browser"><img src="/sites/all/themes/dhani/photos/socialmedia/selenium.png"></div>
<p class="website"><a href="http://www.techlearn.in/drupal-tutorial" target="_blank">Visit "Drupal Tutorial" Website</a></p>
</div>
</div>
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
How to connect cPanel-SSH Access :-
root@debian:/home/chinna# ssh-keygen
Generating public/private rsa key pair.
Enter file in which to save the key (/root/.ssh/id_rsa):
root@debian:/home/chinna# cat ~/.ssh/id_rsa.pub
ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDP3xeohPxX0BkV8Dt0CMF2oLC7DFCi3mA+tcNqZK0pjp4JO+vKXMiYsKwEmccDEoxs1cUBQf4GX9T5OzQVcHgpy7NZ/kPtcwzn//WdUECvlY5KQG30Iq3EdEn91d90kcRdU+h4sewkb5y20Z7i7YE5xi5qrJGDiPyMZMo0HJfe6N1SsAd5qj3Xis1qxnruUpXEtgfF8NbSw8Z7xEW5 root@debian
root@debian:/home/chinna# cat ~/.ssh/id_rsa
-----BEGIN RSA PRIVATE KEY-----
MIIEpAIBAAKCAQEAz98XqIT8V9AZFfA7dAjBdqCwuwxQot5lLWHHB8L3CZN7XM5P
xMr0lwHXsV7TGL17a734NSTZ12UqbaT7Vjb8v9ZwtumTuDwub0/Z4cKQD0dIgFza
.
qZs3Ix4dpjsWZw5JQD4V5Ip1LHvZov87CAhtmN8jhTsUEWiJznkfKczpgkixmzRy
5syVzV03oeUiCxA5gySakm+dvp2RSGjWd59rOmqMzO8CDIYPJCx6Ew==
-----END RSA PRIVATE KEY-----
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
===================================================================
enabling clean urls in drupal 7:-
root@chinna:/home/chinna# nano /etc/apache2/sites-enabled/000-default.conf
<Directory />
Options FollowSymLinks
AllowOverride All
</Directory>
<Directory /var/www/>
RewriteEngine on
RewriteBase /
Options Indexes FollowSymLinks MultiViews
AllowOverride All
Order allow,deny
allow from all
</Directory>
Ctrl+x
Yes and Enter
root@chinna:/home/chinna# service apache2 restart
root@chinna:/home/chinna# /etc/init.d/apache2 restart
also in the terminal.
Next i went back to localhost from my browser and then enabled clean urls
from administer > site configuration > clean urls
OR
You have to modify the virtualhost in httpd.conf
change this line AllowOverride None to AllowOverride All
root@debian:/home/chinna# nano /etc/apache2/sites-available/default
<VirtualHost *:80>
ServerAdmin webmaster@localhost
DocumentRoot /var/www
<Directory />
Options FollowSymLinks
AllowOverride All
</Directory>
<Directory /var/www/>
Options Indexes FollowSymLinks MultiViews
AllowOverride None
Order allow,deny
allow from all
</Directory>
ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/
<Directory "/usr/lib/cgi-bin">
AllowOverride None
Options +ExecCGI -MultiViews +SymLinksIfOwnerMatch
Then restarted apache by:
root@chinna:/home/chinna# /etc/init.d/apache2 restart
also in the terminal.
Next i went back to localhost from my browser and then enabled clean urls
from administer > site configuration > clean urls
Save configuration. And there! It works. No more strange looking characters in my address bar.
If you are using drupal 7,then there is no need to edit the .htaccess file because clean url is enabled by default.
So here's the trick,if the clean url test fails on drupal 7.You will have to edit the url.
Your url at the clean url page should be;
http://www.yoursite.com/?q=admin/config/search/clean-urls {0r} http://localhost/techlearn/?q=admin/config/search/clean-urls
So edit it and change it to;
http://www.yoursite.com/admin/config/search/clean-urls
Now you should see the enable clean url button.
OR
root@chinna:/home/chinna# sudo a2enmod rewrite
Modify the Apache configuration file.
It is located at:
root@chinna:/home/chinna# /etc/apache2/apache2.conf
And change the existing "AllowOverride None" to "AllowOverride All" as below:
<Directory /var/www/>
Options Indexes FollowSymLinks
AllowOverride All
Require all granted
</Directory>
And then Restart Apache
root@chinna:/home/chinna# /etc/init.d/apache2 restart
also in the terminal.
Next i went back to localhost from my browser and then enabled clean urls
from administer > site configuration > clean urls
===================================================================