Issue with wordpress

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

    • Offizieller Beitrag

    What is the output of (replace PASSWORD with your root mysql password) as root:


    echo "PASSWORD" > /tmp/.openmediavault-wordpress-mysql-pwd
    omv-mkconf wordpress createdb

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

    • Offizieller Beitrag

    Unless there is a space in the password, it works with or without quotes.

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

    • Offizieller Beitrag

    Nope.

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

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

    • Offizieller Beitrag

    Looks like wrong mysql root password. Did you set the root password in the mysql plugin?

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

    • Offizieller Beitrag

    You could always change it again.

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

    • Offizieller Beitrag

    You must be using an old version of the mysql plugin. The latest version allows you enter a password of your choice.


    Did you use openmediavault as a password?

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

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

    • Offizieller Beitrag

    I don't think you need to reinstall anything. Are you sure the database is being deleted/dropped?

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

    • Offizieller Beitrag

    Login to mysql:
    mysql -u root -p


    Then execute these commands:
    create database wordpress;
    grant all on wordpress.* to wordpress@localhost identified by 'PASSWORD';
    FLUSH PRIVILEGES;

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

    Einmal editiert, zuletzt von ryecoaaron ()

  • There appears to be a minor typo in the login command, it should be:

    Code
    mysql -u root -p


    You will be asked for the mysql root password. If it was correct, a message will be displayed and the command prompt changes. Similarly to this:

    ESXi: SM X9SCA-F || Xeon E3-1220LV2 || Kingston ECC 16GB DDR3-1333 || 2x IBM M1015 (IT) || 38TB raw || Chenbro SR11269

  • 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

    • Offizieller Beitrag

    Try drop database wordpress; and then create database wordpress;

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!