Trendy:

Blog

How to recover or reset your admin password for Joomla

Normally, you can add, edit and delete users and passwords from the back-end User Manager. To do this, you must be logged in as a member of the Super Administrator group.

In some situations, this may not be possible. For example, your site may have been "hacked" and had the passwords or users changed. Or perhaps the person who knew the passwords is no longer available. Or maybe you have forgotten the password that was used.

In these cases, it is still possible to alter the Joomla! database so you can log back in as a Super Administrator. These are the possible methods available to Joomla! administrators.

Method 1: configuration.php file

If you have access to your configuration.php file for the Joomla installation on your server, then you can recover the password using the following method.

1. Using an FTP program connect to your site. Find the configuration.php file and look at the file permissions. If the permissions are 444 or some other value, then change the permissions of the configuration.php file to 644. This will help prevent issues when uploading the changed configuration.php file later in this process.

2. Download the configuration file.

3. Open the configuration.php file that was downloaded in a text editor such as notepad++ and add this line

public $root_user='myname';

to the bottom of the list where myname is a username with administrator access that you know the password for. An username that is Author level or higher can also be used in place of a username with administrator access.

4. Save the configuration.php file and upload it back to the site. You may leave the permissions on the configuration.php file at 644.

This user will now be a temporary super administrator.

5. Login to the back end and change the password of the administrator user you don't have the password for or create a new super admin user. If you create the new user you may want to block or delete the old user depending on your circumstances.

6. When finished, make sure to use the "Click here to try to do it automatically" link that appears in the alert box to remove the line that was added to the configuration.php file. If using the link was not successful, then go back and delete the added line from your configuration.php file using a text editor. Upload the configuration.php file back to the site.

7. Using your FTP program verify the file permissions of the configuration.php file, they should be 444. If you manually removed the added line, then change the file permissions on the configuration.php file to 444.

If you have no users who know their passwords and you can't utilize front end registration you may need to make a change in your database as outlined below in this document.

 

Method 2: Direct Editing of Database

If the methods above did not work, you have two other options, both of which require working with the MySQL database directly.

Change the Password in the Database

If the admin user is still defined, the simplest option is to change the password in the database to a known value. This requires that you have access to the MySQL database using phpMyAdmin or another client.

 

Stop hand nuvola.svg.png
Make sure you change your password once you regain access
 

These instructions show how to manually change a password to the word - "secret"

 

  1. Navigate to phpMyAdmin and select the database for the Joomla! site in the left-hand drop-down list box. This will show the database tables on the left side of the screen.
  2. Find and click on the table with "_users" appended in the list of tables (note: you may have a prefix that is not jos_, simply go to the _users table for your prefix).
  3. Click on the "Browse" button in the top toolbar. This will show all of the users that are set up for this site.
  4. Find the user whose password you want to change and press the Edit icon for this row.
  5. A form will display that allows you to edit the password field. Copy the value
    d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199
    into the password field and press the Go button. phpMyAdmin should display the message "Affected rows: 1". At this point, the password should be changed to "secret".
  6. Log in with this user and password and change the password of this user to a secure value. Check all of the users using the User Manager to make sure they are legitimate. If you have been hacked, you may want to change all of the passwords on the site.

Add a New Super Administrator User

If changing the password won't work, or you aren't sure which user is a member of the Super Administrator group, you can use this method to create a new user.

  1. Navigate to phpMyAdmin and select the database for the Joomla! site in the left-hand drop-down list box. This will show the database tables on the left side of the screen.
  2. Press the "SQL" button in the toolbar to run an SQL query on the selected database. This will display a field called "Run SQL query/queries on database <your database>".
  3. Delete any text in this field and copy and paste the following query below and press the Go button to execute the query and add the new Administrator user to the table.
  4. Use the SQL query below to add another administrator account.

 

Stop hand nuvola.svg.png
Make sure you match your db table prefix!
 

The following code uses jos31_ as the table name prefix which is only an example table prefix. The prefix when you first installed Joomla is RANDOM or what you set it specifically too. You will need to change all occurrences of jos31_(your install set prefix) found in the code below to the prefix your installation is using.

 

SQL code for use with Joomla Joomla 2.5 Joomla 3.1

INSERT INTO `jos31_users`
   (`name`, `username`, `password`, `params`)
VALUES ('Administrator2', 'admin2',
    'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199', '');
INSERT INTO `jos31_user_usergroup_map` (`user_id`,`group_id`)
VALUES (LAST_INSERT_ID(),'8');

At this point, you should be able to log into the back end of Joomla! with the username of "admin2" and password of "secret". After logging in, go to the User Manager and change the password to a new secure value and add a valid e-mail address to the account. If there is a chance you have been "hacked", be sure to check that all users are legitimate, especially any members of the Super Administrator group.

Stop hand nuvola.svg.png
Warning!
 

Warning: The password values shown on this page are public knowledge and are only for recovery. Your site may be hacked if you do not change the password to a secure value after logging in. Be sure you change the password to a secure value after logging in.


