ok, so I changed the localhost to db right, I have done that, now what
Try to access phpmyadmin again, see if you can log in
So I go through all those steps including the setup, but won’t it trash my original database
In all honesty … i don’t know where your database went.
That’s why we changed the volume to a totally different directory.
It at least creates a new database for you.
Now, the old database… you were using ‘named volumes’ (something like that). Maybe it’s something you can google. Where does Docker store the database of named volumes, something like that.
The reason why i think it’s gone is the error message:
The table ‘settings’ was missing, which is the most important table.
You were facing an empty database with settings in ipconfig.php that showed you had installed InvoicePlane. That’s strange.
@UnderDog I have done as you suggested above and managed to do the setup, but when I go to login I get the following:
It does not seem to know my login details … the email address I gave is correct.
Why is this so hard …?
On a positive, I can get into the database with phpmyadmin …
1 Like
On a positive, I can get into the database with phpmyadmin …
That is so awesome!
Also … make a backup of your database through phpmyadmin: click on export at the top of the page.
Can you check in the database if you have any users?
I usually change my email address to a@a.com if i run into any problems like this
Focus on getting logged in, that’s the important part.
Why is this so hard …?
I’ll get back on that one, once we know why you were almost able to log in (no errors, but root wasn’t working) into phpmyadmin
Also… your ipconfig.php … tell the value for DB_HOSTNAME=
And during troubleshooting, i usually don’t ask ‘why’.
Actually i usually ask ‘can you do this and that’.
Once we’re done, then we can look at ‘why’
DB_USERNAME='ipdevdb'
Also … make a backup of your database through phpmyadmin: click on export at the top of the page.
What is the export format to save as SQL? And Quick or Custom?
I usually change my email address to a@a.com if i run into any problems like this
Where do you change your mail address, and what about the password for a@a.com
I tried the login with a@a.com and a random password and I got this:
Cheers
This is what users are available:
and database:
Clicking on the above database shows 32Kb for some fields like client/invoices but clicking on them shows empty …
@UnderDog Please respond in this thread…
Please respond in this thread…
Please keep in mind, that it’s the middle of the night right now…
Clicking on the above database shows 32Kb for some fields like client/invoices but clicking on them shows empty …
I need a screenshot and click on the ip_users table. This is the place where you make all those changes
always go to invoiceplane_db. That’s your database
DB_USERNAME='ipdevdb
The hostname please
Hostname of what? The host the container is running on? If so it is: casaos.local
Please keep in mind, that it’s the middle of the night right now…
Apologies, not sure what timezone you are … I am NZ 
Here is the screenshot of ip_users
- open ipconfig.php
- find
DB_HOSTNAME= and copy everything on that line
Therr is a problem. Right after i know the hostname in your ipconfig.php i will know for sure.
On your local system there are 2 MySQL versions running:
1 on localhost and 1 on invoiceplane-db
After you have installed InvoicePlane, there is a database in your docker called invoiceplane_db, which is awesome.
There are tables, which is awesome
But the user isn’t created, which is strange
Here is the screenshot of ip_users
always in your invoiceplane_db database
this time in your ip_users table:
Find a link called ‘insert’ in your phpmyadmin, click on that link
add your user, by just entering email address and password.
phpmyadmin will encrypt the password for you
click on save
Try to log in with the username and password you just created
DB_HOSTNAME=‘db’
I’m surprised that this is working and that it not give you errors, but ok…
focus on adding that user.
focus on logging in
I will tell you what the hostname should be, after you have logged in
I am confused with adding user email and password. There is no box to type in, only a pulldown list, am I in the right place? This is in ip_users (insert):
am I in the right place?
You are in the perfect place. Yes, to the right should be edit boxes to enter those 2 fields you need.
Make your screen bigger, maximize your screen.
Those 2 boxes should be there
I’m not behind a PC, so i cannot help you with a screenshot of how it should look like
Ok, found the boxes and entered the details, the went to the bottom and pressed go and the line was inserted.
However, using those details to login, still would not work. (even after a restart of the containers)
I notice that on the ip_users table, if I scroll further down there is duplicate fields for email/password should I have filled those in as well ? I did not bother, as there was a check-box that said ignore.
Perfect! We’re most there
I notice that on the ip_users table, if I scroll further down there is duplicate fields for email/password should I have filled those in as well ? I did not bother, as there was a check-box that said ignore.
Those empty boxes are there to enter a second user, so it’s good, that you ignored it.
Glad that your user is inserted.
Make a backup of your database
Make sure you see all tables, clients, invoices, users
Klik on export, click on quick
Open ipconfig.php
Find DB_HOSTNAME=‘db’
Change it to DB_HOSTNAME='invoiceplane_db'
Try to log in again.
You don’t need to restart the containers
ok, did as you asked, I get this on logging in:
Above repeated a few times then this at the bootom:
Maybe hostname is still incorrect?
That won’t let me login at all again. sigh! 
