hello guyz i have this plugin, SimpleFeatures WebServer and PHP 5.2.8 installed. How do i install phpmyadmin?

whatever i do i get" ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)" even when i inter default password:root

 

Have you tried:

 

mysqladmin -u root password root

Can someone tell me how to set it so that I don't lose my DB at every reboot? Not installed on the cache drive.

Hi guys - quick question regarding mySQL: When I start this program I get the following error:

 

Warning: World-writable config file '/etc/my.cnf' is ignored

 

I've gone through and done:

 

chmod 644 /boot/config/plugins/mysql/my.cnf

 

but when I do an ls -l on that file I don't see it changing permissions. I've also done the chmod 644 on /etc/my.cnf but I still get that error.

 

I had an issue where the USB drive was Read-Only, but I've since loaded it to my Windows PC and had a ScanDisk run on it since, and it appears to be working again (I can add and remove files and edit them).

 

This DOES NOT show up in Putty, just on the console.

 

The included picture shows the top window, which is PuTTy, where I performed the CHMOD commands, then an LS -L. The bottom window shows the errors I run into when I "Enable" the MySQL plugin.

 

Things work - I just have a lot of spare horse-power on this server and figured I'd increase a few settings to see if it made a difference.

So in the plugin it is coded like this:

 

if (file_exists("/boot/config/plugins/mysql/my.cnf")) {

      unlink("/etc/my.cnf");

      copy("/boot/config/plugins/mysql/my.cnf", "/etc/my.cnf");

    }

    else {

      exec_log("cp /etc/mysql/my-medium.cnf /etc/my.cnf");

      exec_log("sed -i -e '/^#innodb_data_home_dir/c\\innodb_data_home_dir = '$DATADIR'' /etc/my.cnf");

      exec_log("sed -i -e '/^#innodb_log_group_home_dir/c\\innodb_log_group_home_dir = '$DATADIR'' /etc/my.cnf");

      exec_log("sed -i -e '/^#innodb_log_arch_dir/c\\innodb_log_arch_dir = '$DATADIR'' /etc/my.cnf");

    }

 

 

So I believe you would want to change the boot/config/plugins/mysql/my.cnf because it gets copied over to /etc/my.cnf

I try changing that file, but the permissions stay exactly the same. I've gone through CHMOD on the PuTTY command and through MC's CHMOD option, nothing changes it.

Isn't that because /boot is a FAT32 file system and Linux file permissions aren't applicable there?

 

You would probably need to edit the section of the plugin highlighted by thedude459 and add the chmod command after the line which copies my.cnf to /etc

Isn't that because /boot is a FAT32 file system and Linux file permissions aren't applicable there?

 

You would probably need to edit the section of the plugin highlighted by thedude459 and add the chmod command after the line which copies my.cnf to /etc

 

Exactly, you can't chmod the flash file system. It should use that file, my install does. I turned off the logging, which was taking a huge amount of space on my cache drive.

That makes more sense. Like I said - it shows up only on the console itself, not in my PuTTY session nor my log from what I can tell so maybe I'm just looking too far into this (especially if it is working for everyone else).

That's the piece that I've been hunting for. The MySQL plugin is giving me the same world-writable error. I removed the /etc/my.cnf and restarted MySQL which puts it back with 666 permissions. I think I'm missing something in the editing of the plugin.

 

if (file_exists("/boot/config/plugins/mysql/my.cnf")) {
      unlink("/etc/my.cnf");
      copy("/boot/config/plugins/mysql/my.cnf", "/etc/my.cnf");
      exec_log("chmod 600 /etc/my.cnf");
    }
    else {
      exec_log("cp /etc/mysql/my-medium.cnf /etc/my.cnf");
      exec_log("sed -i -e '/^#innodb_data_home_dir/c\\innodb_data_home_dir = '$DATADIR'' /etc/my.cnf");
      exec_log("sed -i -e '/^#innodb_log_group_home_dir/c\\innodb_log_group_home_dir = '$DATADIR'' /etc/my.cnf");
      exec_log("sed -i -e '/^#innodb_log_arch_dir/c\\innodb_log_arch_dir = '$DATADIR'' /etc/my.cnf");
    }

 

This looks correct to me, but when I restart MySQL, the /etc/my.cnf file still gets put in place with world-writable permissions. Clearly I'm missing something. Has anyone got any advice on what I'm doing wrong?

Nope, my bad. The change to the plugin worked fine, but it requires the plg to load when UnRAID starts. Simply restarting MySQL wasn't sufficient. Now my changes to the my.cnf are applying correctly and my MySQL performance is more like it should be.

