CMS Password:
1. Open the Crystal Configuration Manager (CCM).
2. Stop the SIA.
3. Open the CMS database administrator application (for example: SQL server enterprise manager if you are using MS SQL2000).
4. Run the following SQL statement on the CMS database:
SELECT * FROM CMS_InfoObjects6 WHERE (ObjectID = 12)
5. Delete the record that is returned.
DELETE FROM CMS_InfoObjects6 WHERE (ObjectID = 12)
6. Restart the SIA server from the CCM. This will recreate the administrator account with a blank password.
7. Log on to the Central Management Console (CMC) using Administrator as a user name and a blank password.
Monday, December 28, 2009
Standard Language Codes
Langs:
LCID Language
1025 Arabic
1028 Chinse - Traditional
1029 Czech
1030 Danish
1031 German
1032 Greek
1033 English
1034 Spanish
1035 Finnish
1036 French
1037 Hebrew
1038 Hungarian
1040 Italian
1041 Japanese
1042 Korean
1043 Dutch
1044 Norwegian
1045 Polish
1046 Portuguese - Brazilian
1049 Russian
1053 Swedish
1054 Thai
1055 Turkish
2052 Chinese - Simplified
2070 Portuguese
LCID Language
1025 Arabic
1028 Chinse - Traditional
1029 Czech
1030 Danish
1031 German
1032 Greek
1033 English
1034 Spanish
1035 Finnish
1036 French
1037 Hebrew
1038 Hungarian
1040 Italian
1041 Japanese
1042 Korean
1043 Dutch
1044 Norwegian
1045 Polish
1046 Portuguese - Brazilian
1049 Russian
1053 Swedish
1054 Thai
1055 Turkish
2052 Chinese - Simplified
2070 Portuguese
MYSQL DB Commands
MYSQL:
User Creation:
GRANT ALL PRIVILEGES ON *.* TO 'plolla'@'localhost' IDENTIFIED BY 'plolla' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'plolla'@'%' IDENTIFIED BY 'plolla' WITH GRANT OPTION;
GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
GRANT USAGE ON *.* TO 'dummy'@'localhost';
OR
mysql --user=root mysql
INSERT INTO user VALUES('localhost','monty',PASSWORD('some_pass'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user VALUES('%','monty',PASSWORD('some_pass'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user SET Host='localhost',User='admin',Reload_priv='Y', Process_priv='Y';
INSERT INTO user (Host,User,Password) VALUES('localhost','dummy','');
FLUSH PRIVILEGES;
* CREATE DATABASE boe;
* show databases;
* use databases;
* show tables;
* mysqladmin -h -P -u -p version variables extended-status ( To check for Mysql Configuration)
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock- replace this value with the full path of your mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
User Creation:
GRANT ALL PRIVILEGES ON *.* TO 'plolla'@'localhost' IDENTIFIED BY 'plolla' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'plolla'@'%' IDENTIFIED BY 'plolla' WITH GRANT OPTION;
GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
GRANT USAGE ON *.* TO 'dummy'@'localhost';
OR
mysql --user=root mysql
INSERT INTO user VALUES('localhost','monty',PASSWORD('some_pass'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user VALUES('%','monty',PASSWORD('some_pass'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user SET Host='localhost',User='admin',Reload_priv='Y', Process_priv='Y';
INSERT INTO user (Host,User,Password) VALUES('localhost','dummy','');
FLUSH PRIVILEGES;
* CREATE DATABASE boe;
* show databases;
* use databases;
* show tables;
* mysqladmin -h
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock- replace this value with the full path of your mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
MYSQL DB Commands
MYSQL:
User Creation:
GRANT ALL PRIVILEGES ON *.* TO 'plolla'@'localhost' IDENTIFIED BY 'plolla' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'plolla'@'%' IDENTIFIED BY 'plolla' WITH GRANT OPTION;
GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
GRANT USAGE ON *.* TO 'dummy'@'localhost';
OR
mysql --user=root mysql
INSERT INTO user VALUES('localhost','monty',PASSWORD('some_pass'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user VALUES('%','monty',PASSWORD('some_pass'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user SET Host='localhost',User='admin',Reload_priv='Y', Process_priv='Y';
INSERT INTO user (Host,User,Password) VALUES('localhost','dummy','');
FLUSH PRIVILEGES;
* CREATE DATABASE boe;
* show databases;
* use databases;
* show tables;
* mysqladmin -h -P -u -p version variables extended-status ( To check for Mysql Configuration)
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock- replace this value with the full path of your mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
User Creation:
GRANT ALL PRIVILEGES ON *.* TO 'plolla'@'localhost' IDENTIFIED BY 'plolla' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'plolla'@'%' IDENTIFIED BY 'plolla' WITH GRANT OPTION;
GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
GRANT USAGE ON *.* TO 'dummy'@'localhost';
OR
mysql --user=root mysql
INSERT INTO user VALUES('localhost','monty',PASSWORD('some_pass'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user VALUES('%','monty',PASSWORD('some_pass'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
INSERT INTO user SET Host='localhost',User='admin',Reload_priv='Y', Process_priv='Y';
INSERT INTO user (Host,User,Password) VALUES('localhost','dummy','');
FLUSH PRIVILEGES;
* CREATE DATABASE boe;
* show databases;
* use databases;
* show tables;
* mysqladmin -h
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock- replace this value with the full path of your mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
How to create Uninstallation Log?
Uninstall:
HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Windows\Installer
Reg_SZ: Logging
Value: voicewarmupx
The letters in the value field can be in any order. Each letter turns on a different logging mode. Each letter's actual function is as follows for MSI version 1.1:
v - Verbose output
o - Out-of-disk-space messages
i - Status messages
c - Initial UI parameters
e - All error messages
w - Non-fatal warnings
a - Start up of actions
r - Action-specific records
m - Out-of-memory or fatal exit information
u - User requests
p - Terminal properties
+ - Append to existing file
! - Flush each line to the log
x - Extra debugging information. The "x" flag is available only on Windows Server 2003 and later operating systems, and on the MSI redistributable version 3.0, and on later versions of the MSI redistributable.
HKEY_LOCAL_MACHINE\Software\Policies\Microsoft\Windows\Installer
Reg_SZ: Logging
Value: voicewarmupx
The letters in the value field can be in any order. Each letter turns on a different logging mode. Each letter's actual function is as follows for MSI version 1.1:
v - Verbose output
o - Out-of-disk-space messages
i - Status messages
c - Initial UI parameters
e - All error messages
w - Non-fatal warnings
a - Start up of actions
r - Action-specific records
m - Out-of-memory or fatal exit information
u - User requests
p - Terminal properties
+ - Append to existing file
! - Flush each line to the log
x - Extra debugging information. The "x" flag is available only on Windows Server 2003 and later operating systems, and on the MSI redistributable version 3.0, and on later versions of the MSI redistributable.
Advanced UNIX
Linux:
* Create User: adduser plolla -d /home/plolla -s /bin/bash
* Set Password: passwd plolla
* Checking RAM: free -m
* uname -m (The output will read x86_64 for 64-bit and i686 or similar for 32-bit)
Solaris:
* Checking RAM: prtconf | head -3 |grep Mem
* /usr/bin/isainfo -kv (If your OS is 64-bit, you will see output like:64-bit sparcv9 kernel modules. If your OS is 32-bit, you will get this output: 32-bit sparc kernel modules)
* pkgchk -p | grep Package Name
* pkginfo -i system
* pvs -d - Displays the dynamic version of the file.
AIX:
* Checking RAM: $ lsattr -El sys0 | grep realmem
* prtconf
* bootinfo -y ----> hardware is 64-bit or 32
* bootinfo -K ----> kernel is 64-bit or 32 ( to check 64 kernel is installed go to /usr/lib/boot and look for " unix_64 "
Windows :
set p | findstr /i archi
1) PROCESSOR_ARCHITECTURE=x86 ..... 32-bit
2) PROCESSOR_ARCHITECTURE=AMD64 ... 64-bit
HPUX:
to find what OS : getconf KERNEL_BITS
what varsion can run :getconf HW_CPU_SUPP_BITS
$ file /stand/vmunix
/stand/vmunix: PA-RISC1.1 executable ---> 32-bit
/stand/vmunix: ELF-64 executable object file ---> 64-bit
To check the Kernel Variables: kctune or kmtune
* Create User: adduser plolla -d /home/plolla -s /bin/bash
* Set Password: passwd plolla
* Checking RAM: free -m
* uname -m (The output will read x86_64 for 64-bit and i686 or similar for 32-bit)
Solaris:
* Checking RAM: prtconf | head -3 |grep Mem
* /usr/bin/isainfo -kv (If your OS is 64-bit, you will see output like:64-bit sparcv9 kernel modules. If your OS is 32-bit, you will get this output: 32-bit sparc kernel modules)
* pkgchk -p | grep Package Name
* pkginfo -i
* pvs -d - Displays the dynamic version of the file.
AIX:
* Checking RAM: $ lsattr -El sys0 | grep realmem
* prtconf
* bootinfo -y ----> hardware is 64-bit or 32
* bootinfo -K ----> kernel is 64-bit or 32 ( to check 64 kernel is installed go to /usr/lib/boot and look for " unix_64 "
Windows :
set p | findstr /i archi
1) PROCESSOR_ARCHITECTURE=x86 ..... 32-bit
2) PROCESSOR_ARCHITECTURE=AMD64 ... 64-bit
HPUX:
to find what OS : getconf KERNEL_BITS
what varsion can run :getconf HW_CPU_SUPP_BITS
$ file /stand/vmunix
/stand/vmunix: PA-RISC1.1 executable ---> 32-bit
/stand/vmunix: ELF-64 executable object file ---> 64-bit
To check the Kernel Variables: kctune or kmtune
Debug Tools
Debug:
1. Run “ps –fu” and share the output
2. Run truss –far –vall –tall and share the output
3. Run jstack (http://java.sun.com/j2se/1.5.0/docs/tooldocs/share/jstack.html) and share the output
a. jstack
4. Run pstack (http://docs.sun.com/app/docs/doc/816-0210/6m6nb7mih?a=view) and share the output
a. pstack
5. The jps utility may be useful as well (http://java.sun.com/j2se/1.5.0/docs/tooldocs/share/jps.html)
6. Modifying the call to run the jarfile so we can use dbx on the process may also be useful. (http://docs.sun.com/source/819-3683/Java_debug.html)
1. Run “ps –fu
2. Run truss –far –vall –tall
3. Run jstack (http://java.sun.com/j2se/1.5.0/docs/tooldocs/share/jstack.html) and share the output
a. jstack
4. Run pstack (http://docs.sun.com/app/docs/doc/816-0210/6m6nb7mih?a=view) and share the output
a. pstack
5. The jps utility may be useful as well (http://java.sun.com/j2se/1.5.0/docs/tooldocs/share/jps.html)
6. Modifying the call to run the jarfile so we can use dbx on the process may also be useful. (http://docs.sun.com/source/819-3683/Java_debug.html)
IIS 32bit to 64bit & Vice-Versa
IIS:
cscript iisweb.vbs /query
64 bit to 32 bit IIS:
ASP.NET 1.1, 32-bit version
To run the 32-bit version of ASP.NET 1.1, follow these steps:
Click Start, click Run, type cmd, and then click OK.
Type the following command to enable the 32-bit mode:
cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1
Type the following command to install the version of ASP.NET 1.1 and to install the script maps at the IIS root and under:
%SYSTEMROOT%\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -i
Make sure that the status of ASP.NET version 1.1.4322 is set to Allowed in the Web service extension list in Internet Information Services Manager.
Back to the top
ASP.NET 2.0, 32-bit version
To run the 32-bit version of ASP.NET 2.0, follow these steps:
Click Start, click Run, type cmd, and then click OK.
Type the following command to enable the 32-bit mode:
cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1
Type the following command to install the version of ASP.NET 2.0 (32-bit) and to install the script maps at the IIS root and under:
%SYSTEMROOT%\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
Make sure that the status of ASP.NET version 2.0.50727 (32-bit) is set to Allowed in the Web service extension list in Internet Information Services Manager.
Back to the top
ASP.NET 2.0, 64-bit version
To run the 64-bit version of ASP.NET 2.0, follow these steps:
Click Start, click Run, type cmd, and then click OK.
Type the following command to disable the 32-bit mode:
cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 0
Type the following command to install the version of ASP.NET 2.0 and to install the script maps at the IIS root and under:
%SYSTEMROOT%\Microsoft.NET\Framework64\v2.0.50727\aspnet_regiis.exe -i
Make sure that the status of ASP.NET version 2.0.50727 is set to Allowed in the Web service extension list in Internet Information Services Manager.
Note The build version of ASP.NET 2.0 may differ depending on what the currently released build version is. These steps are for build version 2.0.50727.
cscript iisweb.vbs /query
64 bit to 32 bit IIS:
ASP.NET 1.1, 32-bit version
To run the 32-bit version of ASP.NET 1.1, follow these steps:
Click Start, click Run, type cmd, and then click OK.
Type the following command to enable the 32-bit mode:
cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1
Type the following command to install the version of ASP.NET 1.1 and to install the script maps at the IIS root and under:
%SYSTEMROOT%\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -i
Make sure that the status of ASP.NET version 1.1.4322 is set to Allowed in the Web service extension list in Internet Information Services Manager.
Back to the top
ASP.NET 2.0, 32-bit version
To run the 32-bit version of ASP.NET 2.0, follow these steps:
Click Start, click Run, type cmd, and then click OK.
Type the following command to enable the 32-bit mode:
cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1
Type the following command to install the version of ASP.NET 2.0 (32-bit) and to install the script maps at the IIS root and under:
%SYSTEMROOT%\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
Make sure that the status of ASP.NET version 2.0.50727 (32-bit) is set to Allowed in the Web service extension list in Internet Information Services Manager.
Back to the top
ASP.NET 2.0, 64-bit version
To run the 64-bit version of ASP.NET 2.0, follow these steps:
Click Start, click Run, type cmd, and then click OK.
Type the following command to disable the 32-bit mode:
cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 0
Type the following command to install the version of ASP.NET 2.0 and to install the script maps at the IIS root and under:
%SYSTEMROOT%\Microsoft.NET\Framework64\v2.0.50727\aspnet_regiis.exe -i
Make sure that the status of ASP.NET version 2.0.50727 is set to Allowed in the Web service extension list in Internet Information Services Manager.
Note The build version of ASP.NET 2.0 may differ depending on what the currently released build version is. These steps are for build version 2.0.50727.
IPV6 Configuration
XP / 2003
###############
To install IPv6, run:
netsh interface ipv6 install
To find your IPv6 addresses when IPv4 is disabled, run:
netsh interface ipv6 show address
To ping a machine, run:
ping (e.g., ping 2001:db8:0:3eee::1)
To uninstall IPv6, run:
netsh interface ipv6 uninstall
To disable IPV4/ IPV6: Go to Network Connection properties and disable IPV6/ V4 Protocol Stack.
Vista / 2008
############
It's installed by default
Red Hat AS5:
###############
** It's installed by default
** To find your IPv6 addresses run one of:
ifconfig
ip addr ls
** To remove IPv6, add the following entries to /etc/modprobe.conf and then reboot:
alias net-pf-10 ipv6 off
alias net-pf-10 off
alias ipv6 off
** To create an IPv6-only with limited support for IPv4 (i.e., IPv6 solo) reboot your machine after modifying your interface configuration file (e.g., /etc/sysconfig/network-scripts/ifcfg-ethX) so it has the following entries
BOOTPROTO=none
IPV6INIT=yes
###############
To install IPv6, run:
netsh interface ipv6 install
To find your IPv6 addresses when IPv4 is disabled, run:
netsh interface ipv6 show address
To ping a machine, run:
ping (e.g., ping 2001:db8:0:3eee::1)
To uninstall IPv6, run:
netsh interface ipv6 uninstall
To disable IPV4/ IPV6: Go to Network Connection properties and disable IPV6/ V4 Protocol Stack.
Vista / 2008
############
It's installed by default
Red Hat AS5:
###############
** It's installed by default
** To find your IPv6 addresses run one of:
ifconfig
ip addr ls
** To remove IPv6, add the following entries to /etc/modprobe.conf and then reboot:
alias net-pf-10 ipv6 off
alias net-pf-10 off
alias ipv6 off
** To create an IPv6-only with limited support for IPv4 (i.e., IPv6 solo) reboot your machine after modifying your interface configuration file (e.g., /etc/sysconfig/network-scripts/ifcfg-ethX) so it has the following entries
BOOTPROTO=none
IPV6INIT=yes
Subscribe to:
Posts (Atom)
-
My quick reference list of questions for Driving License Theory Test Distances: Parking 5meter Before Pedestrian Crossing / Junc...
-
The concept of T-shirt sizes for SAP HANA SAP defined so-called T-shirt sizes for SAP HANA to both simplify the sizing and to limit... -
AJAX Truclient takes a lot longer to execute an iteration compared to Web HTTP/HTML for the same business process. Solution AJAX Truclient...