Find Jobs
Hire Freelancers

Remote MySQL acccess tool

$100-500 USD

Cancelado
Publicado hace alrededor de 20 años

$100-500 USD

Pagado a la entrega
I am looking for a remote database access tool to be written in both PHP4 (server side) and Visual C++ or Visual Basic (client side) to give access to an email authenication/routing database. I prefer Visual C++. The communications between the client and server should be in XML using either SOAP or XML-RPC over http with SSL. All code must be documented as well as the communications protocol. For the server side all I am looking for is the basic framework to handle the clients functions and work with the supplied database in mysql. The server is running FreeBSD 4.9, apache 1.3.x and PHP 4.3.5. The client must compile cleanly (without any errors) under Visual Studio .net 2003 Professional. The client must also be able to work on Windows 2000/XP. Details on the client include; Ability to login and authenticate from the server. Once the server authenticates a username/password it will send a authentication token to be passed for authentication during every other transaction until a logoff (http sessions). I would like the server to support multiple clients at the some time. Please let me know if this would be a problem. User functions; +ability to add a user. +ability to edit a user. +ability to change passwords. +ability to change their names. +ability to lock out a user (simple flag in database). +ability to delete a user. +Details users should have; +loging name +password +Full name +email address +Comment section of an account Email functions... I have an existing database (see below) that I need to remotly administer. For the "accountuser table"; Flags that are settable by the client are "smtp", "pop", "imap", "active" and "remove". With "pop" and "imap", one or both must be set. "added" is a flag that is set at the server, not by the client. If the "remove" flag is set, the "active" flag must be set to "0". For the "virtual" table; "active" is a flag set by the client. "alias" is the email address and "dest" is the destanation email address. "dest" can have more then one email address entered, but if one is the same as "alias" then an account must exist for it in the "accountuser" table that is active. Multiple entries in the "dest" column are seperated by a "\n" and have no more then 1000 enteries maximum. For the "domain" table; The "active" flag is set at the client. CREATE TABLE accountuser ( id int(8) NOT NULL auto_increment, emailaddress varchar(50) NOT NULL default '', password varchar(30) binary NOT NULL default '', quota int(8) NOT NULL default '0', domain int(8) NOT NULL default '0', smtp enum('0','1') NOT NULL default '0', pop enum('0','1') NOT NULL default '0', imap enum('0','1') NOT NULL default '0', added enum('0','1') NOT NULL default '0', active enum('0','1') NOT NULL default '0', remove enum('0','1') NOT NULL default '0', updatequota enum('0','1') NOT NULL default '0', quotausage varchar(10) NOT NULL default '', quotatime datetime default NULL, PRIMARY KEY (id), UNIQUE KEY emailaddress (emailaddress), KEY id (id) ) TYPE=MyISAM; CREATE TABLE virtual ( id int(8) NOT NULL auto_increment, alias varchar(255) NOT NULL default '', dest longtext, username varchar(50) NOT NULL default '', domain int(8) NOT NULL default '0', active enum('0','1') NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY alias (alias) ) TYPE=MyISAM; CREATE TABLE domain ( id int(8) NOT NULL auto_increment, domain_name varchar(255) NOT NULL default '', active enum('0','1') NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY domain_name (domain_name) ) TYPE=MyISAM;
ID del proyecto: 1063

Información sobre el proyecto

11 propuestas
Proyecto remoto
Activo hace 20 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
11 freelancers están ofertando un promedio de $420 USD por este trabajo
Avatar del usuario
Well, I am interested to do it only in C#. I am not very qualified in c#, so may take time for this one. The amount will be $700. I think this will be best for ur requirements.
$500 USD en 28 días
5,0 (2 comentarios)
2,6
2,6
Avatar del usuario
(The bid is preliminary, after a more detailled study I will give You a new bid ( actual bid + or - 20%) I am a Professional (see GuyLT please) Senior Programmer, DBA, Admin, Projectleader, Designer, Translator(6 languages) and I can deliver what You want me to; do You want special effects on Your site ? (Flash, Shockwave, Fireworks, Video, Audio, Radio...etc) Quality assured . Worktime : about 30 hours ; I can send You an SEO-Report, with recommendations for Your site (for FREE) . I use Dreamweaver MX2004, which support ASP.NET_Csharp, ASP.NET_VB, ASP_Js, ASP_Vbs, ColdFusion, JSP, PHP_MySQL, UD4-ColdFusion and supports also Frontpage . I will ad You for 12 $ to any 1000's Search Engines. Submission to 700,000 search engines, Ranking Optimization, Linking etc. after special agreement. Discuss the Project on MSN - Yahoo - ICQ - mIRC - iSPQ is possible !
$475 USD en 7 días
5,0 (1 comentario)
2,0
2,0
Avatar del usuario
I'll do the PHP part of it only
$500 USD en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I can build this in C++ for you. I'm using Visual Studio 6.00 but it will compile cleanly on the .NET compiler because the latter is a superset and backwards compatible. I'm happy to provide full documentation. I work to professional standards so I test the application before delivery, document it, provide executables and complete source file set, invite you to carry out UAT.
$500 USD en 20 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Your technical requirements are total overkill. This poject can be easily done as a simple web app in PHP or Perl, securely accessible online over SSL. We propose to do it for you in Perl.
$500 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Not to point out the obvious but why not just use one of the many pre-existing mysql db admin tools and tunnel your ports through ssh.
$500 USD en 0 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
For the bid price I have specified, I will tell you exactly which open source package to use; will install it for you; and will provide about an hour's worth of support for you. It is an existing package that is written in PHP, can be modified, and works with MySQL. If you just want a client that runs on Windows, then it will be a different story, but if you merely want to admin your database remotely, then I know exactly what to set you up with and get you going ASAP. It's the same thing I use myself and it works like a champ. Contact me via PM and we can discuss it! Good luck, whatever your choice ! James C. Deen
$150 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
This type of Project is best handled using a VB client & few PHP files on server which communicate with VB client. Are you open to such a solutions.
$200 USD en 15 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
we are having team to manage this project
$300 USD en 30 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
San Diego, United States
0,0
0
Miembro desde abr 16, 2004

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.