Featured Images

Creating separate databases and logins phpmyadmin on WAMP server

Editing and hacking your website in the live environment can be risky – a useful approach is to install WAMP server locally on your laptop, load up you website software, then carry out your hacks in a safe environment. Now we have set up correctlyas shown in the last tutorial creating separate logins for each application is very straightforward. Let’s assume I am going to create a local WordPress  instance on my laptop.

The next steps creates the logins:

  • Login to phpmyadmin user the root user and password
  • From the home administration screen go to the tab ‘Privileges’:

  • Select ‘Add a new User’ about a quarter of the way down on the left.

add user phpMyAdmin

  • The rest of the Add User dialogue opens up as shown.
  • Enter wordpress for the user name
  • Select local from the host drop down and localhost will appear in the field to the right.
  • Enter wordpress for the password (repeat wordpress in the retype box)
  • Select  the checkbox ‘Create database with same name and grant all privileges’
  • Check All for global privileges if you wish

create a data base same name user

Scroll down to the bottom of the screen and hit GO as shown on the screen shot.

select go to create the datebase

That’s it

The direct execution panel for SQL will show the query being run and the creation of the new databases along with the credentials we entered above.

Log out of root and you will go back to the initial login screen. To check all is OK just re login with the username ‘wordpress’ and password ‘wordpress’ to check all is in order.

Next:

  • Download the latest distribution of WordPress from www.wordpress.org (currently 3.1)
  • Unzip the package and copy the wordpress folder to the httpdocs folder usually c:\wamp\www\httpdocs\
  • When you have loaded wordpress to the httpdocs directory on the laptop  open up localhost from the wampserver services tab navigate to the wordpress directory and the famous wordpress install routine will start up. Just fill in the db user and password as ‘wordpress’ and enter the default user details and the install completes in about two seconds.

When that is complete just create an alias to wordpress or bookmark the local site to complete the process.

Repeat the above for each local application you wish to install.

So give it a try

Royston

Creating a login screen in phpMyAdmin

When installing local applications on your laptop to run on WAMP server it is often useful to create separate databases and logins for the applications so you can keep things in order. There are several ways to do this but I thought I would set down a step by step process that dummies such as me could follow.

So if you wish to install WordPress, Mantis or Limesurvey as local applications this short tutorial shows you how to do it.

When WAMP server is first installed the root user is created with no password and as default no login intermediate screen is available.

The first task is to edit the phpMyAdmin config file to correct this:

  • Navigate to C:\wamp\apps\phpmyadmin3.3.9
  • And open config.inc.php in wordpad
  • Define two passwords yourpasswordA and yourpasswordB
  • Add the changes to your config .inc.php file  as shown in red below
  • Save the file and close WordPad

Config.inc.php changes:

$cfg[‘blowfish_secret’] = ‘yourpasswordA’;

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg[‘Servers’][$i][‘verbose’] = ‘localhost’;
$cfg[‘Servers’][$i][‘host’] = ‘localhost’;
$cfg[‘Servers’][$i][‘port’] = ”;
$cfg[‘Servers’][$i][‘socket’] = ”;
$cfg[‘Servers’][$i][‘connect_type’] = ‘tcp’;
$cfg[‘Servers’][$i][‘extension’] = ‘mysqli’;
$cfg[‘Servers’][$i][‘auth_type’] = ‘cookie‘;
$cfg[‘Servers’][$i][‘user’] = ‘root’;
$cfg[‘Servers’][$i][‘password’] = yourpasswordB‘;
$cfg[‘Servers’][$i][‘AllowNoPassword’] = false;

/* End of servers configuration */

$cfg[‘DefaultLang’] = ‘en-utf-8’;
$cfg[‘ServerDefault’] = 1;
$cfg[‘UploadDir’] = ”;
$cfg[‘SaveDir’] = ”;

/* rajk – for blobstreaming */
$cfg[‘Servers’][$i][‘bs_garbage_threshold’] = 50;
$cfg[‘Servers’][$i][‘bs_repository_threshold’] = ’32M’;
$cfg[‘Servers’][$i][‘bs_temp_blob_timeout’] = 600;
$cfg[‘Servers’][$i][‘bs_temp_log_threshold’] = ’32M’;

Next go to the WAMP server services panel and select phpMyAdmin

A login screen will appear as shown below – enter your login details as:

Username :Root

Password: yourpasswordB

Login Screen for phpMyAdmin

You will then be taken to the phpMyAdmin administration screen where you see you have logged in a root@localhost if all has gone well – this is the screen you normally go to when no login routine is in place.

admin screen phpmyadmin

Next step creating logins

Creating a Best Practice Self Service Intranet

Self Service Best Practice

A lot of dollars have been invested by companies on implementing internal web sites and more recently on developing HR applications for the intranet to facilitate employee and management ‘self-service’. This idea makes a lot of sense as it helps to increase employee engagement with company goals and procedures as well as reducing workload on internal key personnel and outsourced service companies. This can remove from them the often routine day-to-day trivia enabling them to become more focused on what matters and enables them to control their costs.

As well as this intranets can provide a greater degree of flexibility for individuals and groups as well as assist in the creation of a ‘learning organization’ where change becomes easier and embedded. However, despite what seems to be obvious benefits to both the individual and the organization overall practice shows us that utilisation of these systems is generally very low.

