Wednesday, January 23, 2013
ocsng ERROR: HTTP status code 500
ocsng ERROR: HTTP status code 500
1. check file ocsinventory-server.conf in \xampp\apache\conf\extra\ocsinventory-server.conf
2. make sure the username (line #29)
3. make sure the password (line #31)
Friday, January 18, 2013
Security Alert the default login/password is activate on OCS-NG GUI
Q:
Security Alert the default login/password is activate on OCS-NG GUI
A:
Please change the password of admin
Thursday, January 17, 2013
XAMPP - Access forbidden
Q: Access forbidden!
New XAMPP security concept:
Access to the requested directory is only available from the local network.
This setting can be configured in the file "httpd-xampp.conf".
A:
Mark the like “Deny from all” as a comment at the
Wednesday, January 16, 2013
Error 1067
Q:
Error 1067: The process terminated unexpectedly
A:
First I checked the my.ini file and saw no obvious problems (it was also the default my.ini file produced by the installer). Since the service wouldn’t start, I created a new one that made sure it was reading the right .ini file:
mysqld --install MySql2 --defaults-file="c:\my.ini"
… but to no avail, as the same error occurred. Eventually I gave up and reinstalled MySQL. But it still didn’t work! I did learn two interesting things:
When trying to delete a service from Windows, make sure that the Services Manager is not open. The deleted service only gets truly deleted when the Services Manager is closed, which may leave you wondering why it’s taking so long (“This service is marked for deletion”).
When you need to reinstall MySQL, in order to really start fresh, you need to do three things:
Uninstall MySQL (Add/remove programs, etc.)
Delete the MySQL program directory
Delete the MySQL data directory (under Documents and Settings, Application Data, etc.)
When I did a truly “fresh” install of MySQL, it actually worked again. But only till the next reboot. I found out when there was a power outage later during the day. MySQL wouldn’t start, and manually starting the service would produce, again, the error 1067.
This time I had a look at the MySQL log file, which lives in the data directory (called server001.err in my case). I found this:
120420 8:21:38 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
InnoDB: File name .\ib_logfile0
InnoDB: File operation call: 'aio read'.
InnoDB: Cannot continue operation.
Ah, more information on the error. It turns out that Windows error 87 is ERROR_INVALID_PARAMETER; in other words: “The parameter is incorrect” (see here). Not particularly helpful, but it gets you something to Google for.
There weren’t too many Google results, but after I while I found this. It seems that the error is related to either the disk driver or the formatting of the disk (neither of which I could easily change on a remote server). But the bug report did include a workaround. Add this to my.ini:
Ref: http://www.websofia.com/2012/04/mysql-error-1067-windows-error-87-error_invalid_parameter/
Monday, January 14, 2013
OCSNG - installation mySQL
Q: Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in D:\xampp\htdocs\ocsreports\header.php on line 103
A: in php.ini
error_reporting = E_ALL & ~E_NOTICE & ~E_DEPRECATED
; change this to Off if you still get errors.
display_errors = On //change to OFF
log_errors = Off
after your done... as always, restart apache...
service httpd restart
Subscribe to:
Posts (Atom)