General :: Create A Pptp Username Through Mysql?
May 19, 2011my vpn server has been working well. but all user accounts are stored in /etc/ppp/chap-secrets. the question is how to create a pptp username through mysql?
View 3 Repliesmy vpn server has been working well. but all user accounts are stored in /etc/ppp/chap-secrets. the question is how to create a pptp username through mysql?
View 3 RepliesHow do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies View RelatedCan anyone give me a example to create a acl using username from my active directory.
i have around 3000 users.
i was able to input it directly from the script using this code
Code:
#!/usr/bin/expect -f
set USER "bibingeorge"
[code]...
I have set up an ubuntu server running PPTP Server for VPN connections. I can successfully connect from a laptop within the LAN, but taking that same machine to an internet connection and trying to connect back in does not work. The only difference is that when I connect from within the network, I am obviously using the server's LAN (non-routable) address, and when I am connecting from outside the network (from Verizon Business DSL ), I am using the Comcast connection's static IP address.
I have a static IP address on a Comcast Business Class internet connection. Router is set to forward pptp and GRE ports.
Works:
VPN Server <- Laptop
iPhone -> Internet -> Router -> VPN Server
Does not work:
Laptop -> Internet -> Router -> VPN Server
Here is the weird thing. I have an iPhone that connects flawlessly every time through it's AT&T data connection. The laptop however, gets to "verifying username and password", and then returns error 619. It seems that there is an issue only when going through the router using the PPTP client built into MS windows.
I thought configuring a vpn would be a piece of cake, but it seems I'm missing something.
I'm attempting to create a vpn (pptp) using the networkmanager (0.7.1). I enter the gateway (I assume thats the server I'm trying to connect to) and my login information. What is the NT Domain?
When I try to connect it only tells me after a while that it failed to do so. How can I find the information on what went wrong in the process?
I am using liferay5.2 with tomcat 6. after installation of liferay5.2 i am unable to configure the datasource that points to the database mysql.without this liferay wont function. how to create a mail session in tomcat that points to the mail server. i am using fedora 6.
View 5 Replies View Relatedmysql -u root -p but unable to create any database.
if i tried to configure it's giving error ERROR 1006 (HYOOO) : can't create database 'test' (error: 2)
my location for database is /var/lib/mysql and permissions are
drwxrwxrwx mysql root.....
I am trying to connect to a PPTP VPN at work, and I cannot accomplish that. Both server and client are using Ubuntu 10.10.
Code:
Jan 7 11:32:26 multicore-dev03 NetworkManager: <info> Starting VPN service 'org.freedesktop.NetworkManager.pptp'...
[code]....
i have a VPN server PPTPD on Centos 5.3
eth0: 62.2.2.x (public on the internet)
GW: 62.2.2.1 (cisco router)
i want to configure my ppptp server to allow users access internet with their own public ips of class 62.2.3.0 62.2.4.0 62.2.5.0
every time i configure my server all users can get thier IPs but they only go out with my server IP same as NAT not routing.
can you show me the proper configuration to make my users connect with public IP and have internet access. use specific DNS ( i did this but some users can not brows by DNS)
is there any way to specify an expired date for each pptp user.
I'm trying to connect to a Microsoft ISA PPTP server from my Linux box. The box I'm connecting from is itself a router. I have no problem connecting a Windows XP machine to the VPN via this machine. This is fine, but I would rather connect via the Linux machine, giving me far more advanced routing options (i.e. no to send every packet from the XP box completely unnecessarily via the PPTP tunnel). The Linux router is running Debian Lenny.
I've checked iptables. There were initially some issues. I've fixed those.
Invoking pppd from the console, I can see that authentication succeeds, but then some negotiation goes wrong and the server terminates the connection. Here's the output from pppd, with the more sensitive stuff removed:
Code:
<hostname>:~# pppd call <peer> nodetach debug
using channel 19
Using interface ppp0
Connect: ppp0 <--> /dev/pts/2
sent [LCP ConfReq id=0x1 <asyncmap 0x0> <magic 0xe3e45f75> <pcomp> <accomp>]
code....
How can i create folders in linux? so far i have created the folders i need using mkdir /home/computer now what i need to do is create five more folders but each folder sill have their own username and password
View 6 Replies View Related1. No any input to create new username and password when I install X86-64 bit Core 12 And I can not login with root. So how can I login Fedora core 12?
View 4 Replies View Relatedi am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
I use an atom based processor of 1.60 ghz on intel d945gclf board. My ram is a zion 1gb @ 533mhz. Hdd is from western digital 80gb @ 7200 rpm. I have a broadband(dsl) connection from bsnl dataone (a state owned telecom service provider). I connect to internet via a huawei wa1003a ethernet/usb/wireless modem which is provided by my service provider. I need a username and a password everytime i connect to internet via dial-up.
I was using windows xp service pack ii. It was nice and easy installing my modem on xp either via usb or ethernet. Both ways it was easy as i have both the drivers with me.Only and main problem was fighting viruses. I tried many free downloadable anti-virus software to protect my maching. Initially they were fine. But after few months they stopped taking regular updates and became non-functional. I also tried symantec corporate v.10. But it has its drawbacks also. It made my machine perform like a snail.I had previously heard about linux based operating systems. But never tried one. As i am an ameteur in using computers windows xp was suiting my needs. Recently i saw an article in the newspaper about ubuntu which is a free open source operating system. And most important to me it is virus free.But here is a problem also. I cannot connect to internet. My ubuntu 9.10 karmic koala is not identifying my modem and a network between my modem and my machine cannot be established. Also i cannot create a dial-up option where i can give username and password.
I tried creating a database in mysql but couldn't do so...here is the message i got from the shell:
Code:
Hi. I need to create second mysql instance on the same server but another port. What is the right way to do that?
View 1 Replies View RelatedI've started a webserver at 127.0.0.1:**** I want to be able to use a database for this server. Which schema do I use to add a new table to? Do I create a new Schema altogether?
View 5 Replies View RelatedWhat is the use of UNION=() in CREATE TABLE?
Code:
ENGINE=MRG_MyISAM DEFAULT CHARSET=utf8 UNION=();
I have been given some code and could not explain why it's err's out. Checked the mysql 5.0 manual but nothing[URL]. It only explains using UNION in a SELECT statement which I understand. If I drop off UNION=() then CREATE TABLE works fine.
create a user for php/MySQL under ms win environment?
View 1 Replies View RelatedI installed mysql on FC14, but can't successfully create a new user. It lets me go through all the steps without complaint, but then I can't log into mysql as the new user.
Here's what I did.
1) yum install mysql mysql-server
2) service mysqld start ##sets up mysql
3) mysqladmin -u root password myownsecrectpass ##create a root password
3b) mysql -uroot -p; #log in as root, this works fine
4) CREATE DATABASE webdb;
5) CREATE USER 'anewuser'@'%' IDENTIFIED BY 'password123'; ##create anewuser with a passwd
6) GRANT ALL ON webdb.* TO anewuser@'%';
7) FLUSH PRIVILEGES;
Then I log out of mysql as root and try to log in like this
mysql -uanewuser -p
I enter the password and get this error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
i'm trying to create a database with the mysql that came with the suse installation, my problem is that i can't get mysqladmin to work it spits out this: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists! So I'm stuck at square one php info() seems ok with the installation and the installed client connects to my remote DB ok. I checked the server with ps -ef | grep mysqld and I get the following:
2438 2436 0 15:47 ? 00:00:00 /usr/sbin/mysqld --defaults-file=/home/ben/.local/share/akonadi//mysql.conf --datadir=/home/ben/.local/share/akonadi/db_data/ --socket=/home/ben/.local/share/akonadi/socket-linux-ygk7.site/mysql.socket root 6248 6151 0 16:01 pts/0 00:00:00 grep mysqld
Which doesn't really mean a lot to me but looks ok, anyway my question boils down to does anyone have any obvious ideas of what I'm doing wrong or is, as others have hinted, suse's mysql installation is broken?
MySQL gets installed with root user by default, root user can administer every mysql database installed in the system. Question is how to create a new user that will not be able to administer all the databases in the system the way as root user is? Can it be done using webmin?
View 7 Replies View RelatedI'm using dovecot pop3 server in my website. I tried to create a virtual user system with mysql. But it didn't work. Next I tried to debug my work with reading of dovecot log. I enabled logging in it by changing this values in /etc/dovecot/conf.d/10-logging.conf:
Code:
log_path=/var/log/dov
auth_verbose = yes
auth_debug = yes
auth_debug_passwords = yes
After that I tried to login to the pop3 via telnet and it failed as usual. After I checked the log file (/var/log/dov), but it does not contain any information about that failed login. Only there was some information about starting up of dovecot! Does any body know that what is the problem and why dovecot doesn't log that?
I want to create database from script directly by taking inputs USER, PASSWORD and DBNAME.code...
How to resolve this or any alternate method (other than entering into mysql prompt like mysql -u USER -pPASSWORD)?
After the Opsview packages have been installed, it is necessary to configure Opsview and its databases.but while running below command get an error,#mysqladmin -u root password {password}mysqladmin: connect to server at 'localhost' failederror: 'Access denied for user 'root'@'localhost' (using pa
View 4 Replies View RelatedCan anyone tell me what's going on?(this is the latest version of WINDOZE MySQL (sorry!) downloaded from the web.)
View 2 Replies View RelatedMysql starting problem after changing mysqladmin password.I tried all the solutions available on forums, but not solve the problem.At last I restored the mysql db backup, this make mysql service start, but till other databases not showing all tables.
View 1 Replies View Relatedrecently upgraded, now none of my stored procedures work. All return error 1307. what can I do to prevent this from happening?
View 3 Replies View RelatedI have installed on a remote server phpmyadmin 3.3.1 and mysql 5.1.46 on a centos 5.4 OS.
Any newly created user with phamyadmin is unable to login both from mysql command line (from localhost) and phpmyadmin (localhost and remotely).
No prob when the user is created with mysql command line (from localhost). All of the users created with phpmyadmin, are not "visible" recognized from the show user command via the mysql command line. The setting I used when I create any user was the same as the ones with the mysql command line creation.
The error message I get when accessing from mysql command line (from localhost) is the following: "Access denied for user ... @localhost (using password: yes)"