Nope, my bad. The change to the plugin worked fine, but it requires the plg to load when UnRAID starts. Simply restarting MySQL wasn't sufficient. Now my changes to the my.cnf are applying correctly and my MySQL performance is more like it should be.

 

Thanks - I'll give this a try. Everything is basically fine, but I have so much machine just kind of sitting by that I'd like to use my custom settings and throw a little extra juice at it.

I just had the exact same problem after upgrading to 5.0rc16c. Adding the line to the plg fixed my issues as well. Thanks for this.

after upgrading to 5.0 rc12a to 5.0 final, i get an error when starting mysql:

Warning: World-writable config file '/etc/my.cnf' is ignored

i m using custom my.cnf file at /boot/config/plugins/mysql/ for some tweaks.

 

googled and find the solution:

my /ettc/my.cnf files permission was “-rw-rw-rw-” and to fix it run the code below.

chmod 644 /etc/my.cnf

 

i cant get the relation between this files permission and upgrading to 5.0 final but this is the fact.

 

a) has anybody got the same error?

b) does we need an update on the plugin? otherwise i guess i'll get the error on every boot.

I was just to ask..

does the plugin work with 5.0 final

it works

 

there is a 5.30 release out in this thread

 

ikosa

 

you can add that chmod 644 /etc/my.cnf to the go script ...

ikosa

 

you can add that chmod 644 /etc/my.cnf to the go script ...

 

indeed i can but i m curious about is this a general situation or not. IMHO has to be. Because i just upgrade and get this error. Can there be a recursive chmod for /etc directory difference between rc12a and 5.0 final?

 

if this is a general situation i think adding that cmd into the plugin will be a better idea.

Ikosa

 

I have the same issue :0

 

just never really cared ... the mysql server is working fine .....

 

it would be nice if somebody could make a new plugin for this... with update button if possible .....

but not my cup of tea to do that...

after upgrading to 5.0 rc12a to 5.0 final, i get an error when starting mysql:

Warning: World-writable config file '/etc/my.cnf' is ignored

i m using custom my.cnf file at /boot/config/plugins/mysql/ for some tweaks.

 

googled and find the solution:

my /ettc/my.cnf files permission was “-rw-rw-rw-” and to fix it run the code below.

chmod 644 /etc/my.cnf

 

i cant get the relation between this files permission and upgrading to 5.0 final but this is the fact.

 

a) has anybody got the same error?

b) does we need an update on the plugin? otherwise i guess i'll get the error on every boot.

 

When I upgraded I had the same error. I just updated the line in the plugin manually and now have no issues again. It's a really simple fix.

Ikosa

 

I have the same issue :0

 

just never really cared ... the mysql server is working fine .....

 

it would be nice if somebody could make a new plugin for this... with update button if possible .....

but not my cup of tea to do that...

 

i guess i can but dont want to put my nose into somebodies plugin. is p1lot retired?

What is the command in SQL to verify where I installed the DB?

 

Thanks!

Ikosa

 

I have the same issue :0

 

just never really cared ... the mysql server is working fine .....

 

it would be nice if somebody could make a new plugin for this... with update button if possible .....

but not my cup of tea to do that...

 

i guess i can but dont want to put my nose into somebodies plugin. is p1lot retired?

 

I updated the plugin and posted it a while back, it wasn't a problem.  Vaguely remember there being some issues with a newer version and xbmc compatibility but I may be wrong. 

 

http://lime-technology.com/forum/index.php?topic=20603.msg229248#msg229248

 

 

Sent from my iPad using Tapatalk HD

If i am not mistaken then P1lot went another way then unraid...

his last activity date -> Last Active:    19 May 2013, 03:23:30

 

and like CHBMB said he updated the plugin last time...

there is no real ownership in these plg files is guess..... you could sent a PM to p1lot as a courtesy to say you will be updating the plugin ....

What is the command in SQL to verify where I installed the DB?

 

you can look at your mysql log

'?nstall_dir'/mysql/Tower.err:

130902 21:47:35 mysqld_safe Starting mysqld daemon with databases from /mnt/user/No_move/mysql

 

if this is not enough i think "SHOW VARIABLES;" is what you need.

What is the command in SQL to verify where I installed the DB?

 

you can look at your mysql log

'?nstall_dir'/mysql/Tower.err:

130902 21:47:35 mysqld_safe Starting mysqld daemon with databases from /mnt/user/No_move/mysql

 

if this is not enough i think "SHOW VARIABLES;" is what you need.

 

Thanks so much!

 

Is deleting mysql just as simple? Remove the plg file and remove the directory where it's installed (/mnt/cache/.mysql for me)?