-
Dear All,
I had create a field "assetno" type varchar(11) in the computer_system table to hold the computer asset number. Please kindly tell me how to setup a manual input prompt and to display the asset number in the Computer Details ?.
2009-10-22 06:52:25 UTC by p52ka
-
Hi,
The file takedata.js is the only client file, not other files is needed. You can put it in network-shared drive and add command in logon script to execute it.
2009-10-01 01:42:15 UTC by maz1980
-
Hi,
The software works perfectly fine.
Though if we want to get all the pc data then we have to open the zci home page on each PC and click on the register computer button and then the system will be added to the database.
Is there a way where it can automatically add the computer data for the whole windows domain?
Waiting anxiously for an answer....
Regards
Saabir.
2009-09-30 06:08:34 UTC by shsaifee
-
Hi,
I dropped all the users that were created and recreated the user following your advice as per the manual.
And this time it worked!!!
Thanks.
Saabir.
2009-09-30 06:05:17 UTC by shsaifee
-
Hi,
I followed the same document that you have mentioned here.
I could login with the user created with these statements on the server as well.
Though, I could see that there are 3 different users with the same name myzcidbuser but with different hosts strings (myzcidbuser@localhost | myzcidbuser@asryprtldr.asry.com | myzcidbuser@% )
Is this the main cause of problem. But the...
2009-09-29 11:20:08 UTC by shsaifee
-
Hi,
MySQL login also control the originating host. Please check whether the MySQL console works from zCI server.
This is sample GRANT command from MySQL documentation (% means all hosts):
-----------------
After connecting to the server as root, you can add new accounts. The following statements use GRANT to set up four new accounts:
mysql> GRANT ALL PRIVILEGES ON *.* TO...
2009-09-29 08:35:00 UTC by maz1980
-
Hi,
I have tested the username and password using the MySQL console and it logged in fine without any problems. And also, I was able to query the tables.
Still don't understand why this error is coming...
Any further help would be desirable.
Regards,
Saabir.
2009-09-29 08:27:44 UTC by shsaifee
-
Hi,
The MySQL username and password must be configured in zciconfig file. I suggest that you try the access from MySQL console first before applying it in the zciconfig.php.
2009-09-29 01:48:56 UTC by maz1980
-
I'm not associated with this project, but...it would seem to me that you need to check your username, hostname, and password for your installation to make sure it matches your MySQL information...if those all check, then perhaps your user doesn't have rights to the database you created.
2009-09-28 13:20:38 UTC by dhefley
-
Hi,
Everything went on fine until the step where we have to click on the button Register Computer.
Once I click this button the request is processed as expected by I get an empty table of computer details.
when inspecting the /var/log/httpd/error_log file I found the following entries:
[client 20.0.2.115] PHP Warning: mysql_connect(): Access denied for user...
2009-09-28 11:49:06 UTC by shsaifee