BitNami Forum :: Recent Posts in LAMPStack2011-09-16T09:16:56Zhttp://bitnami.com/forums/forums/lampstack/posts.atomhttp://bitnami.com/forums/forums/lampstack/topics/lampstack-vs-lampp-index-more-slow#post_13910Lampstack vs Lampp (index more slow)<p>hi Beltrán Rueda :<br />
Sorry feedback for a long time.</p>
<p>Yes , index Very slow in SQLRDD+xHarbour .</p>
<p>I try index phpadmin platform no Problem.</p>
<p>SQLRDD+xHarbour Index work in Lampstack or Wampstack was more slow than Lampp or xampp .</p>
<p>I don&#8217;t know why ?</p>2011-09-16T09:16:56Zkokookaohttp://bitnami.com/forums/forums/lampstack/topics/change-datadir-for-mysql#post_13686Change datadir for MySQL?<p>Thanks for the info!</p>2011-07-26T19:35:16Zurasaahttp://bitnami.com/forums/forums/lampstack/topics/mysql-root-password-update-failed-error-unknown-varialbe#post_13671MySQL root password update failed, error: unknown varialbe...<p>Hi,</p>
<p>Take a look this quick guide to change the MySQL root password <a href="http://wiki.bitnami.com/Components/MySQL#How_to_change_the_MySQL_root_password.3f">http://wiki.bitnami.com/Components/MySQL#How_to_change_the_MySQL_root_password.3f</a></p>2011-07-26T07:01:42ZBeltrán Ruedahttp://bitnami.com/forums/forums/lampstack/topics/change-datadir-for-mysql#post_13670Change datadir for MySQL?<p>Hi,</p>
<p>You can find the lib folder at /installdir/mysql/lib. The log file is in the mysql/data folder. I suggest to use BitNami Cloud Hosting for backups, which are properly configured to create consistent snapshots <a href="http://bitnami.com/cloud">http://bitnami.com/cloud</a></p>
<p>Regards.</p>2011-07-26T06:57:52ZBeltrán Ruedahttp://bitnami.com/forums/forums/lampstack/topics/mysql-root-password-update-failed-error-unknown-varialbe#post_13668MySQL root password update failed, error: unknown varialbe...<p>I tried running mysql_secure_installation program at /opt/bitnami/mysql/bin/, but I get the following error message after attempting to change the MySQL root password from &#8216;bitnami&#8217;: &#8220;unknown variable defaults-file=.my.cnf.1258 password update failed&#8221;. Any thoughts? Thanks!</p>2011-07-26T04:33:34Zatsnhttp://bitnami.com/forums/forums/lampstack/topics/change-datadir-for-mysql#post_13662Change datadir for MySQL?<p>Hi! I was following very good instructions in Youtube about <a href="http://www.youtube.com/user/ubuntucloud#p/a/u/0/SPVqJWWiLVI" rel="nofollow">how to make consistent MySql backups</a> (<span class="caps">EBS</span> snapshots) in Amazon <span class="caps">AWS</span>. The tutorial refers to 3 MySQL directories that should be included in the snapshot (and thus be moved to separate volume):<br />
/etc/mysql<br />
/var/lib/mysql<br />
/var/log/mysql</p>
<p>I was wondering which are the corresponding directories in Bitnami. As I understand /installdir/mysql/data is one of them. Which are the other two?</p>2011-07-25T19:39:09Zurasaahttp://bitnami.com/forums/forums/lampstack/topics/lampstack-vs-lampp-index-more-slow#post_13593Lampstack vs Lampp (index more slow)<p>Hi,</p>
<p>Thanks for posting your results. Could you send us the <span class="caps">SQL</span> files so we can test on our own? How you are running the commands to load data in the database (from command line, from <span class="caps">PHP</span> or other language)? Is the amount of time just for <span class="caps">SQL</span> or does it include other stuff, like <span class="caps">PHP</span> being used to load the database?</p>
<p>Regards.</p>2011-07-21T11:22:16ZBeltrán Ruedahttp://bitnami.com/forums/forums/lampstack/topics/shared-library-not-found#post_13590Shared Library Not Found<p>Hi,</p>
<p>Try to start the servers using the &#8220;ctlscript.sh&#8221; that you can find in the installation directory. You can find more info at <a href="http://wiki.bitnami.com/Native_Installers_Quick_Start_Guide#How_can_I_start_or_stop_the_servers.3f">http://wiki.bitnami.com/Native_Installers_Quick_Start_Guide#How_can_I_start_or_stop_the_servers.3f</a></p>2011-07-21T09:44:17ZBeltrán Ruedahttp://bitnami.com/forums/forums/lampstack/topics/lampstack-vs-lampp-index-more-slow#post_13584Lampstack vs Lampp (index more slow)<p>hi:</p>
<p>I test 2 table in Lampstack and Lampp<br />
Lampstack :bitnami-lampstack-5.3.6-0-linux-x64-installer<br />
Lampstack :lampp-linux-1.7.4(32 bit)</p>
<p>same server , same platform(suse linux 11 sp1) , same config of my.cnf</p>
<hr />
<p>[mysqld]<br />
key_buffer_size = 2048M<br />
max_allowed_packet =16M<br />
table_open_cache = 1024<br />
sort_buffer_size = 8M<br />
read_buffer_size = 8M<br />
read_rnd_buffer_size = 16M<br />
myisam_sort_buffer_size = 256M<br />
thread_cache_size = 16<br />
query_cache_size= 64M</p>
<ol>
<li>Try number of CPU&#8217;s*2 for thread_concurrency<br />
thread_concurrency = 16</li>
</ol>
<p>#innodb_data_home_dir = /usr/local/mysql/data<br />
innodb_data_file_path = ibdata1:10M:autoextend<br />
#innodb_log_group_home_dir = /usr/local/mysql/data</p>
<ol>
<li>You can set .._buffer_pool_size up to 50 &#8211; 80 %</li>
<li>of <span class="caps">RAM</span> but beware of setting memory usage too high<br />
innodb_buffer_pool_size = 512M<br />
innodb_additional_mem_pool_size = 200M</li>
<li>Set ..<em>log_file_size to 25 % of buffer pool size<br />
#innodb_log_file_size = 64M<br />
#innodb_log_buffer_size = 8M<br />
#innodb_flush_log_at_trx_commit = 1<br />
#innodb_lock_wait</em>timeout = 50<br />
*************************************</li>
</ol>
<p>table1 : 30480 records , 30.7 MB with 5 index<br />
table2 : 58230 records , 59.7 MB with 7 index</p>
<p>Lampstack: 500 seconds<br />
Lampp: 60 seconds</p>
<p>Why Lampstack more slow than lampp ?</p>2011-07-21T02:57:54Zkokookaohttp://bitnami.com/forums/forums/lampstack/topics/shared-library-not-found#post_13583Shared Library Not Found<p>I&#8217;ve installed the LAMPStack 64 bit version on Amazon&#8217;s cloud server. When attempting to start apache &#8216;apache2/bin/httpd start&#8217; I get the following error:</p>
<p>error while loading shared libraries: libaprutil-1.so.0: cannot open shared object file: No such file or directory</p>
<p>That file is a symlink in apache2/lib/ and points to libaprutil-1.so.0.3.10 so it looks like everything should work as expected. I assume it is some sort of permissions issue &#8211; but I&#8217;m guessing.</p>
<p>Any thoughts on how we can solve this issue?</p>
<p>Thanks.</p>2011-07-21T02:49:20Zdbettshttp://bitnami.com/forums/forums/lampstack/topics/default-mysql-user-has-no-privileges-at-the-end-of-my-tether-3#post_13517Default MySQL user has no privileges. At the end of my tether.<p>I&#8217;m glad to hear that.</p>2011-07-18T13:41:35ZBeltrán Ruedahttp://bitnami.com/forums/forums/lampstack/topics/default-mysql-user-has-no-privileges-at-the-end-of-my-tether-3#post_13516Default MySQL user has no privileges. At the end of my tether.<p>Hooray! Thanks Beltrán! I was obviously wrong about root. Still learning :)</p>2011-07-18T13:04:54Zchichilattehttp://bitnami.com/forums/forums/lampstack/topics/change-datadir-for-mysql#post_13504Change datadir for MySQL?<p>Hi,</p>
<p>I write a quick guide to move the &#8220;data&#8221; folder at <a href="http://wiki.bitnami.com/Components/MySQL#How_to_change_the_data_directory.3f">http://wiki.bitnami.com/Components/MySQL#How_to_change_the_data_directory.3f</a></p>2011-07-17T10:00:42ZBeltrán Ruedahttp://bitnami.com/forums/forums/lampstack/topics/default-mysql-user-has-no-privileges-at-the-end-of-my-tether-3#post_13502Default MySQL user has no privileges. At the end of my tether.<p>Hi,</p>
<p>You should use the &#8220;root&#8221; user to login in the database, not sure why you said that you can not log in. Check that you can login using the command &#8220;mysql -u root -p&#8221; from the same machine. The password is bitnami. You can also login in the phpMyAdmin application but it is not public for security reasons. Check the following link and post if you continue having problems <a href="http://wiki.bitnami.com/Components/phpMyAdmin_and_phpPgAdmin">http://wiki.bitnami.com/Components/phpMyAdmin_a&#8230;</a></p>2011-07-17T09:28:52ZBeltrán Ruedahttp://bitnami.com/forums/forums/lampstack/topics/default-mysql-user-has-no-privileges-at-the-end-of-my-tether-3#post_13496Default MySQL user has no privileges. At the end of my tether.<p>I&#8217;ve got the Lampstack running perfectly on EC2 (with webmin too, alright!). Well, near perfect. I&#8217;m having problems doing anything useful with MySQL.</p>
<p>I can login to phpMyAdmin with the username &#8220;Administrator&#8221; or &#8220;bitnami&#8221; without a password (i tweaked the config.inc.php file to allow this), but under &#8220;Create new database&#8221; it says &#8220;No Privileges&#8221;.</p>
<p>Or, on the command line, running MySQL with &#8220;mysql -u bitnami&#8221; and trying&#8230;</p>
<p><span class="caps">UPDATE</span> user <span class="caps">SET</span> password = <acronym title="&amp;#39;ohgodletmein&amp;#39;"><span class="caps">PASSWORD</span></acronym> <span class="caps">WHERE</span> user = &#8216;bitnami&#8217;</p>
<p>&#8230;gives the answer&#8230;<br />
Access denied for user &#8217;&#8217;@&#8217;localhost&#8217; to database &#8216;mysql&#8217;</p>
<p>Or using mysqladmin&#8230;<br />
sudo mysqladmin -u bitnami password farts<br />
give me&#8230;<br />
Access denied; you need the <span class="caps">SUPER</span> privilege for this operation&#8217;</p>
<p>I even tried the &#8220;mysqld_safe &#8212;skip-grant-tables&#8221; route ( <a href="http://www.ubuntugeek.com/reset-the-root-password-on-mysql.html" rel="nofollow">http://www.ubuntugeek.com/reset-the-root-passwo&#8230;</a> ). No go.</p>
<p>MySQL doesn&#8217;t seem to have a &#8220;root&#8221; user, so i always used either bitnami or Administrator.</p>
<p>How the blazing hellcats do i get the MySQL privileges to do anything useful??</p>2011-07-17T09:08:33Zchichilattehttp://bitnami.com/forums/forums/lampstack/topics/change-datadir-for-mysql#post_13493Change datadir for MySQL?<p>Is there a trick to changing the datadir for MySQL? Many tutorials refer to changing /etc/apparmor.d/usr.sbin.mysqld. The file does not appear to exist in the current Bitnami VM.</p>
<p>Thoughts on how to change the datadir would be appreciated.</p>
<p>Matt</p>2011-07-16T03:28:16Zbugbutcherhttp://bitnami.com/forums/forums/lampstack/topics/phpmyadmin-not-working-on-amazon-3#post_13484phpmyadmin not working on amazon<p>Yes,</p>
You can modify it.2011-07-15T10:19:48ZBeltrán Ruedahttp://bitnami.com/forums/forums/lampstack/topics/phpmyadmin-not-working-on-amazon-3#post_13474phpmyadmin not working on amazon<p>Hey Beltrán &#8211; thanks for your response &#8211; the config.ini.php file says in big <span class="caps">ASCII</span> letters not to edit it. I also could only find AbsoluteUri but no PmaAbsoluteUri &#8211; can I trust they&#8217;re the same?</p>2011-07-14T22:49:36Zaerodoghttp://bitnami.com/forums/forums/lampstack/topics/phpmyadmin-not-working-on-amazon-3#post_13459phpmyadmin not working on amazon<p>Hi,</p>
<p>Check the /opt/bitnami/apps/phpmyadmin/htdocs/config.inc.php and change the &#8220;$cfg[&#8216;PmaAbsoluteUri&#8217;]&#8221; option with your <span class="caps">URL</span>. I hope it helps.</p>2011-07-14T09:04:02ZBeltrán Ruedahttp://bitnami.com/forums/forums/lampstack/topics/phpmyadmin-not-working-on-amazon-3#post_13452phpmyadmin not working on amazon<p>Greetings,</p>
<p>I am having trouble with phpmyadmin. I get the login screen alright and followed your instructions here:</p>
<p><a href="http://bitnami.com/forums/forums/bitnami-cloud/topics/can-t-access-phpmyadmin" rel="nofollow">http://bitnami.com/forums/forums/bitnami-cloud/&#8230;</a></p>
<p>to no avail.</p>
<p>Upon entering the root/bitnami login combo, I still am routed to 127.0.0.1 instead of to my ec2 host name. What&#8217;s going on? How can I rectify this issue?</p>2011-07-14T04:37:08Zaerodoghttp://bitnami.com/forums/forums/lampstack/topics/how-do-i-install-mod_status-for-apache#post_13342How do I install mod_status for Apache?<p>Hi,</p>
<p>This command does not exist in Apache by default. You can list the modules using &#8220;apachectl.sh -L&#8221; but you should edit the /installdir/apache2/conf/httpd.conf file to enable/disable the modules. We will add this command in our <span class="caps">TODO</span> list, thanks for your suggestion.</p>2011-07-06T06:56:35ZBeltrán Ruedahttp://bitnami.com/forums/forums/lampstack/topics/how-do-i-install-mod_status-for-apache#post_13331How do I install mod_status for Apache?<p>The title says it all; normally I would do &#8220;a2enmod info&#8221; with Ubuntu, but Bitnami tells me this does not exist in the LAMPStack.</p>
<p>Can anybody help please?</p>2011-07-05T14:41:46Zyusufhttp://bitnami.com/forums/forums/lampstack/topics/ispcp-omega-and-mysql#post_13201ispCP Omega and MySQL<p>Hi,</p>
<p>The most easy way to restore <span class="caps">LAMP</span> is to stop the servers, rename the /opt/bitnami folder and download the <span class="caps">LAMP</span> native installer and install it manually. Another option is to start a new <span class="caps">AMI</span>.</p>
<p>You can also try to post the mysql error (/opt/bitnami/mysql/data/mysqld.log) and we can see if it is easy to fix it.</p>2011-06-22T07:15:30ZBeltrán Ruedahttp://bitnami.com/forums/forums/lampstack/topics/ispcp-omega-and-mysql#post_13193ispCP Omega and MySQL<p>I am using the 32bit ubuntu <span class="caps">LAMP</span> stack from Bitnami on Amazon EC2 as a basis to attempt an installation if ispCP Omega.</p>
<p>Somewhere along the line the Bitnami install of MySQL get thoroughly trashed. Is there any way to clean all the MySQL&#8217;s off and reload MySql according to Bitnami specs?</p>
<p>If there is a micro image with this preloaded that would work too.</p>
<p>Thanks.</p>2011-06-21T21:01:23Ztrilogichttp://bitnami.com/forums/forums/lampstack/topics/troubleshooting-dns-apache2-virtual-host-issue#post_13161Troubleshooting DNS/Apache2 Virtual Host Issue<p>I&#8217;m glad to hear that. Thanks for posting the solution.</p>2011-06-20T07:08:07ZBeltrán Ruedahttp://bitnami.com/forums/forums/lampstack/topics/troubleshooting-dns-apache2-virtual-host-issue#post_13156Troubleshooting DNS/Apache2 Virtual Host Issue<p>Wahoo! I figured out my issue =) For those curious, here is what I had to do to solve it. Please note that this assumes you have properly configured your <span class="caps">DNS</span> record to allow a wildcard subdomain to point to your BitNami LAMPStack instance.</p>
<p>In my httpd-vhosts.conf file, I have:</p>
<p>NameVirtualHost *:80</p>
<ol>
<li>Virtual Hosts<br />
&lt;VirtualHost *:80&gt;<br />
DocumentRoot &#8220;/opt/bitnami/apache2/htdocs/&#8221;<br />
ServerName <a href="http://www.therobbrennan.com" rel="nofollow">www.therobbrennan.com</a><br />
ServerAlias aws.therobbrennan.com<br />
<br />
&lt;VirtualHost *:80&gt;<br />
DocumentRoot &#8220;/opt/bitnami/apps/wordpress/htdocs&#8221;<br />
ServerAlias blog.therobbrennan.com<br />
</li>
</ol>2011-06-19T19:01:47ZTheRobBrennanhttp://bitnami.com/forums/forums/lampstack/topics/troubleshooting-dns-apache2-virtual-host-issue#post_13155Troubleshooting DNS/Apache2 Virtual Host Issue<p>Hi all! I&#8217;m having a quirky issue with <span class="caps">DNS</span> and Apache2 VirtualHost entries.</p>
<p>In my <span class="caps">DNS</span> record for my domain name, I have successfully set up aws.therobbrennan.com to point to my BitNami Amazon EC2 instance. I also have a wildcard entry so that any subdomain that does not have a <span class="caps">DNS</span> entry would automatically hit my BitNami instance.</p>
<p>&#8212;<br />
In my &#8220;/opt/bitnami/apache2/conf/httpd.conf&#8221; I have the following:</p>
<p>&#8230;<br />
<br />
Options FollowSymLinks<br />
AllowOverride None<br />
Order deny,allow<br />
#Deny from all<br />
Allow from all</p>
<p>&#8230;<br />
Include conf/extra/httpd-vhosts.conf<br />
&#8230;</p>
<p>Include &#8220;/opt/bitnami/apache2/conf/fastcgi.conf&#8221;<br />
Include &#8220;/opt/bitnami/apps/phpmyadmin/conf/phpmyadmin.conf&#8221;<br />
Include &#8220;/opt/bitnami/apps/wordpress/conf/wordpress.conf&#8221;<br />
&#8212;<br />
In my httpd-vhost.conf file, I simply have:<br />
NameVirtualHost *:80<br />
&lt;VirtualHost *:80&gt;<br />
DocumentRoot &#8220;/opt/bitnami/apps/wordpress/htdocs&#8221;<br />
ServerName blog.therobbrennan.com</p>
<p>&#8212;<br />
If I leave my httpd-vhost.conf file as described above, a restart of apache server produces an unintended result. Instead of &#8220;blog.therobbrennan.com&#8221; resolving to my Wordpress installation, it totally fails. However, if I try a subdomain that has a <span class="caps">DNS</span> entry &#8211; aws &#8211; it resolves to the Wordpress site and not my default BitNami server root directory.</p>
<p>If I comment out those changes to the httpd-vhosts.conf file, aws.therobbrennan.com works, as does any other subdomain that doesn&#8217;t have a <span class="caps">DNS</span> entry such as horses.therobbrennan.com. Oddly enough, though, blog.therobbrennan.com still fails. It doesn&#8217;t even bring me to the BitNami server root &#8211; it just totally fails.</p>
<p>Any idea what I&#8217;m missing here?</p>2011-06-19T02:49:02ZTheRobBrennanhttp://bitnami.com/forums/forums/lampstack/topics/sugarcrm-moodle-modules-over-drupal#post_13120SugarCRM & Moodle Modules Over Drupal<p>Sorry, I meant installing SugarCRM and Moodle on top of the <span class="caps">LAMP</span> stack that came with the <span class="caps">DRUPAL</span> stack. Changing properties.ini did the trick. Thanks.</p>2011-06-16T06:20:24Zbigrockhttp://bitnami.com/forums/forums/lampstack/topics/sugarcrm-moodle-modules-over-drupal#post_13079SugarCRM & Moodle Modules Over Drupal<p>Hi,</p>
<p>To install modules on top of drupal is not possible but you can create a properties.ini file with the same info that you can find in the <span class="caps">LAMP</span> Stack installation.</p>2011-06-14T14:12:47ZBeltrán Ruedahttp://bitnami.com/forums/forums/lampstack/topics/sugarcrm-moodle-modules-over-drupal#post_13078SugarCRM & Moodle Modules Over Drupal<p>I have a Bitnami Drupal stack running in the Amazon cloud and I would now like to install two Bitnami modules &#8211; Moodle and SugarCRM to the same instance (Ubuntu, <span class="caps">EBS</span>). I tried installing the respective modules (bitnami-sugarcrm-6.1.5-0-module-linux-installer.bin and the moodle one) but I get the following error message:</p>
<hr />
<p>Begin Session Copy-Paste&#8212;-<br />
Please choose a folder that contains an installation of BitNami LAMPStack.</p>
<p>Select a folder []: /opt/bitnami/</p>
<p>Warning: That folder does not seem to contain a valid installation of BitNami<br />
LAMPStack. The file properties.ini is missing or it is not a valid installation.<br />
Press [Enter] to continue :<br />
<del>&#8212;End Session Copy-Paste</del>&#8212;</p>
<p>properties.ini rightly says this is a Drupal stack but I&#8217;m guessing there must be a way to install Moodle, SugarCRM and other modules that need <span class="caps">LAMP</span> over the Drupal stack with some minor tweaks instead of installing a separate <span class="caps">LAMP</span> stack altogether. All help appreciated. Also when I tried this on a <span class="caps">LAMP</span> stack, the usual default passwords of user/bitnami did not work for either. Thanks</p>2011-06-14T11:49:45Zbigrock