SWKB.NET

The Software Knowledge Base

  • Increase font size
  • Default font size
  • Decrease font size
SWKB.NET: Software Knowledge Base

Welcome to SWKB.NET

E-mail Print PDF

SWKB.NET is an online software development knowledge base for the following technologies:

Oracle PL/SQL, Oracle DB, Java, Web Services, Application Servers, PHP, MySQL, HTML, CSS,

Linux-Unix , Javascript, Siebel , APEX , MS-Access , MS-Excel , Apache , MS-DOS , etc.

Last Updated on Wednesday, 13 November 2013 06:34
 

Siebel: Server Manager Notes (srvrmgr)

E-mail Print PDF

Some useful commands for srvrmgr:

C:\sba80\siebsrvr\BIN>
srvrmgr /g
<siebel_gateway_host_address> /e <siebel_enterprise_name> /s <siebel_server_name>
/u
SADMIN /p SADMIN

list servers
set server SBLAPP1
unset server SBLAPP1
unset server
list component groups

disable component group Workflow

assign component group Remote to server <siebel_server_name>
enable component group Remote for server <siebel_server_name>

shutdown appserver <siebel_server_name>
startup appserver <siebel_server_name>
[stop and restart system service...]

list evtloglvl for component eCommunicationsObjMgr_enu
change evtloglvl Error=5 for component eCommunicationsObjMgr_enu

change evtloglvl GenericLog=1, Performance=1, Trace=0, TaskConfig=0, SrmRouting=0, SQLParseAndExecute=1,
SQLSlowQuery
=4, Perf=1, ProcReq=1 for comp WorkMon

activate component definition GenNewDb for server <siebel_server_name>

spool c:\spool.txt
spool off
Last Updated on Tuesday, 26 March 2013 11:42 Read more...
 

PHP: Connect to DB and fetch data

E-mail Print PDF

Code from login page:

$link=mysql_connect("localhost","dbuser","****");
if(!$link){
die("Couln't open database!");
}

$db="myschema"; mysql_select_db($db) or die("Could not open $db");

if(!empty($_REQUEST['user'])){
$theUser=$_REQUEST['user'];
}
else{
$theUser="";
}

$result=mysql_query("SELECT * FROM users WHERE UserName='$theUser' ");
$num_rows=mysql_num_rows($result);

while($a_row=mysql_fetch_row($result)){
if($_REQUEST['pass']==stripslashes($a_row[1])){
$msg="";
$_SESSION['user']=$theUser;
$_SESSION['userGroup']="admin";            
}
}
Last Updated on Sunday, 17 June 2012 14:50
 

MySQL: Create User

E-mail Print PDF

How to create user and give the necessary grants:

create user 'ms'@'111.222.11.22' identified by 'swkb123';

grant select, delete, insert, update on myschema.* to 'ms'@'111.222.11.22'
grant all privileges on myschema.* to 'ms'@'111.222.11.22';
Last Updated on Saturday, 16 June 2012 23:37 Read more...
 

mod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_counter
mod_vvisit_counterToday106
mod_vvisit_counterYesterday109
mod_vvisit_counterThis week106
mod_vvisit_counterLast week1471
mod_vvisit_counterThis month5816
mod_vvisit_counterLast month7083

We have: 3 guests online
Your IP: 54.146.55.156
 , 
Today: Aug 29, 2016

Empasi - empowering youth in Eastern Europe