Unable to login with default "admin" account

[BeegG]

I have installed PHP Point of sale 9.1 on a Debian box, apache, MySQL and PHP. The install worked, but I am unable to login as the first time default users with admin/pointofsale.

Where do I begin to look to try to resolve this?

Thanks

[tmoore]

Look to see that you are able to access the databases. Have you configured them in database.php ?

[BeegG]

There is no database.php in the pos folder in /var/www/

I have an installation of Joomla, there is a database.php in this folder, would it also apply?

[tmoore]

The database php will not be in your /var/www directory. I assume that your install has your web server root directory as /var/www (mine is /var/www/html). If that's so then your database.php will be in /var/www/pos/application/config/database.php

The above is assuming that you have installed PHP Pos into a directory called pos. What ever the directory that you've installed this into, you will need to look in the application/config sub folders.

Regards,
Tom Moore

There is no database.php in the pos folder in /var/www/

I have an installation of Joomla, there is a database.php in this folder, would it also apply?

[BeegG]

Thanks for the reply Tom.
There does not appear to be an application or config folder in my "pos" folder. Below is a list of what is there:
saotanet:/var/www/okha-pos# ls
backupDB.php home.php language reports users
backups images login.php sales
classes index.php logout.php settings
customers install menubar.php settings.php
general_public_license.txt items readme.txt upgrade
saotanet:/var/www/okha-pos#

If I use locate to find a database.php file, it only finds one in my joomla folder.

Thanks
Grant

[BeegG]

I have removed my installation, I have removed the database.

I created a new database and have reinstalled PHP point of sale through it's web install. It all seems to work, the table in the database are created, but I cannot login as the default admin.

I had thought that maybe the "-" in the database name, okha-pos, had caused the problem, the new database name is "okhapos", no difference.

Still no database.php in the /var/www/okhapos folder or sub-folders.

Any further ideas? I seem to have missed the boat on this one.

Thanks

[gmlga]

I have removed my installation, I have removed the database.

I created a new database and have reinstalled PHP point of sale through it's web install. It all seems to work, the table in the database are created, but I cannot login as the default admin.

I had thought that maybe the "-" in the database name, okha-pos, had caused the problem, the new database name is "okhapos", no difference.

Still no database.php in the /var/www/okhapos folder or sub-folders.

Any further ideas? I seem to have missed the boat on this one.

Thanks

Can you look at the data in your database and verify that there is an entry the employees table?

You should see at least one entry.

[BeegG]

There does not appear to be an "Employees" table, below is a list of the tables that are there:
mysql> use okhapos;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-------------------+
| Tables_in_okhapos |
+-------------------+
| brands |
| categories |
| customers |
| discounts |
| items |
| sales |
| sales_items |
| suppliers |
| users |
+-------------------+
9 rows in set (0.00 sec)

mysql>

There is a John Doe - Admin - in the users table, I reset the password, which didn't work. I also added another user whichis also unable to login:
mysql> select * from users
-> ;
+------------+-----------+----------+-----------+-------+----+
| first_name | last_name | username | password | type | id |
+------------+-----------+----------+-----------+-------+----+
| John | Doe | admin | admin | Admin | 1 |
| Grant | Hall | grant | pass | admin | 2 |
+------------+-----------+----------+-----------+-------+----+
2 rows in set (0.00 sec)

mysql>

[LeMec]

BeegG,

I am afraid you are given instructions based on 10.7, but you are clearly using 9.1.

There may not be a database.php in 9.1. Also, do the same exercise but instead of looking in employee table, look in users table.

I am not using 9.1 so I can't realy help you more than that.

If you really can't figure it out, I will install 9.1 on my end and see what is going on.

Let me know.

Alain

[BeegG]

Thanks Alain, I'll try the 10.7 route and see how that goes and let you know.