phpmyadmin error #2002

#2002 - No connection could be made because the target machine actively refused it.

Solved

Modified appropriate line in config.inc.php line to $cfg['Servers'][$i]['auth_type'] = 'cookie'; (instead of 'config') and the system works fine.

Procedure to connect windows server2003 to client XP

Server side work

Step1:   Add Client machine to active directory users and computers =>Open admin tools => manage your server =>manage user and computers in active directory

Setp2: Servername=> builtin=> computers (right click)(computers right click) => new => computer

Setp3:  Provide computer name => next => next

Client side work

Setp4: Go to system properties => computer name => change –member of domain server name=> ok asks for server credentials provide it => welcome message appears

Setp5: Go to network neighborhood /my network places => tcp/ip => properties => preferred dns server ip (ip address of dns server ie., wi2003 server ip)

Setp6: Restart machine

Setp7: Logon => user name : user/admin => give password=> logon to =>server domain name

Password restrictions in windows server 2003

è        Start => admin tools => domain security policy => account policies => password policy => password meet complexity requirements (right click & disable it)

    

To import data from Excel to MySQL phpmyadmin.

used software: phpMyAdmin 3.1.1 and MySQL 5.1

 Save your Excel data as a csv file (In Excel 2007/2003 using Save As)

1. Check the saved file using a text editor such as Notepad to see what it actually looks like, i.e. what delimiter was used ex. : ; , etc.
2. Goto localhost-phpmyadmin, select required database and create a table with column crediantials.
3. Select the table and select the import tab then browse file to import.
4. Select the format of imported file .csv file, goto fields terminated by change your delimited symbol example ; or , which ever on your data mostly select , symbol there.
5. Click on go button.
6. Thats all your data sheet will be imported into mysql database

Hope this my help.

Regards
Janardhan

Solution to provide tomcat 6.0.26 server webapps environment to deploy Servlets/JSP files compiled by client XP machines.

Server information

Server Information
Tomcat Version	JVM Version	JVM Vendor	OS Name	OS Version
Apache Tomcat/6.0.26	1.6.0_20-b20	Sun Microsystems Inc.	Linux	2.6.35.6-45.fc14.i686

My Server is Core Fedora 14.

1	Install Samba Server Configuration Tool 1.2.90 on Server.
2	Disable firewall and suse linux in Administration tool on Server.
3	Add a Samba Share -> choose a folder i.e., webapps of/var/lib/tomcat6/webapps and tick in writable and visible.
4	Provide Access permission to a particular created user or give access to everybody  after creating  user/users whatever necessary
5	Now access Samba share from client through \\192.168.1.10(or )IP of your server, enter user credentials.
6	Copy the compiled servlets/jsp files to samba share webapps directory from client XP.
7	Now access http://192.168.1.10:8080/ (remote tomcat) from client and enter to tomcat manager by giving credentials.
8	Now you will see your application here you can deploy/undeploy/start/stop your Application.

 Hope you will enjoy..

Janardhan..

JDBC connection from XP client to remote Oracle 10g server using thin driverjdbc version 10.2.0.1.0

Step 1 Create a table and insert some data in Oracle 10g
Step 1 Copy classes12.jar to java/lib
Step 2 Create classpath :) set classpath=C:\Program Files\Java\jdk1.6.0_12\lib\classes12.jar;
Step 3 Create below code and change ip as your oracle server ip address 
Step 4 Compile the code
Step 5 Execute the code

import java.sql.*;
class sampleDB{
public static void main(String args[]) throws Exception
{ boolean repeat=true;
while(repeat)
{
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con =
DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.162:1521:orcl","scott","tiger");
System.out.println("Connected Successfully To Oracle");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from emp321");
while(rs.next())
{
int no=rs.getInt(1);
String name=rs.getString(2);
float sal=rs.getFloat(3);
System.out.println("EMPLOYEE NO:"+no);
System.out.println("EMPLOYEE NAME:"+name);
System.out.println("EMPLOYEE SAL:"+sal);
System.out.println("---------------");
} repeat=false; }
catch(Exception e)
{ System.out.println("exception is raised,try again"); }
} }
}

Hope you enjoy :)
Janardhan..

Q&A - 1

Could not start the Apache Tomcat service on Local Computer Error ... I installed Apache Tomcat on windows XP and unable to start the service.

Sol:

problem in laptop of xp os the solution i found is i installed jre-1_5_0_22-windows-i586-p.exe first and then i installed apache-tomcat-6.0.16.exe and given the path of jre-1_5 when its asked.

it works for me, try it BestOfLuck.

Jami

MySql setup in FEDORA 9

MYSQL SETUP IN FC9
Steps to install and connect to MySql (type the following in terminal prompt)
1. yum install MySql-server
2. /sbin/chkconfig mysqld on
3. /sbin/service mysqld start
4. mysqladmin -u root `newpassword`
5. mysql -u root -p or mysql
6. enter newpassword
Now you will get mysql> prompt
7. Finally we can stop service by this command
8. /sbin/service mysqld stop

Bye, Have a nice time
Jami.