Setup ejabberd with SQL Server 2008Problem with Ejabberd external authentication with PHPHow do I get this SQL Server ODBC Connection working?Developer Laptop with SQL Server 2008 can't login to SSIS when offsiteLogin failed when SQL Server startsMSSQL 2008 login failed for windows authenticationHow do I log in, using SSPI, to SQL Server 2008 R2 on a server in one workgroup from a workstation in another?SQL Server Windows Authentication fails after tonight's security updates: The login is from an untrusted domainWindows logins are not supported in this version of SQL ServerConnecting to SQL Server outside the domain with SQL AuthenticationCan SQL Express be installed on Server Core?
List of newcommands used
How can I support myself financially as a 17 year old with a loan?
Out of scope work duties and resignation
Why does sound not move through a wall?
Where can I go to avoid planes overhead?
What to use instead of cling film to wrap pastry
How did the Venus Express detect lightning?
Something that can be activated/enabled
How to adjust tikz picture so it fits to current size of a table cell?
Can you Ready a Bard spell to release it after using Battle Magic?
IP addresses from public IP block in my LAN
SafeCracker #3 - We've Been Blocked
Wrong answer from DSolve when solving a differential equation
Emotional immaturity of comic-book version of superhero Shazam
Are the Night's Watch still required?
What is the solution to this metapuzzle from a university puzzling column?
Will 700 more planes a day fly because of the Heathrow expansion?
Should I dumb down my writing in a foreign country?
Has a commercial or military jet bi-plane ever been manufactured?
Decoupling cap routing on a 4 layer PCB
Nominativ or Akkusativ
Where are the "shires" in the UK?
How to write a 12-bar blues melody
How can internet speed be 10 times slower without a router than when using a router?
Setup ejabberd with SQL Server 2008
Problem with Ejabberd external authentication with PHPHow do I get this SQL Server ODBC Connection working?Developer Laptop with SQL Server 2008 can't login to SSIS when offsiteLogin failed when SQL Server startsMSSQL 2008 login failed for windows authenticationHow do I log in, using SSPI, to SQL Server 2008 R2 on a server in one workgroup from a workstation in another?SQL Server Windows Authentication fails after tonight's security updates: The login is from an untrusted domainWindows logins are not supported in this version of SQL ServerConnecting to SQL Server outside the domain with SQL AuthenticationCan SQL Express be installed on Server Core?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
Here's what I have got so far.
- Windows 2008 Server 64 bit.
- Installed the latest version of ejabberd, ejabberd-2.1.8-windows-installer.exe.
- The windows service starts up fine but seems ineffective. However, using the start & stop scripts work. I am able to login to the admin page which so far doesn't seem that versatile.
- Opened up ports 5222, 5226 and 5280 for my workstation to talk to the server.
- I've got Spark and Jabbear Windows clients to register, login and instant message with multiple accounts using the server.
After confirming that I've got the very basics working, I've decided to make use of SQL Server 2008 as the database. Reason? Mainly, I am very comfortable with SQL Server. I can deal with redundancy, failover, data analysis easily. Not sure if ejabberd's built in DB provides all that.
- Following the instructions from ejabberd's documentation, I setup a system DSN that points to another physical database. The DSN checks out fine. (Tried both Named Pipes and TCP/IP)
- Modified ejabberd.cfg. Commented line
%%auth_method, internaland uncommented lineauth_method, odbc - Uncommented and modified
odbc_server, "DSN=ejabberd;UID=somelogin;PWD=somepassword". - After making these changes, I restarted. No errors are found in the log files.
- The jabber clients are no longer able to register new accounts. I'm not sure where to look for errors besides the /logs/ folder as I'm new to all this.
I am basically stuck here on step 5. Has anyone got this setup to work recently? Some of the posts I've found around are years old and of no help. I can't be the only one setting up ejabberd with MS SQL. Any help would be appreciated!
sql-server windows xmpp ejabberd
asked Sep 2 '11 at 21:40
wonsterwonster
1113
migrated from stackoverflow.com Sep 3 '11 at 16:03
This question came from our site for professional and enthusiast programmers.
add a comment |
Here's what I have got so far.
- Windows 2008 Server 64 bit.
- Installed the latest version of ejabberd, ejabberd-2.1.8-windows-installer.exe.
- The windows service starts up fine but seems ineffective. However, using the start & stop scripts work. I am able to login to the admin page which so far doesn't seem that versatile.
- Opened up ports 5222, 5226 and 5280 for my workstation to talk to the server.
- I've got Spark and Jabbear Windows clients to register, login and instant message with multiple accounts using the server.
After confirming that I've got the very basics working, I've decided to make use of SQL Server 2008 as the database. Reason? Mainly, I am very comfortable with SQL Server. I can deal with redundancy, failover, data analysis easily. Not sure if ejabberd's built in DB provides all that.
- Following the instructions from ejabberd's documentation, I setup a system DSN that points to another physical database. The DSN checks out fine. (Tried both Named Pipes and TCP/IP)
- Modified ejabberd.cfg. Commented line
%%auth_method, internaland uncommented lineauth_method, odbc - Uncommented and modified
odbc_server, "DSN=ejabberd;UID=somelogin;PWD=somepassword". - After making these changes, I restarted. No errors are found in the log files.
- The jabber clients are no longer able to register new accounts. I'm not sure where to look for errors besides the /logs/ folder as I'm new to all this.
I am basically stuck here on step 5. Has anyone got this setup to work recently? Some of the posts I've found around are years old and of no help. I can't be the only one setting up ejabberd with MS SQL. Any help would be appreciated!
sql-server windows xmpp ejabberd
asked Sep 2 '11 at 21:40
wonsterwonster
1113
migrated from stackoverflow.com Sep 3 '11 at 16:03
This question came from our site for professional and enthusiast programmers.
Found my answer -> link There are two versions of the ODBC Config utility. The one in Administrative tools is the x64 one. The one at C:WindowsSysWOW64odbcad32.exe is the 32 bit version. Made a system DSN using the 32bit ver.
– wonster
Sep 2 '11 at 23:23
add a comment |
Here's what I have got so far.
- Windows 2008 Server 64 bit.
- Installed the latest version of ejabberd, ejabberd-2.1.8-windows-installer.exe.
- The windows service starts up fine but seems ineffective. However, using the start & stop scripts work. I am able to login to the admin page which so far doesn't seem that versatile.
- Opened up ports 5222, 5226 and 5280 for my workstation to talk to the server.
- I've got Spark and Jabbear Windows clients to register, login and instant message with multiple accounts using the server.
After confirming that I've got the very basics working, I've decided to make use of SQL Server 2008 as the database. Reason? Mainly, I am very comfortable with SQL Server. I can deal with redundancy, failover, data analysis easily. Not sure if ejabberd's built in DB provides all that.
- Following the instructions from ejabberd's documentation, I setup a system DSN that points to another physical database. The DSN checks out fine. (Tried both Named Pipes and TCP/IP)
- Modified ejabberd.cfg. Commented line
%%auth_method, internaland uncommented lineauth_method, odbc - Uncommented and modified
odbc_server, "DSN=ejabberd;UID=somelogin;PWD=somepassword". - After making these changes, I restarted. No errors are found in the log files.
- The jabber clients are no longer able to register new accounts. I'm not sure where to look for errors besides the /logs/ folder as I'm new to all this.
I am basically stuck here on step 5. Has anyone got this setup to work recently? Some of the posts I've found around are years old and of no help. I can't be the only one setting up ejabberd with MS SQL. Any help would be appreciated!
sql-server windows xmpp ejabberd
asked Sep 2 '11 at 21:40
wonsterwonster
1113
Here's what I have got so far.
- Windows 2008 Server 64 bit.
- Installed the latest version of ejabberd, ejabberd-2.1.8-windows-installer.exe.
- The windows service starts up fine but seems ineffective. However, using the start & stop scripts work. I am able to login to the admin page which so far doesn't seem that versatile.
- Opened up ports 5222, 5226 and 5280 for my workstation to talk to the server.
- I've got Spark and Jabbear Windows clients to register, login and instant message with multiple accounts using the server.
After confirming that I've got the very basics working, I've decided to make use of SQL Server 2008 as the database. Reason? Mainly, I am very comfortable with SQL Server. I can deal with redundancy, failover, data analysis easily. Not sure if ejabberd's built in DB provides all that.
- Following the instructions from ejabberd's documentation, I setup a system DSN that points to another physical database. The DSN checks out fine. (Tried both Named Pipes and TCP/IP)
- Modified ejabberd.cfg. Commented line
%%auth_method, internaland uncommented lineauth_method, odbc - Uncommented and modified
odbc_server, "DSN=ejabberd;UID=somelogin;PWD=somepassword". - After making these changes, I restarted. No errors are found in the log files.
- The jabber clients are no longer able to register new accounts. I'm not sure where to look for errors besides the /logs/ folder as I'm new to all this.
I am basically stuck here on step 5. Has anyone got this setup to work recently? Some of the posts I've found around are years old and of no help. I can't be the only one setting up ejabberd with MS SQL. Any help would be appreciated!
sql-server windows xmpp ejabberd
sql-server windows xmpp ejabberd
asked Sep 2 '11 at 21:40
wonsterwonster
1113
asked Sep 2 '11 at 21:40
wonsterwonster
1113
asked Sep 2 '11 at 21:40
wonsterwonster
1113
asked Sep 2 '11 at 21:40
wonsterwonster
1113
asked Sep 2 '11 at 21:40
wonsterwonster
1113
1113
migrated from stackoverflow.com Sep 3 '11 at 16:03
This question came from our site for professional and enthusiast programmers.
migrated from stackoverflow.com Sep 3 '11 at 16:03
This question came from our site for professional and enthusiast programmers.
Found my answer -> link There are two versions of the ODBC Config utility. The one in Administrative tools is the x64 one. The one at C:WindowsSysWOW64odbcad32.exe is the 32 bit version. Made a system DSN using the 32bit ver.
– wonster
Sep 2 '11 at 23:23
add a comment |
Found my answer -> link There are two versions of the ODBC Config utility. The one in Administrative tools is the x64 one. The one at C:WindowsSysWOW64odbcad32.exe is the 32 bit version. Made a system DSN using the 32bit ver.
– wonster
Sep 2 '11 at 23:23
Found my answer -> link There are two versions of the ODBC Config utility. The one in Administrative tools is the x64 one. The one at C:WindowsSysWOW64odbcad32.exe is the 32 bit version. Made a system DSN using the 32bit ver.
– wonster
Sep 2 '11 at 23:23
Found my answer -> link There are two versions of the ODBC Config utility. The one in Administrative tools is the x64 one. The one at C:WindowsSysWOW64odbcad32.exe is the 32 bit version. Made a system DSN using the 32bit ver.
– wonster
Sep 2 '11 at 23:23
add a comment |
1 Answer
1
active
oldest
votes
Make sure to use the corect verion of the ODBC config utility based on the program you are using. In this case, you would want to use the 32 bit version:
http://www.ejabberd.im/node/4369#comment-form
answered Sep 19 '11 at 17:58
AaronAaron
2,97011835
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f307900%2fsetup-ejabberd-with-sql-server-2008%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Make sure to use the corect verion of the ODBC config utility based on the program you are using. In this case, you would want to use the 32 bit version:
http://www.ejabberd.im/node/4369#comment-form
answered Sep 19 '11 at 17:58
AaronAaron
2,97011835
add a comment |
Make sure to use the corect verion of the ODBC config utility based on the program you are using. In this case, you would want to use the 32 bit version:
http://www.ejabberd.im/node/4369#comment-form
answered Sep 19 '11 at 17:58
AaronAaron
2,97011835
add a comment |
Make sure to use the corect verion of the ODBC config utility based on the program you are using. In this case, you would want to use the 32 bit version:
http://www.ejabberd.im/node/4369#comment-form
answered Sep 19 '11 at 17:58
AaronAaron
2,97011835
Make sure to use the corect verion of the ODBC config utility based on the program you are using. In this case, you would want to use the 32 bit version:
http://www.ejabberd.im/node/4369#comment-form
answered Sep 19 '11 at 17:58
AaronAaron
2,97011835
answered Sep 19 '11 at 17:58
AaronAaron
2,97011835
answered Sep 19 '11 at 17:58
AaronAaron
2,97011835
answered Sep 19 '11 at 17:58
AaronAaron
2,97011835
2,97011835
add a comment |
add a comment |
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f307900%2fsetup-ejabberd-with-sql-server-2008%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Found my answer -> link There are two versions of the ODBC Config utility. The one in Administrative tools is the x64 one. The one at C:WindowsSysWOW64odbcad32.exe is the 32 bit version. Made a system DSN using the 32bit ver.
– wonster
Sep 2 '11 at 23:23