Small bug in the script which doesn't really cause any trouble but I will fix it nonetheless.

Can't figure it out, would be glad if someone helped me out here:

 

    exec_log("grep ^mysql /etc/passwd");
    
    //create mysql user if required
    if ($results == "") {
      exec_log("useradd -r -g users -d / -s /bin/false mysql &> /dev/null");
      exec_log("cp /etc/passwd /etc/shadow /boot/config");
    }

 

exec_log returns a $results variable, and it should be NOT be blank, but the if at $results == "" is always entered and I have no idea why as I can't really debug the output.

 

Could anybody help me out here?

 

 

Also, couldn't the user "mysql" be created from scratch each time the server boots instead of being copied to the flash??

 

 

Can't figure it out, would be glad if someone helped me out here:

 

    exec_log("grep ^mysql /etc/passwd");
    
    //create mysql user if required
    if ($results == "") {
      exec_log("useradd -r -g users -d / -s /bin/false mysql &> /dev/null");
      exec_log("cp /etc/passwd /etc/shadow /boot/config");
    }

 

exec_log returns a $results variable, and it should be NOT be blank, but the if at $results == "" is always entered and I have no idea why as I can't really debug the output.

 

Could anybody help me out here?

 

 

Also, couldn't the user "mysql" be created from scratch each time the server boots instead of being copied to the flash??

variables set in a sub-shell are not visible in the parent.  perhaps exec_log is a sub-process?

 

 

Its a php-function, so that means i need to set it global? Thanks joe

 

Sent from my GT-N7000 using Tapatalk 2

Its a php-function, so that means i need to set it global? Thanks joe

 

Sent from my GT-N7000 using Tapatalk 2

not knowing how variable scope works in your php script, yes, the variable probably needs global scope.

I've got a minor issue with the XBMC integration. I'm not sure if this is an issue with the mySQL plugin, or how XBMC interfaces with it. Here are the details.

 

When XBMC upgrades the databases and creates new ones, they are all created with the user mysql and group mysql. This means I can not browse the databases through windows explorer. My original databases got created with user nobody and group users. The user and pass in the XBMC advancedsettings.xml file are both xbmc. Why is this happening? Is this something XBMC is doing or mySQL?

@kricker, I know this is a "problem" now, but do you really need to access mysql-files via windows explorer?

 

The problem is, if S set rights to nobody, the db-repairs don't work anymore. The only thing that is possible to set rights to 777, read and write for everybody? What do the other people think here?

I don't think it is dire. I just like to see what is going on in the database. I'm a XBMC official team member. I often do testing of various things for XBMC and try to help those posting on the boards with issues. I figured it'd be good to have access to the files mySQL makes if I need to dive into troubleshooting issues.

Well I am abroad and will return in about 5 weeks, so can't do anything in the meantime. Would be great if some experienced plugin-dev would look into that request and find the best solution.

Dear Pilot and all,

Could you please explain what might be the problem with installing the plugin.

Here is the output from the console:

root@UNRAID:~# installplg /boot/config/plugins/mysql5_v1.plg

installing plugin: mysql5_v1

file /boot/packages/mysql-5.5.25-i486-1gds.txz: downloading from http://ftp.sotirov-bg.net/pub/contrib/slackware/packages/slackware-13.37/mysql-5.5.25-i486-1gds.txz ... 2012-07-31 22:54:27 URL:http://ftp.sotirov-bg.net/pub/contrib/slackware/packages/slackware-13.37/mysql-5.5.25-i486-1gds.txz [8621156/8621156] -> "/boot/packages/mysql-5.5.25-i486-1gds.txz" [1]

success

  upgradepkg --install-new /boot/packages/mysql-5.5.25-i486-1gds.txz ... sh: upgradepkg: command not found

failed

Thanks.

Are you on unraid 5?

Are you on unraid 5?

 

I presume so, otherwise the installplg command wouldn't be present?

Alexandro: Try to install another package please and let me know if you get the same error message.

p1lot, thank you for your answer.

Yes I am on Unraid RC5

I just reinstalled transmission. Everything seems to be fine with it.

 

EDIT: I gave a try to install Couchpotato plugin to test the install ability of my system. The same error message. Probably it is not the plugin but unraid which is messed arround somehow.

 

Yes must be, because this plugin is very basic and does no fancy things during installation.

Problem solved after a complete reinstall of the system from scratch.

 

 

Sent from my iPhone using Tapatalk

Sorry to hear that you had to start from scratch, but I am glad your server works now.

Thank you for the plugin p1lot, it works great. One request I do have is if you could have the plugin make a symbolic link to the sock file?

 

ln -s /tmp/mysql.sock /var/run/mysql/mysql.sock

 

I'm running mysql in conjuction with some webapps with speeding_ant's web server and software complains about the file being in the tmp folder instead of there. Not sure on which end of the problem the issue resides on.

There are 2 possible solutions for this, the symlink probably being the easier one.

Please try, if it works I will make this the stable version.

mysql5_v1_socketfix.zip

Thank you, works just fine with reboots and startups. One less thing in my go file

Installed the plugin, had to chmod 777 the tmp folder like described earlier in the topic. But, now what? It seems to be running, but where is the phpmyadmin page? If i go to my unraid's port 3306 from my pc i get an error in the log :

 

120915 15:42:47 [Warning] IP address '192.168.1.10' could not be resolved: Name or service not known

 

Do i need to do some more settings and change configurations to actually make it work? Which ones, where, how?

Installed the plugin, had to chmod 777 the tmp folder like described earlier in the topic. But, now what? It seems to be running, but where is the phpmyadmin page? If i go to my unraid's port 3306 from my pc i get an error in the log :

 

120915 15:42:47 [Warning] IP address '192.168.1.10' could not be resolved: Name or service not known

 

Do i need to do some more settings and change configurations to actually make it work? Which ones, where, how?

 

no phpmyadmin web-page (as usual in mysql)

 

yo should use console or external program, like HeidiSQL in Windows, etc...

 

This plug works perfect with RC6-test2.

Ah i understand... i was under the impression the plugin would somehow give that functionality. I've installed MySQL workbench on my windows pc, but i still get the message from unraid's mysql server that acces is not allowed for that ip adress. Is there a mysql setup-for-dummies somewhere?

Looks like the mysql package has been taken down.

 

file /boot/packages/mysql-5.5.25-i486-1gds.txz: downloading from http://ftp.sotirov-bg.net/pub/contrib/slackware/packages/slackware-13.37/mysql-5.5.25-i486-1gds.txz ... http://ftp.sotirov-bg.net/pub/contrib/slackware/packages/slackware-13.37/mysql-5.5.25-i486-1gds.txz:

2012-10-05 01:17:26 ERROR 404: Not Found.