Web Serverstaging/Dev: Oldtas270c

Intranet

Web serverStaging/Dev://oldtas270C

Production://oldtas270E

SQL Server:

Dev: oldtas270D

Production: oldtas270F

Master id / password: k12_admin / k12admin

Pearson Learning Group:

CF Data Source: plearn

Directory: Staging/Dev://oldtas270C/plearn ( )

Production://oldtas270E/plearn ( )

SQL database: plearn

Correlation Posting:

Contact: GraceMensah,
Post via Interent StatePage builder:
A daily job, ‘PLG Intranet Correlation Refresh (from Internet)’, will transfer all internet correlation info to PLG Intranet correlation table: crr_tb

NOTE:

for national correlations: please post files under directory /correlation/nl/
to find correct program code: go to PLG Intranet, Product.

Select a product from the drop down list. You should see the prgm_cd at the end of the URL.

For a new program, create a new prgm_cd on table dbo_prod_doc_prgm

Product document Posting:

Connect to SQL server oldtas270E/plearntable Name: prod_doc_src
Save/copy file to oldtas270E/plearn/product/product_files/

NOTE:

For a new program, create the prgm_cd on table dbo_prod_doc_prgm

To find correct program code & doc type: go to PLG Intranet, Product.

For a new program, create a new prgm_cd on table prod_doc_prgm
For a new document type: create a new prod_doc_type on table prod_doc_type

Phnet:

CF Data Source: phschool

Directory: Staging/Dev://oldtas270C/phent/ ( )

Production://oldtas270E/phnet/ (

SQL database: phschool

Scott Foresman:

CF Data Source: sforesman

Directory: Staging/Dev://oldtas270C/elementray/ ( )

Production://oldtas270E/elementray/ ( )

SQL database: elementary

K12 School:

CF Data Source: k12schl

Directory: Staging/Dev://oldtas270C/k12schl

Production://oldtas270E/k12schl

SQL database: k12schl

URL:

Intranet Web Applications/Server:

Oldtas248/Oldtas249:

CF admin password: 248admin

Remote access: U42/network password

FTP: ID: ftp_user password: ftpuser

Master CF Datasource ID: k12user/(null)

Server support: IBM: Tyrone Rollins (201) 767-5037

K12 Product Master:

FTP: server oldtut004

Development: pdcoxf3 / master

Production: k12plsfa / sch001 (sch-zero-zero-one)

For UPPS product Info: oldtas249/e$/fileroot/ftp_upps_feed.bat (call ftp_upps_credentials.txt to execute FTP comments)

SQL server: oldtas249

Master ID: k12user password: null for all

SQL SA ID: PPHBOMM/uphbom1

Domain name: PEROOT

SQL support:

(most of DTS jobs are on oldtas249)

K12SFD:

CF datasource: k12sfd (ID: k12user password: null)

Directory:Dev://parsas248/d$/Inetpub/webroot/dev/k12SFD/ ( )

Production://oldtas248/d$/Inetpub/webroot/k12SFD/ ( )

SQL Database: parsas249/k12sfd

Web login: sfd_admin (same for PLG, PH, & SF)

Password: PLG: plgadmin

PH: phadmin

SF: sfadmin

SolutionBuilder:

CF datasource: solutbuilder (ID: k12user password: null)

Directory:Dev://parsas248/d$/Inetpub/webroot/dev/ SolutionBuilder (

Prod: //parsas248/d$/Inetpub/webroot/SolutionBuilder/ ( )

SQL Database: parsas249/[production] solutbuilder

Notes: user login refreshed by sfa_sos & product tables: k12_prodmaster

Product Master:

CF datasource: Prod: k12_ProdMaster(ID: k12user password: null)

Dev: dev_ProdMaster (ID: k12user password: null)

SQL Database: parsas249/[production] k12_prodmaster

CAMS:

Dev:

CF datasource: k12cams_dev (user: k12user pswd: k12user)

Directory://parsas248/d$/Inetpub/wwwroot/dev/k12cams/ (

SQL Database: //oldtas249/Development/k12cams

production:

CF datasource: k12cams (user: k12user pswd: k12user)

Directory://parsas248/d$/Inetpub/wwwroot/k12cams/ (

SQL Database: //oldtas249/Production/k12cams

Oldtas220:

CF admin password: cfadmin

TOS:

CF datasource: slsRpt (user: slsRpt_user pswd: (null))

Directory:Dev:DInetpub/dev/sls_adminRpt/ ( )

Prod: DInetpub/sls_adminRpt/ ( )

SQL Database: oldtas220/sls_adminRpt

Internet Applications

PE Contact: ITG:

(Oracle issue: Tao Fan; Web server: Brian McCarthy or Wilson Christian)

Other technical assistance:

Brian McCarthy 201- 767 - 4911

Sean King201- 236 - 7716

Ken Simmons201- 784 - 6187

ID & password (Web server):

