Beiträge von Athor

Is there a log file for mysql that I could look at? I looked through the setting in the mysql management interface and they look consistent with the other databases that are working. Is there a way to force the creation of the db for wordpress?

What does that do to my other databases etc. that would have been created? Do I lose those as well?

I got this sorted. Issue with the configuration and SSL.

I get "Error establishing a database connection" when I try to get to the web page. The tables are still not being created.

Ok I have some progress. The db directory is back but I do not see any tables in it.
I'm not getting the access error anymore.

Thanks deejc. I took a slightly different route but got the same result:
I shutdown the virtual. Set virtualbox not to start automatically.
rebooted the machine then ran the upgrade and that seems to have worked.

Today I saw two plugins to be upgraded; plex and virtualbox.

On attempting to upgrade i got this message:

Reading package lists...
Building dependency tree...
Reading state information...
Recommended packages:
libsdl-ttf2.0-0 dkms linux-headers pdf-viewer
The following packages will be upgraded:
virtualbox-4.3
1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
Need to get 0 B/65.9 MB of archives.
After this operation, 84.0 kB of additional disk space will be used.
WARNING: The following packages cannot be authenticated!
virtualbox-4.3
Preconfiguring packages ...
Authentication warning overridden.
(Reading database ... 81625 files and directories currently installed.)
Preparing to replace virtualbox-4.3 4.3.16-95972~Debian~wheezy (using .../virtualbox-4.3_4.3.18-96516~Debian~wheezy_amd64.deb) ...
dpkg: warning: subprocess old pre-removal script returned error exit status 1
dpkg: trying script from the new package instead ...
dpkg: error processing /var/cache/apt/archives/virtualbox-4.3_4.3.18-96516~Debian~wheezy_amd64.deb (--unpack):
subprocess new pre-removal script returned error exit status 1
Errors were encountered while processing:
/var/cache/apt/archives/virtualbox-4.3_4.3.18-96516~Debian~wheezy_amd64.deb

On attempting to upgrade plex:

Reading state information...
Recommended packages:
libsdl-ttf2.0-0 dkms linux-headers pdf-viewer
The following packages will be upgraded:
openmediavault-plexmediaserver virtualbox-4.3
2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
Need to get 66.0 MB of archives.
After this operation, 84.0 kB of additional disk space will be used.
WARNING: The following packages cannot be authenticated!
openmediavault-plexmediaserver virtualbox-4.3
Authentication warning overridden.
Get:1 http://packages.omv-extras.org/debian/ kralizec-plex/main openmediavault-plexmediaserver all 1.0.2 [17.8 kB]
Get:2 http://download.virtualbox.org/virtualbox/debian/ wheezy/contrib virtualbox-4.3 amd64 4.3.18-96516~Debian~wheezy [65.9 MB]

Where do I go from here?

root@homsrvr:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 53
Server version: 5.5.38-0+wheezy1 (Debian)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> drop database wordpress;
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'wordpress'
mysql> create database wordpress;
ERROR 1044 (42000): Access denied for user 'root'@'localhost' to database 'wordpress'
mysql> ^CCtrl-C -- exit!
Aborted
root@homsrvr:~#

Thanks for the pointer T-A-Z I figured that one out. But I'm still getting an error when I try to create the db.

mysql> create database wordpress;
ERROR 1044 <42000>: Access denied for user [email='root'@'localhost']'root'@'localhost'[/email] to database 'wordpress'

I've had to type the above longhand. For some reason I can't cut and past from Bitvise

hi ryecoaaron and thanks very much for your patience and help.

Should I be getting this ambiguous message?

Last login: Thu Oct 9 17:45:48 2014 from xxxxxxxxxx.com
root@homsrvr:~# mysql --u root -p
mysql: ambiguous option '--u' (unbuffered, user)
root@homsrvr:~# create database wordpress;
-bash: create: command not found
root@homsrvr:~#

Yes the db is gone. It's not in the directory anymore.

I think I have the latest version there is a box there so I set it and hit the reset button but I'm still getting the same result when I execute the commands. Should I remove the plugin first? Is there a way to do a global default reset of all permissions and passwords?

I hit reset button in the GUI and tried to d\create the db but nothing

Hmmmm. that was a while ago when I set it up. I may have.

I got this error:

root@homsrvr:~# echo "XXXXXXXXXX*" > /tmp/.openmediavault-wordpress-mysql-pwd
root@homsrvr:~# omv-mkconf wordpress createdb
ERROR 1044 (42000) at line 1: Access denied for user 'root'@'localhost' to datab
ase 'wordpress'

Is it permissions?

Ok that seemed fine.

Do I need to be in any specific directory to execute the second command?

Do I use the quotes in the command?

Thanks in advance for any assistance that you can lend in advance.

I'm back with another problem. I set up a wordpress site which worked fine internally and displayed correctly but from the internet the formatting was not right and basically the forms were not displaying correctly.

I removed the wordpress site and from the mysql gui I dropped the database. Since then OMV will not recreate a db for wordpress. I've tried apt-clean, since that seemed to resolve the problem for nighthawk36 although the postfix-keyring did not run: it reported that everything was up to date.

How do I fix it?

Thanks for that. It is clear.
I assume that the current wordpress site does not need one but if it was a separate and distinct site e.g. business site then you would need nginx to do that. Is there a guide for setting up nginx?

Yes everything works fine from the network just not the internet so in my limited wisdom (apparently very limited) I thought that it needed some kind of forwarding internally or advertising. What do we use nginx for and when?