Posts by 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?

    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:~#

    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 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?

    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?