Application
PLG Internet / Login/password: plgcorp/plg911(?)
DEV server:10.160.3.140 (prs11.di.pearsontc.net)
Old server: prs09 ../webroot/pearsonlearing/ (plearn/plearn11(?))
Prod server: prs76
Dev root: /user1/webroot/plgcorp/
Dev root: /production/prs76/webroot/plgcorp/
Dev URL:
Prod URL:
companion / Login/password: plcomp/plcomp1(?)
DEV server:prs09
Production:prs107.ot.pearsontc.net (IP: 165.193.130.115)
Dev root: /user1/webroot/pearsonlearing/companion
Prod root: /production/prs107/pearsonlearing/companion
Cust Library / Production:prs109.ot.pearsontc.net
Dev root: /user1/webroot/plgcorp/custlibrary/
Prod root:/production/prs109/webroot/plgcorp/custlibrary/
Dev URL:
Prod URL:
K12 School / Login/password: k12schl/h88py!
DEV server:10.160.3.140
Production:prs107.ot.pearsontc.net (IP: 165.193.130.115)
Dev root:/usr1/webroot/k12/
Prod root: /production/prs107/webroot/k12/
Dev URL: (ID/pswd: k12_user/k12user)
Prod URL: (ID/pswd: k12_user/k12user)
PE workbooks / Directory: /workbooks/
Dev URL:

Prod URL:

StatePage Builder / Direcotry: /statepage/builder/
FTP login for each BU (Lisa Sharp manages the passwords):

PH: phstate SF: sfstate PLG: plstate

DEV URL:
Prod URL:
Notes for statepage Correlations:
Each BU has it’s own correlation folder: plg_corr; ph_corr; sf_corr
All state folders under such folder should assign permission group to ID: statepg
UNIX commends: chgrpgroup_namefile/directory
SF Internet Dev / Login/password: edtechdev/SFdev159
FTP server: Prs11.di.pearsontc.net
Dev URL:
K12Profile
(AJAXschoolfinder) / Login/password: k12profile/ k12911
Dev root: /usr1/webroot/k12profile/schoofinder/
Production root: /production/prs76/webroot/k12profile/schoolfinder/
Dev API:
Prod API:
DEV server: prs09.di.pearsontc.net (ID/pswd: phsdev/devph123)
Prentice Hall (phschool.com) / Login/password: phsdev / phst4gin9
DEV server:10.160.3.140
Production:prs106.ot.pearsontc.net
Dev root: /usr1/webroot/phschool/
Production root: /production/prs106/webroot/phschool/
Dev URL: (ID/pswd: staging/ph1staging)
Prod URL:

Notes: passwords expires every 60 days

FTP:

login onto dev site via CuteFTP or Putty using above login info
- CuteFTP: go up to the /production/ level, then find the proper server to drill down to different folder again

- Putty: use UNIX commends: (example for k12schl:

cd stateapge

cp -r target_directory destination_directory

(i.e. cp –r builder /production/prs107/webroot/k12/statepage/)

Oracle Database:

Application /

Servers

DB schema

/ ID/ password / CF Datasource
PLG Internet & customer Profile / dev08 / DB07TG / Gfearon / K12schl/k12schl / gfearon
(plg admin) / dev08 / DB07TG / pladmin / pladmin/ pladmin / pladmin
Online Catalog (delivery tbs) / K12catalog / k12catalog/k12911 / K12catalog
K12 Content management System / k12cms/ k12911 / k12cms
PLG Companion website OCD / dev08 / DB079i / Plearn / plocd/pl08d / plocd
State Page & Correlations
workbooks
K12 contact us forms / dev08 / DB07TG / K12schl / k12schl/ k12schl / K12schl
SF Internet / scottforesman / scottforesman/sfaw1data / scottforesman

Oracle Connecting Info: (need Oracle client)

Dev:

HOST: 10.160.3.139

SID: DEV08

PORT 1521

Production:

HOST: 10.160.14.34

SID: DB07TG

PORT 1521

Connecting String for tnsname.ora:

DB07TG =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = tcp.world)

(PROTOCOL = TCP)

(Host = 10.160.14.34)

(Port = 1521)

)

(CONNECT_DATA =

(SID = DB07TG)

)

DEV08 =

(DESCRIPTION =

(FAILOVER=ON)

(LOAD_BALANCE=OFF)

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = tcp.world)

(PROTOCOL = TCP)

(Host = 10.160.3.139)

(Port = 1521)

)

(ADDRESS =

(PROTOCOL = TCP)

(Host = 10.160.3.139)

(Port = 1521)

)

(CONNECT_DATA =

(SID = Dev08)

)

Oracle SQL Plus:

sqlplus k12schl/k12schl@DB07TG

insert data:

COPY FROM [database]/[password]@db07TG TO [database]/[password]@dev08 INSERT [tablename] Using select *

From [tablename] where xxxx;

Example:

copy from k12catalog/k12911@db07tg to k12catalog/k12911@dev08 insert dt_product using select *

