Hello - I am a new to Combu, just purchased the plugin. I am going through the YouTube tutorial:
https://www.youtube.com/watch?v=PsZyYopzi40&feature=youtu.be
and I've encountered a problem logging in to the admin panel. On first launch, I did not get automatically logged in as the tutorial stated. I went in to the MySQL CB_AdminAccount table and copy and pasted the admin password into the login window and it is giving me "Username and/or Password invalid". I created another username and password login in the table and tried that as well and it still didn't work. What am I missing here? Many thanks for the assistance on this!
Maybe a misconfiguration of your PHP, have you followed the FAQ to setup your webserver?
You cannot create manually the password in the database because it's stored encrypted. If you don't see the admin page correctly (for example with strange text "$something" etc) that seems source code then you need to set the short-open-tag flag in php.ini, it's in the FAQ.
FRANCESCO CROCETTI @ SKARED CREATIONS
I'm not getting any errors on the admin login page, could you verify for me as well please? {URL REMOVED BY MODERATOR FOR SECURITY}
I went through the FAQ and it seems like everything is correct. I'm connect to a live server, not working locally.
I also got this error when I imported combu_db.sql into the db (below), how can I fix this? Perhaps this is why login is not working?
Error
SQL query:
--
-- Indexes for table `CB_ServerSettings`
--
ALTER TABLE `CB_ServerSettings`
ADD PRIMARY KEY (`DataKey`), ADD UNIQUE KEY `DataKey_UNIQUE` (`DataKey`);
MySQL said:
mmh.. Try to delete that line from the file and delete the tables and reimport it, then open the table CB_ServerSettings in phpMyAdmin and make sure that the fields IdAccount and DataKey are set as Primary Key.
FRANCESCO CROCETTI @ SKARED CREATIONS
I'm not sure I understand. You want me to delete just the CB_ServerSettings table and then try to re-import it?
I was saying to edit the .sql file removing the line that you wrote above, then delete the whole database and reimport the file. When it's done open the table CB_ServerSettings and make IdAccount and DataKey as primary keys. I'm away for the weekend so if you still have issues we can see together at Monday what's happening on your server.
Anyway, is the Unity client part working? Are you able to register and login users in Unity?
FRANCESCO CROCETTI @ SKARED CREATIONS
Thanks for getting back to me. I removed these lines in the .sql file:
--
-- Indexes for table `CB_ServerSettings`
--
ALTER TABLE `CB_ServerSettings`
ADD PRIMARY KEY (`DataKey`), ADD UNIQUE KEY `DataKey_UNIQUE` (`DataKey`);
--
I was then able to reimport the file without errors this time. I checked theCB_ServerSettings and this is what it is after importing.
The two rows in in CB_ServerSettings are, I don't see an IDAccount row.:
1 | varchar(45) | utf8_general_ci | No | None |
2 | text | utf8_general_ci | Yes | NULL |
I was able to get access to the admin panel though - I created a new admin login for myself and I'm able to login with this new account from the backend, so all of that part (my original problem) is working now.
But now I've got another problem I've got now is happening as I'm following along with the tutorial. I set my URL Production path but when I hit run I get the following errors which result in failed login/registration from the client part:
----------------------------------------------------------------------------------------------------------------------------
Sending: {URL REMOVED BY MODERATOR}
UnityEngine.Debug:Log(Object)
Combu.<DownloadUrl>c__Iterator1:MoveNext() (at Assets/Combu/Scripts/CombuManager.cs:383)
UnityEngine.MonoBehaviour:StartCoroutine(IEnumerator)
Combu.CombuManager:CallWebservice(String, WWWForm, Action`2) (at Assets/Combu/Scripts/CombuManager.cs:349)
Combu.CombuManager:GetServerInfo(Action`2) (at Assets/Combu/Scripts/CombuManager.cs:552)
Combu.CombuManager:Start() (at Assets/Combu/Scripts/CombuManager.cs:294)
Unauthorized request
UnityEngine.Debug:Log(Object)
Combu.<DownloadUrl>c__Iterator1:MoveNext() (at Assets/Combu/Scripts/CombuManager.cs:403)
Failed to get Combu server info
UnityEngine.Debug:LogError(Object)
Combu.CombuManager:<Start>m__3B(Boolean, CombuServerInfo) (at Assets/Combu/Scripts/CombuManager.cs:303)
Combu.<GetServerInfo>c__AnonStorey28:<>m__3D(String, String) (at Assets/Combu/Scripts/CombuManager.cs:565)
Combu.<DownloadUrl>c__Iterator1:MoveNext() (at Assets/Combu/Scripts/CombuManager.cs:405)
----------------------------------------------------------------------------------------------------------------------------
Looking forward to your reply.
Please use the file that I uploaded here to create your tables (delete the current ones).
Anyway I've set your URL in my demo scene and I succeeded to create and login a user. Not sure what's happening on your side, you may want to download the latest version from this website (it contains the file combu_db.sql updated so in case you won't need to download the above link).
FRANCESCO CROCETTI @ SKARED CREATIONS
Thank you so much! That worked.