password not recognized

You need to use your xibo_admin account password. No other account will
work

Hi Alex.
I have 2 password for 2 users but none of these works!
I do not know how to do ...

User accounts will not work. You need your xibo_admin account for the
upgrade process

ah! And where can I recover it?
I no have other xibo_admin account to enter in administration page ...
Can I come in folders with Filezilla, but where do I find this account?

If you don't know your xibo_admin account password then you'll need to
reset it by running some SQL directly on the database. It's been covered
before so search for that.

Sorry Alex, I found the folder SETTING password in the database, I replaced it but still does not work ...

There is another password in USER folder but even this does not work ... :(

The password lives in the database.

You need to connect to your Xibo database and change the xibo_admin account password. NO OTHER USER ACCOUNT WILL WORK FOR THE UPGRADE so please stop referring to other users.

Alex Harrington suggests this article as an answer to your question:
FAQ #2590: “Reset xibo_admin password”.

I followed step by step the simple procedure and I have changed the password exactly as suggested but still can not enter.
It may be a problem with Chrome? I've updated the page several times but to no avail ...

What happens exactly when you try to log in to the upgrade routine?

Nothing happens. There is a new page that says:
--
Xibo Aggiornamento
Password sbagliata. Please riprova di Nuovo.
--

Then the password is wrong, or you're updating it in the wrong place.

Have you done something like disable your xibo_admin user? Or renamed it?

L'utente no.
Ho riscritto la password e l'ho nominata "password" come descritto nella FAQ # 2590
Davvero, non so più che fare ... :(

I'm sorry we provide support here in English only. Launchpad has the
facility to ask questions in other languages but I'm not aware there are
others who can help you in that case.

Sorry.
Repeat:
No, the user name is not changed.
I followed the steps exactly as described in the FAQ that you suggested.
Now the password should be "password" but it does not work.

So the user account must be disabled or it's been deleted.

I checked all the settings and I think everything is ok ...
Can I send to you any screenshot of the database folders?

What's the result of this query:

select * from user where userid=1;

Copy and paste:

SELECT * FROM `user` WHERE 1

I need you to run the query:

select * from user where userid=1;

You've just copied part of the query and sent it back to me. You need to
connect to your MySQL database, run that query, and give me the result.

Alex

No Alex.
I copied and pasted my results.
I'm connected to my database by 4 hours ...

another method:

SELECT *
FROM `user`
WHERE 1
LIMIT 0 , 30

I think we're going around the problem. It seems easy but it is not.

If I delete the account and create a new one that it happens?

That's not the query I asked you to run. Please run the query I asked for.
I cannot help otherwise

Give me a way to send pictures otherwise we do not understand

No. Run the query. Paste the text result of the query. It's very simple

If I run the quesry, the result is this:

La query SQL è stata eseguita con successo
EXPLAIN SELECT *
FROM `user`
WHERE 1

La query SQL è stata eseguita con successo

TRANSLATE:
The SQL query has been executed successfully

SORRY!!!!!
Alex ... :(

This is the result:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`UserID`SELECT * FROM `user` WHERE 1 LIMIT 0, 30' at line 1

I give up. I'm sorry. You're not running the query I've asked you to. I
can't help you.

You should be getting a table with one row in it with the data I need.

do not abandon me Alex ... I do not know how to do! You asked me to run the query "userID and I did.

The only thing I get is an error:
# 1064 - You have an error in your SQL syntax; check the manual That Corresponds to your MySQL server version for the right syntax to use near '* FROM `user` UserID`SELECT` WHERE 1 LIMIT 0, 30' at line 1

I have no other information to give you ...

Again, you're not running the query I gave you. It doesn't contain a limit
statement, nor does it say anywhere 'WHERE 1'

Please run the correct query

Alex, I do not know how to tell you ... if you give me the chance to send a picture you send the screenshot of the transaction

I click on the database, I select the USER folder, and choose USER_ID. Load and run the query but there is no information. Only a string with the error I have written before.

You keep saying to do a task that I still do not understand but that result has to come out.
Can you give an example of the result?

No. Open mysql command line, connect to your database and run the query

If you need to send a screen shot then upload it to something like twitpic,
Google Drive, Dropbox or similar and post a link. But you don't want a GUI
utility. You just need the MySQL command line

Eg

mysql -u username -p databasename

Then it'll ask for your database password

Then paste in the query

If it returns no results then someone deleted the xibo_admin user from the
database and that's why you can't upgrade any longer.

Here the link ...
excuse, surely some mistake passage

https://drive.google.com/folderview?id=0BxUFhBxO0hIgMG1reWd3Tk1sM00&usp=sharing

Yes. As I suggested earlier, you've renamed the xibo_admin user to frank.

You need to change that back.

If you want to log in as Frank then you need to create a new user after the
upgrade and use that instead.

Hi! See now your answer! ...
Ok, I rinamed frank in "xibo_admin" and password in "password" but not work. Can I do other settings?

You can't just put password in the password box. You need to run the query
from the FAQ

You keep telling me to do this thing, but I do not know how to do. I sent the pictures to show you the steps and errors.
Thanks for your patience but it is not repeating the same things that I solve my problem.

I asked if the procedure to execute the query is correct but have not answered me. It is correct?

OK. I think it's better to close the conversation.
You've been very patient, but I have not solved my problem. I use Xibo for several years and have always solved the problems.
This time I think it will wipe everything and will share again.

Thanks Alex and I'm sorry for the lost time.

And I've said numerous times now not to use that GUI and to use the MySQL
command line and run the query from the FAQ. There is no other way than
running that query.

Try this instead.

Set the password field for the xibo_admin user to:
5f4dcc3b5aa765d61d8327deb882cf99

Make sure that the CSPRNG field is set to 0, and that retired is also set
to 0

Alex

AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

YOU ARE MY ANGEEEEELLLL!!!

I changed the password with the long number and I logged with "password"

THANK'S THANK'S ... MANY THANK'S ..... :D

Glad we got a resolution

Best wishes

Alex