dt_product where isbn = '0328240915';

copy from k12schl/k12schl@dev08 create tablename using select * from k12schl.tablename;

exp k12schl@dev08[DB07TG] file=k12schl.exp tables=[table1,table2] rows=[yes/no] indexes=[yes/no] owner=k12schl

imp k12schl @dev08[DB07TG] file=k12schl.exp tables=[table1,table2] rows=[yes/no] indexes=[yes/no] fromuser=k12schl touser= k12schl

grant [insert,update,select,delete] on tbl_attrib to [ID];

CREATE TABLE [table name] (

id number(5) constraint classes_id_pk Primary Key ,

fieldname1 varchar2(250),

fieldname2 number(10)

);

describe tabs;  to view table schema

select table_name from tabs order by table_name;

create sequence DSP_rqstCatalog_id_sq

start with 1

increment by 1;

create index [index name] on [table name]

([field1, field2,…..];

altertable[table name]dropcolumn [column name];

for example: altertableTBL_CORRELATIONdropcolumn DISPALY_SEQ;

UNIX Commends:

Change permission to a group:

chgrpgroup_namefile/directory

Chk group: ls -gl

cp -r target_directory destination_directory

(i.e. cp –r forms /production/prs107/webroot/pearsonlearning/)

rm -r target_directory (also for symbolic link directory)

create symbolic link:

ln -s realdir_name newalias_name (.e. ln -s 2101A 2101a)

create symbolic link for a phycial file:

ln realfilename newalias_name (.e. ln dra.cfm index.cfm)

Check/alter password:

alter user [user_id] identified by [somenewpassword];

______

Get Log files:

For ColdFusion:

At prompt type: cd /production/prs107/app/coldfusion/ (for production)

For Statistics Log:

At prompt type: cd /production/prs107/logs/pearsonlearning_com.access (for production)

Internet Customer Profile database:

PLG:
Schema: gfearon
XREF_ATTRIB_HISTORY
TBL_ATTRIB
TBL_ONLINE_CONTACT
Schema: pladmin
TBL_SOURCE
TLKP_SOURCE_TYPE / PH:
Schema: gfearon
PH_ATTRIB_HISTORY
PH_ONLINE_CONTACT
PH_TBL_ATTRIB
PH_TBL_SOURCE

from: gfearon.tbl_attribinsert into xref_attribut_history

Position:
1:Other
2:Title 1 Coordinator
3:Teachers Aide
4:Teacher
5:Superintendent
6:School Purchasing Agent
7:Principal
8:Parent
9:Media Specialist
10:Librarian
11:Language Arts
12:Homeschooler
13:Funding Supervisor
14:ESL Specialist
15:Department Chair
16:Curriculum Developer
17:Coordinator
18:Assistant Superintendent
19:Assistant Principal
20:Administrator / Curriculum Area:
50: Arts
49: Assessment
48: Foreign Language/ESL
47: Language Arts
46: Life Skills
45: Mathematics
37: Other
44: Reading and Literature
43: Science
42: Social Studies/Economics
41: Special Education
40: Staff Development
39: Teacher Training
38: Test Preparatio
Grade Level:
36: Pre-K
35: Kindergarten
34: 1st
33: 2nd
32: 3rd
31: 4th
30: 5th
29: 6th
28: 7th
27: 8th
26: 9th
25: 10th
24: 11th
23: 12th
22: Adult Basic Education
21: Other /

Opt in: 58

Opt out: 57
Special Character Codes
Character / Code / Character / Code / Character / Code
© / © / > / µ / µ
® / ® / ) / ) / ½ / ½
™ /  / ] / ] / ¼ / ¼
$ / $ / » / » / 8° / 8°
% / % / " /  / ¾ / ¾
< / ' /  / ƒ / 
( / ( / ` / ` / / / /
[ / [ / « / « / ~ / ~
& / " / " / × / }
? / ? / { / { / ± / ±
§ / § / } / } / ¯ / ¯
¦ / ¦ /   / ÷ / ÷
! / ! / ´ / ´ / + / 
@ / @ / ' /  / ¸ / ¸
£ / £ / ¤ / ¤ / - / 
¢ / ¢ / † /  / = / =
¥ / ¥ / " / &#148 / ‰ / 
‡ /  / • /  / A³ / A&#179 ;
| / | / ¶ / ¶ / Aª / A&#170 ;
\ / \ / ¬ / ¬ / A¹ / A&#185 ;
¨ / ¨ / … /  / Aº / Aº
# / # / · / · / A² / A²

Remedy:

Contact: Tom Sheridan (PTC)

URL: then click on “Support Console”

On the left hand site navigations: click on New Request.

From the popup window, click “Change Request”

ID/Passwords for other applications:

System / ID / Password / As DateC
Business Object / ulin9je / ulin9je / 09/06/2005
Remedy / PEROOT\ulin9je / Welcome / 06/01/2005