The examples above change the password to "secret". Two other possible values are shown below:

- password = "this is the MD5 and salted hashed password"
------------------------------------------------------
- admin  = 433903e0a9d6a712e00251e44d29bf87:UJ0b9J5fufL3FKfCc0TLsYJBh2PFULvT
- secret = d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199
- OU812  = 5e3128b27a2c1f8eb53689f511c4ca9e:J584KAEv9d8VKwRGhb8ve7GdKoG7isMm

How to fix it No installation plugin has been enabled - Joomla 3.6

Joomla 3.6 is a new version of popular CMS. We all are very happy that it arrived. Joomla! 3 is the latest major release of the Joomla! CMS, with 3.6 the seventh standard-term support release in this series. New version introduces more than 400 improvements, including many features which make administration of Joomla! Web sites easier and more feature-rich, as well as many UX (user experience) improvements. But there is one issue, which may be painful. We have easy solution how to fix it.

Since beginning Joomla! allows user to install  modules, components and plugins from back-end of admin section. But since update from Joomla 3.5 to Joomla 3.6 some or all of those options dissapeared. And all you can see is message : "No installation plugin has been enabled. At least one must be enabled to be able to use the installer. Go to the Plugin Manager to enable the plugins."

In current short guide/tip we will show you how to fix it: 

1. First login to your joomla administratior.

2. Go to Extensions -> Manage -> Discover

3. Click Discover button (left top) 

4. After few seconds you should see 3 or 4 plugins with names starting with "Installer - Install from ..."

5. Click checkbox for all or just for Installer - Install from Upload.

6. Then click Install button at the top

7. Now you have to enable them.

8. Go to Extensions -> Plugins and there find all plugins with "Installer" name , next you should enable them (!)

9. That's all. Now you can install Joomla! extensions again.

 

 

Guest Level Members

If you are interested in creating articles on our website blog.

Kindly register an account and contact us using the support form.

PhilmoreSMS would be happy to welcome any interested to share their idea and thoughts in the manner of writing to us. We will publish all the guest

 

DND Policy - How to Deactivate it

DO-NOT-DISTURB POLICY

You must now be fully aware of the new DO-NOT-DISTURB policy of the Nigerian Communication Commission where GSM networks bar subscribers from receiving messages on their phone lines (MTN to be precise).

Ordinarily the policy is harmless, but as everything  goes in our dear country Nigeria, this policy has turn out to be a nightmare to those of us using web sms platform.

The purpose of the DO-NOT-DISTURB policy is very simple, for instance, if a subscriber does not want to receive unwanted messages such as advertisement from custom numbers it is just as simple as sending ‘STOP’ to 2442 for MTN to activate the service and that subscriber no longer receives such messages and if he or she feels like receiving the messages again on his or her telephone line, it is just to send ‘ALLOW’ to 2442.

It is meant to be optional, but what the GSM networks (especially MTN) did was to force some of their subscribers to the service and so subscribers in that category are not receiving messages on their MTN line when they do not in the first instance subscribe to the service and if they send ‘ALLOW’ to 2442 the response they usually get is that they are not subscribed to the DO-NOT-DISTURB service.

The truth is if you continue to send ‘ALLOW’ to 2442 one million times that is the response you will continual get because the restriction is network system induced, but the good news is that we are here to tell you how you can go about it and deactivate that service on your phone line and begin to receive messages on your telephone line and then spread the news to others because the truth is that the GSM networks (especially MTN) are cheating on us. They charge BulkSMS providers for messages they do not deliver to the recipient and that is more money for them.

HOW TO GO ABOUT IT

  1. Send ‘STOP’ to 2442, wait for the response from the GSM network. In this case you have activated the DO –NOT- DISTURB service on your phone line,  This is the only way you can start receiving messages on your phone line (MTN Subscribers only)
  2. Send ‘ALLOW’ to 2442 and wait for the response. Once you get the second response, your MTN line is ready to receive messages.

PLEASE SPREAD THE ABOVE MESSAGE

 

How to Run a Successful SMS Marketing Campaign

SMS - invest in what works 

First of all, let’s remind you that one of the best things about SMS is that almost 100% of all mobile phones are SMS enabled. Regardless of being “smart” or “not smart” enough, the one thing in common to all mobile phones is SMS. This means that SMS is the mobile channel with the widest reach possible today. So, if you’re using SMS in marketing purposes then you definitely have an ace up your sleeve. If you’re not using SMS as your mobile marketing tool, than you should consider using it now.

 

If you’re asking why, we’ll tell you one more fact about SMS efficiency – more than 90% of text messages are read within 3 minutes of being received. Compared to email marketing, with only 22% open rate, SMS is one of the most powerful marketing tools that can assure your marketing message is reaching your customers for real. This is the reason why some of the world’s most famous brands use SMS marketing as integral part of their mobile marketing strategy. It’s been quoted so many times that Coca-Cola spends 70% of their mobile budget on SMS marketing. And when asked why, the answer was simple: “Because we invest in what works.”

 

