I’m in the process of developing a website in Joomla and have been using WAMP in XP on my laptop. Now that I’ve moved to openSUSE, I’d like to set up the LAMP stack so I can move the site over from XP to Linux.
What’s the best way of setting this up in openSUSE?
Install the LAMP pattern from YaST, for a start.
Thanks. I did a search for lamp in YAST but it came up with nothing. I always forget about the patterns option in YAST. :shame:
Next, enable the PHP module in Apache, so that it will process PHP scripts.
a2enmod php5
Make sure apache2 and mysql are running by enabling them in YaST.
Then extract Joomla in /srv/www/htdocs, point your browser to the config page, and follow Joomla’s instructions to create a configuration.
Thanks. So is htdocs the www root folder of the web server, i.e. anything that is displayed on a web page goes in here?
Not necessarily. You can put web pages pretty much anywhere if you know how to Alias them. But it is the default DocumentRoot so it’s as good a place as any to start.
Thanks. I’ve got the joomla installation page up.
Hey TPX,
I just finished installing a LAMP server on my OpenSUSE 11.1 system a few weeks ago, so I hope I can be of some help to you. The first step is to install the packages for the LAMP server, which you have already done. Once you have the files installed for the server, the next step is to configure the server to run automatically and run HTTP properly. There are many ways to configure the server, but I’m going to give you the steps I used, which worked out great and are working properly for me. The URL for the tutorial is as follows:
Install & Configure LAMP (Apache/MySQL/PHP) in openSUSE 11.0
(Not my personal tutorial. Found on Google)
While the title says 11.0, it will also work with 11.1.
I hope that helps!
Thanks. I eventually found this guide which is similar. Linux Apache MySQL PHP Server (lamp)](http://en.opensuse.org/Linux_Apache_MySQL_PHP_Server_(lamp)).
It all seemed to go fine except in phpmyadmin I have a warning saying “The additional features for working with linked tables have been deactivated. To find out why click here.” which I haven’t looked into yet. Joomla installed fine despite that warning.
One of the same problems I was having was with PHPMyAdmin. Try running this command and see if the problem persists:
rcmysql start
If this doesn’t work, would you be able to please post the output?
Don’t worry about it for now. The fact that you could use most of the database features through phpmyadmin means that the MySQL server is running so that bit of advice to restart mysql is a red herring. To use the advanced features, you need to do some extra configuration of phymyadmin.
Hey TPX,
Like Ken said, as long as the features in PHPMyAdmin are working, then the problems you are experiencing are not serious errors. Although, it’s good to fix any errors that are coming up, so, if you want, you can try to fix the errors, just so they don’t cause any errors in the future, but it is not a necessity that you do. Please keep in mind that I’m gather this information from different sources, and I hope this properly targets the issues you are having. Based on documentation, the errors appear to be happening in your configuration file and are related to configuring MySQL. More specifically, the problem is related to the database table name in the PHPMyAdmin configuration file. In short, it means that PHPMyAdmin can’t find the database table specified. Simply following the directions below:
Changing PMADB value
[ol]
[li]Open a terminal window
[/li][li]Issue the command su
[/li][li]Enter root password when prompted
[/li][li]Issue the command cp /srv/www/htdocs/phpMyAdmin/config.sample.inc.php /srv/www/htdocs/phpMyAdmin/config.inc.php
[/li][li]Issue the command chmod 777 /srv/www/htdocs/phpMyAdmin/config.inc.php
[/li][li]Issue the command gedit /srv/www/htdocs/phpMyAdmin/config.inc.php
[/li][li]Press Ctrl+F in Gedit
[/li][li]Enter $cfg[‘Servers’][$i][‘pmadb’] into the search field
[/li][li]Press the find button
[/li][li]Enter phpmyadmin into the value of $cfg[‘Servers’][$i][‘pmadb’]
[/li][Line should appear as: // $cfg[‘Servers’][$i][‘pmadb’] = ‘phpmyadmin’; ]
[li]Save the file (press Save anyway if prompted
[/li][li]Issue the command chmod 664 /srv/www/htdocs/phpMyAdmin/config.inc.php
[/li][li]Close the terminal window
[/li][/ol]
Now check PHPMyAdmin and see if the issue has been resolved. This may only change the first error ($cfg[‘Servers’][$i][‘pmadb’] … not OK), but if it does resolve this error, that means we are on the correct path. Another good source of information is the MySQL log file. To access this file, issue the following command in the terminal and enter your root password when prompted:
su -c ‘gedit /var/log/mysqld.log’
Again, as long as PHPMyAdmin is working properly, then this is not a serious problem, but it always good to resolve a problem if possible because there is a reason that PHPMyAdmin is warning you about the problem.
I hope this helps!
Thanks for the effort but unfortunately it didn’t work.
*// $cfg'Servers']$i]'pmadb'] = 'phpmyadmin';*
already existed.
I tried looking at the mysqld log file but it seems empty at the moment.
// means that line is commented out.
YES! Removing the // has removed that error in phpmyadmin.
Thank you, Ken. lol!
Forgot to mention that // is a not a string, but a comment.
Glad that fixed your problem then.
Now I just need to figure out how to get rid of the other errors in the list. I uncommented all the other $cfgs in the list but it didn’t work. Now that would have been too easy