Warning errors during xibo installer

Hi Rob

Which database option did you choose? Create New or Use Existing?

Where you say "I still have a blank password for the mysql user", do you mean you're trying to get it to create you a user (Create New route) with a blank password, or your MySQL admin password is blank (Create New route) or you have created the user yourself with a blank password (Use Existing route).

The installer will expect no password to be blank - it's not a use case I had considered, mainly because of the gaping security hole a configuration like that would leave...

Cheers

Alex

I tried the Create New route using my admin user (root with its password) and still get the warning.

When I connect to the mysql install on the box through a root terminal it lets me in without a password. Maybe it is just my ignorance with mysql when it gets installed, I am not sure what user gets created as the admin user for mysql because it never prompts you to create a user, admin or otherwise, and set a password for them. I have also been trying to go through mysql documentation to figure that part out.

I also tried creating a user (xibo with a password) and try the "use existing" option, but the warning still comes up.

If I need to create separate, mysql users, where would I go to view those existing users, create them, set passwords, etc? It does not look like the installer uses normal system users, is that correct?
Sorry if this does not make sense, if you have not noticed I am just a little confused. :-)
Thanks for your patience and help.
Rob

Hi Rob

Mysql users are destinct from system users. They live in the MySQL mysql table.

On Ubuntu, the root user for mysql is given the password of the first user you create in the installer, and that is then used until you change it. It doesn't change if you change the password for that system user. I don't know if this is the same in Debian.

From a command line, do "mysql -u root -p" and find what password it will let you connect with.

That is then the password you need to give to the Xibo "Create New" routine as the MySQL admin user (root) and password. You can then choose a database, database user and database user and we'll create those for you.

The warning is strange though. It's not one I've seen the installer generate before. Which version of Xibo are you installing, and which version of PHP do you have (exactly - eg 5.2.4).

Cheers

Alex

Rob

I've had a quick look. The warning is coming because of a change in 1.0.0-final which we propose to revert when 1.0.1 is released.

For now, download kit.class.php from here:
http://bazaar.launchpad.net/~xibo-maintainers/xibo/halley/annotate/34/server/lib/app/kit.class.php

Use the "download file" link at the top and replace the version in your installation with that one. It lives in the lib/app folder.

That should get rid of the warning for you.

You'll still need to find the root password for your MySQL install though.

Cheers

Alex

I found the documentation in mysql to work with users and passwords and have changed the password for the root mysql user.

I have PHP 5.2.0.8+etch13
Xibo: I just downloaded it and I believe it is v1.0.0.

thanks, I will download that file and put it in the lib/app directory. I will let you know how it goes.
Rob

Got the file and it got me past the warnings. Put a fork in this one! :-)

Thanks, so much for your help and patience on this.

Just an FYI, this is the first successful experience I have had on getting answers on question forums of any kind...KUDO's :-)

Thanks again,
Rob

:D

Glad to be of help.

A