User Tools

Site Tools


projects:cugar

Project Cugar

Cugar is a Frontend for CAO-Faktura and SugarCRM written in C#.NET.

  • The Sourcecode is available at github.com
  • The Project Documentation is available for my fellow classmates on my Google Docs Account
  • For you Anonymous guys out there: You don't really want to read the Project Documentation… Believe me :)

CAO-Faktura uses MySQL 4. The appropriate download is here. The CAO-Faktura Client Software is available here
SugarCRM is a open source CRM solution which we use at my company. Its based on MySQL 5 and uses a Web Frontend.

It seems that .NET needs an extra Connector for MySQL. I use this one MySQL Connector .NET 6.3.7
Infos about the usage of .NET in combination with MySQL can be found here (German) In order to connect to the mysql 4 server you need the odbc drivers aswell. Get them from here

The Databases

sugarcrm

Hostname: sugarcrm.lan.darktemple.ch
port: 3306
eth0 ip: variable (dhcp)
eth1 ip: 192.168.56.102
mysql Version: 5.1
Additional Software: phpmyadmin
relevant Database sugarcrm
rootpw: 00mysql00

winxp

Hostname: winxp.lan.darktemple.ch
post: 3306
ip: 192.168.56.101
mysql Version: 4.1.22-win32
Additional Software: phpmyadmin, heidisql
relevant Database: caofaktura
root password: 00mysql00

The SQL Users

Username: Password host
root 00mysql00 both
sugarcrm 00sugar00 sugarcrm

CAO Users

Username: Password
Administrator sysdba
Thomas Thomas
Silvio Silvio
Peter Peter
Cugar Cugar
Mathias 1234

Sugar Users

Username: Password
admin 00sugaradmin00
Mathias 1234
Cugar Cugar
Thomas Thomas
Silvio Silvio
Peter Peter

Activate query logging

# /etc/my.cnf
[mysqld]
log=/var/log/mysqld.log
service mysqld restart

View the live log

tail -f /var/log/mysqld.log

Software:

projects/cugar.txt · Last modified: 2013/03/14 17:17 by skull@darktemple.ch