This post offers some best practice pointers we can follow to ensure employees are motivated to use company intranets and self- service facilities.

  • Make sure each business area or department whose services are being delivered on the intranet are involved in the design, implementation, evolution and diffusion of their web sections. Better still, ensure they plan and define their expectations and use of the web to ensure goal attainment – the system is far more likely to be effective if it is business needs driven.
  • Ensure that the end users are monitored continuously and asked for feedback on the design and useability and any later changes you decide to implement.
  • These sorts of initiatives must have enthusiastic support from the very top – and make sure that this is disseminated in a controlled manner.
  • Ensure all information on your intranet is important and relevant to user’s jobs and of benefit to them in their work – it should also be up to date. If you can include aspects of work that they must use, or will be motivated to use because it is simpler (such as booking vacation on line or clearing expenses), that will help increase usage.
  • Make available a searchable, easy to navigate, repository of information. Whilst care should be taken not to overload people with too much information, research shows staff can become more productive if they have easy access on the intranet to a range of standard company documentation.
  • Give recognition for any work published or pages developed to those who created the content. This not only increases motivation but ensures changes can be communicated to the right person, increasing accuracy and reliability.
  • Technically the system must be fast, reliable, and easy to use. If not and staff have to invest time finding information, or struggle with using the system, they will give up. There are detailed best practice guidelines for the technical development of websites available, which include best use of colour, format and content presentation, identifying new items, ensuring no broken links, and reducing the number of clicks/ease of navigation. These should be adhered to.

Things to Avoid:

  • Do not leave it all to the IT department to organise. They can only take responsibility for the technical aspects, not motivating individuals or selling business practices. The strategic effectiveness of intranets can also be adversely affected if content and structure is left solely to IT.
  • Do not assume that staff will start to use it in time, or after a short initial training course. They will need good reasons for using the system as well as ease of use – if there is no value they will not use it!
  • Do not use as a general data repository or an uncontrolled mass-communication device. People suffering from information overload actually reduce the time and effort spent on the system and can miss the information that is valuable. Focus on the relevant.

Developing these areas of best practice should enable companies to ensure that investment in intranets is not wasted and users will actually get some benefit from accessing the information

Operating systems 64-Bit what does this mean

64-Bit Operating System

The 64-bit operating system is one that is capable of storing information in memory that is at least 64 bits or 8 bytes wide. They are also based on registers, address buses, or data buses of that same size. A bus is a subsystem that transfers data or power between computer components inside a computer or between computers. The bus is controlled by a device driver similar to those that control outside peripherals like a mouse or printer. 64-bit CPUs have existed in super computers since the 1960’s and work stations and servers since the 1990’s. While this architecture has been around for awhile, 64-bit operating systems are relatively new oncepts
in the computer world. Windows XP, Windows Vista, and Mac OS X Tiger are all 64-bit operating systems.

The advantages to 64-bit operating systems are far-reaching. They are more powerful and more reliable than the 32-bit systems. The 64-bit operating system can address more memory directly without using complex indexing or register-addressing schemes. Because internal memory is several orders of magnitude faster than storage, combining a 64-bit processing architecture with more RAM lets a processor pull more data into memory and operate on it directly, increasing performance manifold. A 64-bit file system also can improve disk management. Rather than having to take a large disk, such as a 9 GB storage module, and segmenting it into 32-bit addressable chunks (2 GB each), you can address the entire disk. That can help, for example, both in database performance and the performance of the operating system itself. 64-bit operating systems are great for user who need to access very large data stores. The system is valuable in industries such as CAD (computer aided drafting), science and engineering, human resources, and financial modeling. Users working with these computer-intensive applications will probably see immediate improvement with 64-bit machines over 32-bit machines running at the same clock rate and with similar memory configurations. There is a simple analogy that can help explain the difference between a 32-bit operating system and a 64-bit operating system. A 32-bit addressing environment can keep track of the name and address of every person who has lived in the United States since 1997. A 64-bit environment can keep track of the name and address of every person who has every lived in the world from the beginning of time. That’s a powerful system!

The advent of the 64-bit operating system is technology that has been sorely needed for some time. Users notice a marked improvement in performance, storage, and much more with these new, powerful 64-bit operating systems.

The History of Operating Systems – Windows 98

Windows 98

Windows 98 – codenamed Memphis – was released by Microsoft Corporation on June 25, 1998.  Windows 98 was the successor to Windows 95 and presented a hybrid 16-bit/32-bit monolithic product which was based on MS-DOS.  It was quickly followed by an updated to the operating system with Windows 98 SE (second edition) as Microsoft attempted to fix many bugs that were present in the original version.

Among the newer features of Windows 98 were better AGP (accelerated graphics port) support, functional USB (universal serial bus) drivers, and support for multiple monitors and Web TV.  It also featured support for the FAT32 file system allowing it to support disk partitions larger than the two gigabyte maximum accepted by Windows 95.  It was also the first version of Windows to support ACPI (advanced configuration and power interface.

Windows 98 was also the first operating system to use Windows Driver Model which standardized device driver programs and allowed for more peripherals to runs smoothly on the system.  When Windows 98 was released, this fact was not well published and device manufacturers continued to develop devices with drivers under the old system which would make them incompatible with the new operating system.

One huge advantage of Windows 98 as an operating system was that the system requirements were low.  That means that even older machines can effectively and efficiently run Windows 98 and users can take advantage of the new updates to the system.

Windows 98 also offered up full support for DOS applications because it can easily be switched to DOS mode.  In doing this, DOS based applications can handle the system in their native environment.  Having DOS mode available also provides for easier ways to fix system errors without having to enter into the graphical user interface.

Like other previous versions of Windows, this operating system wasn’t without its problems.  Windows 98 was never as stable as common users had hoped.  Often, the software developers of drivers and applications had insufficient experience with the creation of programs for this new system.  This caused many errors generally described as system errors by users even if the error was not caused by parts of Windows or DOS.

Newer versions of Windows would fix these problems, and Microsoft worked quickly to provide patches to the Windows 98 system for users to download and make their system much more stable.

As with most operating system, Windows 98 was updated soon after its release and improved upon.  It did provide some great updates that would serve as models for subsequent versions of Windows.