Yes, the mobile phone has become a primarily means of communication in so many ways, from its basic function to call and answer the phone call to browsing the Internet, watching movies, checking social networks and chatting with friends, playing games and even shopping online. Among all these variety of options mobile phones offer us today, there is one everyone uses – SMS. And to prove this statement we’ll quote Mobile Marketing Association who published data that over 350 billion text messages are being sent across the world’s mobile networks each month! And 15% of this number, according to Yankee Group, are classified as marketing messages.

 

So, let’s take a look at some of the rules you should follow if you want to create and run successful SMS marketing campaign.

 

1. Define your goal

This is the key thing to start with. As in any other marketing campaign, you must know what you want to achieve with your SMS marketing campaign. More leads, more sales, brand awareness, driving website traffic etc. So, first pick your strategic business goal because it will lay a foundation of your SMS marketing campaign and help you to easily structure it and execute it.

 

2. If selling is your main goal, go for BOGO

BOGO deal, better known as Buy-One-Get-One, is the best price-based offer you can use if your main goal is to sell more products or services. Why? Because some studies have shown that even 66% of consumers are ready for action if they receive price-based offer in an SMS. And even 68% of those interested in price-based offers will not only positively react, but will really act if you offer them your products as a BOGO deal. The reason behind this number is fact that people consider such deals as the most valuable. The point is you’re offering your customers to buy one product in order to get another one, similar or with a similar price etc. And options are limitless because ‘buy something – get something’ strategy allows you to mix & match products to get the best possible results and positive ROI, of course. But, pay attention to this – people don’t like free things so much as you might think. So if you structure your offer like: “Free product if you buy…” your customers might not react very well. Why? Because people consider free products as items that probably have little value and you’re giving them for free because of that. But you’re asking them to spend specific amount of money in return? Nope, this will not work well, believe us.

 

3. Never, ever send messages early in the morning or late at night

This sounds so logical, but you might be surprised to find out that some marketers still make such mistakes. Trying to be different, to create an exceptional service experience or to stand out from the rest at all costs, some make such crucial mistakes that have serious consequences. First and foremost, people don’t like to be harassed. Especially after they’ve finally finished their work and went home. The point is to put yourself into your customers’ shoes and answer this simple question – would you like to be waken up early in the morning or late at night with a text message offering you some special discount? No, of course not. So if you wouldn’t like to experience something like that why would you want to make your clients go through that? The point is to make them fall in love with your brand, not the opposite. In this case, direct consequence is opting out from your SMS marketing campaign. In other words, you’re losing clients (read money).  

 

4. Avoid SMS O’clock time

So, the next logical question is: When to send SMS marketing messages? Clearly you should not send your SMS marketing messages at an inappropriate time because this would be considered as very rude interruption. Actually, the rule when to send promotional messages has already been defined: don’t send SMS marketing messages before 8 A.M. and after 9 P.M. (referring to subscriber’s own time zone). But, there is one interesting thing that happens regularly and you can notice it if you subscribe to a lot SMS marketing campaigns. Some call it an SMS marketing rush hour but we’ll call it ‘SMS O’clock’ time. When creating SMS marketing campaign, many tend to schedule their messages to be sent at certain o’clock time, for example at 10 o’clock, 11 o’clock, noon etc. It’s definitely easier to schedule your campaign this way, but if your clients have subscribed to receive promotional messages from other brands or services, your SMS marketing message will likely be lost among other messages and you’ll miss your business opportunity. Because everyone else is sending their messages at the top of the hour. So, if you want to achieve the best results and really stand out from the rest, avoid these o’clock moments. Schedule your messages 15 minutes after or 21 minutes after or… You get the point.  

 

5. Create effective call-to-action

And, at the end, there is another mistake you should avoid. Don't assume people will know what to do after you tell them how great is your product. People want precise instructions what to do next and how to do it. The best way is, of course, the clear call-to-action. So, if you’re giving them a special discount coupon, make sure to put redemption instructions. Or, if you’re promoting your mobile optimized website and want to drive more traffic through this channel, make sure to tell customers why they should click on the link you sent them in your promotional SMS message. Also, if you’re using the keyword and short code to trigger some action, the best practice is to capitalize both of them to make them stand out within your call-to-action. Avoid using quotations around the keyword because people might send keyword with quotations which will not trigger the campaign. 

IMPORTANT NOTICE

Online Payment:

We have Added a new Payment Method, you can now pay for SMS on paystack.philmoresms.com

Click to Buy SMS

 

DND Issue Resolved:

The default sender ID are now rUPDATE to MTN.  Whatever sender ID you use to send SMS will automatically be  replaced by the new default sender ID. Please, endeavour to add your sender name in the message to indicate it is from you.

With Our corporate route, your messages will enjoy real-time magic delivery to all Nigerian numbers regardless of the DND status. We shall keep you posted on the progress we are making. Thank you for your perfect understanding.

Please note: SMS Charges to MTN is now 2 units/SMS.