Hi
I have already installed:
I have checked extension=mysql.so in php.ini
and restart de services
However it looks that “Your PHP installation appears to be missing the MySQL extension” and I cannot run a simple wordpress.
Could you please help me? What am i doing wrong?
Which version of these apps did you install? I.e., where did you get them from?
Hi Ricardo, Thanks a lot for your attention.
I´m getting all of them from ftp://updates.drobo.com/droboapps/2.0/downloads/
Let me know,
Hmm, as far as I can tell, the official Apache server from Drobo does not integrate well with the PHP package from Droboports.
Unfortunately, I had to remove the Apache app from Droboports because it conflicts with the official app. I haven’t had the time to fix it, so for now the only option for the 5N is the official Apache app. The problem is that the official Apache app is very, very old. And quite limited as well.
You can try to configure the official Apache app to use the Droboports version of PHP using CGI instead of mod_php. You can Google around for the details, but it basically means editing Apache’s httpd.conf file and adding something like this:
ScriptAlias /local-bin /mnt/DroboFS/Shares/DroboApps/php/bin
AddHandler application/x-httpd-php5 php
Action application/x-httpd-php5 /local-bin/php-cgiJust keep in mind that you shouldn’t expect performance miracles out of this setup, but it should work.
Hi Ricardo,
Thanks again for your help.
Well I have added this sentences to the httpd.conf and I´m restarting the Drobo. Let me see…
Ok, now it is working…
In addition,
It is not mandatory for me use Apache. What recomendation are coming from you? PHP+MYSQL AND LIGHTTPD … for example?
Thank you too much!
You can try lighttpd, but as a rule of thumb if your setup is working without it then there is no reason to add another app to the Drobo. More apps mean more CPU usage, and less RAM available for everyone. Less RAM means more swapping, which is the real performance killer.
Hi,
Once We have already installed the Apache2 and PHP, both working perfectly, We have some problems with the last version MYSQL (mysql-5.6.13) downloaded from droboports.com
In old version we got the password from /mnt/DroboFS/Shares/DroboApps/mysql/data/.mysql_secret
However in this last version we have to use the script included /scripts called mysql_install_db
This script has the options:
OPTIONS:
-h Show this message
-n Name of the database
-u User account with all rights to the new database
-p Password for the user account
-f Force the creation (remove first if the database exists)
-b Folder to place the database backup
we have try many times but it is not resolving the installation.
MySQL root config file not found.
Also for mysql/mysql credentials but the same msg.
We have copied my.cnf to several folders and also introduce the -b option to assign a new folder DDBB… … nothing
Only with
“mysqld_safe --skip-grant-tables &” we started the service but we can not access to the mysql.tables to find or modify the root password.
the log show
2014-06-25 09:45:30 909 [Note] Server hostname (bind-address): ‘*’; port: 3306
2014-06-25 09:45:30 909 [Note] IPv6 is available.
2014-06-25 09:45:30 909 [Note] - ‘::’ resolves to ‘::’;
2014-06-25 09:45:30 909 [Note] Server socket created on IP: ‘::’.
2014-06-25 09:45:30 909 [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql.user’ doesn’t exist
Fatal error: Can’t open and lock privilege tables: Table ‘mysql.user’ doesn’t exist
What steps are to get mysql works…?
Thanks in advance!
When you first installed MySQL, did you install Perl first? This is a small annoyance of MySQL. It requires Perl for the install. After that you can remove Perl if you want.
Perl, Yes already I had it installed with created link
ln -s /mnt/DroboFS/Shares/DroboApps/perl5/bin/perl /usr/bin/perl
Also, Phython for dependences.
my.conf file is /mysql &
/mysql/data &
/mysql/scripts
We have tried
MySQL root config file not found.
MySQL root config file not found.
Including where I want to create the DDBB
MySQL root config file not found.
We have read MySQL’s documentation to try find more information, but not luck abouth why MySQL root config file not found.
Could you explain by steps the mysql process install?
Just to know if we are forgetting anything…
If your install did complete successfully, there should be a file /mnt/DroboFS/Shares/DroboApps/mysql/data/.root.cnf that contains the username and password for the mysql root account.
Mind you, this file is only readable by root, for obvious reasons. In other words, only root can use the mysql_create_db.sh script.
Yes my installation did complete sucessfully, not there is not any .root.cnf file in the path /mnt/DroboFS/Shares/DroboApps/mysql/data/
Anyway here is my contributation to solve:
SSH by root
#cd . ; ./bin/mysqld_safe &
The root password has changed!
Then I get ID process of mysqld_safe using
#ps -w | grep mysqld_safe
16971 mysql 727m S /mnt/DroboFS/Shares/DroboApps/mysql/bin/mysqld_safe
normal restart the service
#service.sh start
Verify using:
#service.sh status
mysql is enabled and running
Check if there is any issue on the log
2014-06-26 13:44:48 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-06-26 13:44:48 19260 [Note] Plugin ‘FEDERATED’ is disabled.
2014-06-26 13:44:48 19260 [Note] InnoDB: The InnoDB memory heap is disabled
2014-06-26 13:44:48 19260 [Note] InnoDB: Mutexes and rw_locks use InnoDB’s own implementation
2014-06-26 13:44:48 19260 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-06-26 13:44:48 19260 [Note] InnoDB: Not using CPU crc32 instructions
2014-06-26 13:44:48 19260 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-06-26 13:44:48 19260 [Note] InnoDB: Completed initialization of buffer pool
2014-06-26 13:44:48 19260 [Note] InnoDB: Highest supported file format is Barracuda.
2014-06-26 13:44:48 19260 [Note] InnoDB: The log sequence numbers 1626037 and 1626037 in ibdata files do not match the log sequence number 1626057 in the ib_logfiles!
2014-06-26 13:44:48 19260 [Note] InnoDB: Database was not shutdown normally!
2014-06-26 13:44:48 19260 [Note] InnoDB: Starting crash recovery.
2014-06-26 13:44:48 19260 [Note] InnoDB: Reading tablespace information from the .ibd files…
2014-06-26 13:44:48 19260 [Note] InnoDB: Restoring possible half-written data pages
2014-06-26 13:44:48 19260 [Note] InnoDB: from the doublewrite buffer…
2014-06-26 13:44:48 19260 [Note] InnoDB: 128 rollback segment(s) are active.
2014-06-26 13:44:48 19260 [Note] InnoDB: Waiting for purge to start
2014-06-26 13:44:49 19260 [Note] InnoDB: 5.6.13 started; log sequence number 1626057
2014-06-26 13:44:49 19260 [Note] Server hostname (bind-address): ‘*’; port: 3306
2014-06-26 13:44:49 19260 [Note] IPv6 is available.
2014-06-26 13:44:49 19260 [Note] - ‘::’ resolves to ‘::’;
2014-06-26 13:44:49 19260 [Note] Server socket created on IP: ‘::’.
2014-06-26 13:44:49 19260 [Note] Event Scheduler: Loaded 0 events
2014-06-26 13:44:49 19260 [Note] /mnt/DroboFS/Shares/DroboApps/mysql/bin/mysqld: ready for connections.
Version: ‘5.6.13’ socket: ‘/tmp/mysql.sock’ port: 3306 Source distribution
Done,